jenkins-bot has submitted this change and it was merged.
Change subject: Add languages for deployment on 20150618
......................................................................
Add languages for deployment on 20150618
Change-Id: I1e1f7fd91d42d376ea22e315949719460e803f56
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
3 files changed, 107 insertions(+), 3 deletions(-)
Approvals:
KartikMistry: Looks good to me, approved
jenkins-bot: Verified
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index ee85461..df759c6 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -205,7 +205,23 @@
tetwiki,
towiki,
tywiki,
- xalwiki
+ xalwiki,
+ alswiki,
+ angwiki,
+ barwiki,
+ dewiki,
+ dsbwiki,
+ fowiki,
+ frrwiki,
+ hsbwiki,
+ ikwiki,
+ iswiki,
+ klwiki,
+ kshwiki,
+ lbwiki,
+ ndswiki,
+ pflwiki,
+ stqwiki
from (select *
from ( select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx' and up_value = 1 ) ca
@@ -633,6 +649,42 @@
( select count(*) as tywiki from tywiki.user_properties where
up_property = 'cx' and up_value = 1 ) ty on 1=1
left join
( select count(*) as xalwiki from xalwiki.user_properties
where up_property = 'cx' and up_value = 1 ) xal on 1=1
+ left join
+ ( select count(*) as alswiki from alswiki.user_properties
where up_property = 'cx' and up_value = 1 ) als on 1=1
+ left join
+ ( select count(*) as angwiki from angwiki.user_properties
where up_property = 'cx' and up_value = 1 ) ang on 1=1
+ left join
+ ( select count(*) as barwiki from barwiki.user_properties
where up_property = 'cx' and up_value = 1 ) bar on 1=1
+ left join
+ ( select count(*) as dewiki from dewiki.user_properties where
up_property = 'cx' and up_value = 1 ) de on 1=1
+ left join
+ ( select count(*) as dsbwiki from dsbwiki.user_properties
where up_property = 'cx' and up_value = 1 ) dsb on 1=1
+ left join
+ ( select count(*) as fowiki from fowiki.user_properties where
up_property = 'cx' and up_value = 1 ) fo on 1=1
+ left join
+ ( select count(*) as frrwiki from frrwiki.user_properties
where up_property = 'cx' and up_value = 1 ) frr on 1=1
+ left join
+ ( select count(*) as hsbwiki from hsbwiki.user_properties
where up_property = 'cx' and up_value = 1 ) hsb on 1=1
+ left join
+ ( select count(*) as ikwiki from ikwiki.user_properties where
up_property = 'cx' and up_value = 1 ) ik on 1=1
+ left join
+ ( select count(*) as iswiki from iswiki.user_properties where
up_property = 'cx' and up_value = 1 ) is on 1=1
+ left join
+ ( select count(*) as klwiki from klwiki.user_properties where
up_property = 'cx' and up_value = 1 ) kl on 1=1
) seventh30
+ cross join
+
+ (select *
+ from ( select count(*) as kshwiki from kshwiki.user_properties
where up_property = 'cx' and up_value = 1 ) ksh
+ left join
+ ( select count(*) as lbwiki from lbwiki.user_properties where
up_property = 'cx' and up_value = 1 ) lb on 1=1
+ left join
+ ( select count(*) as ndswiki from ndswiki.user_properties
where up_property = 'cx' and up_value = 1 ) nds on 1=1
+ left join
+ ( select count(*) as pflwiki from pflwiki.user_properties
where up_property = 'cx' and up_value = 1 ) pfl on 1=1
+ left join
+ ( select count(*) as stqwiki from stqwiki.user_properties
where up_property = 'cx' and up_value = 1 ) stq on 1=1
+ ) eigth30
+
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index 52be72a..90db624 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -205,7 +205,23 @@
tetwiki,
towiki,
tywiki,
- xalwiki
+ xalwiki,
+ alswiki,
+ angwiki,
+ barwiki,
+ dewiki,
+ dsbwiki,
+ fowiki,
+ frrwiki,
+ hsbwiki,
+ ikwiki,
+ iswiki,
+ klwiki,
+ kshwiki,
+ lbwiki,
+ ndswiki,
+ pflwiki,
+ stqwiki
from (select *
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
@@ -633,6 +649,42 @@
( select count(*) as tywiki from tywiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
tywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ty on 1=1
left join
( select count(*) as xalwiki from xalwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from xalwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) xal on 1=1
+ left join
+ ( select count(*) as alswiki from alswiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from alswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) als on 1=1
+ left join
+ ( select count(*) as angwiki from angwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from angwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ang on 1=1
+ left join
+ ( select count(*) as barwiki from barwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from barwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bar on 1=1
+ left join
+ ( select count(*) as dewiki from dewiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
dewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) de on 1=1
+ left join
+ ( select count(*) as dsbwiki from dsbwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from dsbwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) dsb on 1=1
+ left join
+ ( select count(*) as fowiki from fowiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fowiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fo on 1=1
+ left join
+ ( select count(*) as frrwiki from frrwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from frrwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) frr on 1=1
+ left join
+ ( select count(*) as hsbwiki from hsbwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from hsbwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) hsb on 1=1
+ left join
+ ( select count(*) as ikwiki from ikwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
ikwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ik on 1=1
+ left join
+ ( select count(*) as iswiki from iswiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
iswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) is on 1=1
+ left join
+ ( select count(*) as klwiki from klwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
klwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) kl on 1=1
) seventh30
+ cross join
+
+ (select *
+ from ( select count(*) as kshiki from kshwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
kshwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ksh
+ left join
+ ( select count(*) as lbwiki from lbwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
lbwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) lb on 1=1
+ left join
+ ( select count(*) as ndswiki from ndswiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from ndswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) nds on 1=1
+ left join
+ ( select count(*) as pflwiki from pflwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from pflwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pfl on 1=1
+ left join
+ ( select count(*) as stqwiki from stqwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from stqwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) stq on 1=1
+ ) eigth30
+
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index 5435e4d..fc7dc23 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", "kn", "uk", "bg", "fr", "mk", "sh", "sl", "gu",
"vi", "af", "an", "ast", "ba", "cv", "eu", "gl", "koi", "kv", "lez", "oc",
"sah", "simple", "tt", "tyv", "udm", "xh", "cs", "el", "kk", "zu", "ak", "bm",
"ee", "ff", "kg", "ki", "lg", "ny", "om", "rn", "sg", "ss", "st", "ti", "tn",
"ts", "tum", "tw", "ve", "ab", "av", "az", "crh", "gag", "hy", "kaa", "kbd",
"krc", "lad", "mt", "mwl", "os", "rmy", "roa-rup", "sq", "tr", "war", "ceb",
"tl", "cbk-zam", "pam", "pag", "ilo", "be-x-old", "be", "bcl", "ka", "rue",
"csb", "ltg", "lv", "li", "bh", "pl", "hi", "sw", "so", "sn", "yo", "am",
"kab", "wo", "ig", "nso", "qu", "nah", "ay", "gn", "ext", "pap", "lt",
"bat-smg", "bs", "et", "fi", "fiu-vro", "fy", "hr", "hu", "nds-nl", "nl", "ro",
"se", "sk", "sr", "szl", "vep", "as", "bn", "bpy", "my", "dz", "km", "lo",
"ml", "mr", "ne", "new", "or", "pi", "sa", "si", "te", "th", "kw", "ga", "rw",
"gv", "nv", "pdc", "sco", "gd", "srn", "tpi", "ur", "cy", "vls", "yi", "zea",
"bi", "br", "chr", "chy", "frp", "ht", "ln", "mai", "nrm", "pcd", "pih", "pms",
"sm", "ta", "wa", "ace", "bjn", "bug", "bxr", "ch", "fj", "haw", "hif", "jv",
"lbe", "map-bms", "mdf", "mg", "mhr", "mi", "mrj", "myv", "na", "ru", "tet",
"to", "ty", "xal" ]
+ "languages": [ "ca", "da", "eo", "es", "id", "ky", "ms", "nn", "no",
"pa", "pt", "sv", "min", "uz", "kn", "uk", "bg", "fr", "mk", "sh", "sl", "gu",
"vi", "af", "an", "ast", "ba", "cv", "eu", "gl", "koi", "kv", "lez", "oc",
"sah", "simple", "tt", "tyv", "udm", "xh", "cs", "el", "kk", "zu", "ak", "bm",
"ee", "ff", "kg", "ki", "lg", "ny", "om", "rn", "sg", "ss", "st", "ti", "tn",
"ts", "tum", "tw", "ve", "ab", "av", "az", "crh", "gag", "hy", "kaa", "kbd",
"krc", "lad", "mt", "mwl", "os", "rmy", "roa-rup", "sq", "tr", "war", "ceb",
"tl", "cbk-zam", "pam", "pag", "ilo", "be-x-old", "be", "bcl", "ka", "rue",
"csb", "ltg", "lv", "li", "bh", "pl", "hi", "sw", "so", "sn", "yo", "am",
"kab", "wo", "ig", "nso", "qu", "nah", "ay", "gn", "ext", "pap", "lt",
"bat-smg", "bs", "et", "fi", "fiu-vro", "fy", "hr", "hu", "nds-nl", "nl", "ro",
"se", "sk", "sr", "szl", "vep", "as", "bn", "bpy", "my", "dz", "km", "lo",
"ml", "mr", "ne", "new", "or", "pi", "sa", "si", "te", "th", "kw", "ga", "rw",
"gv", "nv", "pdc", "sco", "gd", "srn", "tpi", "ur", "cy", "vls", "yi", "zea",
"bi", "br", "chr", "chy", "frp", "ht", "ln", "mai", "nrm", "pcd", "pih", "pms",
"sm", "ta", "wa", "ace", "bjn", "bug", "bxr", "ch", "fj", "haw", "hif", "jv",
"lbe", "map-bms", "mdf", "mg", "mhr", "mi", "mrj", "myv", "na", "ru", "tet",
"to", "ty", "xal", "als", "ang", "bar", "de", "dsb", "fo", "frr", "gsw", "ik",
"is", "kl", "ksh", "lb", "nds", "pfl", "stq"]
}
--
To view, visit https://gerrit.wikimedia.org/r/219186
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I1e1f7fd91d42d376ea22e315949719460e803f56
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-language-data
Gerrit-Branch: master
Gerrit-Owner: KartikMistry <kartik.mis...@gmail.com>
Gerrit-Reviewer: KartikMistry <kartik.mis...@gmail.com>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
