KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/218629
Change subject: Add languages for deployment on 20150616
......................................................................
Add languages for deployment on 20150616
Change-Id: I41148f167c6eb8b0d8f1aac83f7e11b53a84234a
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
M reportgenerator/config/config.json
3 files changed, 149 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/29/218629/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index 21cbb94..ee85461 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -182,7 +182,30 @@
pmswiki,
smwiki,
tawiki,
- wawiki
+ wawiki,
+ acewiki,
+ bjnwiki,
+ bugwiki,
+ bxrwiki,
+ chwiki,
+ fjwiki,
+ hawwiki,
+ hifwiki,
+ jvwiki,
+ lbewiki,
+ map_bmswiki,
+ mdfwiki,
+ mgwiki,
+ mhrwiki,
+ miwiki,
+ mrjwiki,
+ myvwiki,
+ nawiki,
+ ruwiki,
+ tetwiki,
+ towiki,
+ tywiki,
+ xalwiki
from (select *
from ( select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx' and up_value = 1 ) ca
@@ -560,6 +583,56 @@
( select count(*) as tawiki from tawiki.user_properties where
up_property = 'cx' and up_value = 1 ) ta on 1=1
left join
( select count(*) as wawiki from wawiki.user_properties where
up_property = 'cx' and up_value = 1 ) wa on 1=1
+ left join
+ ( select count(*) as acewiki from acewiki.user_properties
where up_property = 'cx' and up_value = 1 ) ace on 1=1
+ left join
+ ( select count(*) as bjnwiki from bjnwiki.user_properties
where up_property = 'cx' and up_value = 1 ) bjn on 1=1
+ left join
+ ( select count(*) as bugwiki from bugwiki.user_properties
where up_property = 'cx' and up_value = 1 ) bug on 1=1
+ left join
+ ( select count(*) as bxrwiki from bxrwiki.user_properties
where up_property = 'cx' and up_value = 1 ) bxr on 1=1
) sixth30
+ cross join
+
+ (select *
+ from ( select count(*) as chwiki from chwiki.user_properties where
up_property = 'cx' and up_value = 1 ) ch
+ left join
+ ( select count(*) as fjwiki from fjwiki.user_properties where
up_property = 'cx' and up_value = 1 ) fj on 1=1
+ left join
+ ( select count(*) as hawwiki from hawwiki.user_properties
where up_property = 'cx' and up_value = 1 ) haw on 1=1
+ left join
+ ( select count(*) as hifwiki from hifwiki.user_properties
where up_property = 'cx' and up_value = 1 ) hif on 1=1
+ left join
+ ( select count(*) as jvwiki from jvwiki.user_properties where
up_property = 'cx' and up_value = 1 ) jv on 1=1
+ left join
+ ( select count(*) as lbewiki from lbewiki.user_properties
where up_property = 'cx' and up_value = 1 ) lbe on 1=1
+ left join
+ ( select count(*) as map_bmswiki from
map_bmswiki.user_properties where up_property = 'cx' and up_value = 1 ) map_bms
on 1=1
+ left join
+ ( select count(*) as mdfwiki from mdfwiki.user_properties
where up_property = 'cx' and up_value = 1 ) mdf on 1=1
+ left join
+ ( select count(*) as mgwiki from mgwiki.user_properties where
up_property = 'cx' and up_value = 1 ) mg on 1=1
+ left join
+ ( select count(*) as mhrwiki from mhrwiki.user_properties
where up_property = 'cx' and up_value = 1 ) mhr on 1=1
+ left join
+ ( select count(*) as miwiki from miwiki.user_properties where
up_property = 'cx' and up_value = 1 ) mi on 1=1
+ left join
+ ( select count(*) as mrjwiki from mrjwiki.user_properties
where up_property = 'cx' and up_value = 1 ) mrj on 1=1
+ left join
+ ( select count(*) as myvwiki from myvwiki.user_properties
where up_property = 'cx' and up_value = 1 ) myv on 1=1
+ left join
+ ( select count(*) as nawiki from nawiki.user_properties where
up_property = 'cx' and up_value = 1 ) na on 1=1
+ left join
+ ( select count(*) as ruwiki from ruwiki.user_properties where
up_property = 'cx' and up_value = 1 ) ru on 1=1
+ left join
+ ( select count(*) as tetwiki from tetwiki.user_properties
where up_property = 'cx' and up_value = 1 ) tet on 1=1
+ left join
+ ( select count(*) as towiki from towiki.user_properties where
up_property = 'cx' and up_value = 1 ) to on 1=1
+ left join
+ ( 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
+ ) seventh30
+
;
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index eb82a83..52be72a 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -182,7 +182,30 @@
pmswiki,
smwiki,
tawiki,
- wawiki
+ wawiki,
+ acewiki,
+ bjnwiki,
+ bugwiki,
+ bxrwiki,
+ chwiki,
+ fjwiki,
+ hawwiki,
+ hifwiki,
+ jvwiki,
+ lbewiki,
+ map_bmswiki,
+ mdfwiki,
+ mgwiki,
+ mhrwiki,
+ miwiki,
+ mrjwiki,
+ myvwiki,
+ nawiki,
+ ruwiki,
+ tetwiki,
+ towiki,
+ tywiki,
+ xalwiki
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
@@ -560,6 +583,56 @@
( select count(*) as tawiki from tawiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
tawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ta on 1=1
left join
( select count(*) as wawiki from wawiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
wawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) wa on 1=1
+ left join
+ ( select count(*) as acewiki from acewiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from acewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ace on 1=1
+ left join
+ ( select count(*) as bjnwiki from bjnwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from bjnwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bjn on 1=1
+ left join
+ ( select count(*) as bugwiki from bugwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from bugwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bug on 1=1
+ left join
+ ( select count(*) as bxrwiki from bxrwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from bxrwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bxr on 1=1
) sixth30
+ cross join
+
+ (select *
+ from ( select count(*) as chwiki from chwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
chwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ch
+ left join
+ ( select count(*) as fjwiki from fjwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fjwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fj on 1=1
+ left join
+ ( select count(*) as hawwiki from hawwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from hawwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) haw on 1=1
+ left join
+ ( select count(*) as hifwiki from hifwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from hifwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) hif on 1=1
+ left join
+ ( select count(*) as jvwiki from jvwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
jvwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) jv on 1=1
+ left join
+ ( select count(*) as lbewiki from lbewiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from lbewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) lbe on 1=1
+ left join
+ ( select count(*) as map_bmswiki from
map_bmswiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from map_bmswiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) map_bms on 1=1
+ left join
+ ( select count(*) as mdfwiki from mdfwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from mdfwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mdf on 1=1
+ left join
+ ( select count(*) as mgwiki from mgwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
mgwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mg on 1=1
+ left join
+ ( select count(*) as mhrwiki from mhrwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from mhrwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mhr on 1=1
+ left join
+ ( select count(*) as miwiki from miwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
miwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mi on 1=1
+ left join
+ ( select count(*) as mrjwiki from mrjwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from mrjwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) mrj on 1=1
+ left join
+ ( select count(*) as myvwiki from myvwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from myvwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) myv on 1=1
+ left join
+ ( select count(*) as nawiki from nawiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
nawiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) na on 1=1
+ left join
+ ( select count(*) as ruwiki from ruwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
ruwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ru on 1=1
+ left join
+ ( select count(*) as tetwiki from tetwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from tetwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) tet on 1=1
+ left join
+ ( select count(*) as towiki from towiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
towiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) to on 1=1
+ left join
+ ( 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
+ ) seventh30
+
;
diff --git a/reportgenerator/config/config.json
b/reportgenerator/config/config.json
index 426c445..5435e4d 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" ]
+ "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" ]
}
--
To view, visit https://gerrit.wikimedia.org/r/218629
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I41148f167c6eb8b0d8f1aac83f7e11b53a84234a
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
