protected function execute(InputInterface $input, OutputInterface $output) { $em = $this->getContainer()->get('doctrine')->getManager(); $parser = $this->getContainer()->get('lke_core.parse_csv'); $rows = $parser->parse(self::FILE); foreach ($rows as $row) { $response = new Response(); $response->setSentence(substr($row[self::SENTENCE], 0, 140)); $response->setPostedAt($this->getDateTime($row[self::POSTEDAT])); $response->setRemark($this->getRemark($row[self::REMARK_ID])); $response->setAuthor($this->getUser($row[self::USER_ID])); $em->persist($response); } $em->flush(); $output->writeln("Responses loaded"); }