# backend/database.py
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from urllib.parse import quote_plus # Import the encoder

# --- ZMIEŃ TE DANE NA WŁASNE! ---
DB_USER = "db_user"
DB_PASSWORD_RAW = "Jedendwa12!@" # Twoje oryginalne hasło
DB_HOST = "localhost"
DB_NAME = "schock_helper"

# Python automatycznie zakoduje hasło
DB_PASSWORD_ENCODED = quote_plus(DB_PASSWORD_RAW)

DATABASE_URL = f"mysql+mysqlconnector://{DB_USER}:{DB_PASSWORD_ENCODED}@{DB_HOST}/{DB_NAME}"
# --- Koniec sekcji konfiguracji ---

engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()

def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()