aboutsummaryrefslogtreecommitdiffstats
path: root/createdb.py
blob: 7ec9cd0cc3c91d2fabee848c24bc1ffcf99f2f42 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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, detect_types=sqlite3.PARSE_DECLTYPES)
    schema = open(args.schema)
    conn.executescript( schema.read() )
    conn.close()