Quarry health point at /.health/summary/v1/<int:minutes> that indicates the number of created queries, revisions, runs by state in the last <minutes>.
Description for Google-Code-in-2018
Python skills are needed to work on Flask and SQLAlchemy frameworks.
Quarry is a simple web interface that can be used to execute queries on sql servers that contain Wikipedia data.
We want to develop the monitoring of this service, to be sure it works as excepted and to be notified if it doesn't. To get this the distant software that will perform the monitoring will in fact fetch on a regular basis a specific url, like /.health/summary/v1/<int:minutes>, where <int:minutes> is the period he want to get statistics for. This endpoint will return :
-number of created new queries
-number of created new revisions (that's a query SQL code version linked to a query ID)
-number of last query runs, grouped by state (successful, failed, ...)
So this task is to create this new api endpoint to these return computed values probably generated using SQLAlchemy functions.
Patch in gerrit in analytics/quarry/web repo wanted.