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';
}
