public function restoreBackup(ImportFile $file) { $data = $file->open(); $connection = \DB::em()->getConnection(); $platform = $connection->getDatabasePlatform(); $connection->executeUpdate($platform->getTruncateTableSQL('copy', true)); foreach ($data as $row) { $copyEntity = new \Entity\Copy(); $copyEntity->setLocale($row['locale']); $copyEntity->setMessage($row['message']); $copyEntity->setMessageId($row['messageid']); // print_r($copyEntity); \DB::em()->persist($copyEntity); } \DB::em()->flush(); return 'success'; }