Google Code-in

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.

The software has a list of recent executed queries at /query/runs/all. Recently, since T126888: Show execution time in the Recent Queries page, the execution time of each query_run is stored internally in the database.

This task is about adding a column in the table of recent queries that contains each execution time. It's needed to look at https://phabricator.wikimedia.org/T126888 patch where is stored the execution time, and in the creation of the table for each query decode its value of last query_run and show it in the new column (edit rendered template and amend where it is populated with data).

You are expected to provide a patch in Wikimedia Gerrit. The repository is analytics/quarry/web. See https://www.mediawiki.org/wiki/Gerrit/Tutorial for how to set up Git and Gerrit.