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()
|