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

load_dotenv()
url = os.getenv('DATABASE_URL')
engine = create_engine(url)
inspector = inspect(engine)

for table_name in ["User", "users"]:
    print(f"\nColumns in '{table_name}':")
    try:
        columns = inspector.get_columns(table_name)
        for col in columns:
            print(f"  {col['name']}: {col['type']} (Nullable: {col['nullable']})")
    except Exception as e:
        print(f"  Error reading columns for {table_name}: {e}")
