import os
from dotenv import load_dotenv
from sqlalchemy import create_engine, inspect, text

load_dotenv()
url = os.getenv('DATABASE_URL')
print('DATABASE_URL:', url)
if not url:
    print('No DATABASE_URL found')
    exit(1)

engine = create_engine(url)
inspector = inspect(engine)

try:
    with engine.connect() as conn:
        print("\n--- TABLES AND ROW COUNTS ---")
        for table_name in inspector.get_table_names():
            res = conn.execute(text(f'SELECT COUNT(*) FROM "{table_name}"'))
            count = res.scalar()
            print(f"Table '{table_name}': {count} rows")
except Exception as e:
    print("Error:", e)
