db_builder.py

import sqlite3, pathlib

DB_PATH = pathlib.Path("company.db")
SCHEMA_FILE = pathlib.Path("schema.sql")

def build_db():
    DB_PATH.unlink(missing_ok=True)
    with sqlite3.connect(DB_PATH) as conn, open(SCHEMA_FILE) as f:
        conn.executescript(f.read())
    print("Database created")

if __name__ == "__main__":
    build_db()