/** * {@inheritdoc} */ public function apply(base $appbox, Application $app) { $em = $app['orm.em']; $sql = "SELECT date_modif, usr_id, base_id, en_cours, refuser\n FROM demand"; $rsm = new ResultSetMapping(); $rsm->addScalarResult('base_id', 'base_id'); $rsm->addScalarResult('en_cours', 'en_cours'); $rsm->addScalarResult('refuser', 'refuser'); $rsm->addScalarResult('usr_id', 'usr_id'); $rsm->addScalarResult('date_modif', 'date_modif'); $rs = $em->createNativeQuery($sql, $rsm)->getResult(); $n = 0; foreach ($rs as $row) { try { $user = $em->createQuery('SELECT PARTIAL u.{id} FROM Phraseanet:User s WHERE u.id = :id')->setParameters(['id' => $row['usr_id']])->setHint(Query::HINT_FORCE_PARTIAL_LOAD, true)->getSingleResult(); } catch (NoResultException $e) { $app['monolog']->addInfo(sprintf('Patch %s : Registration for user (%s) could not be turn into doctrine entity as user could not be found.', $this->get_release(), $row['usr_id'])); continue; } try { $collection = \collection::get_from_base_id($app, $row['base_id']); } catch (\Exception $e) { $app['monolog']->addInfo(sprintf('Patch %s : Registration for user (%s) could not be turn into doctrine entity as base with id (%s) could not be found.', $this->get_release(), $row['usr_id'], $row['base_id'])); continue; } $registration = new Registration(); $registration->setCollection($collection); $registration->setUser($user); $registration->setPending($row['en_cours']); $registration->setCreated(new \DateTime($row['date_modif'])); $registration->setRejected($row['refuser']); if ($n % 100 === 0) { $em->flush(); $em->clear(); } $n++; } $em->flush(); $em->clear(); }
private function insertOneRegistration(\Pimple $DI, EntityManager $em, User $user, \collection $collection, $when, $name) { $em->getEventManager()->removeEventSubscriber(new TimestampableListener()); $registration = new Registration(); $registration->setCollection($collection); $registration->setUser($user); $registration->setUpdated(new \DateTime($when)); $registration->setCreated(new \DateTime($when)); $em->persist($registration); $em->flush(); $em->getEventManager()->addEventSubscriber(new TimestampableListener()); $DI[$name] = $registration; }