"""Per-request DB connection (PyMySQL, DictCursor) — same patterns as
scanner-ng. The site only READS parts/scan_count/last_price (+ future
builds tables), so connections are read-light. Dev → local mirror;
prod → vdb1b (read-only user)."""

from flask import current_app, g


def get_db():
    if "db" not in g:
        import pymysql
        g.db = pymysql.connect(
            host=current_app.config["DB_HOST"],
            port=current_app.config["DB_PORT"],
            user=current_app.config["DB_USER"],
            password=current_app.config["DB_PASSWORD"],
            database=current_app.config["DB_NAME"],
            charset="utf8mb4",
            cursorclass=pymysql.cursors.DictCursor,
            autocommit=True,
            connect_timeout=10,
            read_timeout=30,
        )
    return g.db


def close_db(_exc=None):
    db = g.pop("db", None)
    if db is not None:
        db.close()


def init_app(app):
    app.teardown_appcontext(close_db)
