summaryrefslogtreecommitdiff
path: root/Projekt/app/database.py
diff options
context:
space:
mode:
Diffstat (limited to 'Projekt/app/database.py')
-rw-r--r--Projekt/app/database.py38
1 files changed, 0 insertions, 38 deletions
diff --git a/Projekt/app/database.py b/Projekt/app/database.py
deleted file mode 100644
index 1abafa0..0000000
--- a/Projekt/app/database.py
+++ /dev/null
@@ -1,38 +0,0 @@
-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)