piano_repertoire/builddb.py

import sqlite3

con = sqlite3.connect('repertoire.db')
cursor = con.cursor()

def execute_sql_from_file(filename, cursor):
    with open(filename) as sqlfile:
        sqlcommands = sqlfile.read()
    list_of_commands = sqlcommands.split(';')
    for command in list_of_commands:
        cursor.execute(command)


execute_sql_from_file('repertoire.sql', cursor)
execute_sql_from_file('composer.sql', cursor)
execute_sql_from_file('work.sql', cursor)
execute_sql_from_file('movement.sql', cursor)

con.commit()

# cursor.execute('COMMIT')

con.close()