KartikMistry has uploaded a new change for review.
https://gerrit.wikimedia.org/r/218615
Change subject: Fix Wiki database names
......................................................................
Fix Wiki database names
"-" -> "_"
Change-Id: I113d25b35960ede367964c61e4a4c0e79827628a
---
M language/content_translation_beta.sql
M language/content_translation_beta_manual.sql
2 files changed, 20 insertions(+), 20 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/15/218615/1
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
index e64e262..21cbb94 100644
--- a/language/content_translation_beta.sql
+++ b/language/content_translation_beta.sql
@@ -88,11 +88,11 @@
warwiki,
cebwiki,
tlwiki,
- cbk-zamwiki,
+ cbk_zamwiki,
pamwiki,
pagwiki,
ilowiki,
- be-x-oldwiki,
+ be_x_oldwiki,
bewiki,
bclwiki,
kawiki,
@@ -120,15 +120,15 @@
extwiki,
papwiki,
ltwiki,
- bat-smgwiki,
+ bat_smgwiki,
bswiki,
etwiki,
fiwiki,
- fiu-vrowiki,
+ fiu_vrowiki,
fywiki,
hrwiki,
huwiki,
- nds-nlwiki,
+ nds_nlwiki,
nlwiki,
rowiki,
sewiki,
@@ -359,7 +359,7 @@
left join
( select count(*) as tlwiki from tlwiki.user_properties where
up_property = 'cx' and up_value = 1 ) tl on 1=1
left join
- ( select count(*) as cbk-zamwiki from
cbk-zamwiki.user_properties where up_property = 'cx' and up_value = 1 ) cbk-zam
on 1=1
+ ( select count(*) as cbk_zamwiki from
cbk_zamwiki.user_properties where up_property = 'cx' and up_value = 1 ) cbk_zam
on 1=1
left join
( select count(*) as pamwiki from pamwiki.user_properties
where up_property = 'cx' and up_value = 1 ) pam on 1=1
left join
@@ -367,7 +367,7 @@
left join
( select count(*) as ilowiki from ilowiki.user_properties
where up_property = 'cx' and up_value = 1 ) ilo on 1=1
left join
- ( select count(*) as be-x-oldwiki from
be-x-oldwiki.user_properties where up_property = 'cx' and up_value = 1 )
be-x-old on 1=1
+ ( select count(*) as be_x_oldwiki from
be_x_oldwiki.user_properties where up_property = 'cx' and up_value = 1 )
be_x_old on 1=1
left join
( select count(*) as bewiki from bewiki.user_properties where
up_property = 'cx' and up_value = 1 ) be on 1=1
left join
@@ -427,7 +427,7 @@
left join
( select count(*) as ltwiki from ltwiki.user_properties where
up_property = 'cx' and up_value = 1 ) lt on 1=1
left join
- ( select count(*) as bat-smgwiki from
bat-smgwiki.user_properties where up_property = 'cx' and up_value = 1 ) bat-smg
on 1=1
+ ( select count(*) as bat_smgwiki from
bat_smgwiki.user_properties where up_property = 'cx' and up_value = 1 ) bat_smg
on 1=1
left join
( select count(*) as bswiki from bswiki.user_properties where
up_property = 'cx' and up_value = 1 ) bs on 1=1
left join
@@ -435,7 +435,7 @@
left join
( select count(*) as fiwiki from fiwiki.user_properties where
up_property = 'cx' and up_value = 1 ) fi on 1=1
left join
- ( select count(*) as fiu-vrowiki from
fiu-vrowiki.user_properties where up_property = 'cx' and up_value = 1 ) fiu-vro
on 1=1
+ ( select count(*) as fiu_vrowiki from
fiu_vrowiki.user_properties where up_property = 'cx' and up_value = 1 ) fiu_vro
on 1=1
left join
( select count(*) as fywiki from fywiki.user_properties where
up_property = 'cx' and up_value = 1 ) fy on 1=1
left join
@@ -447,7 +447,7 @@
cross join
(select *
- from ( select count(*) as nds-nlwiki from
nds-nlwiki.user_properties where up_property = 'cx' and up_value = 1 ) nds-nl
+ from ( select count(*) as nds_nlwiki from
nds_nlwiki.user_properties where up_property = 'cx' and up_value = 1 ) nds_nl
left join
( select count(*) as nlwiki from nlwiki.user_properties where
up_property = 'cx' and up_value = 1 ) nl on 1=1
left join
diff --git a/language/content_translation_beta_manual.sql
b/language/content_translation_beta_manual.sql
index 0fbabc1..eb82a83 100644
--- a/language/content_translation_beta_manual.sql
+++ b/language/content_translation_beta_manual.sql
@@ -88,11 +88,11 @@
warwiki,
cebwiki,
tlwiki,
- cbk-zamwiki,
+ cbk_zamwiki,
pamwiki,
pagwiki,
ilowiki,
- be-x-oldwiki,
+ be_x_oldwiki,
bewiki,
bclwiki,
kawiki,
@@ -120,15 +120,15 @@
extwiki,
papwiki,
ltwiki,
- bat-smgwiki,
+ bat_smgwiki,
bswiki,
etwiki,
fiwiki,
- fiu-vrowiki,
+ fiu_vrowiki,
fywiki,
hrwiki,
huwiki,
- nds-nlwiki,
+ nds_nlwiki,
nlwiki,
rowiki,
sewiki,
@@ -359,7 +359,7 @@
left join
( select count(*) as tlwiki from tlwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
tlwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) tl on 1=1
left join
- ( select count(*) as cbk-zamwiki from
cbk-zamwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from cbk-zamwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) cbk-zam on 1=1
+ ( select count(*) as cbk_zamwiki from
cbk_zamwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from cbk_zamwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) cbk_zam on 1=1
left join
( select count(*) as pamwiki from pamwiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from pamwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) pam on 1=1
left join
@@ -367,7 +367,7 @@
left join
( select count(*) as ilowiki from ilowiki.user_properties
where up_property = 'cx' and up_value = 1 and up_user not in ( select up_user
from ilowiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) ilo on 1=1
left join
- ( select count(*) as be-x-oldwiki from
be-x-oldwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from be-x-oldwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) be-x-old on 1=1
+ ( select count(*) as be_x_oldwiki from
be_x_oldwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from be_x_oldwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) be_x_old on 1=1
left join
( select count(*) as bewiki from bewiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
bewiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) be on 1=1
left join
@@ -427,7 +427,7 @@
left join
( select count(*) as ltwiki from ltwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
ltwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) lt on 1=1
left join
- ( select count(*) as bat-smgwiki from
bat-smgwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from bat-smgwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) bat-smg on 1=1
+ ( select count(*) as bat_smgwiki from
bat_smgwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from bat_smgwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) bat_smg on 1=1
left join
( select count(*) as bswiki from bswiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
bswiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) bs on 1=1
left join
@@ -435,7 +435,7 @@
left join
( select count(*) as fiwiki from fiwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fiwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fi on 1=1
left join
- ( select count(*) as fiu-vrowiki from
fiu-vrowiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from fiu-vrowiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) fiu-vro on 1=1
+ ( select count(*) as fiu_vrowiki from
fiu_vrowiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from fiu_vrowiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) fiu_vro on 1=1
left join
( select count(*) as fywiki from fywiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
fywiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) fy on 1=1
left join
@@ -447,7 +447,7 @@
(select *
from ( select count(*) as huwiki from huwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
huwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) hu
left join
- ( select count(*) as nds-nlwiki from
nds-nlwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from nds-nlwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) nds-nl on 1=1
+ ( select count(*) as nds_nlwiki from
nds_nlwiki.user_properties where up_property = 'cx' and up_value = 1 and
up_user not in ( select up_user from nds_nlwiki.user_properties where
up_property = 'betafeatures-auto-enroll' and up_value = 1 ) ) nds_nl on 1=1
left join
( select count(*) as nlwiki from nlwiki.user_properties where
up_property = 'cx' and up_value = 1 and up_user not in ( select up_user from
nlwiki.user_properties where up_property = 'betafeatures-auto-enroll' and
up_value = 1 ) ) nl on 1=1
left join
--
To view, visit https://gerrit.wikimedia.org/r/218615
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I113d25b35960ede367964c61e4a4c0e79827628a
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
