jenkins-bot has submitted this change and it was merged.
Change subject: Add Nigeria in English to the database
......................................................................
Add Nigeria in English to the database
Bug: T143573
Change-Id: Ie3c3c0b7f4ebfd37a8f7fa4d9c5decd5cabe0ef9
---
A erfgoedbot/monuments_config/ng_en.json
M erfgoedbot/sql/fill_table_monuments_all.sql
2 files changed, 93 insertions(+), 0 deletions(-)
Approvals:
Jean-Frédéric: Looks good to me, approved
jenkins-bot: Verified
diff --git a/erfgoedbot/monuments_config/ng_en.json
b/erfgoedbot/monuments_config/ng_en.json
new file mode 100644
index 0000000..9f3d89a
--- /dev/null
+++ b/erfgoedbot/monuments_config/ng_en.json
@@ -0,0 +1,64 @@
+{
+ "country": "ng",
+ "lang": "en",
+ "description": "Monuments in Nigeria in English",
+ "project": "wikipedia",
+ "namespaces": [
+ 0
+ ],
+ "table": "monuments_ng_(en)",
+ "truncate": false,
+ "primkey": "wd_item",
+ "headerTemplate": "Nigeria listed historic sites header",
+ "rowTemplate": "Nigeria listed historic sites item",
+ "commonsTemplate": "",
+ "commonsTrackerCategory": "",
+ "commonsCategoryBase": "Cultural heritage monuments in Nigeria",
+ "unusedImagesPage": "",
+ "imagesWithoutIdPage": "",
+ "fields": [
+ {
+ "dest": "name",
+ "source": "name"
+ },
+ {
+ "dest": "wd_item",
+ "source": "id"
+ },
+ {
+ "dest": "monument_article",
+ "source": "name",
+ "conv": "extractWikilink"
+ },
+ {
+ "dest": "place",
+ "source": "location"
+ },
+ {
+ "dest": "state",
+ "source": "state"
+ },
+ {
+ "dest": "lat",
+ "source": "lat",
+ "check": "checkLat"
+ },
+ {
+ "dest": "lon",
+ "source": "lon",
+ "check": "checkLon"
+ },
+ {
+ "dest": "address",
+ "source": "address"
+ },
+ {
+ "dest": "image",
+ "source": "image"
+ },
+ {
+ "dest": "commonscat",
+ "source": "commonscat"
+ }
+ ]
+}
diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql
b/erfgoedbot/sql/fill_table_monuments_all.sql
index 5498d1e..b549f5e 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -1958,6 +1958,35 @@
'' AS `registrant_url`
FROM `monuments_mx_(es)`;
+/* Nigeria in English */
+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`,
`wd_item`
+ ) SELECT
+ 'ng' AS `country`,
+ 'en' AS `lang`,
+ `wd_item` AS `id`,
+ 'ng' AS `adm0`,
+ NULL AS `adm1`,
+ NULL AS `adm2`,
+ NULL AS `adm3`,
+ NULL AS `adm4`,
+ `name` AS `name`,
+ `place` AS `address`,
+ `state` 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`,
+ `monument_article` AS `monument_article`,
+ '' AS `registrant_url`,
+ `wd_item` AS `wd_item`
+ FROM `monuments_ng_(en)`;
+
/* Netherlands in Dutch */
REPLACE INTO
`monuments_all_tmp` (
--
To view, visit https://gerrit.wikimedia.org/r/314860
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ie3c3c0b7f4ebfd37a8f7fa4d9c5decd5cabe0ef9
Gerrit-PatchSet: 2
Gerrit-Project: labs/tools/heritage
Gerrit-Branch: master
Gerrit-Owner: Lokal Profil <lokal.pro...@gmail.com>
Gerrit-Reviewer: Jean-Frédéric <jeanfrederic.w...@gmail.com>
Gerrit-Reviewer: Lokal Profil <lokal.pro...@gmail.com>
Gerrit-Reviewer: Multichill <maar...@mdammers.nl>
Gerrit-Reviewer: Siebrand <siebr...@kitano.nl>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
