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

load_dotenv()
# Get default connection url
url = os.getenv('DATABASE_URL')
# Create engine to connect to standard postgres DB to query other databases
base_url = url.rsplit('/', 1)[0] + '/postgres'
engine = create_engine(base_url)

with engine.connect() as conn:
    print("--- Databases on the PostgreSQL server ---")
    try:
        res = conn.execute(text("SELECT datname FROM pg_database WHERE datistemplate = false;"))
        for row in res:
            print(row[0])
    except Exception as e:
        print("Error listing databases:", e)
