498266 - Update global_stats to record history and expose via API

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Statistics, defect)

Description

[Justin Scott [:fligtar]]

Attachment: patch, v1

This is a patch to keep a daily record of the global_stats, adds a bunch more global_stats, and exposes it via the API.

API URL: /api/1.3/stats/{optional date}

Comment 1

[Justin Scott [:fligtar]]

Attachment: SQL to be run

This is the SQL to be run. It drops and re-creates the table, since there will only be 2 rows in that table that will need to be removed anyway.

Comment 2

[Justin Scott [:fligtar]]

Attachment: sample output

Comment 3

[Wil Clouser [:clouserw]]

Comment on attachment 383212 [details] [diff] [review]
patch, v1

wfm.  Please add this to the top of the global_stats cron to fix the minor php warning:

$affected_rows = 0;

thanks

Comment 4

[Justin Scott [:fligtar]]

r27877 and r27879.

Added the SQL to wiki and ran on preview.

Note: this will require a SAMO push.