| from sqlalchemy import create_engine | |
| from dotenv import load_dotenv | |
| import os | |
| load_dotenv() | |
| USER = os.getenv("POSTGRES_USER", "myuser") | |
| PWD = os.getenv("POSTGRES_PASSWORD", "mypass") | |
| DB = os.getenv("POSTGRES_DB", "mydb") | |
| PORT = os.getenv("DB_PORT", "5432") | |
| HOST = "localhost" | |
| engine = create_engine( | |
| f"postgresql+psycopg2://{USER}:{PWD}@{HOST}:{PORT}/{DB}", future=True | |
| ) | |
| if __name__ == "__main__": | |
| with engine.begin() as conn: | |
| print(conn.execute("select version();").scalar()) | |