Add: teste de conexão do python com postgres

SBD1 · Dec 18, 2024 · 46f155c · 46f155c
1 parent 3c10ece
commit 46f155c
Show file tree

Hide file tree

Showing 2 changed files with 16 additions and 0 deletions.
diff --git a/requirements.txt b/requirements.txt
@@ -0,0 +1,2 @@
+psycopg2-binary==2.9.3
+sqlalchemy==2.0.21
diff --git a/velho-oeste/main.py b/velho-oeste/main.py
@@ -0,0 +1,14 @@
+from sqlalchemy import create_engine
+
+def test_connection():
+    try:
+        # Formato de URL de conexão do SQLAlchemy
+        engine = create_engine('postgresql://velho_oeste_user:vopassword@velho-oeste-postgres:5432/velho_oeste_db')
+        connection = engine.connect()
+        print("Conexão bem-sucedida ao banco de dados!")
+        connection.close()
+    except Exception as e:
+        print(f"Erro na conexão: {e}")
+
+if __name__ == "__main__":
+    test_connection()