KartikMistry has uploaded a new change for review. https://gerrit.wikimedia.org/r/219186
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(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data refs/changes/86/219186/1 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: newchange Gerrit-Change-Id: I1e1f7fd91d42d376ea22e315949719460e803f56 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