# connectors/db.py
import os
from sqlalchemy import create_engine
from sqlalchemy.orm import declarative_base, sessionmaker

# You can also read from env
DATABASE_URL = os.getenv(
    "DATABASE_URL",
    "mysql+pymysql://root:zsVmczGzq9D0NRq1ZseKUrwyucWd0w@localhost:3306/blood_donation_dev_june_5",
)

engine = create_engine(
    DATABASE_URL,
    pool_pre_ping=True,
    future=True,
)

SessionLocal = sessionmaker(
    autocommit=False,
    autoflush=False,
    bind=engine,
    future=True,
)

# 👇 THIS is your shared Base for all models
Base = declarative_base()