56 lines
1.6 KiB
Python
56 lines
1.6 KiB
Python
"""Schema-Migrationen fuer SjAudioSearch.
|
|
|
|
Die Version wird in ``PRAGMA user_version`` gespeichert. Jede Migration laeuft
|
|
in einer eigenen Transaktion, damit ein Abbruch keinen halb migrierten Zustand
|
|
hinterlaesst.
|
|
"""
|
|
|
|
from __future__ import annotations
|
|
|
|
import sqlite3
|
|
|
|
from ..utils.logging import get_logger
|
|
from .schema import SCHEMA_VERSION, TABLES_SQL
|
|
|
|
logger = get_logger("database.migrations")
|
|
|
|
|
|
def current_version(conn: sqlite3.Connection) -> int:
|
|
row = conn.execute("PRAGMA user_version").fetchone()
|
|
return int(row[0]) if row else 0
|
|
|
|
|
|
def _migration_1(conn: sqlite3.Connection) -> None:
|
|
conn.executescript(TABLES_SQL)
|
|
|
|
|
|
MIGRATIONS: list[tuple[int, object]] = [
|
|
(1, _migration_1),
|
|
]
|
|
|
|
|
|
def migrate(conn: sqlite3.Connection, target: int = SCHEMA_VERSION) -> int:
|
|
"""Fuehrt alle ausstehenden Migrationen aus und liefert die neue Version."""
|
|
version = current_version(conn)
|
|
if version > target:
|
|
raise RuntimeError(
|
|
f"Datenbankversion {version} ist neuer als die unterstuetzte Version {target}."
|
|
)
|
|
if version == target:
|
|
return version
|
|
|
|
for migration_version, migration in MIGRATIONS:
|
|
if migration_version <= version:
|
|
continue
|
|
logger.info("Migration %s wird angewendet", migration_version)
|
|
with conn:
|
|
migration(conn) # type: ignore[operator]
|
|
conn.execute(f"PRAGMA user_version = {int(migration_version)}")
|
|
version = migration_version
|
|
|
|
if version != target:
|
|
raise RuntimeError(
|
|
f"Migration unvollstaendig: Version {version}, erwartet {target}."
|
|
)
|
|
return version
|