| 247 | |
| 248 | |
| 249 | def _migrateUser(self): |
| 250 | if exists("pyload.db"): |
| 251 | try: |
| 252 | self.core.log.info(_("Converting old Django DB")) |
| 253 | except: |
| 254 | print "Converting old Django DB" |
| 255 | conn = sqlite3.connect('pyload.db') |
| 256 | c = conn.cursor() |
| 257 | c.execute("SELECT username, password, email from auth_user WHERE is_superuser") |
| 258 | users = [] |
| 259 | for r in c: |
| 260 | pw = r[1].split("$") |
| 261 | users.append((r[0], pw[1] + pw[2], r[2])) |
| 262 | c.close() |
| 263 | conn.close() |
| 264 | |
| 265 | self.c.executemany("INSERT INTO users(name, password, email) VALUES (?, ?, ?)", users) |
| 266 | move("pyload.db", "pyload.old.db") |
| 267 | |
| 268 | def createCursor(self): |
| 269 | return self.conn.cursor() |