import os from urllib.parse import quote_plus from dotenv import load_dotenv from sqlalchemy import create_engine from sqlalchemy.orm import declarative_base, sessionmaker load_dotenv() def build_database_url(): database_url = os.getenv("DATABASE_URL") if database_url: return database_url user = os.getenv("DB_USER", "root") password = quote_plus(os.getenv("DB_PASSWORD", "")) host = os.getenv("DB_HOST", "localhost") port = os.getenv("DB_PORT", "3306") name = os.getenv("DB_NAME", "speedotector") return f"mysql+pymysql://{user}:{password}@{host}:{port}/{name}" DATABASE_URL = build_database_url() engine = create_engine(DATABASE_URL, echo=False) SessionLocal = sessionmaker(bind=engine, autoflush=False, autocommit=False) Base = declarative_base() def create_tables(): Base.metadata.create_all(bind=engine)