Milimetric has submitted this change and it was merged. Change subject: Productionize failure types by user type ......................................................................
Productionize failure types by user type 1) Modifies the report query to add a first 'day' column, and also to accept exploding by wiki and by editor. 2) Adds configuration to config.yaml to run the report through reportupdater. Bug: T91123 Change-Id: Ib521e9be71a60f372006ae8ed43ca0e6d0de7935 --- M edit/config.yaml M edit/failure_types_by_user_type.sql 2 files changed, 19 insertions(+), 10 deletions(-) Approvals: Milimetric: Verified; Looks good to me, approved diff --git a/edit/config.yaml b/edit/config.yaml index f797ee9..4ad2f9a 100644 --- a/edit/config.yaml +++ b/edit/config.yaml @@ -90,3 +90,13 @@ by_wiki: true explode_by: editor: "visualeditor, wikitext" + + failure_types_by_user_type: + frequency: days + granularity: days + timeboxed: true + funnel: true + starts: 2015-05-01 + by_wiki: true + explode_by: + editor: "visualeditor, wikitext" diff --git a/edit/failure_types_by_user_type.sql b/edit/failure_types_by_user_type.sql index 6eefc0b..235e362 100644 --- a/edit/failure_types_by_user_type.sql +++ b/edit/failure_types_by_user_type.sql @@ -1,6 +1,5 @@ -set @from_time = '20150101000000'; -set @to_time = '20150201000000'; select + date(timestamp) as day, case when `event_user.class` = 'IP' then 'anonymous' when `event_user.editCount` >= 1000 then 'over1000' @@ -9,8 +8,7 @@ when `event_user.editCount` >= 1 then 'over1' when `event_user.editCount` = 0 then 'firstEdit' else 'unknown-user-type' - end as State, -- This column needs to be named like this for now. - -- See stacked-bar-prototype.js's TODOs. + end as user_type, sum(`event_action.saveFailure.type` = 'userBadToken') as userBadToken, sum(`event_action.saveFailure.type` = 'userNewUser') as userNewUser, sum(`event_action.saveFailure.type` = 'extensionAbuseFilter') as extensionAbuseFilter, @@ -20,11 +18,12 @@ sum(`event_action.saveFailure.type` = 'responseUnknown') as responseUnknown, sum(`event_action.saveFailure.type` = 'editPageDeleted') as editPageDeleted, sum(`event_action.saveFailure.type` = 'editConflict') as editConflict -from milimetric_edit +from Edit_11448630 where - `event_action.saveFailure.type` is not null and - event_editor = 'visualeditor' and - timestamp >= @from_time and - timestamp < @to_time -group by 1 + event_editor = '{editor}' and + ('{wiki}' = 'all' or wiki = '{wiki}') and + timestamp >= '{from_timestamp}' and + timestamp < '{to_timestamp}' and + `event_action.saveFailure.type` is not null +group by 1, 2 ; -- To view, visit https://gerrit.wikimedia.org/r/212276 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ib521e9be71a60f372006ae8ed43ca0e6d0de7935 Gerrit-PatchSet: 1 Gerrit-Project: analytics/limn-edit-data Gerrit-Branch: master Gerrit-Owner: Mforns <mfo...@wikimedia.org> Gerrit-Reviewer: Milimetric <dandree...@wikimedia.org> Gerrit-Reviewer: Springle <sprin...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits