summaryrefslogtreecommitdiffstats
path: root/migdb.py
diff options
context:
space:
mode:
authorArno <am@disconnect.de>2010-07-29 20:41:07 +0200
committerArno <am@disconnect.de>2010-07-29 20:41:07 +0200
commit5926a52a30428a2fa10ff8f367e4cb4355f62c2d (patch)
tree2c82ef867ce0e9863658107e9d405f823a7a50d5 /migdb.py
parentd27a1ac45fddeeb4a0bc1220f3858534f5aeca37 (diff)
downloadSheMov-5926a52a30428a2fa10ff8f367e4cb4355f62c2d.tar.gz
SheMov-5926a52a30428a2fa10ff8f367e4cb4355f62c2d.tar.bz2
SheMov-5926a52a30428a2fa10ff8f367e4cb4355f62c2d.zip
Don't add quality to covers
Fix adding quality to cover files in database by binding a NULL value when type != Movie in FilesTreeModel. While fixing this I discovered a typo in the database schema. The sequence for genres was named genres_igrenres_id__seq. Removed the superfluous 'r' in the name and fixed migdb.py on the way. Now SheMov doesn't crash any more when adding a new series part, but the new item still doesn't get selected...
Diffstat (limited to 'migdb.py')
-rw-r--r--migdb.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/migdb.py b/migdb.py
index a5babb4..ca3d75d 100644
--- a/migdb.py
+++ b/migdb.py
@@ -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