[MediaWiki-commits] [Gerrit] labs...heritage[master]: Harvest Wikidata item for fr (ca)
jenkins-bot has submitted this change and it was merged. Change subject: Harvest Wikidata item for fr (ca) .. Harvest Wikidata item for fr (ca) Bug: T140795 Change-Id: Id670fc430b2dbdb89f587b30bb8878abcfceba56 --- M erfgoedbot/monuments_config/fr_ca.json M erfgoedbot/sql/fill_table_monuments_all.sql 2 files changed, 8 insertions(+), 2 deletions(-) Approvals: Lokal Profil: Looks good to me, approved jenkins-bot: Verified diff --git a/erfgoedbot/monuments_config/fr_ca.json b/erfgoedbot/monuments_config/fr_ca.json index d72cd9b..b1ebc57 100644 --- a/erfgoedbot/monuments_config/fr_ca.json +++ b/erfgoedbot/monuments_config/fr_ca.json @@ -75,6 +75,11 @@ "dest": "registrant_url", "source": "id", "conv": "generateRegistrantUrl" +}, +{ +"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 13cbeb5..98d0d88 100644 --- a/erfgoedbot/sql/fill_table_monuments_all.sql +++ b/erfgoedbot/sql/fill_table_monuments_all.sql @@ -1293,7 +1293,7 @@ /* France in Catalan */ 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 'fr' AS `country`, 'ca' AS `lang`, @@ -1315,7 +1315,8 @@ `source` AS `source`, `changed` AS `changed`, `monument_article` AS `monument_article`, -`registrant_url` AS `registrant_url` +`registrant_url` AS `registrant_url`, +`wd_item` AS `wd_item` FROM `monuments_fr_(ca)`; /* France in French */ -- To view, visit https://gerrit.wikimedia.org/r/317577 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Id670fc430b2dbdb89f587b30bb8878abcfceba56 Gerrit-PatchSet: 1 Gerrit-Project: labs/tools/heritage Gerrit-Branch: master Gerrit-Owner: Jean-Frédéric Gerrit-Reviewer: Lokal Profil Gerrit-Reviewer: Multichill Gerrit-Reviewer: jenkins-bot <> ___ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
[MediaWiki-commits] [Gerrit] labs...heritage[master]: Harvest Wikidata item for fr (ca)
Jean-Frédéric has uploaded a new change for review. https://gerrit.wikimedia.org/r/317577 Change subject: Harvest Wikidata item for fr (ca) .. Harvest Wikidata item for fr (ca) Bug: T140795 Change-Id: Id670fc430b2dbdb89f587b30bb8878abcfceba56 --- M erfgoedbot/monuments_config/fr_ca.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/77/317577/1 diff --git a/erfgoedbot/monuments_config/fr_ca.json b/erfgoedbot/monuments_config/fr_ca.json index d72cd9b..b1ebc57 100644 --- a/erfgoedbot/monuments_config/fr_ca.json +++ b/erfgoedbot/monuments_config/fr_ca.json @@ -75,6 +75,11 @@ "dest": "registrant_url", "source": "id", "conv": "generateRegistrantUrl" +}, +{ +"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 13cbeb5..98d0d88 100644 --- a/erfgoedbot/sql/fill_table_monuments_all.sql +++ b/erfgoedbot/sql/fill_table_monuments_all.sql @@ -1293,7 +1293,7 @@ /* France in Catalan */ 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 'fr' AS `country`, 'ca' AS `lang`, @@ -1315,7 +1315,8 @@ `source` AS `source`, `changed` AS `changed`, `monument_article` AS `monument_article`, -`registrant_url` AS `registrant_url` +`registrant_url` AS `registrant_url`, +`wd_item` AS `wd_item` FROM `monuments_fr_(ca)`; /* France in French */ -- To view, visit https://gerrit.wikimedia.org/r/317577 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Id670fc430b2dbdb89f587b30bb8878abcfceba56 Gerrit-PatchSet: 1 Gerrit-Project: labs/tools/heritage Gerrit-Branch: master Gerrit-Owner: Jean-Frédéric ___ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits