Gilles has uploaded a new change for review. https://gerrit.wikimedia.org/r/171560
Change subject: Action schema update ...................................................................... Action schema update Change-Id: I4c087f68818bd218ddc5d0db1178b7ff4e679c14 Mingle: https://wikimedia.mingle.thoughtworks.com/projects/multimedia/cards/977 --- M actions/template.sql 1 file changed, 3 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia refs/changes/60/171560/1 diff --git a/actions/template.sql b/actions/template.sql index 083b8cf..820726b 100644 --- a/actions/template.sql +++ b/actions/template.sql @@ -82,6 +82,9 @@ SELECT timestamp, event_action, event_samplingFactor FROM MediaViewer_10277480 WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) UNION ALL + SELECT timestamp, event_action, event_samplingFactor FROM MediaViewer_10308479 + WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) + UNION ALL SELECT timestamp, (CASE WHEN event_value = 0 THEN 'pref-optout-loggedin' ELSE 'pref-optin-loggedin' END) AS event_action, 1 AS event_samplingFactor FROM PrefUpdate_5563398 WHERE event_property = 'multimediaviewer-enable' AND timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) ) AS MediaViewerUnioned -- To view, visit https://gerrit.wikimedia.org/r/171560 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4c087f68818bd218ddc5d0db1178b7ff4e679c14 Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia Gerrit-Branch: master Gerrit-Owner: Gilles <gdu...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits