diff options
| -rw-r--r-- | filestreemodel.cpp | 6 | ||||
| -rw-r--r-- | migdb.py | 4 |
2 files changed, 7 insertions, 3 deletions
diff --git a/filestreemodel.cpp b/filestreemodel.cpp index b02c8ac..1f224fd 100644 --- a/filestreemodel.cpp +++ b/filestreemodel.cpp @@ -254,7 +254,11 @@ bool FilesTreeModel::addFile(const QString &fullPath, int type, int quality, int mInsertFileQuery->bindValue(":dvd", dvd); mInsertFileQuery->bindValue(":type", type); mInsertFileQuery->bindValue(":fileno", filePart); - mInsertFileQuery->bindValue(":quality", quality); + if(type == Movie){ + mInsertFileQuery->bindValue(":quality", quality); + }else{ + mInsertFileQuery->bindValue(":quality", QVariant(QVariant::Int)); + } //insert item if(mInsertFileQuery->exec()){ @@ -24,7 +24,7 @@ class Migrator: cur = self.mNewConn.cursor() cur.execute("DELETE FROM series") cur.execute("SELECT setval('series_iseries_id__seq', 1)") - cur.execute("SELECT setval('genres_igrenres_id__seq', 1)") + cur.execute("SELECT setval('genres_igenres_id__seq', 1)") cur.execute("SELECT setval('seriesparts_seriesparts_id__seq', 1)") cur.execute("SELECT setval('actors_iactors_id__seq', 1)") cur.execute("DELETE FROM genres") @@ -123,7 +123,7 @@ class Migrator: print "Error %s" % (ex.pgerror,) self.mNewConn.rollback() return -1 - cur.execute("SELECT currval('genres_igrenres_id__seq')") + cur.execute("SELECT currval('genres_igenres_id__seq')") retval = cur.fetchone() self.mNewConn.commit() self.mNewGenreMap[genreName] = retval |