{"id":108,"date":"2009-10-10T09:36:28","date_gmt":"2009-10-10T07:36:28","guid":{"rendered":"https:\/\/www.opengis.ch\/2009\/10\/10\/mysql-world-database-as-yaml-fixture\/"},"modified":"2020-04-29T16:08:00","modified_gmt":"2020-04-29T14:08:00","slug":"mysql-world-database-as-yaml-fixture","status":"publish","type":"post","link":"https:\/\/www.opengis.ch\/it\/2009\/10\/10\/mysql-world-database-as-yaml-fixture\/","title":{"rendered":"MySql World Database as YAML fixture"},"content":{"rendered":"

For Symfony application I’m developing I needed all the Region separated by continent (7 continents model). I converted the MySql World Database (https:\/\/dev.mysql.com\/doc\/world-setup\/en\/world-setup.html) to a YAML NestedSet fixture file.
\nI just had to make 4 minor changes to it:
\n– rename the 3 continents that had region with the same name name (North America, South America, Antarctica)
\n– rename the Micronesia\/Caribbean region to Micronesia-Caribbean.
\nthats’ all, enjoy the file Region.yml<\/a>
\nMarco<\/p>\n","protected":false},"excerpt":{"rendered":"

For Symfony application I’m developing I needed all the Region separated by continent (7 continents model). I converted the MySql World Database (https:\/\/dev.mysql.com\/doc\/world-setup\/en\/world-setup.html) to a YAML NestedSet fixture file. I just had to make 4 minor changes to it: – rename the 3 continents that had region with the same […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[28],"tags":[125,93],"class_list":["post-108","post","type-post","status-publish","format-standard","hentry","category-web-development","tag-qgis-org","tag-symfony"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":99,"url":"https:\/\/www.opengis.ch\/it\/2009\/09\/17\/adapting-doctrineexport-grt-lua-to-symfony-standards\/","url_meta":{"origin":108,"position":0},"title":"Adapting doctrineexport.grt.lua to symfony standards","author":"Marco Bernasocchi","date":"17 Settembre 2009","format":false,"excerpt":"Using Mysql workbench to visually design a data model for a symfony application is pretty cool. Thanks to the guys of https:\/\/code.google.com\/p\/mysql-workbench-doctrine-plugin\/ you can export the model to a YAML file ready for Doctrine. the only problem I found using version 0.36 is that classes names are not in UpperCamelCase\u2026","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/it\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17,"url":"https:\/\/www.opengis.ch\/it\/2009\/07\/10\/symfony-project-on-bluehost-shared-hosting\/","url_meta":{"origin":108,"position":1},"title":"Symfony project on (bluehost) shared hosting","author":"Marco Bernasocchi","date":"10 Luglio 2009","format":false,"excerpt":"set up a working Symfony project (with SVN) on my bluehost shared hosting, this tutorial should work for other hosters with minor changes. What I wanted was to be able of using my account as a development server for a small group of developers that would automatically show the last\u2026","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/it\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":60,"url":"https:\/\/www.opengis.ch\/it\/2009\/07\/14\/activating-error-503-from-a-shell-script\/","url_meta":{"origin":108,"position":2},"title":"Activating error 503 from a shell script","author":"Marco Bernasocchi","date":"14 Luglio 2009","format":false,"excerpt":"During deployment of a new version of a website you might want to have your server returning an error 503 (temporarily unavailable). here a solution","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/it\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":116,"url":"https:\/\/www.opengis.ch\/it\/2010\/02\/17\/custom-php-5-3-1-with-apc-and-xdebug-on-dreamhost-shared-hosting\/","url_meta":{"origin":108,"position":3},"title":"Custom PHP 5.3.1 with APC and XDEBUG on (Dreamhost) Shared Host","author":"Marco Bernasocchi","date":"17 Febbraio 2010","format":false,"excerpt":"I've recently been setting up my new dreamhost for symfony projects deployment and the only thing the default PHP is missing is the support for APC (alternate php cache). So after looking at the dreamhost wiki I cleaned up and added some features to the one of the install scripts.\u2026","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/it\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2021,"url":"https:\/\/www.opengis.ch\/it\/2016\/02\/04\/increasing-the-stability-of-processing-algorithms\/","url_meta":{"origin":108,"position":4},"title":"Increasing the stability of processing algorithms","author":"Matthias Kuhn","date":"4 Febbraio 2016","format":false,"excerpt":"Processing just got a new testing framework to improve\u00a0the long-term stability of this important plugin. And you can help to improve it, even if you are not a software developer! This is yet another piece in our never-stopping crusade to improve the stability and quality of the best\u00a0desktop GIS on\u2026","rel":"","context":"In "C++"","block_context":{"text":"C++","link":"https:\/\/www.opengis.ch\/it\/category\/programming\/cpp\/"},"img":{"alt_text":"pr","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2016\/02\/pr.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2016\/02\/pr.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2016\/02\/pr.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2016\/02\/pr.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4497,"url":"https:\/\/www.opengis.ch\/it\/2009\/07\/02\/installing-redmine-on-bluehost-shared-hosting\/","url_meta":{"origin":108,"position":5},"title":"Installing Redmine on (bluehost) shared hosting","author":"Marco Bernasocchi","date":"2 Luglio 2009","format":false,"excerpt":"script to install readmine 0.8.4 on a shared host that offers ruby on rails.","rel":"","context":"In "Web Development"","block_context":{"text":"Web Development","link":"https:\/\/www.opengis.ch\/it\/category\/web-development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/pbdBtI-1K","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":1,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":11236,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/posts\/108\/revisions\/11236"}],"wp:attachment":[{"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opengis.ch\/it\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}