492998 - implement AMO 2009 home page stats

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Les Orchard [:lorchard]]

See: https://bugzilla.mozilla.org/show_bug.cgi?id=490906#c5

The new design calls for vitality statistics on the home page, including all-time downloads and daily downloads.

These counts should be calculated in a maintenance script and stashed in a table for the home page to fetch and display,

Comment 1

[Les Orchard [:lorchard]]

Per nick's comment (https://bugzilla.mozilla.org/show_bug.cgi?id=490906#c8)...

Guessing these are the queries I need for this:

add-ons downloaded = SELECT SUM(count) FROM download_counts;
add-ons in use = SELECT SUM(count) FROM update_counts WHERE date > ( now() - INTERVAL 1 DAY )

Do we happen to have this data anywhere already in a summary table?  Or, should introducing a summary table be part of this bug?  Definitely needs to be in the maintenance script, since the "downloaded" query took 30 seconds on my laptop

Comment 2

[Les Orchard [:lorchard]]

Attachment: implementation of a global stats model, with maintenance script to update home page stats

I couldn't find a global stats summary table, so this patch introduces one.  The maintenance script gets a new 'global_stats' command that updates the two counts used by the home page.  A new model class lets the home page controller fetch the counts and pass them to the view.

r? to clouserw, but feel free to pass it along if someone else has time

Comment 3

[Les Orchard [:lorchard]]

Filed bug 494171 to get the SQL into preview and added to:

https://wiki.mozilla.org/AMO:Developers/Database_Changes#5.0.6

Will wait until the DB changes are made to check in, so as not to break anything.

Comment 4

[Les Orchard [:lorchard]]

bug 493320 closed, so checked in as r26088

FYI: The stats will not appear until the 'global_stats' maintenance.php command is
run on preview.

Comment 5

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED on https://preview.addons.mozilla.org/en-US/firefox/; showing up now (all-time downloads, daily downloads).