/**
* Import Bearbeiter table into the FLOW domain_model tabel subugoe_germaniasacra_domain_model_bearbeiter and creates an account for every user
* @return int
*/
private function importAndJoinBearbeiterWithAccount()
{
/** @var \Doctrine\DBAL\Connection $sqlConnection */
$sqlConnection = $this->entityManager->getConnection();
$sql = 'SELECT ID, Bearbeiter FROM Bearbeiter ORDER BY ID ASC';
$bearbeiters = $sqlConnection->fetchAll($sql);
if (isset($bearbeiters) and is_array($bearbeiters)) {
$nBearbeiter = 0;
foreach ($bearbeiters as $be) {
$uid = $be['ID'];
$bearbeiter = $be['Bearbeiter'];
$userName = $this->createUsername($bearbeiter);
$password = $this->createPassword();
$account = $this->accountFactory->createAccountWithPassword($userName, $password, ['Flow.Login:Administrator']);
$this->accountRepository->add($account);
$bearbeiterObject = new Bearbeiter();
$bearbeiterObject->setUid($uid);
$bearbeiterObject->setBearbeiter($bearbeiter);
$bearbeiterObject->setAccount($account);
$this->bearbeiterRepository->add($bearbeiterObject);
$this->persistenceManager->persistAll();
$this->createUsernamePasswordFile($userName, $password, $uid);
$nBearbeiter++;
}
return $nBearbeiter;
}
}
