23 lines
426 B
Python
23 lines
426 B
Python
DB_VERSION = 1
|
|
|
|
|
|
def check_db(conn):
|
|
cur = conn.cursor()
|
|
|
|
cur.execute("SELECT value FROM meta WHERE name='version'")
|
|
|
|
ver = cur.fetchone()
|
|
if ver:
|
|
ver = int(ver)
|
|
|
|
if ver < DB_VERSION:
|
|
upgrade_db(conn, ver, DB_VERSION)
|
|
else:
|
|
with open('sql/ledd.sql', 'r') as f:
|
|
cur.executescript(f.read())
|
|
conn.commit()
|
|
|
|
|
|
def upgrade_db(conn, old, new):
|
|
pass
|