- public function load(\Doctrine\Common\Persistence\ObjectManager $manager) {
- $encoder = $this->container->get('security.password_encoder');
+ public function load(ObjectManager $manager) {
+ //Civility tree
+ $civilityTree = [
+ 'Mister',
+ 'Madam',
+ 'Miss'
+ ];
+
+ //Create titles
+ $civilitys = [];
+ foreach($civilityTree as $civilityData) {
+ $civility = new Civility($civilityData);
+ $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;