Add dbal types and orm query deps

[airbundle] / DataFixtures / AirFixtures.php

diff --git a/DataFixtures/AirFixtures.php b/DataFixtures/AirFixtures.php
index ee2c3635ca26c4b4c873aa7d3d4fab65d66e2936..fd8074cdf8704684d5295a971250e12a7930ac1f 100644 (file)
--- a/DataFixtures/AirFixtures.php
+++ b/DataFixtures/AirFixtures.php
@@ -14,8 +14,7 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
         */
        private $container;
 
-       public function setContainer(\Symfony\Component\DependencyInjection\ContainerInterface $container = null)
-       {
+       public function setContainer(\Symfony\Component\DependencyInjection\ContainerInterface $container = null) {
                $this->container = $container;
        }
 
@@ -75,23 +74,33 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'short' => 'Mr.',
                                'group' => 'Admin',
                                'mail' => 'tango@rapsys.eu',
-                               'pseudonym' => 'Rapsys',
+                               'pseudonym' => 'Milonga Raphaël',
                                'forename' => 'Raphaël',
                                'surname' => 'Gertz',
                                'phone' => '+33677952829',
                                'password' => 'test'
                        ),
+                       array(
+                               'short' => 'Mr.',
+                               'group' => 'Senior',
+                               'mail' => 'denis.courvoisier@wanadoo.fr',
+                               'pseudonym' => 'DJ Sined',
+                               'forename' => 'Denis',
+                               'surname' => 'Courvoisier',
+                               'phone' => '+33600000000',
+                               'password' => 'test'
+                       ),
                        array(
                                'short' => 'Mr.',
                                'group' => 'Senior',
                                'mail' => 'rannou402@orange.fr',
-                               'pseudonym' => 'Mitch',
+                               'pseudonym' => 'Trio Tango',
                                'forename' => 'Michel',
                                'surname' => 'Rannou',
                                'phone' => '+33600000000',
                                'password' => 'test'
                        ),
-                       array(
+                       /*array(
                                'short' => 'Ms.',
                                'group' => 'Regular',
                                'mail' => 'roxmaps@gmail.com',
@@ -100,37 +109,7 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'surname' => 'Prado',
                                'phone' => '+33600000000',
                                'password' => 'test'
-                       ),
-                       array(
-                               'short' => 'Mr.',
-                               'group' => 'Regular',
-                               'mail' => 'majid.ghedjatti@gmail.com',
-                               'pseudonym' => 'El Guerrillero',
-                               'forename' => 'Majid',
-                               'surname' => 'Ghedjatti',
-                               'phone' => '+33600000000',
-                               'password' => 'test'
-                       ),
-                       array(
-                               'short' => 'Mr.',
-                               'group' => 'Senior',
-                               'mail' => 'denis.courvoisier@wanadoo.fr',
-                               'pseudonym' => 'Sined',
-                               'forename' => 'Denis',
-                               'surname' => 'Courvoisier',
-                               'phone' => '+33600000000',
-                               'password' => 'test'
-                       ),
-                       array(
-                               'short' => 'Mr.',
-                               'group' => 'Regular',
-                               'mail' => 'kastango13@gmail.com',
-                               'pseudonym' => 'Kastrat',
-                               'forename' => 'Kastrat',
-                               'surname' => 'Hasaj',
-                               'phone' => '+33600000000',
-                               'password' => 'test'
-                       ),
+                       ),*/
                );
 
                //Create users
@@ -157,7 +136,26 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                $manager->flush();
 
                //Location tree
+               //XXX: adding a new zipcode here requires matching accuweather uris in Command/WeatherCommand.php
                $locationTree = [
+                       [
+                               'title' => 'Opera Garnier',
+                               'short' => 'Garnier',
+                               'address' => '10 Place de l\'Opéra',
+                               'zipcode' => '75009',
+                               'city' => 'Paris',
+                               'latitude' => 48.871268,
+                               'longitude' => 2.331832
+                       ],
+                       [
+                               'title' => 'Tino-Rossi garden',
+                               'short' => 'Docks',
+                               'address' => '2 Quai Saint-Bernard',
+                               'zipcode' => '75005',
+                               'city' => 'Paris',
+                               'latitude' => 48.847736,
+                               'longitude' => 2.360953
+                       ],
                        [
                                'title' => 'Trocadero esplanade',
                                'short' => 'Trocadero',
@@ -168,15 +166,6 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'latitude' => 48.861888,
                                'longitude' => 2.288853
                        ],
-                       [
-                               'title' => 'Orleans gallery',
-                               'short' => 'Orleans',
-                               'address' => '8 Galerie du Jardin',
-                               'zipcode' => '75001',
-                               'city' => 'Paris',
-                               'latitude' => 48.863885,
-                               'longitude' => 2.337387
-                       ],
                        [
                                'title' => 'Colette square',
                                'short' => 'Colette',
@@ -187,31 +176,31 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'longitude' => 2.335847
                        ],
                        [
-                               'title' => 'Tino-Rossi garden',
-                               'short' => 'Docks',
-                               'address' => '2 Quai Saint-Bernard',
-                               'zipcode' => '75005',
+                               'title' => 'Swan Island',
+                               'short' => 'Swan',
+                               'address' => 'Allée des Cygnes',
+                               'zipcode' => '75015',
                                'city' => 'Paris',
-                               'latitude' => 48.847736,
-                               'longitude' => 2.360953
+                               'latitude' => 48.849976, #48.849976
+                               'longitude' => 2.279603 #2.2796029
                        ],
                        [
-                               'title' => 'Drawings\' garden',
-                               'short' => 'Villette',
-                               'address' => 'Allée du Belvédère',
-                               'zipcode' => '75019',
+                               'title' => 'Jussieu esplanade',
+                               'short' => 'Jussieu',
+                               'address' => '25 rue des Fossés Saint-Bernard',
+                               'zipcode' => '75005',
                                'city' => 'Paris',
-                               'latitude' => 48.892503,
-                               'longitude' => 2.389300
+                               'latitude' => 48.847955, #48.8479548
+                               'longitude' => 2.353291 #2.3532907
                        ],
                        [
-                               'title' => 'Saint-Honore market',
-                               'short' => 'St-Honore',
-                               'address' => '1 Passage des Jacobins',
+                               'title' => 'Orleans gallery',
+                               'short' => 'Orleans',
+                               'address' => '8 Galerie du Jardin',
                                'zipcode' => '75001',
                                'city' => 'Paris',
-                               'latitude' => 48.866992,
-                               'longitude' => 2.331752
+                               'latitude' => 48.863885,
+                               'longitude' => 2.337387
                        ],
                        [
                                'title' => 'Orsay museum',
@@ -223,13 +212,13 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'longitude' => 2.325815
                        ],
                        [
-                               'title' => 'Opera Garnier',
-                               'short' => 'Opera',
-                               'address' => '10 Place de l\'Opéra',
-                               'zipcode' => '75009',
+                               'title' => 'Saint-Honore market',
+                               'short' => 'Honore',
+                               'address' => '1 Passage des Jacobins',
+                               'zipcode' => '75001',
                                'city' => 'Paris',
-                               'latitude' => 48.871268,
-                               'longitude' => 2.331832
+                               'latitude' => 48.866992,
+                               'longitude' => 2.331752
                        ],
                        [
                                'title' => 'Tokyo palace',
@@ -239,6 +228,15 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.863827,
                                'longitude' => 2.297339
+                       ],
+                       [
+                               'title' => 'Drawings\' garden',
+                               'short' => 'Villette',
+                               'address' => 'Allée du Belvédère',
+                               'zipcode' => '75019',
+                               'city' => 'Paris',
+                               'latitude' => 48.892503,
+                               'longitude' => 2.389300
                        ]
                ];