Graphql 쿼리 사용법 예제

[Likilee]

UseCase1) 특정 기수의 남녀 성비 데이터를 가져오고자 할 때,

Operation

query GetNumOfPeopleByFilter(
  $filtersGrade: Filter!
  $filtersMan: Filter!
  $filtersWoman: Filter!
) {
  man: getNumOfPeopleByFilter(filters: [$filtersGrade, $filtersMan])

  woman: getNumOfPeopleByFilter(filters: [$filtersGrade, $filtersWoman])
}

Variables

{
  "filtersGrade": {
    "entityName": "user",
    "column": "grade",
    "operator": "=",
    "givenValue": "2기",
    "lastest": true,
  },
  "filtersWoman": {
    "entityName": "userPersonalInformation",
    "column": "gender",
    "operator": "=",
    "givenValue": "여",
    "lastest": true
  },
  "filtersMan": {
    "entityName": "userPersonalInformation",
    "column": "gender",
    "operator": "=",
    "givenValue": "남",
    "lastest": true
  },
}

Response

{
  "data": {
    "man": 262,
    "woman": 22
  }
}

[jinbekim]

2022.07.25 추가

• lastest -> latest 로 수정 바람
• 마지막 인자는 , 제거 바람(스택오버플로우)

[Likilee]

쿼리에 기준 시점도 인자로 추가될 예정
latest : true 일 경우, 조인 테이블 로우 중 최신 값만 리턴 되고,
latest: false 일 경우, 조인 테이블에서 데이터 전체 가져오게됨.

[Likilee]

Table 데이터 가져오기 위한 쿼리 테스트

query Test($filtersMan: Filter!, $learningData: Filter!){
  getPeopleByFilter(filters: [$filtersMan, $learningData]) {
    name,
    grade,
    coalition,
    userPersonalInformation {
      age,
      gender
    },
    userLearningDataAPI {
      circle,
      coalition_score
    } 
  }
}

필터 변수

{
  "filtersMan": {
    "entityName": "userPersonalInformation",
    "column": "gender",
    "operator": "=",
    "givenValue": "여",
    "latest": true
  },
  "learningData" : {
    "entityName": "userLearningDataAPI",
    "column": null,
  	"operator": null,
    "givenValue": null,
    "latest":true
  }
}

[Likilee]

getPeopleByfilters로 모든 필드 가져오기

Qeury

query GetTableDatas($User: Filter!, $UserPersonalInformation: Filter!, $UserCourseExtension: Filter!, $UserLeaveOfAbsence: Filter!, $UserBlackhole: Filter!, $UserInterruptionOfCourse: Filter!, $UserLearningDataAPI: Filter!, $UserLoyaltyManagement: Filter!, $UserEmploymentStatus: Filter!, $UserHrdNetUtilizeConsent: Filter!, $UserHrdNetUtilize: Filter!, $UserOtherEmploymentStatus: Filter!, $UserComputationFund: Filter!, $UserAccessCardInformation: Filter!, $UserOtherInformation: Filter!, $UserLapiscineInformation: Filter!) {
    getPeopleByFilter(
      filters: [$User, $UserPersonalInformation, $UserCourseExtension, $UserLeaveOfAbsence, $UserBlackhole, $UserInterruptionOfCourse, $UserLearningDataAPI, $UserLoyaltyManagement, $UserEmploymentStatus, $UserHrdNetUtilizeConsent, $UserHrdNetUtilize, $UserOtherEmploymentStatus, $UserComputationFund, $UserAccessCardInformation, $UserOtherInformation, $UserLapiscineInformation]
    ) {
      intra_no
      intra_id
      name
      grade
      start_process_date
      coalition
      academic_state
      uniqueness
      anonymization
    userPersonalInformation {
        region
        gender
        birthday
        social_security_key
        age
        phone_number
        email
    }
    userCourseExtension {
        basic_expiration_date
        request_extension
        final_expiration_date
        extension_level
        extension_circle
    }
    userLeaveOfAbsence {
        absenced
        begin_absence_date
        end_absence_date
        return_from_absence_date
        absence_reason
        AGU_reason
        uniqueness
    }
    userBlackhole {
        blackholed
        blackhole_date
        reason_of_blackhole
        blackholed_level
        remarks
    }
    userInterruptionOfCourse {
        breaked
        break_date
        reason_of_break
        HRD_Net_drop_out
    }
    userLearningDataAPI {
        coalition_score
        scored_date
        circle
        circled_date
        level
        leveled_date
        outcircle
        outcircled_date
    }
    userLoyaltyManagement {
        loyalty_period
        loyalty_presence
        loyalty_circle
    }
    userEmploymentStatus {
        employmented
        employment_date
        enterprise
    }
    userHrdNetUtilizeConsent {
        consent_to_provide_information
        consented_date
    }
    userHrdNetUtilize {
        hrd_net_date
        employmented
        business_registration_number
        employment_insurance_date
        enterprise_size
        health_insurance_enterprise
    }
    userOtherEmploymentStatus {
        employment_date
        enterprise
    }
    userComputationFund {
        payment_date
        received
        recevied_amount
    }
    userAccessCardInformation {
        profile_picture_path
        lapiscine_physical_number
        lapiscine_logical_number
        logical_number_for_main_course
        name_of_entry_card_for_main_course
    }
    userOtherInformation {
        highest_level_of_education
        majored
        major_name
    }
    userLapiscineInformation {
        lapiscine_grade
        lapiscine_degree
        record_participate_lapiscine
        lapiscine_final_score
    }
  }
}

Variable

{
  "User": {
    "entityName": "user",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserAccessCardInformation": {
    "entityName": "userAccessCardInformation",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserBlackhole": {
    "entityName": "userBlackhole",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserComputationFund": {
    "entityName": "userComputationFund",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserCourseExtension": {
    "entityName": "userCourseExtension",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserEmploymentStatus": {
    "entityName": "userEmploymentStatus",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserHrdNetUtilize": {
    "entityName": "userHrdNetUtilize",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserHrdNetUtilizeConsent": {
    "entityName": "userHrdNetUtilizeConsent",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserInterruptionOfCourse": {
    "entityName": "userInterruptionOfCourse",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserLapiscineInformation": {
    "entityName": "userLapiscineInformation",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserLearningDataAPI": {
    "entityName": "userLearningDataAPI",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserLeaveOfAbsence": {
    "entityName": "userLeaveOfAbsence",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserLoyaltyManagement": {
    "entityName": "userLoyaltyManagement",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserOtherEmploymentStatus": {
    "entityName": "userOtherEmploymentStatus",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserOtherInformation": {
    "entityName": "userOtherInformation",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  },
  "UserPersonalInformation": {
    "entityName": "userPersonalInformation",
    "column": null,
    "operator": null,
    "givenValue": null,
    "latest": true
  }
}