From 6d3b28f9b12964b161b5a7ac0038435cfdd6e27b Mon Sep 17 00:00:00 2001
From: Arno <am@disconnect.de>
Date: Sat, 31 Jul 2010 11:05:59 +0200
Subject: 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.
---
 mappingtablemodel.h | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'mappingtablemodel.h')

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
-- 
cgit v1.2.3-70-g09d2