aboutsummaryrefslogtreecommitdiffstats
path: root/createdb.py
blob: 7f50807b02749880361babd80b32d56d0a8567d2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
import sqlite3
from argparse import ArgumentParser

if __name__ == "__main__":
    arg_parser = ArgumentParser()
    arg_parser.add_argument("-d", "--database", help="Name of the database file",
                            required=True)
    arg_parser.add_argument("-s", "--schema", help="File containing the db schema",
                            required=True)
    args = arg_parser.parse_args()

    conn = sqlite3.connect(args.database)
    c = conn.cursor()
    schema = open(args.schema)
    c.executescript( schema.read() )
    conn.commit()
    c.close()