Lokal Profil has uploaded a new change for review. https://gerrit.wikimedia.org/r/310889
Change subject: Add Georgia in Georgian to database ...................................................................... Add Georgia in Georgian to database Bug: T144772 Change-Id: Iaad07d33a14cb8682940e9ca5f440be0ad3ce278 --- M erfgoedbot/monuments_config.py M erfgoedbot/sql/fill_table_monuments_all.sql 2 files changed, 97 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/labs/tools/heritage refs/changes/89/310889/1 diff --git a/erfgoedbot/monuments_config.py b/erfgoedbot/monuments_config.py index 7a2bbc1..e64069c 100755 --- a/erfgoedbot/monuments_config.py +++ b/erfgoedbot/monuments_config.py @@ -4274,6 +4274,75 @@ }, ], }, + ('ge', 'ka'): { # Monuments in Georgia in Georgian + 'project': u'wikipedia', + 'lang': u'ka', + 'headerTemplate': u'GEO Monument header', + 'rowTemplate': u'GEO Monument row', + 'commonsTemplate': u'Cultural Heritage Georgia', + 'commonsTrackerCategory': u'Cultural heritage monuments in Georgia with known IDs', + 'commonsCategoryBase': u'Cultural heritage monuments in Georgia', + 'autoGeocode': False, + 'unusedImagesPage': u'ვიკიპედია:გამოუყენებელი სურათები', + 'imagesWithoutIdPage': u'ვიკიპედია:სურათები იდენტიფიკატორის გარეშე', + 'registrantUrlBase': u'', + 'namespaces': [4], + 'table': u'monuments_ge_(ka)', + 'truncate': False, + 'primkey': u'id', + 'fields': [ + { + 'source': u'state_iso', + 'dest': u'region_iso', + }, + { + 'source': u'municipality', + 'dest': u'municipality', + }, + { + 'source': u'name', + 'dest': u'name', + }, + { + 'source': u'ID', + 'dest': u'id', + }, + { + 'source': u'type', + 'dest': u'type', + }, + { + 'source': u'date', + 'dest': u'date', + }, + { + 'source': u'lat', + 'dest': u'lat', + 'check': u'checkLat', + }, + { + 'source': u'lon', + 'dest': u'lon', + 'check': u'checkLon', + }, + { + 'source': u'address', + 'dest': u'address', + }, + { + 'source': u'image', + 'dest': u'image', + }, + { + 'source': u'commonscat', + 'dest': u'commonscat', + }, + { + 'source': u'ref', + 'dest': u'registrant_url', + }, + ], + }, ('gh', 'en'): { # Ghana monuments in English 'project': u'wikipedia', 'lang': u'en', diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql b/erfgoedbot/sql/fill_table_monuments_all.sql index 2dd688a..17e1d2e 100644 --- a/erfgoedbot/sql/fill_table_monuments_all.sql +++ b/erfgoedbot/sql/fill_table_monuments_all.sql @@ -1482,6 +1482,34 @@ `registrant_url` AS `registrant_url` FROM `monuments_gb-wls_(en)`; +/* Georgia in Georgian */ +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 + 'ge' AS `country`, + 'ka' AS `lang`, + `id` AS `id`, + 'ge' AS `adm0`, + LOWER(`region_iso`) AS `adm1`, + `municipality` AS `adm2`, + NULL AS `adm3`, + NULL AS `adm4`, + `name` AS `name`, + `address` AS `address`, + `municipality` AS `municipality`, + `lat` AS `lat`, + `lon` AS `lon`, + ROUND(`lat` * @granularity) AS `lat_int`, + ROUND(`lon` * @granularity) AS `lon_int`, + `image` AS `image`, + `commonscat` AS `commonscat`, + `source` AS `source`, + `changed` AS `changed`, + '' AS `monument_article`, -- Not available + `registrant_url` AS `registrant_url`, + FROM `monuments_ge_(ka)`; + /* Ghana in English */ REPLACE INTO `monuments_all_tmp` ( -- To view, visit https://gerrit.wikimedia.org/r/310889 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Iaad07d33a14cb8682940e9ca5f440be0ad3ce278 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