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