Spaces:
Sleeping
Sleeping
File size: 2,166 Bytes
6ea020b | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | """Schema audit: compare model definitions vs actual database columns."""
import sys, os
sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
import sqlite3
from sqlmodel import SQLModel
# Import all models to register them
from app.models import *
project_root = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
DB_PATH = os.path.join(project_root, "lab_database.db")
conn = sqlite3.connect(DB_PATH)
# 1. Get DB schema
db_schema = {}
tables = [r[0] for r in conn.execute("SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'").fetchall()]
for t in tables:
cols = set(r[1] for r in conn.execute(f"PRAGMA table_info(\"{t}\")").fetchall())
db_schema[t.lower()] = cols
# 2. Get model schema
model_schema = {}
for table_name, table_obj in SQLModel.metadata.tables.items():
model_schema[table_name.lower()] = set(col.name for col in table_obj.columns)
# 3. Compare
print("=" * 60)
print(" NexLab Schema Audit: Models vs Database")
print("=" * 60)
issues = []
# Tables in models but not in DB
for table in sorted(model_schema.keys()):
if table not in db_schema:
issues.append(f"MISSING TABLE: '{table}' exists in models but NOT in database")
print(f"\n[MISSING TABLE] {table}")
print(f" Columns needed: {sorted(model_schema[table])}")
# Columns comparison
for table in sorted(model_schema.keys()):
if table in db_schema:
model_cols = model_schema[table]
db_cols = db_schema[table]
missing_in_db = model_cols - db_cols
extra_in_db = db_cols - model_cols
if missing_in_db or extra_in_db:
print(f"\n[MISMATCH] {table}")
for col in sorted(missing_in_db):
issues.append(f"MISSING COLUMN: {table}.{col}")
print(f" MISSING in DB: {col}")
for col in sorted(extra_in_db):
print(f" EXTRA in DB (not in model): {col}")
if not issues:
print("\n [OK] All models match the database schema perfectly!")
else:
print(f"\n{'=' * 60}")
print(f" TOTAL ISSUES: {len(issues)}")
print(f"{'=' * 60}")
conn.close()
|