import pymysql
from .settings import DB_CONFIG


def connect_db():
    """Conecta con la base de datos local de Flask."""
    try:
        conn = pymysql.connect(**DB_CONFIG)
        return conn
    except Exception as e:
        print(f"❌ Error al conectar a la base de datos: {e}")
        return None

def save_order(user_id, request_text):
    """Guarda el pedido en la base de datos local."""
    conn = connect_db()
    if not conn:
        return False

    try:
        with conn.cursor() as cursor:
            sql = "INSERT INTO wp_orders (user_id, request_text) VALUES (%s, %s)"
            cursor.execute(sql, (user_id, request_text))
            conn.commit()
            print(f"✅ Pedido guardado: {user_id} - {request_text}")
            return True
    except Exception as e:
        print(f"❌ Error guardando pedido en la BD: {e}")
        return False
    finally:
        conn.close()