[MediaWiki-commits] [Gerrit] Add Iran in Farsi to Monuments database - change (labs...heritage)

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

Change subject: Add Iran in Farsi to Monuments database
..


Add Iran in Farsi to Monuments database

Change-Id: I1ce5a25dbd9dc8adedcada495fd9f745b1d9
---
M erfgoedbot/monuments_config.py
M erfgoedbot/sql/fill_table_monuments_all.sql
2 files changed, 96 insertions(+), 0 deletions(-)

Approvals:
  Lokal Profil: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/erfgoedbot/monuments_config.py b/erfgoedbot/monuments_config.py
index 4f466f7..7d5a29b 100755
--- a/erfgoedbot/monuments_config.py
+++ b/erfgoedbot/monuments_config.py
@@ -4738,6 +4738,74 @@
 },
 ],
 },
+('ir', 'fa'): {  # National monuments in Iran in Farsi
+'project': u'wikipedia',
+'lang': u'fa',
+'headerTemplate': u'سرآیند_یادمان_ایران',
+'rowTemplate': u'ردیف یادمان ایران',
+'commonsTemplate': u'Cultural Heritage Iran',
+'commonsTrackerCategory': u'Cultural heritage monuments in Iran with 
known IDs',
+'commonsCategoryBase': u'Cultural heritage monuments in Iran',
+'unusedImagesPage': u'User:LilyOfTheWest/Unused images',
+'imagesWithoutIdPage': u'User:LilyOfTheWest/Images without Id',
+'namespaces': [0],
+'table': u'monuments_ir_(fa)',
+'truncate': False,
+'primkey': u'id',
+'fields': [
+{
+'source': u'شناسه',
+'dest': u'id',
+},
+{
+'source': u'توضیح',
+'dest': u'name',
+},
+{
+'source': u'شهر',
+'dest': u'city',
+},
+{
+'source': u'مکان',
+'dest': u'address',
+},
+{
+'source': u'تاریخ ثبت',
+'dest': u'registration_date',
+},
+{
+'source': u'قدمت',
+'dest': u'age',
+},
+{
+'source': u'عکس',
+'dest': u'image',
+},
+{
+'source': u'ISO',
+'dest': u'ISO',
+},
+{
+'source': u'طول جغرافیایی',
+'dest': u'lat',
+'check': u'checkLat',
+},
+{
+'source': u'عرض جغرافیایی',
+'dest': u'lon',
+'check': u'checkLon',
+},
+{
+'source': u'commonscat',
+'dest': u'commonscat',
+},
+{
+'source': u'توضیح',
+'dest': u'monument_article',
+'conv': u'extractWikilink',
+},
+],
+},
 ('it', 'it'): {  # Monuments in Italy in Italian
 'project': u'wikipedia',
 'lang': u'it',
diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql 
b/erfgoedbot/sql/fill_table_monuments_all.sql
index f992ee5..587ee2c 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -1617,6 +1617,34 @@
 '' AS `registrant_url`
 FROM `monuments_ie_(en)`;
 
+/* Iran in Farsi */
+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
+'ir' AS `country`,
+'fa' AS `lang`,
+`id` AS `id`,
+'ir' AS `adm0`,
+LOWER(`ISO`) AS `adm1`,
+NULL AS `adm2`,
+NULL AS `adm3`,
+NULL AS `adm4`,
+`name` AS `name`,
+'address' AS `address`,
+`city` 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`
+FROM `monuments_ir_(fa)`;
+
 /* Italy in Italian */
 REPLACE INTO
   `monuments_all_tmp` (

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1ce5a25dbd9dc8adedcada495fd9f745b1d9
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: Springle 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] Add Iran in Farsi to Monuments database - change (labs...heritage)

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

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

Change subject: Add Iran in Farsi to Monuments database
..

Add Iran in Farsi to Monuments database

Change-Id: I1ce5a25dbd9dc8adedcada495fd9f745b1d9
---
M erfgoedbot/monuments_config.py
M erfgoedbot/sql/fill_table_monuments_all.sql
2 files changed, 96 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/labs/tools/heritage 
refs/changes/07/295507/1

diff --git a/erfgoedbot/monuments_config.py b/erfgoedbot/monuments_config.py
index 4f466f7..7d5a29b 100755
--- a/erfgoedbot/monuments_config.py
+++ b/erfgoedbot/monuments_config.py
@@ -4738,6 +4738,74 @@
 },
 ],
 },
+('ir', 'fa'): {  # National monuments in Iran in Farsi
+'project': u'wikipedia',
+'lang': u'fa',
+'headerTemplate': u'سرآیند_یادمان_ایران',
+'rowTemplate': u'ردیف یادمان ایران',
+'commonsTemplate': u'Cultural Heritage Iran',
+'commonsTrackerCategory': u'Cultural heritage monuments in Iran with 
known IDs',
+'commonsCategoryBase': u'Cultural heritage monuments in Iran',
+'unusedImagesPage': u'User:LilyOfTheWest/Unused images',
+'imagesWithoutIdPage': u'User:LilyOfTheWest/Images without Id',
+'namespaces': [0],
+'table': u'monuments_ir_(fa)',
+'truncate': False,
+'primkey': u'id',
+'fields': [
+{
+'source': u'شناسه',
+'dest': u'id',
+},
+{
+'source': u'توضیح',
+'dest': u'name',
+},
+{
+'source': u'شهر',
+'dest': u'city',
+},
+{
+'source': u'مکان',
+'dest': u'address',
+},
+{
+'source': u'تاریخ ثبت',
+'dest': u'registration_date',
+},
+{
+'source': u'قدمت',
+'dest': u'age',
+},
+{
+'source': u'عکس',
+'dest': u'image',
+},
+{
+'source': u'ISO',
+'dest': u'ISO',
+},
+{
+'source': u'طول جغرافیایی',
+'dest': u'lat',
+'check': u'checkLat',
+},
+{
+'source': u'عرض جغرافیایی',
+'dest': u'lon',
+'check': u'checkLon',
+},
+{
+'source': u'commonscat',
+'dest': u'commonscat',
+},
+{
+'source': u'توضیح',
+'dest': u'monument_article',
+'conv': u'extractWikilink',
+},
+],
+},
 ('it', 'it'): {  # Monuments in Italy in Italian
 'project': u'wikipedia',
 'lang': u'it',
diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql 
b/erfgoedbot/sql/fill_table_monuments_all.sql
index f992ee5..587ee2c 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -1617,6 +1617,34 @@
 '' AS `registrant_url`
 FROM `monuments_ie_(en)`;
 
+/* Iran in Farsi */
+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
+'ir' AS `country`,
+'fa' AS `lang`,
+`id` AS `id`,
+'ir' AS `adm0`,
+LOWER(`ISO`) AS `adm1`,
+NULL AS `adm2`,
+NULL AS `adm3`,
+NULL AS `adm4`,
+`name` AS `name`,
+'address' AS `address`,
+`city` 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`
+FROM `monuments_ir_(fa)`;
+
 /* Italy in Italian */
 REPLACE INTO
   `monuments_all_tmp` (

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

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