protected function execute(InputInterface $input, OutputInterface $output)
{
$app = $this->app;
$removeExistingData = $input->getOption('remove-existing-data');
if ($removeExistingData) {
try {
$app['db']->query('SET foreign_key_checks = 0;');
$tables = $app['db']->getSchemaManager()->listTables();
foreach ($tables as $table) {
$table = $table->getName();
$app['db']->query('TRUNCATE TABLE ' . $table . ';');
}
$app['db']->query('SET foreign_key_checks = 1;');
$output->writeln('<info>All tables were successfully truncated!</info>');
} catch (\Exception $e) {
$output->writeln('<error>' . $e->getMessage() . '</error>');
}
}
/***** Roles *****/
$roles = (include APP_DIR . '/fixtures/roles.php');
foreach ($roles as $role) {
$roleEntity = new \Application\Entity\RoleEntity();
$roleEntity->setId($role[0])->setName($role[1])->setDescription($role[2])->setRole($role[3])->setPriority($role[4]);
$app['orm.em']->persist($roleEntity);
}
/*
* We already need to flush the first time here,
* else the roles are not available later for the users,
* who want to use them.
*/
$app['orm.em']->flush();
/***** Users *****/
$users = (include APP_DIR . '/fixtures/users.php');
foreach ($users as $user) {
$userEntity = new \Application\Entity\UserEntity();
$profileEntity = new \Application\Entity\ProfileEntity();
// Profile
$profileEntity->setFirstName($user['profile']['firstName'])->setLastName($user['profile']['lastName']);
if (isset($user['profile']['gender'])) {
$profileEntity->setGender($user['profile']['gender']);
}
if (isset($user['profile']['birthdate'])) {
$profileEntity->setBirthdate($user['profile']['birthdate']);
}
// User Roles
$userRolesCollection = new \Doctrine\Common\Collections\ArrayCollection();
if (!empty($user['roles'])) {
$userRoles = $user['roles'];
foreach ($userRoles as $userRole) {
$roleEntity = $app['orm.em']->getRepository('Application\\Entity\\RoleEntity')->findOneByRole($userRole);
if ($roleEntity) {
$userRolesCollection->add($roleEntity);
}
}
}
// User
$userEntity->setId($user['id'])->setUsername($user['username'])->setEmail($user['email'])->setPlainPassword($user['plainPassword'], $app['security.encoder_factory'])->setRoles($userRolesCollection)->setProfile($profileEntity)->enable();
$app['orm.em']->persist($userEntity);
}
try {
$app['orm.em']->flush();
$output->writeln('<info>Data was successfully hydrated!</info>');
} catch (\Exception $e) {
$output->writeln('<error>' . $e->getMessage() . '</error>');
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$app = $this->app;
$removeExistingData = $input->getOption('remove-existing-data');
$testData = $input->getOption('test-data');
if ($removeExistingData) {
try {
$app['db']->query('SET foreign_key_checks = 0;');
$tables = $app['db']->getSchemaManager()->listTables();
foreach ($tables as $table) {
$table = $table->getName();
$app['db']->query('TRUNCATE TABLE ' . $table . ';');
}
$app['db']->query('SET foreign_key_checks = 1;');
$output->writeln('<info>All tables were successfully truncated!</info>');
} catch (\Exception $e) {
$output->writeln('<error>' . $e->getMessage() . '</error>');
}
}
if ($testData) {
$timeMin = strtotime('-4 weeks');
$timeMax = strtotime('now');
for ($i = 0; $i < 1000; $i++) {
$participantEntity = new \Application\Entity\ParticipantEntity();
$entryEntity = new \Application\Entity\EntryEntity();
$rand = rand($timeMin, $timeMax);
$randDate = date('Y-m-d H:i:s', $rand);
$userAgent = \random_uagent();
$datetime = new \Datetime($randDate);
$participantEntity->setVia('administration')->setName('Participant ' . $i)->setEmail($i . '*****@*****.**')->setUserAgent($userAgent)->setIp('127.0.0.1')->setTimeCreated($datetime)->setTimeUpdated($datetime);
$entryEntity->setParticipant($participantEntity)->setUserAgent($userAgent)->setIp('127.0.0.1')->setTimeCreated($datetime)->setTimeUpdated($datetime);
$app['orm.em']->persist($participantEntity);
$app['orm.em']->persist($entryEntity);
}
$output->writeln('<info>Participants and Entries were successfully hydrated (with random data)!</info>');
}
/***** Roles *****/
$roles = (include APP_DIR . '/fixtures/roles.php');
foreach ($roles as $role) {
$roleEntity = new \Application\Entity\RoleEntity();
$roleEntity->setId($role[0])->setName($role[1])->setDescription($role[2])->setRole($role[3])->setPriority($role[4]);
$app['orm.em']->persist($roleEntity);
}
/*
* We already need to flush the first time here,
* else the roles are not available later for the users,
* who want to use them.
*/
$app['orm.em']->flush();
/***** Users *****/
$users = (include APP_DIR . '/fixtures/users.php');
foreach ($users as $user) {
$userEntity = new \Application\Entity\UserEntity();
$profileEntity = new \Application\Entity\ProfileEntity();
// Profile
$profileEntity->setFirstName($user['profile']['firstName'])->setLastName($user['profile']['lastName']);
if (isset($user['profile']['gender'])) {
$profileEntity->setGender($user['profile']['gender']);
}
if (isset($user['profile']['birthdate'])) {
$profileEntity->setBirthdate($user['profile']['birthdate']);
}
// User Roles
$userRolesCollection = new \Doctrine\Common\Collections\ArrayCollection();
if (!empty($user['roles'])) {
$userRoles = $user['roles'];
foreach ($userRoles as $userRole) {
$roleEntity = $app['orm.em']->getRepository('Application\\Entity\\RoleEntity')->findOneByRole($userRole);
if ($roleEntity) {
$userRolesCollection->add($roleEntity);
}
}
}
// User
$userEntity->setId($user['id'])->setUsername($user['username'])->setEmail($user['email'])->setPlainPassword($user['plainPassword'], $app['security.encoder_factory'])->setRoles($userRolesCollection)->setProfile($profileEntity)->enable();
$app['orm.em']->persist($userEntity);
}
try {
$app['orm.em']->flush();
$output->writeln('<info>Data was successfully hydrated!</info>');
} catch (\Exception $e) {
$output->writeln('<error>' . $e->getMessage() . '</error>');
}
}