import sqlite3
from pathlib import Path

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

print("=== LIVE SQLITE READ-ONLY CHECK ===")
print("Database:", DB_PATH)

if not DB_PATH.is_file():
    print("STOP: Database file not found.")
    raise SystemExit(1)

print("File size:", DB_PATH.stat().st_size, "bytes")

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

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

        print("\n=== INTEGRITY CHECK ===")
        for row in conn.execute("PRAGMA integrity_check"):
            print(row[0])

        print("\n=== MIGRATION RECORDS ===")
        rows = conn.execute("""
            SELECT app, name, applied
            FROM django_migrations
            WHERE app IN ('core', 'accounts')
            ORDER BY app, applied, name
        """).fetchall()

        for row in rows:
            print(" | ".join(str(value) for value in row))

        print("\n=== CHECK COMPLETE ===")

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