Files
cryptopad/migrate.py
2023-03-15 20:13:34 -04:00

17 lines
335 B
Python

import anydbm
import sqlite3
data = anydbm.open("cryptopad.db", 'c');
con = sqlite3.connect("my.db")
con.text_factory = str
con.execute("CREATE TABLE data (k BLOB, v BLOB, PRIMARY KEY (`k`))")
cur = con.cursor()
for k,v in data.iteritems():
print k
cur.execute("INSERT INTO data VALUES (?,?)", [k,v])
con.commit()