You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We should have a way to list and search the raw test report JSON that we are storing. We should create the following endpoints:
GET /v3/report - Get a list of reports
GET /v3/report/dist/:dist_name - Get a list of reports about a distribution
GET /v3/report/author/:author_name - Get a list of reports about an author
Other fields could be added as query parameters for more constraints like ?grade=(pass|fail).
The above endpoints are only examples. If they can not perform decently, we cannot add them. We need to test these APIs against all the records (which means this cannot be released until the old test report records are migrated: cpan-testers/cpantesters-backend#6).
Since there are 80 million records and climbing, this will need to be paginated. Each endpoint should accept offset and limit parameters. The limit parameter must be less than or equal to 1000 (this number chosen because it matches the old Metabase log.txt limit). The output should contain pagination information along with the records returned, like:
There is a problem that doing a COUNT(*) on an InnoDB table in MySQL is super-slow. But, without that information, it becomes much harder to use the API.
The text was updated successfully, but these errors were encountered:
We should have a way to list and search the raw test report JSON that we are storing. We should create the following endpoints:
GET /v3/report
- Get a list of reportsGET /v3/report/dist/:dist_name
- Get a list of reports about a distributionGET /v3/report/author/:author_name
- Get a list of reports about an authorOther fields could be added as query parameters for more constraints like
?grade=(pass|fail)
.The above endpoints are only examples. If they can not perform decently, we cannot add them. We need to test these APIs against all the records (which means this cannot be released until the old test report records are migrated: cpan-testers/cpantesters-backend#6).
Since there are 80 million records and climbing, this will need to be paginated. Each endpoint should accept
offset
andlimit
parameters. The limit parameter must be less than or equal to 1000 (this number chosen because it matches the old Metabaselog.txt
limit). The output should contain pagination information along with the records returned, like:There is a problem that doing a
COUNT(*)
on an InnoDB table in MySQL is super-slow. But, without that information, it becomes much harder to use the API.The text was updated successfully, but these errors were encountered: