Added database maintenance code

Implemented a function in MappingTableModel to remove all actors/genres
with no references in the according mapping table. Available through the
"File" menu.

1 files changed, 6 insertions, 0 deletions

diff --git a/mappingtablemodel.h b/mappingtablemodel.h
index ae64600..9d00f72 100644
--- a/mappingtablemodel.h
+++ b/mappingtablemodel.h
@@ -41,6 +41,10 @@ class MappingTableModel : public SmTreeModel{
 		bool removeMapping(int seriesId, int itemId);
 		QList<QVariant> mappings(int seriesId);
 
+		//database maintenance
+		QHash<QString, int> zeroUsers();
+		void deleteItems(const QList<int> &ids);
+
 	signals:
 		void needResort();
 
@@ -61,6 +65,8 @@ class MappingTableModel : public SmTreeModel{
 		QSqlQuery *mAddMappingQuery;
 		QSqlQuery *mRemoveMappingQuery;
 		QSqlQuery *mMappingQuery;
+		QSqlQuery *mAllItemsQuery;
+		QSqlQuery *mItemCountQuery;
 };
 
 #endif // MAPPINGTABLEMODEL_H