deepakkumarsoni/aicoach
1
1# from sqlalchemy import create_engine2# from sqlalchemy.orm import sessionmaker, declarative_base3# from .core.config import settings4 5# DATABASE_URL = f"mysql+pymysql://{settings.MYSQL_USER}:{settings.MYSQL_PASSWORD}@{settings.MYSQL_HOST}/{settings.MYSQL_DB}"6 7# engine = create_engine(8# DATABASE_URL,9# pool_size=10, 10# max_overflow=20, 11# pool_recycle=3600, 12# pool_pre_ping=True 13# )14 15# SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)16 17# Base = declarative_base()18 19 20from sqlalchemy import create_engine21from sqlalchemy.orm import sessionmaker, declarative_base22from .core.config import settings23 24DATABASE_URL = f"mysql+pymysql://{settings.MYSQL_USER}:{settings.MYSQL_PASSWORD}@{settings.MYSQL_HOST}/{settings.MYSQL_DB}"25 26engine = create_engine(27 DATABASE_URL,28 pool_size=10, 29 max_overflow=20, 30 pool_recycle=3600, 31 pool_pre_ping=True,32 connect_args={"init_command": "SET time_zone='+00:00'"}33)34 35SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)36 37Base = declarative_base()38 