Implement between query feature for client

[dragon0170]

Reference

24

• Client에 Between query 기능 추가
  • between query용 인터페이스 types.go에 추가
  • cli에 between query 커맨드 및 response 출력 추가

Between query 설계 초안

• path: /between

1. user key, type 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==",
  "type":"cpu"
  }

• response Value 예시

  [
  {"timestamp":1544772882435375000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"YWJj"},
  {"timestamp":1544772960049177000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"ZGVm"},
  {"timestamp":1544772967331458000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"Z2hp"}
  ]

  2. user key 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ=="
  }

• response Value 예시

  [
  {"timestamp":1544772882435375000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"YWJj"},
  {"timestamp":1544772960049177000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"mem","data":"ZGVm"},
  {"timestamp":1544772967331458000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"speed","data":"Z2hp"}
  ]

  3. type 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "type":"cpu"
  }

• response Value 예시

  [
  {"timestamp":1544772882435375000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"YWJj"},
  {"timestamp":1544772960049177000,"userKey":"RMMfqsKyYVV4i89jCgGgF5VXaODpf2HCpX4tShmnXWh8XO4wZwEdcZJ27D18GazZe5/h+P6rir5G1v3yzjx7Sw==","type":"cpu","data":"ZGVm"},
  {"timestamp":1544772967331458000,"userKey":"Ky6L4XxaFX9ZAutbzGNPHyZDEKFaDYqiq/MfjKI6fTZajmtSy6lO030VPPGAvtzbpAqxW6H1tPREPu9a+qJasQ==","type":"cpu","data":"Z2hp"}
  ]

  4. 시간만 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000
  }

• response Value 예시

  [
  {"timestamp":1544772882435375000,"userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==","type":"cpu","data":"YWJj"},
  {"timestamp":1544772960049177000,"userKey":"RMMfqsKyYVV4i89jCgGgF5VXaODpf2HCpX4tShmnXWh8XO4wZwEdcZJ27D18GazZe5/h+P6rir5G1v3yzjx7Sw==","type":"mem","data":"ZGVm"},
  {"timestamp":1544772967331458000,"userKey":"Ky6L4XxaFX9ZAutbzGNPHyZDEKFaDYqiq/MfjKI6fTZajmtSy6lO030VPPGAvtzbpAqxW6H1tPREPu9a+qJasQ==","type":"cpu","speed":"Z2hp"}
  ]

[dragon0170]

Working branch

• between-query branch in dragon0170/paust-db

[code-to-gold]

4. 의 response value에서 speed는 뭔가요?

[dragon0170]

https://github.com/paust-team/paust-db/issues/29#issuecomment-448843741 오타네요ㅋㅋㅋㅋ type의 값을 변경한다는 게 실수로 data를 변경했네요.

[dragon0170]

type BetweenQuery struct {
    Start   int64  `json:"start"`
    End     int64  `json:"end"`
    UserKey []byte `json:"userKey"`
    Type    string `json:"type"`
}

• between query의 경우 client와 server에서 데이터 처리를 편리하게 하기위해 위와 같이 하나의 struct로 통일하였습니다.
• https://github.com/paust-team/paust-db/issues/29#issue-392461477 에 있는 request data는 아래와 같이 변경하였습니다.

1. user key, type 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==",
  "type":"cpu"
  }

  2. user key 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":"Krc92XkJ+LhkDMO+Qe1utVg1KNGbXdhri3Ol9u5dIAY97w88jgyruQkiMMmN9+hOXqzkR7MZBLIhy7ljYpgNoQ==",
  "type":""
  }

  3. type 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":null
  "type":"cpu"
  }

  4. 시간만 명시

• request Data 예시

  {
  "start":1544772882435375000,
  "end":1544772967331462000,
  "userKey":null,
  "type":""
  }

[dragon0170]

https://github.com/paust-team/paust-db/issues/22#issuecomment-448918493 의 영향으로 아래와 같이 query struct 통일

type DataQuery struct {
    Start   int64  `json:"start"`
    End     int64  `json:"end"`
    UserKey []byte `json:"userKey"`
    Type    string `json:"type"`
}