Update global_stats to record history and expose via API

RESOLVED FIXED in 5.0.7

Status

RESOLVED FIXED
10 years ago
3 years ago

People

(Reporter: fligtar, Assigned: fligtar)

Tracking

Details

Attachments

(3 attachments)

(Assignee)

Description

10 years ago
Posted patch patch, v1Splinter Review
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}
Attachment #383212 - Flags: review?(clouserw)
(Assignee)

Comment 1

10 years ago
Posted file 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.
(Assignee)

Comment 2

10 years ago
Posted file sample output
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
Attachment #383212 - Flags: review?(clouserw) → review+
(Assignee)

Comment 4

10 years ago
r27877 and r27879.

Added the SQL to wiki and ran on preview.

Note: this will require a SAMO push.
Status: ASSIGNED → RESOLVED
Last Resolved: 10 years ago
Keywords: push-needed
Resolution: --- → FIXED
Keywords: push-needed
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.