recycle-docker/backend/database.py

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
import redis

DATABASE_URL = "mysql+pymysql://root:root@mysql:3306/recycle"

engine = create_engine(DATABASE_URL, pool_pre_ping=True)
SessionLocal = sessionmaker(bind=engine)

redis_client = redis.Redis(
    host="redis",
    port=6379,
    decode_responses=True
)