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