예제 #1
0
파일: LoadData.php 프로젝트: jmiridis/atc
 /**
  * @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);
     }
 }