https://bugzilla.wikimedia.org/show_bug.cgi?id=38312
Web browser: ---
Bug #: 38312
Summary: Make a script to fill the admin_tree table
Product: Monuments database
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General
AssignedTo: [email protected]
ReportedBy: [email protected]
Depends on: 38311
Classification: Unclassified
Mobile Platform: ---
A script should be created to be run once a day. This script should take
monuments_all and use this to fill the admin_tree table.
Monuments_all contains adm0-4. Level 0:
mysql> SELECT DISTINCT(adm0) FROM `monuments_all`;
+------+
| adm0 |
+------+
| ad |
| at |
| be |
| ch |
| dk |
| ee |
| es |
| fr |
| gb |
| ie |
| it |
| lu |
| mt |
| nl |
| no |
| pl |
| pt |
| se |
| sk |
| us |
+------+
And deeper
mysql> SELECT DISTINCT(adm1) FROM `monuments_all` WHERE adm0='nl';
+-------+
| adm1 |
+-------+
| NL-UT |
| NL-NB |
| NL-ZH |
| NL-GE |
| NL-NH |
| NL-LI |
| NL-ZE |
| NL-GR |
| NL-FR |
| NL-OV |
| NL-DR |
| NL-FL |
+-------+
12 rows in set (1.21 sec)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
