import sqlite3
from pathlib import Path

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

print("=== READ-ONLY SQLITE INTEGRITY CHECK ===")
print("Target:", DB_PATH)

if not DB_PATH.is_file():
    print("STOP: Backup 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 RESULT ===")
        results = conn.execute("PRAGMA integrity_check").fetchall()

        for result in results:
            print(result[0])

        print("\n=== TABLES ===")
        tables = conn.execute("""
            SELECT name
            FROM sqlite_master
            WHERE type = 'table'
            ORDER BY name
        """).fetchall()

        for table in tables:
            print(table[0])

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

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