Experimental project

This is a sandbox project, which contains experimental code for developer use only.

Queries, scripts, and related things for running core metrics queries on Drupal.org's staging.

To use this project, you need to have shell and database access on Drupal.org's staging server, and optionally access to the Core metric spreadsheets.

How to use this tool

  1. Clone the project into your home directory on Drupal.org's staging server.

    git clone --branch master http://git.drupal.org/sandbox/xjm/core_metrics.git core_metrics
cd core_metrics

  2. Execute the shell script for each query set:

    bash run_queries.sh criticals
bash run_queries.sh majors
bash run_queries.sh components
bash run_queries.sh beta

    This runs queries against staging's copy of the Drupal.org database. Note that some of the queries are slow. Be patient! (If you receive query errors about missing tables, staging is probably being rebuilt. Wait a couple hours and try again.)

  3. Run the PHP script to parse data from the CSV files into useful formats.

    php count_issues.php

    (NB: I do not apologize for the sprawling tangle of hacks in this script. It gets the job done.)

  4. Locate tabs in the Core metric spreadsheets that have names starting with (csv). For each, import the updated CSV file indicated in the tab name. Use the "Replace current sheet" option when importing to update the data in the tab.

  5. Check the tabs labeled (formulae) to make sure they were properly updated and have no errors.

  6. Check the tabs labeled (chart) to ensure they include the full range of data.

Project information

  • Created by xjm on , updated