Executes sql from schema.sql file into database

db_init.py

import sqlite3

def dbinit():
    connection = sqlite3.connect('database.db')
    with open('schema.sql') as f:
        connection.executescript(f.read())
    cur = connection.cursor()
    connection.commit()
    connection.close()