Implement cleanHidden

2 files changed, 22 insertions, 1 deletions

diff --git a/src/assignmentList.cpp b/src/assignmentList.cpp
index 5168914..09ef6e3 100644
--- a/src/assignmentList.cpp
+++ b/src/assignmentList.cpp
@@ -128,7 +128,8 @@ void AssignmentList::reload() {
 }
 
 void AssignmentList::cleanHidden() {
-	qDebug() << "WIP";
+	BackendDB database;
+	database.cleanHidden();
 }
 
 void AssignmentList::aboutDialog() {
diff --git a/src/backend/db_sqlite.cpp b/src/backend/db_sqlite.cpp
index 91bb3e5..763fba5 100644
--- a/src/backend/db_sqlite.cpp
+++ b/src/backend/db_sqlite.cpp
@@ -245,6 +245,26 @@ int BackendDB::removeGroup(const Group &group) {
 	return output;
 }
 
+// permanently delete removed/hidden groups and entries
+void BackendDB::cleanHidden() {
+	{
+		QSqlDatabase database(this->openDB());
+		QSqlQuery query;
+
+		// remove rules associated with hidden entries
+		query.exec("DELETE FROM rules WHERE id IN ("
+				"SELECT rules.id FROM rules"
+				"INNER JOIN entries ON rules.entry_id = entries.id"
+				"WHERE entries.hidden = 1)");
+		// remove hidden entries
+		query.exec("DELETE FROM entries WHERE hidden = 1");
+		// remove hidden groups
+		query.exec("DELETE FROM groups WHERE hidden = 1");
+	}
+
+	QSqlDatabase::removeDatabase("qt_sql_default_connection");
+}
+
 QString BackendDB::getDBPath() {
 	QSettings settings;
 	settings.beginGroup("paths");