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
