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) |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 35: | Line 35: | ||
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) | 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) | ||
<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 137: | 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 144: | Line 149: | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* name ''varchar30'' | * name ''varchar30'' | ||
* | * count ''int'' | ||
| Line 150: | Line 155: | ||
* id ''identity'' | * id ''identity'' | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* status '' | * status ''varchar64'' | ||
* count ''int'' | * count ''int'' | ||
| Line 157: | 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 169: | 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 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 175: | 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 activity counters''' : simple count from bugs_activity table (public bugs only) | * '''by-status activity counters''' : simple count from bugs_activity table (public bugs only) | ||
* '''by-product activity counters''' : simple count from bugs_activity + | * '''by-product activity counters''' : simple count from bugs_activity + longdescs table (public bugs, comments and attachments only) | ||
[[Category:BMO]] | |||