/** * @param ObjectManager $manager * @throws \Doctrine\DBAL\DBALException */ protected function loadClients(ObjectManager $manager) { echo "\nClients ... "; $stmt = $this->connection->executeQuery('SELECT * FROM client'); foreach ($stmt->fetchAll() as $i => $record) { $client = new Client(); $client->setFirstname($record['firstname']); $client->setLastname($record['lastname']); $client->setOrigin($record['origin']); $client->setPhone($record['phone']); $client->setEmailAddress($record['email_address']); $client->setIsEmailConfirmed($record['email_confirmed']); $client->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at']))); $client->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at']))); $manager->persist($client); $i += 1; $this->addReference("client-" . $record['id'], $client); } }