- public function load(\Doctrine\Common\Persistence\ObjectManager $manager) {
- $encoder = $this->container->get('security.password_encoder');
-
- //Title tree
- $titleTree = array(
- 'M.' => 'Monsieur',
- 'Mlle' => 'Mademoiselle',
- 'Mme' => 'Madame'
+ public function load(ObjectManager $manager) {
+ //Civility tree
+ $civilityTree = array(
+ 'Mister',
+ 'Madam',
+ 'Miss'
+ );
+
+ //Create titles
+ $civilitys = array();
+ foreach($civilityTree as $civilityData) {
+ $civility = new Civility();
+ $civility->setTitle($civilityData);
+ $civility->setCreated(new \DateTime('now'));
+ $civility->setUpdated(new \DateTime('now'));
+ $manager->persist($civility);
+ $civilitys[$civilityData] = $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 = array(
+ 'Argentine Tango' => [
+ 'Milonga', 'Class and milonga', 'Public class', 'Private class'
+ ]