import sqlite3
from pathlib import Path

DB_PATH = Path("/home/skeversu/skever-portal-v1/db copy")

print("=== BACKUP MIGRATION HISTORY ===")
print("Database:", DB_PATH)

uri = DB_PATH.resolve().as_uri() + "?mode=ro"

try:
    with sqlite3.connect(uri, uri=True, timeout=5) as conn:
        conn.execute("PRAGMA query_only = ON")

        rows = conn.execute("""
            SELECT app, name, applied
            FROM django_migrations
            WHERE app IN (
                'core', 'accounts', 'auth',
                'admin', 'contenttypes', 'sessions'
            )
            ORDER BY app, applied, name
        """).fetchall()

        if not rows:
            print("No matching migration records found.")

        for app, name, applied in rows:
            print(f"{app} | {name} | {applied}")

        print("\n=== TABLES AND MIGRATION RECORDS ===")
        print("Migration records returned:", len(rows))

except sqlite3.DatabaseError as exc:
    print("DATABASE ERROR:", repr(exc))

print("\n=== READ-ONLY CHECK COMPLETE ===")