inital commit

1 files changed, 38 insertions, 0 deletions

diff --git a/Projekt/app/database.py b/Projekt/app/database.py
new file mode 100644
index 0000000..1abafa0
--- /dev/null
+++ b/Projekt/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)