[MediaWiki-commits] [Gerrit] labs...heritage[master]: Harvest Wikidata item for es (ca)

2016-10-25 Thread jenkins-bot (Code Review) 
jenkins-bot has submitted this change and it was merged.

Change subject: Harvest Wikidata item for es (ca)
..


Harvest Wikidata item for es (ca)

Bug: T140795

Change-Id: Ibf81583be081578de275b8076fb207e01c76bb6f
---
M erfgoedbot/monuments_config/es_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/es_ca.json 
b/erfgoedbot/monuments_config/es_ca.json
index fd3d3ef..1cf6507 100644
--- a/erfgoedbot/monuments_config/es_ca.json
+++ b/erfgoedbot/monuments_config/es_ca.json
@@ -90,6 +90,11 @@
 {
 "dest": "registrant_url",
 "source": ""
+},
+{
+"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 20df63c..c37c39b 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -1152,7 +1152,7 @@
 /* Spain 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
 'es' AS `country`,
 'ca' AS `lang`,
@@ -1174,7 +1174,8 @@
 `source` AS `source`,
 `changed` AS `changed`,
 `monument_article` AS `monument_article`,
-'' AS `registrant_url`
+'' AS `registrant_url`,
+`wd_item` AS `wd_item`
 FROM `monuments_es_(ca)`;
 
 /* Spain in Spanish */

-- 
To view, visit https://gerrit.wikimedia.org/r/317579
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Ibf81583be081578de275b8076fb207e01c76bb6f
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 es (ca)

2016-10-24 Thread Code Review 
Jean-Frédéric has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/317579

Change subject: Harvest Wikidata item for es (ca)
..

Harvest Wikidata item for es (ca)

Bug: T140795

Change-Id: Ibf81583be081578de275b8076fb207e01c76bb6f
---
M erfgoedbot/monuments_config/es_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/79/317579/1

diff --git a/erfgoedbot/monuments_config/es_ca.json 
b/erfgoedbot/monuments_config/es_ca.json
index fd3d3ef..1cf6507 100644
--- a/erfgoedbot/monuments_config/es_ca.json
+++ b/erfgoedbot/monuments_config/es_ca.json
@@ -90,6 +90,11 @@
 {
 "dest": "registrant_url",
 "source": ""
+},
+{
+"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 20df63c..c37c39b 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -1152,7 +1152,7 @@
 /* Spain 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
 'es' AS `country`,
 'ca' AS `lang`,
@@ -1174,7 +1174,8 @@
 `source` AS `source`,
 `changed` AS `changed`,
 `monument_article` AS `monument_article`,
-'' AS `registrant_url`
+'' AS `registrant_url`,
+`wd_item` AS `wd_item`
 FROM `monuments_es_(ca)`;
 
 /* Spain in Spanish */

-- 
To view, visit https://gerrit.wikimedia.org/r/317579
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibf81583be081578de275b8076fb207e01c76bb6f
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