Actors and genre edit

Implemented widgets for actor and genre editing of movies. Created new
MappingTableWidget for both genres and actors and revamped
ArchiveTreeView to show 2 widgets below the FilesTreeView separated by a
splitter.

While testing the new setup several bugs were fixed:
-an SQL syntax error in FilesTreeModel
-fixed SmModelSingleton to properly work with table names

I also changed the signature of MappingTableModel::addMapping for the
ease of use and added MappingTableModel::removeMapping.
MappingTableModel got 2 new convenience functions:
1. bool contains(QString) to check if an item is already present
2. QModelIndex find() to get the index of a specific value from the
model.

1 files changed, 5 insertions, 1 deletions

diff --git a/mappingtablemodel.h b/mappingtablemodel.h
index f624bff..d600437 100644
--- a/mappingtablemodel.h
+++ b/mappingtablemodel.h
@@ -29,13 +29,16 @@ class MappingTableModel : public SmTreeModel{
 		virtual Qt::ItemFlags flags(const QModelIndex &index) const;
 		virtual QVariant data(const QModelIndex &index, int role) const;
 		virtual bool setData(const QModelIndex &index, const QVariant &value, int role);
+		bool contains(const QString &value) const;
+		QModelIndex find(const QVariant &value, int column = 0, const QModelIndex &parent = QModelIndex()) const;
 
 		//add and remove items
 		bool addItem(const QVariant &name);
 		bool removeItem(const QModelIndex &idx);
 
 		//mappings
-		bool addMapping(int seriesId, const QList<int> &itemIds);
+		bool addMapping(int seriesId, int itemId);
+		bool removeMapping(int seriesId, int itemId);
 		QList<QVariant> mappings(int seriesId);
 
 	signals:
@@ -56,6 +59,7 @@ class MappingTableModel : public SmTreeModel{
 		QSqlQuery *mInsertItemQuery;
 		QSqlQuery *mDeleteItemQuery;
 		QSqlQuery *mAddMappingQuery;
+		QSqlQuery *mRemoveMappingQuery;
 		QSqlQuery *mMappingQuery;
 };