README.md

Job Data Repository

Requirements

• Java 17

Main Class

io.github.battorydev.springboot.demo.DemoApplication

REST Endpoint

GET /job_data

Returns all job data.

Request Parameter

• field - specify the fields to return.
  Filterable column: job title, salary, gender

• condition - apply query condition. Filterable field and operation:

  • title operand: =
  • salary operand: =, >=, >, <=, <
  • gender operand: =

• sort - field to sort. Sortable fields: title, salary

• sort_type - Sort order. ASC (default) or DESC

Sample URL request

• GET http://localhost:8080/job_data
• GET http://localhost:8080/job_data?fields=title,gender,salary
• GET http://localhost:8080/job_data?fields=title,salary&sort=salary
• GET http://localhost:8080/job_data?fields=title,salary&sort=salary&sort_type=DESC
• GET http://localhost:8080/job_data?fields=title,gender,salary&sort=title&condition=salary%3E=10000000

Documentation (Swagger)

http://localhost:8080/swagger-ui/index.html

Test Cases

• JobDataControllerTests#givenTitleAndSalaryField_whenGetJobData_showTitleAndSalaryOnly
• JobDataControllerTests#givenConditionSalaryGraterThan_whenGetJobData_returnJobSalaryGreaterThan
• JobDataControllerTests#givenSortAndSortType_whenGetJobData_returnSortedData