| from sqlalchemy import create_engine | |
| from sqlalchemy.ext.declarative import declarative_base | |
| from sqlalchemy.orm import sessionmaker | |
| from dotenv import load_dotenv | |
| load_dotenv() | |
| import os | |
| ##pymysql | |
| ##mysql -u root -p users | |
| DB_URL = os.getenv('MYSQL_URI') | |
| engine = create_engine( | |
| DB_URL, | |
| pool_pre_ping=True, | |
| pool_recycle=3600, | |
| ) | |
| SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) | |
| Base = declarative_base() | |