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

def get_service_list(
    payload,
    request_data,
    db: Session) -> dict:
    """
    Fetch all experts using SQLAlchemy ORM.
    """
    # Query the database using ORM
    services = (
        db.query(ExpertServices.xcs_id, ExpertServices.xcs_service_name)  # Specify columns
        .filter(ExpertServices.xcs_status == 1)  # Add filter for status
        .all()  # Execute the query and fetch results
    )

    # Transform query result into a list of dictionaries
    service_list = [{"id": service[0], "name": service[1]} for service in services]
    access_token = request_data["access_token"]
    isExpired = request_data["isExpired"]
    return {"service_list": service_list, "access_token": access_token, "isExpired": isExpired}