# app/repositories/queries/mission_queries.py
"""
HealthSync AI 미션 관련 쿼리 모음
"""


class MissionQueries:
    """미션 관련 쿼리"""

    # 사용자 미션 정보 조회
    GET_USER_MISSION_BY_ID = """
        SELECT 
            umg.mission_id,
            umg.member_serial_number,
            umg.mission_name,
            umg.mission_description,
            umg.daily_target_count,
            umg.is_active,
            umg.performance_date,
            umg.created_at
        FROM goal_service.user_mission_goal umg
        WHERE umg.mission_id = :mission_id
    """

    # 사용자별 활성 미션 목록 조회
    GET_ACTIVE_MISSIONS_BY_USER = """
        SELECT 
            umg.mission_id,
            umg.mission_name,
            umg.mission_description,
            umg.daily_target_count,
            umg.performance_date
        FROM goal_service.user_mission_goal umg
        WHERE umg.member_serial_number = :user_id
        AND umg.is_active = true
        ORDER BY umg.created_at DESC
    """