database/db.py

import sqlite3

DB_PATH = "app.db"

def get_connection():

    return sqlite3.connect(DB_PATH)

def init_db():

    with open("database/schema.sql", "r") as f:
        schema = f.read()

    conn = get_connection()
    conn.executescript(schema)  # Виконуємо SQL з файлу
    conn.commit()
    conn.close()