Jsahleen has uploaded a new change for review.
https://gerrit.wikimedia.org/r/193128
Change subject: Add min and uz to for beta features dashboard.
......................................................................
Add min and uz to for beta features dashboard.
Change-Id: If776791ecaada8b3c2e1cf6344b20d6c51341305
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
M reportgenerator/reports/BetaFeatureEnablementsReport.php
4 files changed, 16 insertions(+), 4 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/28/193128/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index abc3ea9..73b7b72 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -8,7 +8,9 @@
nnwiki,
nowiki,
ptwiki,
- svwiki
+ svwiki,
+ minwiki,
+ uzwiki
from
( select count(*) as cawiki from cawiki.user_properties where up_property =
'cx' and up_value = 1 ) ca
left join
@@ -29,4 +31,8 @@
( select count(*) as ptwiki from ptwiki.user_properties where up_property =
'cx' and up_value = 1 ) pt on 1=1
left join
( select count(*) as svwiki from svwiki.user_properties where up_property =
'cx' and up_value = 1 ) sv on 1=1
+left join
+( select count(*) as minwiki from minwiki.user_properties where up_property =
'cx' and up_value = 1 ) min on 1=1
+left join
+( select count(*) as uzwiki from uzwiki.user_properties where up_property =
'cx' and up_value = 1 ) uz on 1=1
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index c23de31..5ee1f2c 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -8,7 +8,9 @@
nnwiki,
nowiki,
ptwiki,
- svwiki
+ svwiki,
+ minwiki,
+ uzwiki
from
( select count(*) as cawiki from cawiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
cawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ca
left join
@@ -29,4 +31,8 @@
( select count(*) as ptwiki from ptwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
ptwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pt on 1=1
left join
( select count(*) as svwiki from svwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
svwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) sv on 1=1
+left join
+( select count(*) as minwiki from minwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
minwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) min on 1=1
+left join
+( select count(*) as uzwiki from uzwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
uzwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) uz on 1=1
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index b887742..ad7ecb8 100644
--- a/reportgenerator/config/config.json
+++ b/reportgenerator/config/config.json
@@ -1,3 +1,3 @@
{
- "languages": [ "ca", "da", "eo", "es", "id", "ms", "nn", "no", "pt",
"sv" ]
+ "languages": [ "ca", "da", "eo", "es", "id", "ms", "nn", "no", "pt",
"sv", "min", "uz" ]
}
diff --git a/reportgenerator/reports/BetaFeatureEnablementsReport.php
b/reportgenerator/reports/BetaFeatureEnablementsReport.php
index 571aa6f..49cc3e9 100644
--- a/reportgenerator/reports/BetaFeatureEnablementsReport.php
+++ b/reportgenerator/reports/BetaFeatureEnablementsReport.php
@@ -9,7 +9,7 @@
$wikis[$language] = $language . 'wiki';
}
- $sql .= "select current_date() as date,\n\t";
+ $sql = "select current_date() as date,\n\t";
$sql .= implode( ",\n\t", $wikis );
$sql .= "\n\tfrom\n";
--
To view, visit https://gerrit.wikimedia.org/r/193128
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: If776791ecaada8b3c2e1cf6344b20d6c51341305
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-language-data
Gerrit-Branch: master
Gerrit-Owner: Jsahleen <jsahl...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
