586915 - [UX] Add list of sites to dashboard

Status: VERIFIED FIXED

(Input :: General, defect, P2)

Description

[Fred Wenzel [:wenzel]]

The list of sites is currently commented out. Needs to be pulled out of the website_issues DB and shown in the right sidebar.

Comment 1

[Fred Wenzel [:wenzel]]

Michael, can you either do this or give me a code snippet I can use to squeeze this information out of the DB? We need the most mentioned URLs for the last day, along with the count.

Comment 2

[Michael Kurze [:michaelk]]

This does not strictly require clusters/the website_issues db if I understand correctly. But sorting by an aggregate criteria is always expensive. And probably sites for the past day will also be needed on the sites page or somewhere else. So I added clusters per day to the generate-command, in addition to the clusters per week and per latest beta that we already have.


How to query this: should look similar to the _fetch_summaries function. As data is pre-aggregated and grouped, it is important that the "version" and "positive" fields are specified in every query (otherwise there are duplicates).

Example: Get the top ten sites for the last day, with any feedback:
SiteSummary.objects.filter(version__exact='<day>').filter(positive__exact=None)[:10]

Get the top ten sites with positive feedback for the beta 3:
SiteSummary.objects.filter(version__exact='4.0b3').filter(positive__exact=1)[:10]

Comment 3

[Fred Wenzel [:wenzel]]

Thanks. I'll kick this out of the milestone for now, though.

Comment 4

[Michael Kurze [:michaelk]]

Okay, the "<day>" version is in the stage database (exported it manually), and the code above should work as advertised.

Commit: http://github.com/michaelku/reporter/commit/aeddd3a6dc1b2d8e8df93c9c15487f583eeae2e9

Comment 5

[Michael Kurze [:michaelk]]

(That commit URL might be confusing: I already pushed it to fwenzel/master)

Comment 6

[Fred Wenzel [:wenzel]]

Thanks to your code, that was pretty simple, thanks:
http://github.com/fwenzel/reporter/commit/61c51fc

Comment 7

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

This is the "While Visiting" block on the right, correct?

Comment 8

[Fred Wenzel [:wenzel]]

Yup!

Comment 9

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

Verified FIXED on http://input.stage.mozilla.com/en-US/.