Lokal Profil has uploaded a new change for review.
https://gerrit.wikimedia.org/r/158346
Change subject: Make table name correspond to country name
......................................................................
Make table name correspond to country name
Since country in monuments_all is limited to 10 characters the
previous strings were cropped. Changing the source names to
reflect this leads to less confusion.
Affected tables:
* monuments_se-arbetsliv_(sv) -> monuments_se-arbetsl_(sv)
* monuments_se-fornminne_(sv) -> monuments_se-fornmin_(sv)
Change-Id: I52d43574130db0f12427507a1cc924fca77fe5d7
---
M erfgoedbot/monuments_config.py
M erfgoedbot/sql/fill_table_monuments_all.sql
2 files changed, 5 insertions(+), 5 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/labs/tools/heritage
refs/changes/46/158346/1
diff --git a/erfgoedbot/monuments_config.py b/erfgoedbot/monuments_config.py
index 1183f19..b011ce8 100755
--- a/erfgoedbot/monuments_config.py
+++ b/erfgoedbot/monuments_config.py
@@ -7218,7 +7218,7 @@
},
],
},
- ('se-arbetsliv', 'sv') : { # Working Life Museums in Sweden in Swedish
+ ('se-arbetsl', 'sv') : { # Working Life Museums in Sweden in Swedish
'project' : u'wikipedia',
'lang' : u'sv',
'headerTemplate' : u'Arbetslivsmuseum-huvud',
diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql
b/erfgoedbot/sql/fill_table_monuments_all.sql
index e66962c..067bd59 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -2018,7 +2018,7 @@
FROM `monuments_se-bbr_(sv)`;
/* Fornminne Monuments in Sweden in Swedish */
REPLACE INTO `monuments_all_tmp` (`country`, `lang`, `id`, `adm0`, `adm1`,
`adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`,
`lat_int`, `lon_int`, `image`, `commonscat`, `source`, `changed`,
`monument_article`, `registrant_url` )
-SELECT 'se-fornminne' AS `country`,
+SELECT 'se-fornmin' AS `country`,
'sv' AS `lang`,
`id` AS `id`,
'se' AS `adm0`,
@@ -2039,7 +2039,7 @@
`changed` AS `changed`,
`artikel` AS `monument_article`,
`registrant_url` AS `registrant_url`
- FROM `monuments_se-fornminne_(sv)`;
+ FROM `monuments_se-fornmin_(sv)`;
/* Listed historical ships in Sweden in Swedish */
REPLACE INTO `monuments_all_tmp` (`country`, `lang`, `id`, `adm0`, `adm1`,
`adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`,
`lat_int`, `lon_int`, `image`, `commonscat`, `source`, `changed`,
`monument_article`, `registrant_url` )
SELECT 'se-ship' AS `country`,
@@ -2066,7 +2066,7 @@
FROM `monuments_se-ship_(sv)`;
/* Working Life Museums in Sweden in Swedish */
REPLACE INTO `monuments_all_tmp` (`country`, `lang`, `id`, `adm0`, `adm1`,
`adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`,
`lat_int`, `lon_int`, `image`, `commonscat`, `source`, `changed`,
`monument_article`, `registrant_url` )
-SELECT 'se-arbetsliv' AS `country`,
+SELECT 'se-arbetsl' AS `country`,
'sv' AS `lang`,
`id` AS `id`,
'se' AS `adm0`,
@@ -2087,7 +2087,7 @@
`changed` AS `changed`,
`monument_article` AS `monument_article`,
'' AS `registrant_url` /* FIXME: Add this field to source table */
- FROM `monuments_se-arbetsliv_(sv)`;
+ FROM `monuments_se-arbetsl_(sv)`;
/* Slovakia in German */
REPLACE INTO `monuments_all_tmp` (`country`, `lang`, `id`, `adm0`, `adm1`,
`adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`,
`lat_int`, `lon_int`, `image`, `commonscat`, `source`, `changed`,
`monument_article`, `registrant_url` )
SELECT 'sk' AS `country`,
--
To view, visit https://gerrit.wikimedia.org/r/158346
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I52d43574130db0f12427507a1cc924fca77fe5d7
Gerrit-PatchSet: 1
Gerrit-Project: labs/tools/heritage
Gerrit-Branch: master
Gerrit-Owner: Lokal Profil <lokal.pro...@gmail.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
