Milimetric has uploaded a new change for review.
https://gerrit.wikimedia.org/r/155803
Change subject: Fix config and sql
......................................................................
Fix config and sql
Change-Id: I3d46cc48d5827e513b4762f43b6f3fdfa190297f
---
M mobile/app-edits-starts.sql
M mobile/config.yaml
2 files changed, 4 insertions(+), 4 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/03/155803/1
diff --git a/mobile/app-edits-starts.sql b/mobile/app-edits-starts.sql
index 0980e74..1b43df0 100644
--- a/mobile/app-edits-starts.sql
+++ b/mobile/app-edits-starts.sql
@@ -3,11 +3,11 @@
SUM( IF( userAgent LIKE '%Android%', 1, 0) ) AS Android,
SUM( IF( userAgent LIKE '%Darwin%' OR userAgent LIKE '%iPhone
OS%', 1, 0) ) AS iOS
-FROM {{ tables.edits_app }} as Edits
+FROM {{ tables.edits_app }}
WHERE event_action = 'start'
AND wiki != 'testwiki'
- AND Edits.timestamp >= '{from_timestamp}'
- AND Edits.timestamp < '{to_timestamp}'
+ AND timestamp >= '{from_timestamp}'
+ AND timestamp < '{to_timestamp}'
GROUP BY DATE( timestamp )
diff --git a/mobile/config.yaml b/mobile/config.yaml
index 9623252..e3dce07 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -11,7 +11,7 @@
db: commonswiki
tables:
upload_attempts: (SELECT id, uuid, clientIp, isTruncated,
clientValidated, timestamp, webHost, wiki, event_appversion, event_device,
event_filename, 0 as event_multiple, event_platform, event_result,
event_source, event_username FROM MobileAppUploadAttempts_5257716 UNION SELECT
id, uuid, clientIp, isTruncated, clientValidated, timestamp, webHost, wiki,
event_appversion, event_device, event_filename, event_multiple, event_platform,
event_result, event_source, event_username FROM
MobileAppUploadAttempts_5334329) as MobileAppUploadAttempts
- edits_app: (SELECT timestamp, wiki, event_username, event_action,
event_namespace, event_userEditCount FROM MobileWikiAppEdit_9003125 as
MobileAppEditing
+ edits_app: (SELECT timestamp, wiki, userAgent, event_action FROM
MobileWikiAppEdit_9003125) as MobileAppEditing
edits_web: (SELECT timestamp, wiki, event_username, event_action,
event_namespace, event_userEditCount FROM MobileWebEditing_5644223 UNION SELECT
timestamp, wiki, event_username, event_action, event_namespace,
event_userEditCount FROM MobileWebEditing_6077315 UNION SELECT timestamp, wiki,
event_username, event_action, event_namespace, event_userEditCount from
MobileWebEditing_6637866 UNION SELECT timestamp, wiki, event_username,
event_action, event_namespace, event_userEditCount from
MobileWebEditing_7675117 UNION SELECT timestamp, wiki, event_username,
event_action, event_namespace, event_userEditCount from
MobileWebEditing_8599025) as MobileWebEditing
login_attempts: MobileAppLoginAttempts_5257721
share_attempts: MobileAppShareAttempts_5346170
--
To view, visit https://gerrit.wikimedia.org/r/155803
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I3d46cc48d5827e513b4762f43b6f3fdfa190297f
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Milimetric <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
