diff options
| -rw-r--r-- | module/DatabaseBackend.py | 16 |
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): |