KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/200101
Change subject: Add 'kn' and 'uk' languages
......................................................................
Add 'kn' and 'uk' languages
Change-Id: I9668cf68727dcb195ad39e27e43d85214abd39e3
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
3 files changed, 15 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/01/200101/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index 311b5a7..2d8b270 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -12,7 +12,9 @@
minwiki,
uzwiki,
kywiki,
- pawiki
+ pawiki,
+ knwiki,
+ ukwiki
from
( select count(*) as cawiki from cawiki.user_properties where up_property =
'cx' and up_value = 1 ) ca
left join
@@ -41,4 +43,8 @@
( select count(*) as kywiki from kywiki.user_properties where up_property =
'cx' and up_value = 1 ) ky on 1=1
left join
( select count(*) as pawiki from pawiki.user_properties where up_property =
'cx' and up_value = 1 ) pa on 1=1
+left join
+( select count(*) as knwiki from knwiki.user_properties where up_property =
'cx' and up_value = 1 ) kn on 1=1
+left join
+( select count(*) as ukwiki from ukwiki.user_properties where up_property =
'cx' and up_value = 1 ) uk on 1=1
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index 0e34aa1..98f0d75 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -12,7 +12,9 @@
minwiki,
uzwiki,
kywiki,
- pawiki
+ pawiki,
+ knwiki,
+ ukwiki
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
@@ -41,4 +43,8 @@
( select count(*) as kywiki from kywiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
kywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ky on 1=1
left join
( select count(*) as pawiki from pawiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
pawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pa on 1=1
+left join
+( select count(*) as knwiki from knwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
knwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) kn on 1=1
+left join
+( select count(*) as ukwiki from ukwiki.user_properties where up_property =
'cx' and up_value = 1 and up_user not in ( select up_user from
ukwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) uk on 1=1
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index a915929..c0c6de3 100644
--- a/reportgenerator/config/config.json
+++ b/reportgenerator/config/config.json
@@ -1,3 +1,3 @@
{
- "languages": [ "ca", "da", "eo", "es", "id", "ky", "ms", "nn", "no",
"pa", "pt", "sv", "min", "uz" ]
+ "languages": [ "ca", "da", "eo", "es", "id", "ky", "ms", "nn", "no",
"pa", "pt", "sv", "min", "uz", "kn", "uk" ]
}
--
To view, visit https://gerrit.wikimedia.org/r/200101
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I9668cf68727dcb195ad39e27e43d85214abd39e3
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-language-data
Gerrit-Branch: master
Gerrit-Owner: KartikMistry <kartik.mis...@gmail.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
