def createFinalDb(workFileName, finalFileName): dumpFileName = "dump.sql" print("Dumping into %s" % dumpFileName) dumpFile = open(dumpFileName, "w", encoding='utf-8') dump.dumpDatabase(workFileName, dumpFile) dumpFile.close() database = db.Database(finalFileName, True, updateMode=True) print("Restoring dump from %s into %s" % (dumpFileName, finalFileName)) err = subprocess.call(["sqlite3", finalFileName, ".read %s" % dumpFileName]) if err != 0: raise Exception("Dump restoration failed")
def createFinalDb(workFileName, finalFileName): dumpFileName = "dump.sql" print "Dumping into %s" % dumpFileName dumpFile = file(dumpFileName, "w") dump.dumpDatabase(workFileName, dumpFile) dumpFile.close() print "Restoring dump from %s into %s" % (dumpFileName, finalFileName) sqlhub.processConnection = connectionForURI("sqlite:" + finalFileName) db.createTables() err = subprocess.call(["sqlite3", finalFileName, ".read %s" % dumpFileName]) if err != 0: raise Exception("Dump restoration failed")