Confirmed users
1,927
edits
BMO/UserProfiles: Difference between revisions
m
added Category:BMO using HotCat
No edit summary |
m (added Category:BMO using HotCat) |
||
| (13 intermediate revisions by 2 users not shown) | |||
| Line 13: | Line 13: | ||
* Name: lizzard | * Name: lizzard | ||
* | * Email: lhenry@mozilla.com | ||
* Mozillians.org profile: [link ] | * Mozillians.org profile: [link ] | ||
| Line 19: | Line 19: | ||
* Last activity: 2013-03-26 | * Last activity: 2013-03-26 | ||
* Bugs filed: 13 | * Bugs filed: 13 | ||
* Comments made: 46 | |||
* Assigned to: 1 | |||
* Commented on: 53 | * Commented on: 53 | ||
* Confirmed: 10 | * Confirmed: 10 | ||
| Line 24: | Line 26: | ||
* Patches submitted: 0 | * Patches submitted: 0 | ||
* Patches reviewed: 0 | * Patches reviewed: 0 | ||
* Bugs poked: 155 | |||
* Bugs poked: | |||
Activity: | |||
Statuses changed: RESOLVED (20), INVALID (3), FIXED (5), VERIFIED (5) | |||
By Product: Core(2), Firefox(5), FirefoxOS(0), Firefox for Android(1), Firefox for Metro(0), Toolkit(1), Marketplace(1), Thunderbird(1), SeaMonkey(1), Mozilla Localizations(3), Mozilla Services(1), Other Products(10) | |||
Core(2), Firefox(5), FirefoxOS(0), Firefox for Android(1), Firefox for Metro(0), Toolkit(1), Marketplace(1), Thunderbird(1), SeaMonkey(1), Mozilla Localizations(3), Mozilla Services(1), Other Products(10) | |||
<small>[https://wiki.mozilla.org/BMO/User_profile_fields What do these fields mean?] </small> | |||
------------------------- | ------------------------- | ||
| Line 55: | Line 56: | ||
({{bug|862441}} and {{bug|859550}}) | ({{bug|862441}} and {{bug|859550}}) | ||
The user profiles will have a link "What do these fields mean?" that leads to [https://wiki.mozilla.org/BMO/User_profile_fields User profile fields] rather than the original idea of descriptions in tooltips for each field. | |||
Clicking on the field names in the profile would take the user to that term (anchor text) on a page with descriptions of all the user profile field names. | Clicking on the field names in the profile would take the user to that term (anchor text) on a page with descriptions of all the user profile field names. | ||
| Line 73: | Line 74: | ||
The total number of bugs that the user has commented on. More info: <a href="https://bugzilla.mozilla.org/page.cgi?id=etiquette.html">Bugzilla etiquette</a> | The total number of bugs that the user has commented on. More info: <a href="https://bugzilla.mozilla.org/page.cgi?id=etiquette.html">Bugzilla etiquette</a> | ||
'''Comments made''' | |||
The total number of comments that the user has added. More info: <a href="https://bugzilla.mozilla.org/page.cgi?id=etiquette.html">Bugzilla etiquette</a> | |||
'''Confirmed''' | '''Confirmed''' | ||
| Line 133: | Line 138: | ||
Add a field to the ''profiles'' table which is used to track if a user's statistics need to be updated (triggered when the user file/updates/comments on a bug). Schedule a cron job to run at an off-peak time which updates the statistics for users. Expose those statistics via a package which monkey patches a getter into the User package. | Add a field to the ''profiles'' table which is used to track if a user's statistics need to be updated (triggered when the user file/updates/comments on a bug). Schedule a cron job to run at an off-peak time which updates the statistics for users. Expose those statistics via a package which monkey patches a getter into the User package. | ||
Administrative actions, such as editing a user, group, product, etc, should also trigger the statistics to be updated. | |||
''note'' This "dirty-only" approach may not be viable, as changing a bug's visibility will changes bug counts for everyone who has interacted with the patch (assuming only public bug data is displayed). | |||
=== Schema === | === Schema === | ||
| Line 140: | Line 149: | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* name ''varchar30'' | * name ''varchar30'' | ||
* | * count ''int'' | ||
| Line 146: | Line 155: | ||
* id ''identity'' | * id ''identity'' | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* status '' | * status ''varchar64'' | ||
* count ''int'' | * count ''int'' | ||
| Line 153: | Line 162: | ||
* id ''identity'' | * id ''identity'' | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* product_id ''fk products.id'' | * product_id ''fk products.id'' (when 0, refers to 'other' products) | ||
* count ''int'' | * count ''int'' | ||
new fields: | new fields: | ||
* profiles.mozillians_id '' | |||
* profiles.mozillians_id ''varchar30'' (mozillians.org username) | |||
* profiles.last_activity_ts ''datetime'' timestamp of most recent update, comment, etc | * profiles.last_activity_ts ''datetime'' timestamp of most recent update, comment, etc | ||
* profiles.last_statistics_ts ''datetime'' timestamp of last time the statistics were generated for this user | * profiles.last_statistics_ts ''datetime'' timestamp of last time the statistics were generated for this user | ||
| Line 165: | Line 176: | ||
* '''last_activity''' : from ''profiles.last_activity_ts'' | * '''last_activity''' : from ''profiles.last_activity_ts'' | ||
* '''bugs_filed''' : simple count from bugs table (public bugs only) | * '''bugs_filed''' : simple count from bugs table (public bugs only) | ||
* '''comments''' : simple count from | * '''comments''' : simple count from longdescs table (public comments only on public bugs) | ||
* '''commented_on''' : simple count from longdescs table (public comments only on public bugs) | |||
* '''confirmed''' : bugs_activity where field=status and removed='UNCONFIRMED' (public bugs only) | * '''confirmed''' : bugs_activity where field=status and removed='UNCONFIRMED' (public bugs only) | ||
* '''qa_contact''' : simple count from bugs table (public bugs only) | * '''qa_contact''' : simple count from bugs table (public bugs only) | ||
| Line 171: | Line 183: | ||
* '''reviews''' : review+ flags count (public bugs and attachments only) | * '''reviews''' : review+ flags count (public bugs and attachments only) | ||
* '''assigned''' : simple count from bugs table (public bugs only) | * '''assigned''' : simple count from bugs table (public bugs only) | ||
* '''touched''' : simple count from bugs_activity + | * '''touched''' : simple count from bugs_activity + longdescs table (public bugs, comments and attachments only) | ||
* '''by-status counters''' : simple count from | * '''by-status activity counters''' : simple count from bugs_activity table (public bugs only) | ||
* '''by-product counters''' : simple count from | * '''by-product activity counters''' : simple count from bugs_activity + longdescs table (public bugs, comments and attachments only) | ||
[[Category:BMO]] | |||