Issue Details (XML | Word | Printable)

Key: MBS-4274
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Ian McEwen
Reporter: Ian McEwen
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

Stats by edit type

Created: 03/Feb/12 01:33 PM   Updated: 23/Jul/12 05:24 AM   Resolved: 23/Jul/12 05:24 AM
Component/s: Misc features
Affects Version/s: None
Fix Version/s: Bug fixes, 2012-07-23


 Description  « Hide

Requested by ocharles, simple "SELECT count(id) FROM edit WHERE type = ?"



Sort Order: Ascending order - Click to sort in descending order
Oliver Charles added a comment - 14/Feb/12 11:04 AM

You can do this without edit names in the database simply by using SELECT whatever FROM edit WHERE type IN (SELECT DISTINCT type FROM edit), and calling the stat edit.count.{type-number}. For the display, you just use the EditRegistry to look up the edit type and it has an "edit_name" function.


Ian McEwen added a comment - 14/Feb/12 12:21 PM

Already doing the former for collection; the concern was figuring out the names for display. I'll look into this EditRegistry thing, then, thanks.


Oliver Charles added a comment - 09/Jul/12 12:50 PM

ianmcorvidae/mbs-4274-4307-3842-various-stats merged into beta.