Something went wrong. Try again.
Reference implementation for the Phoenix Architecture. Work in progress. aicoding.leaflet.pub
Something went wrong. Try again.
1234567891011121314151617181920212223import osimport sqlite3
DB_PATH = os.environ.get("DB_PATH", "data/app.db")os.makedirs(os.path.dirname(DB_PATH) or ".", exist_ok=True)
db = sqlite3.connect(DB_PATH, check_same_thread=False)db.row_factory = sqlite3.Rowdb.execute("PRAGMA journal_mode = WAL")db.execute("PRAGMA foreign_keys = ON")
_migrations: list[tuple[str, str]] = []
def register_migration(name: str, sql: str) -> None: _migrations.append((name, sql))
def run_migrations() -> None: for _name, sql in _migrations: db.executescript(sql) db.commit()