/**
* @param ObjectManager $manager
* @throws \Doctrine\DBAL\DBALException
*/
protected function loadMessages(ObjectManager $manager)
{
echo "\nMessages ... ";
$stmt = $this->connection->executeQuery('SELECT * FROM message');
foreach ($stmt->fetchAll() as $record) {
$message = new Message();
if ($record['client_id']) {
$message->setClient($this->getReference('client-' . $record['client_id']));
}
$message->setEmailAddress($record['client_id'] ? $record['client_id'] : '');
$message->setMessage($record['message']);
$message->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at'])));
$message->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at'])));
$manager->persist($message);
}
}
