| import sqlite3
|
| from pathlib import Path
|
|
|
| DB_PATH = Path(__file__).resolve().parents[2] / "demo" / "data" / "audiodescriptions.db"
|
|
|
|
|
| def main() -> None:
|
| print(f"DB path: {DB_PATH} exists={DB_PATH.exists()}")
|
| if not DB_PATH.exists():
|
| return
|
|
|
| conn = sqlite3.connect(str(DB_PATH))
|
| conn.row_factory = sqlite3.Row
|
| cur = conn.cursor()
|
|
|
|
|
| cur.execute(
|
| "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'"
|
| )
|
| tables = [r[0] for r in cur.fetchall()]
|
| print("\nTABLAS EN audiodescriptions.db:")
|
| for t in tables:
|
| print(f" - {t}")
|
|
|
| print("\nRESUMEN POR TABLA Y COLUMNA:\n")
|
|
|
| for table in tables:
|
| print(f"=== Tabla: {table} ===")
|
|
|
|
|
| cur.execute(f"SELECT COUNT(*) AS n FROM {table}")
|
| row_count = cur.fetchone()["n"]
|
| print(f"Filas totales: {row_count}")
|
|
|
|
|
| cur.execute(f"PRAGMA table_info({table})")
|
| cols = [r[1] for r in cur.fetchall()]
|
|
|
| for col in cols:
|
|
|
| cur.execute(f"SELECT COUNT(DISTINCT {col}) AS n_distinct FROM {table}")
|
| n_distinct = cur.fetchone()["n_distinct"]
|
|
|
|
|
| cur.execute(
|
| f"SELECT COUNT(*) AS n_missing FROM {table} "
|
| f"WHERE {col} IS NULL OR (typeof({col}) = 'text' AND TRIM({col}) = '')"
|
| )
|
| n_missing = cur.fetchone()["n_missing"]
|
|
|
| print(
|
| f" - Columna '{col}': distintos={n_distinct}, "
|
| f"missing (NULL o '')={n_missing}"
|
| )
|
|
|
| print("")
|
|
|
| conn.close()
|
|
|
|
|
| if __name__ == "__main__":
|
| main()
|
|
|
