testdb.py

import os
from sqlalchemy import create_engine, text

def test_detailed_connection():
    database_url = os.getenv("DATABASE_URL")
    
    if not database_url:
        return "DATABASE_URL is not set"
    
    try:
        # Try SQLAlchemy connection
        engine = create_engine(database_url)
        with engine.connect() as connection:
            result = connection.execute(text("SELECT version()"))
            version = result.scalar()
            
        return f"Connection successful! Database version: {version}"
    
    except Exception as e:
        return f"Connection failed: {str(e)}"

if __name__ == "__main__":
    test_detailed_connection()