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

load_dotenv()
url = os.getenv('DATABASE_URL')
# Change the database name to insurance_border_db
border_url = url.rsplit('/', 1)[0] + '/insurance_border_db'
print("Connecting to:", border_url)
engine = create_engine(border_url)
inspector = inspect(engine)

try:
    with engine.connect() as conn:
        print("\n--- TABLES AND ROW COUNTS IN insurance_border_db ---")
        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")
            
        print("\n--- Users in insurance_border_db ---")
        if 'users' in inspector.get_table_names():
            res = conn.execute(text("SELECT id, name, email FROM \"users\""))
            for row in res:
                print(row)
        else:
            print("No 'users' table in insurance_border_db.")
            
except Exception as e:
    print("Error:", e)
