search

revaturelabs / caliber-2-meta

Meta Repository for Caliber 2
5 stars 1 forks source link

Dummy Data seems non-helpful for implementing Service Fully #63

Closed Jwkellenberger closed 5 years ago

Jwkellenberger commented 5 years ago

@Quinn-Donnelly Example of data pull from the Assessment Service:

It seems impossible to coordinate the necessary functionality to migrate to caliber2 without a feature full database.

Assessments: All assessments have category of -1 and batchid of -1 /assessment/all/assessment/all

{"assessmentId":2050,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":1,"batchId":-1,"assessmentCategory":-1},{"assessmentId":2051,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":2,"batchId":-1,"assessmentCategory":-1},{"assessmentId":2052,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":3,"batchId":-1,"assessmentCategory":-1},{"assessmentId":2053,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":4,"batchId":-1,"assessmentCategory":-1},{"assessmentId":2054,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":5,"batchId":-1,"assessmentCategory":-1},{"assessmentId":2055,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":6,"batchId":-1,"assessmentCategory":-1},

All grades have trainee of -1 /assessment/all/grade/all

{"gradeId":1050,"dateReceived":1492636264377,"score":67.86,"assessmentId":2050,"traineeId":-1},{"gradeId":1051,"dateReceived":1492636276655,"score":87.04,"assessmentId":2050,"traineeId":-1},{"gradeId":1052,"dateReceived":1492636292339,"score":90.19,"assessmentId":2050,"traineeId":-1},{"gradeId":1053,"dateReceived":1492636304107,"score":88.3,"assessmentId":2050,"traineeId":-1},{"gradeId":1054,"dateReceived":1492636313001,"score":80.97,"assessmentId":2050,"traineeId":-1},{"gradeId":1055,"dateReceived":1492636327815,"score":77.67,"assessmentId":2050,"traineeId":-1},{"gradeId":1056,"dateReceived":1492636341049,"score":79.75,"assessmentId":2050,"traineeId":-1},{"gradeId":1057,"dateReceived":1492636349040,"score":86.63,"assessmentId":2050,"traineeId":-1},
Jwkellenberger commented 5 years ago

Actually, after digging around further, it seems the data integrity is fine. I expect this query behavior is for some reason expected?

For example, the data is appropriate in the H2 tables, now. And the query data is edited to -1 values.

For example: /assessment/all/assessment/all

[{"assessmentId":2050,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2051,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":2,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2052,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":3,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2053,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":4,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2054,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":5,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2055,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":6,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2056,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":6,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2057,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":7,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2058,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2059,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":2,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2060,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":3,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2061,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":4,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2062,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":5,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2063,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":6,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2064,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":7,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2065,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":7,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2066,"rawScore":40,"assessmentTitle":null,"assessmentType":"Verbal","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2067,"rawScore":40,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2068,"rawScore":20,"assessmentTitle":null,"assessmentType":"Other","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2069,"rawScore":50,"assessmentTitle":null,"assessmentType":"Verbal","weekNumber":2,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2070,"rawScore":50,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":2,"batchId":-1,"assessmentCategory":-1},
... ... ...

But, after looking up some batch id's that capability is actually functional

/assessment/all/assessment/batch/2100


[{"assessmentId":2058,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":1,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2059,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":2,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2060,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":3,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2061,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":4,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2062,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":5,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2063,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":6,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2064,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":7,"batchId":-1,"assessmentCategory":-1},
{"assessmentId":2065,"rawScore":100,"assessmentTitle":null,"assessmentType":"Exam","weekNumber":7,"batchId":-1,"assessmentCategory":-1}]

I was unaware that these values were appropriate in the H2 and only faulty in queries.