from sqlalchemy.orm import Session
from db.models.ExpertDetails import ExpertDetails

def get_all_expert_names(
    payload,
    request_data,
    db: Session) -> dict:
    """
    Fetch all experts using SQLAlchemy ORM.
    """
    # Query the database using ORM
    experts = (
        db.query(ExpertDetails.mxd_id, ExpertDetails.mxd_expert_name)  # Specify columns
        .filter(ExpertDetails.mxd_expert_status == 1)  # Add filter for status
        # .limit(5)  # Limit to 5 results
        .all()  # Execute the query and fetch results
    )

    # Transform query result into a list of dictionaries
    expert_list = [{"id": expert[0], "name": expert[1]} for expert in experts]
    access_token = request_data["access_token"]
    isExpired = request_data["isExpired"]
    return {"expert_names": expert_list, "access_token": access_token, "isExpired": isExpired}