from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

import config
from .sql_generated import *
import configparser

alembic = configparser.ConfigParser()
alembic.read("alembic.ini")

dburl = config.DBURL

engine = create_engine(
    dburl,
    pool_pre_ping=True,
    pool_recycle=1800
)

ergoEngine = create_engine(
    dburl,
    pool_pre_ping=True,
    pool_recycle=1800
)

SessionMaker = sessionmaker(autocommit=False, autoflush=False, bind=engine, )