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

if __name__ == '__main__':
    load_dotenv()
    url = os.getenv('DATABASE_URL')
    print('DATABASE_URL:', url)
    if not url:
        raise RuntimeError('DATABASE_URL not set')
    engine = create_engine(url)
    with engine.connect() as conn:
        if url.startswith("sqlite"):
            result = conn.execute(text('SELECT sqlite_version();'))
        else:
            result = conn.execute(text('SELECT version();'))
        print('DB version:', result.fetchone())
        print('Database connection SUCCESSFUL!')

