EBernhardson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/177111
Change subject: Filter testwiki and test2wiki from flow analytics
......................................................................
Filter testwiki and test2wiki from flow analytics
Change-Id: I4e578ab318f41bf603309a5483544dfc7895ebb4
---
M flow/active-boards.sql
M flow/active-topics.sql
M flow/messages-posted.sql
M flow/moderation-actions.sql
M flow/unique-users.sql
5 files changed, 5 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-flow-data
refs/changes/11/177111/1
diff --git a/flow/active-boards.sql b/flow/active-boards.sql
index 8aa6132..f40b7fe 100644
--- a/flow/active-boards.sql
+++ b/flow/active-boards.sql
@@ -11,4 +11,5 @@
GROUP BY b.tree_descendant_id
) y ON y.max = a.tree_depth AND y.tree_descendant_id =
a.tree_descendant_id
) z ON z.tree_ancestor_id = workflow_id
+ WHERE workflow_wiki NOT IN ( 'testwiki', 'test2wiki' )
GROUP BY z.weekstart;
diff --git a/flow/active-topics.sql b/flow/active-topics.sql
index fb53661..a8c2b45 100644
--- a/flow/active-topics.sql
+++ b/flow/active-topics.sql
@@ -10,4 +10,5 @@
GROUP BY b.tree_descendant_id
) y ON y.max = a.tree_depth AND y.tree_descendant_id =
a.tree_descendant_id
) z ON z.tree_ancestor_id = workflow_id
+ WHERE workflow_wiki NOT IN ( 'testwiki', 'test2wiki' )
GROUP BY z.weekstart;
diff --git a/flow/messages-posted.sql b/flow/messages-posted.sql
index c879b72..c85bd3f 100644
--- a/flow/messages-posted.sql
+++ b/flow/messages-posted.sql
@@ -2,5 +2,6 @@
count( rev_id ) as num_replies
FROM flow_revision
WHERE rev_change_type = 'reply'
+ AND rev_user_wiki NOT IN ( 'testwiki', 'test2wiki' )
GROUP BY weekstart;
diff --git a/flow/moderation-actions.sql b/flow/moderation-actions.sql
index 606ab56..88b34c2 100644
--- a/flow/moderation-actions.sql
+++ b/flow/moderation-actions.sql
@@ -9,6 +9,7 @@
from (select
DATE(DATE_SUB(FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000),
interval DAYOFWEEK(
FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000)) day)) as
weekstart,
rev_change_type
from flow_revision
+ where rev_user_wiki not in ('testwiki', 'test2wiki')
) change_type_by_week
where weekstart > DATE_SUB(CURDATE(), INTERVAL 12 WEEK)
diff --git a/flow/unique-users.sql b/flow/unique-users.sql
index 9e74817..f40638d 100644
--- a/flow/unique-users.sql
+++ b/flow/unique-users.sql
@@ -5,6 +5,7 @@
DATE(DATE_SUB(FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000),
interval DAYOFWEEK(
FROM_UNIXTIME((conv(substring(hex(rev_id),1,12),16,10)>>2)/1000)) day)) as
weekstart
FROM flow_revision
WHERE rev_change_type = 'reply'
+ AND rev_user_wiki NOT IN ( 'testwiki', 'test2wiki' )
GROUP BY rev_user_wiki, rev_user_id, rev_user_ip
) x
GROUP BY weekstart;
--
To view, visit https://gerrit.wikimedia.org/r/177111
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I4e578ab318f41bf603309a5483544dfc7895ebb4
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-flow-data
Gerrit-Branch: master
Gerrit-Owner: EBernhardson <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
