From 6a6afdbe72c626b01245c9372c9d10be79789bb0 Mon Sep 17 00:00:00 2001
From: Rasmus Luha <rasmus.luha@gmail.com>
Date: Sun, 6 Feb 2022 13:41:11 +0200
Subject: restrucurring the stucture of the folderstruture --> structure

---
 app/database.py | 38 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100644 app/database.py

(limited to 'app/database.py')

diff --git a/app/database.py b/app/database.py
new file mode 100644
index 0000000..1abafa0
--- /dev/null
+++ b/app/database.py
@@ -0,0 +1,38 @@
+from sqlalchemy import create_engine  # Copied imports  from fastapi sqlalchemy docs.
+from sqlalchemy.ext.declarative import declarative_base
+from sqlalchemy.orm import sessionmaker
+from psycopg2.extras import RealDictCursor
+from time import sleep
+import psycopg2 #Library to connect to postgres
+from .config import settings
+
+SQLALCHEMY_DATABASE_URL = f'postgresql://{settings.database_username}:{settings.database_password}@{settings.database_hostname}:{settings.database_port}/{settings.database_name}'
+
+
+engine = create_engine(SQLALCHEMY_DATABASE_URL)
+
+SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
+Base = declarative_base()
+
+# Dependency
+def get_db():
+    db = SessionLocal()
+    try:
+        yield db
+    finally:
+        db.close()
+
+
+# Setting connection with DataBase
+# PS: thats only for reference --> kautad nüüd ju hoopiki sqlalchemyt db sessioniks. Ülal
+
+#while True:
+#    try:
+#        conn = psycopg2.connect(host='localhost', database='fastapi', user='postgres', password='password123', cursor_factory = RealDictCursor)#CursorFactory minig library teema, no matter::prg pole password
+#        cursor = conn.cursor()
+#        print("DataBase Connection Was a Huge and Massive Success!")
+#        break
+#    except Exception as error:
+#        print("Connecting to database failed")
+#        print("error was: ", error)
+#        sleep(3)
-- 
cgit v1.2.3