Python-сообщество

 if __name__=="__main__":
    conn = db.connect('old.sqlite')
    cur = conn.cursor()
    sql = [i.strip() for i in emptydb.split(';')]
    try:
        for i in sql:
            if i: cur.execute(i)
    except Exception as e:
        print str(e)
    else:
        print 'OK'    
    conn.commit()
    conn.close()

 ./datasql.py

 emptydb = """
PRAGMA foreign_keys = ON;
create table customer
(code integer primary key,
 name text,
 surname text,
 secname text,
 address text,
 phone integer);
create table route
(code integer primary key,
 country text,
 climate integer,
 durability integer,
 hotel text,
 value integer);
create table voucher
(code integer primary key,
 route integer references route(code) on update cascade on delete set null,
 customer integer references customer(code) on update cascade on delete set null,
 number integer,
 discount integer);
"""