diff options
Diffstat (limited to 'createdb.py')
| -rw-r--r-- | createdb.py | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/createdb.py b/createdb.py new file mode 100644 index 0000000..7f50807 --- /dev/null +++ b/createdb.py @@ -0,0 +1,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() |
