Version 0.5.0

[airbundle] / DataFixtures / AirFixtures.php

diff --git a/DataFixtures/AirFixtures.php b/DataFixtures/AirFixtures.php
index 8ccf57266b668fd4e3c37cbeaf8d4aefaf485048..89593f07555e5a8174cb766da9640be5ab8b1c52 100644 (file)
--- a/DataFixtures/AirFixtures.php
+++ b/DataFixtures/AirFixtures.php
@@ -1,64 +1,92 @@
-<?php
+<?php declare(strict_types=1);
+
+/*
+ * This file is part of the Rapsys AirBundle package.
+ *
+ * (c) Raphaël Gertz <symfony@rapsys.eu>
+ *
+ * For the full copyright and license information, please view the LICENSE
+ * file that was distributed with this source code.
+ */

 
 namespace Rapsys\AirBundle\DataFixtures;
 
 
 namespace Rapsys\AirBundle\DataFixtures;
 

+use Doctrine\Bundle\FixturesBundle\Fixture;
+use Doctrine\Persistence\ObjectManager;
+use Symfony\Component\DependencyInjection\ContainerInterface;
+use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
+

 use Rapsys\AirBundle\Entity\Civility;
 use Rapsys\AirBundle\Entity\Group;
 use Rapsys\AirBundle\Entity\User;
 use Rapsys\AirBundle\Entity\Location;
 use Rapsys\AirBundle\Entity\Slot;
 
 use Rapsys\AirBundle\Entity\Civility;
 use Rapsys\AirBundle\Entity\Group;
 use Rapsys\AirBundle\Entity\User;
 use Rapsys\AirBundle\Entity\Location;
 use Rapsys\AirBundle\Entity\Slot;
 

-class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Symfony\Component\DependencyInjection\ContainerAwareInterface {
+/**
+ * {@inheritdoc}
+ */
+class AirFixtures extends Fixture {

        /**
        /**

-        * @var ContainerInterface
+        * Air fixtures constructor

         */
         */

-       private $container;
-
-       public function setContainer(\Symfony\Component\DependencyInjection\ContainerInterface $container = null) {
-               $this->container = $container;
+       public function __construct(protected ContainerInterface $container, protected UserPasswordHasherInterface $hasher) {

        }
 
        /**
         * {@inheritDoc}
         */
        }
 
        /**
         * {@inheritDoc}
         */

-       public function load(\Doctrine\Common\Persistence\ObjectManager $manager) {
-               $encoder = $this->container->get('security.password_encoder');
-
+       public function load(ObjectManager $manager) {

                //Civility tree
                //Civility tree

-               $civilityTree = array(
-                       'Mr.' => 'Mister',
-                       'Mrs.' => 'Madam',
-                       'Ms.' => 'Miss'
-               );
+               $civilityTree = [
+                       'Mister',
+                       'Madam',
+                       'Miss'
+               ];

 
                //Create titles
 
                //Create titles

-               $civilitys = array();
-               foreach($civilityTree as $shortData => $civilityData) {
-                       $civility = new Title($civilityData);
-                       $civility->setShort($shortData);
-                       $civility->setCreated(new \DateTime('now'));
-                       $civility->setUpdated(new \DateTime('now'));
+               $civilitys = [];
+               foreach($civilityTree as $civilityData) {
+                       $civility = new Civility($civilityData);

                        $manager->persist($civility);
                        $manager->persist($civility);

-                       $civilitys[$shortData] = $civility;
+                       $civilitys[$civilityData] = $civility;

                        unset($civility);
                }
 
                        unset($civility);
                }
 

+               //TODO: insert countries from https://raw.githubusercontent.com/raramuridesign/mysql-country-list/master/country-lists/mysql-country-list-detailed-info.sql
+               #CREATE TABLE `countries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(2) NOT NULL, `alpha` varchar(3) NOT NULL, `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), UNIQUE KEY `alpha` (`alpha`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+               #insert into countries (code, alpha, title, created, updated) select countryCode, isoAlpha3, countryName, NOW(), NOW() FROM apps_countries_detailed ORDER BY countryCode ASC, isoAlpha3 ASC;
+
+               //Dance tree
+               $danceTree = [
+                       'Argentine Tango' => [
+                          'Milonga', 'Class and milonga', 'Public class', 'Private class'
+                       ]
+               ];
+
+               //Create titles
+               $dances = [];
+               foreach($danceTree as $danceTitle => $danceData) {
+                       foreach($danceData as $danceType) {
+                               $dance = new Dance($danceTitle, $danceType);
+                               $manager->persist($dance);
+                               unset($dance);
+                       }
+               }
+

                //Group tree
                //XXX: ROLE_XXX is required by
                //Group tree
                //XXX: ROLE_XXX is required by

-               $groupTree = array(
+               $groupTree = [

                        'User',
                        'Guest',
                        'Regular',
                        'Senior',
                        'Admin'
                        'User',
                        'Guest',
                        'Regular',
                        'Senior',
                        'Admin'

-               );
+               ];

 
                //Create groups
 
                //Create groups

-               $groups = array();
+               $groups = [];

                foreach($groupTree as $groupData) {
                        $group = new Group($groupData);
                foreach($groupTree as $groupData) {
                        $group = new Group($groupData);

-                       $group->setCreated(new \DateTime('now'));
-                       $group->setUpdated(new \DateTime('now'));

                        $manager->persist($group);
                        $groups[$groupData] = $group;
                        unset($group);
                        $manager->persist($group);
                        $groups[$groupData] = $group;
                        unset($group);


@@ -68,8 +96,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                $manager->flush();
 
                //User tree
                $manager->flush();
 
                //User tree

-               $userTree = array(
-                       array(
+               $userTree = [
+                       [

                                'short' => 'Mr.',
                                'group' => 'Admin',
                                'mail' => 'tango@rapsys.eu',
                                'short' => 'Mr.',
                                'group' => 'Admin',
                                'mail' => 'tango@rapsys.eu',


@@ -78,8 +106,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'surname' => 'Gertz',
                                'phone' => '+33677952829',
                                'password' => 'test'
                                'surname' => 'Gertz',
                                'phone' => '+33677952829',
                                'password' => 'test'

-                       ),
-                       /*array(
+                       ],
+                       /*[

                                'short' => 'Mr.',
                                'group' => 'Senior',
                                'mail' => 'denis.courvoisier@wanadoo.fr',
                                'short' => 'Mr.',
                                'group' => 'Senior',
                                'mail' => 'denis.courvoisier@wanadoo.fr',


@@ -88,8 +116,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'surname' => 'Courvoisier',
                                'phone' => '+33600000000',
                                'password' => 'test'
                                'surname' => 'Courvoisier',
                                'phone' => '+33600000000',
                                'password' => 'test'

-                       ),*/
-                       array(
+                       ],*/
+                       [

                                'short' => 'Mr.',
                                'group' => 'Senior',
                                'mail' => 'rannou402@orange.fr',
                                'short' => 'Mr.',
                                'group' => 'Senior',
                                'mail' => 'rannou402@orange.fr',


@@ -98,8 +126,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'surname' => 'Rannou',
                                'phone' => '+33600000000',
                                'password' => 'test'
                                'surname' => 'Rannou',
                                'phone' => '+33600000000',
                                'password' => 'test'

-                       ),
-                       /*array(
+                       ],
+                       /*[

                                'short' => 'Ms.',
                                'group' => 'Regular',
                                'mail' => 'roxmaps@gmail.com',
                                'short' => 'Ms.',
                                'group' => 'Regular',
                                'mail' => 'roxmaps@gmail.com',


@@ -108,22 +136,18 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'surname' => 'Prado',
                                'phone' => '+33600000000',
                                'password' => 'test'
                                'surname' => 'Prado',
                                'phone' => '+33600000000',
                                'password' => 'test'

-                       ),*/
-               );
+                       ],*/
+               ];

 
                //Create users
 
                //Create users

-               $users = array();
+               $users = [];

                foreach($userTree as $userData) {
                foreach($userTree as $userData) {

-                       $user = new User($userData['mail']);
+                       $user = new User($userData['mail'], $userData['password'], $civilitys[$userData['short']], $userData['forename'], $userData['surname']);
+                       #TODO: check that password is hashed correctly !!!
+                       #$user->setPassword($this->hasher->hashPassword($user, $userData['password']));

                        $user->setPseudonym($userData['pseudonym']);
                        $user->setPseudonym($userData['pseudonym']);

-                       $user->setForename($userData['forename']);
-                       $user->setSurname($userData['surname']);

                        $user->setPhone($userData['phone']);
                        $user->setPhone($userData['phone']);

-                       $user->setPassword($encoder->encodePassword($user, $userData['password']));
-                       $user->setCivility($civilitys[$userData['short']]);

                        $user->addGroup($groups[$userData['group']]);
                        $user->addGroup($groups[$userData['group']]);

-                       $user->setCreated(new \DateTime('now'));
-                       $user->setUpdated(new \DateTime('now'));

                        $manager->persist($user);
                        $users[] = $user;
                        unset($user);
                        $manager->persist($user);
                        $users[] = $user;
                        unset($user);


@@ -134,6 +158,7 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
 
                //Location tree
                //XXX: adding a new zipcode here requires matching accuweather uris in Command/WeatherCommand.php
 
                //Location tree
                //XXX: adding a new zipcode here requires matching accuweather uris in Command/WeatherCommand.php

+               //TODO: add descriptions as well

                $locationTree = [
                        [
                                'title' => 'Garnier opera',
                $locationTree = [
                        [
                                'title' => 'Garnier opera',


@@ -143,7 +168,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.871268,
                                'longitude' => 2.331832,
                                'city' => 'Paris',
                                'latitude' => 48.871268,
                                'longitude' => 2.331832,

-                               'hotspot' => true
+                               'hotspot' => true,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Tino-Rossi garden',
                        ],
                        [
                                'title' => 'Tino-Rossi garden',


@@ -153,7 +179,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.847736,
                                'longitude' => 2.360953,
                                'city' => 'Paris',
                                'latitude' => 48.847736,
                                'longitude' => 2.360953,

-                               'hotspot' => true
+                               'hotspot' => true,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Trocadero esplanade',
                        ],
                        [
                                'title' => 'Trocadero esplanade',


@@ -164,7 +191,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.861888,
                                'longitude' => 2.288853,
                                'city' => 'Paris',
                                'latitude' => 48.861888,
                                'longitude' => 2.288853,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Colette place',
                        ],
                        [
                                'title' => 'Colette place',


@@ -174,7 +202,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.863219,
                                'longitude' => 2.335847,
                                'city' => 'Paris',
                                'latitude' => 48.863219,
                                'longitude' => 2.335847,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Swan island',
                        ],
                        [
                                'title' => 'Swan island',


@@ -184,7 +213,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.849976, #48.849976
                                'longitude' => 2.279603, #2.2796029,
                                'city' => 'Paris',
                                'latitude' => 48.849976, #48.849976
                                'longitude' => 2.279603, #2.2796029,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Jussieu esplanade',
                        ],
                        [
                                'title' => 'Jussieu esplanade',


@@ -194,7 +224,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.847955, #48.8479548
                                'longitude' => 2.353291, #2.3532907,
                                'city' => 'Paris',
                                'latitude' => 48.847955, #48.8479548
                                'longitude' => 2.353291, #2.3532907,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Orleans gallery',
                        ],
                        [
                                'title' => 'Orleans gallery',


@@ -204,7 +235,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.863885,
                                'longitude' => 2.337387,
                                'city' => 'Paris',
                                'latitude' => 48.863885,
                                'longitude' => 2.337387,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Orsay museum',
                        ],
                        [
                                'title' => 'Orsay museum',


@@ -214,7 +246,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.860418,
                                'longitude' => 2.325815,
                                'city' => 'Paris',
                                'latitude' => 48.860418,
                                'longitude' => 2.325815,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Saint-Honore market',
                        ],
                        [
                                'title' => 'Saint-Honore market',


@@ -224,7 +257,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.866992,
                                'longitude' => 2.331752,
                                'city' => 'Paris',
                                'latitude' => 48.866992,
                                'longitude' => 2.331752,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Igor Stravinsky place',
                        ],
                        [
                                'title' => 'Igor Stravinsky place',


@@ -234,7 +268,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.859244,
                                'longitude' => 2.351289,
                                'city' => 'Paris',
                                'latitude' => 48.859244,
                                'longitude' => 2.351289,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Tokyo palace',
                        ],
                        [
                                'title' => 'Tokyo palace',


@@ -244,7 +279,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.863827,
                                'longitude' => 2.297339,
                                'city' => 'Paris',
                                'latitude' => 48.863827,
                                'longitude' => 2.297339,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Drawings\' garden',
                        ],
                        [
                                'title' => 'Drawings\' garden',


@@ -254,7 +290,8 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.892503,
                                'longitude' => 2.389300,
                                'city' => 'Paris',
                                'latitude' => 48.892503,
                                'longitude' => 2.389300,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Louvre palace',
                        ],
                        [
                                'title' => 'Louvre palace',


@@ -264,34 +301,25 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                                'city' => 'Paris',
                                'latitude' => 48.860386,
                                'longitude' => 2.332611,
                                'city' => 'Paris',
                                'latitude' => 48.860386,
                                'longitude' => 2.332611,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ],
                        [
                                'title' => 'Monde garden',
                        ],
                        [
                                'title' => 'Monde garden',

-                               'short' => 'Monde',

                                'address' => '63 avenue Pierre Mendès-France',
                                'zipcode' => '75013',
                                'city' => 'Paris',
                                'latitude' => 48.840451,
                                'longitude' => 2.367638,
                                'address' => '63 avenue Pierre Mendès-France',
                                'zipcode' => '75013',
                                'city' => 'Paris',
                                'latitude' => 48.840451,
                                'longitude' => 2.367638,

-                               'hotspot' => false
+                               'hotspot' => false,
+                               'indoor' => false

                        ]
                ];
 
                //Create locations
                        ]
                ];
 
                //Create locations

-               $locations = array();
+               $locations = [];

                foreach($locationTree as $locationData) {
                foreach($locationTree as $locationData) {

-                       $location = new Location();
-                       $location->setTitle($locationData['title']);
-                       $location->setShort($locationData['short']);
-                       $location->setAddress($locationData['address']);
-                       $location->setZipcode($locationData['zipcode']);
-                       $location->setCity($locationData['city']);
-                       $location->setLatitude($locationData['latitude']);
-                       $location->setLongitude($locationData['longitude']);
-                       $location->setHotspot($locationData['hotspot']);
-                       $location->setCreated(new \DateTime('now'));
-                       $location->setUpdated(new \DateTime('now'));
+                       $location = new Location($locationData['title'], $locationData['address'], $locationData['zipcode'], $locationData['city'], $locationData['latitude'], $locationData['longitude'], $locationData['hotspot'], $locationData['indoor']);

                        $manager->persist($location);
                        $locations[$locationData['title']] = $location;
                        unset($location);
                        $manager->persist($location);
                        $locations[$locationData['title']] = $location;
                        unset($location);


@@ -309,12 +337,9 @@ class AirFixtures extends \Doctrine\Bundle\FixturesBundle\Fixture implements \Sy
                ];
 
                //Create slots
                ];
 
                //Create slots

-               $slots = array();
+               $slots = [];

                foreach($slotTree as $slotData) {
                foreach($slotTree as $slotData) {

-                       $slot = new Slot();
-                       $slot->setTitle($slotData);
-                       $slot->setCreated(new \DateTime('now'));
-                       $slot->setUpdated(new \DateTime('now'));
+                       $slot = new Slot($slotData);

                        $manager->persist($slot);
                        $slots[$slot->getId()] = $slot;
                        unset($slot);
                        $manager->persist($slot);
                        $slots[$slot->getId()] = $slot;
                        unset($slot);