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