/** * @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); } }