jenkins-bot has submitted this change and it was merged.
Change subject: Bump MobileOptions revision
......................................................................
Bump MobileOptions revision
Discard old data (has been preserved in ticket)
Bug: T115129
Change-Id: I12d66b2efbce33964802daa3f56657153c18c6e5
---
M mobile/mobile-options-last-3-months.sql
M mobile/mobile-options.sql
2 files changed, 8 insertions(+), 2 deletions(-)
Approvals:
Jdlrobson: Verified; Looks good to me, approved
jenkins-bot: Verified
diff --git a/mobile/mobile-options-last-3-months.sql
b/mobile/mobile-options-last-3-months.sql
index 1df1613..14cc2a3 100644
--- a/mobile/mobile-options-last-3-months.sql
+++ b/mobile/mobile-options-last-3-months.sql
@@ -7,7 +7,10 @@
sum(if(event_images = 'on', 1, 0)) as 'Images turned on',
sum(if(event_images = 'off', 1, 0)) as 'Images turned off'
from
- MobileOptionsTracking_8101982
+(select timestamp, event_beta, event_images, event_alpha from
MobileOptionsTracking_8101982
+ union all
+select timestamp, event_beta, event_images, 'nochange' as event_alpha from
MobileOptionsTracking_14003392)
+ as motable
where
timestamp >= CURRENT_DATE - INTERVAL 90 DAY
group by 1
diff --git a/mobile/mobile-options.sql b/mobile/mobile-options.sql
index 320e80e..5b5a5d3 100644
--- a/mobile/mobile-options.sql
+++ b/mobile/mobile-options.sql
@@ -7,7 +7,10 @@
sum(if(event_images = 'on', 1, 0)) as 'Images turned on',
sum(if(event_images = 'off', 1, 0)) as 'Images turned off'
from
- MobileOptionsTracking_8101982
+(select timestamp, event_beta, event_images, event_alpha from
MobileOptionsTracking_8101982
+ union all
+select timestamp, event_beta, event_images, 'nochange' as event_alpha from
MobileOptionsTracking_14003392)
+ as motable
where
timestamp >= '{from_timestamp}' and
timestamp <= '{to_timestamp}'
--
To view, visit https://gerrit.wikimedia.org/r/248990
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I12d66b2efbce33964802daa3f56657153c18c6e5
Gerrit-PatchSet: 5
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Jdlrobson <[email protected]>
Gerrit-Reviewer: Jdlrobson <[email protected]>
Gerrit-Reviewer: Milimetric <[email protected]>
Gerrit-Reviewer: Nuria <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
Gerrit-Reviewer: Yuvipanda <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
