Jean-Frédéric has uploaded a new change for review. https://gerrit.wikimedia.org/r/317580
Change subject: Harvest Wikidata item for de-he (de) ...................................................................... Harvest Wikidata item for de-he (de) Bug: T140795 Change-Id: I18be4569ce7acea41783a930317d9fd641538259 --- M erfgoedbot/monuments_config/de-he_de.json M erfgoedbot/sql/fill_table_monuments_all.sql 2 files changed, 8 insertions(+), 2 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/labs/tools/heritage refs/changes/80/317580/1 diff --git a/erfgoedbot/monuments_config/de-he_de.json b/erfgoedbot/monuments_config/de-he_de.json index d281686..4638ca7 100644 --- a/erfgoedbot/monuments_config/de-he_de.json +++ b/erfgoedbot/monuments_config/de-he_de.json @@ -77,6 +77,11 @@ { "dest": "flurst", "source": "Flurstück" + }, + { + "dest": "wd_item", + "source": "Wikidata", + "check": "checkWD" } ] } \ No newline at end of file diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql b/erfgoedbot/sql/fill_table_monuments_all.sql index c37c39b..df2ff31 100644 --- a/erfgoedbot/sql/fill_table_monuments_all.sql +++ b/erfgoedbot/sql/fill_table_monuments_all.sql @@ -1012,7 +1012,7 @@ /* Hessen, Germany 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` + `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 'de-he' AS `country`, 'de' AS `lang`, @@ -1034,7 +1034,8 @@ `source` AS `source`, `changed` AS `changed`, REPLACE( `artikel`, ' ', '_' ) AS `monument_article`, - `registrant_url` AS `registrant_url` + `registrant_url` AS `registrant_url`, + `wd_item` AS `wd_item` FROM `monuments_de-he_(de)`; /* Bergheim, NRW, Germany in German */ -- To view, visit https://gerrit.wikimedia.org/r/317580 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I18be4569ce7acea41783a930317d9fd641538259 Gerrit-PatchSet: 1 Gerrit-Project: labs/tools/heritage Gerrit-Branch: master Gerrit-Owner: Jean-Frédéric <jeanfrederic.w...@gmail.com> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits