summaryrefslogtreecommitdiffstats
path: root/module/DatabaseBackend.py
diff options
context:
space:
mode:
Diffstat (limited to 'module/DatabaseBackend.py')
-rw-r--r--module/DatabaseBackend.py16
1 files changed, 16 insertions, 0 deletions
diff --git a/module/DatabaseBackend.py b/module/DatabaseBackend.py
index 5aa3365fa..ca4ab1e56 100644
--- a/module/DatabaseBackend.py
+++ b/module/DatabaseBackend.py
@@ -219,6 +219,22 @@ class DatabaseBackend(Thread):
self.c.executemany("INSERT INTO users(name, password, email) VALUES (?, ?, ?)", users)
move("pyload.db", "pyload.old.db")
+ if exists("web.db"):
+ try:
+ self.core.log.info(_("Moving users"))
+ except:
+ print "Moving users"
+ conn = sqlite3.connect('web.db')
+ c = conn.cursor()
+ c.execute("SELECT name, password, email, role, permission FROM users")
+ for r in c:
+ self.c.execute('SELECT name FROM users WHERE name=?', (r[0], ))
+ if self.c.fetchone() is None:
+ self.c.executemany("INSERT INTO users (name, password, email, role, permission) VALUES (?, ?, ?, ?, ?)", r)
+ c.close()
+ conn.close()
+
+ move("web.db", "web.old.db")
self.c.execute('VACUUM')
def createCursor(self):