Refresh not working: Issue after resetting Doctrine Manager

Question

There is something wrong with my data, I get the error out of range on a integer column and I try to prevent Close Entity Manager from continuing to work, as Ireset manager in exception

public function renewDeliveryTime($delayReport) : void
{
    try {
        $this->delayReportRepository->updateRenewedDeliveryTimeAt($delayReport, 50000000);
    }catch (\Exception $exception){
        // out of range error
        $this->managerRegistry->resetManager();
    }

}

public function updateRenewedDeliveryTimeAt($delayReport,$delayDuration)
{
    /*** @var DelayReport $delayReport*/
    $delayReport->setDelayDuration($delayDuration);
    $delayReport->setStatus(DelayReport::STATUS['DONE']);
    $this->getEntityManager()->flush();
}

The problem is, I'm running into an error in my data, I'm getting the error message out of range on a integer column, and I'm trying to prevent closed entity manager< /code>Continue working and for this purpose in the exception reset manager

public function enqueue($delayReport) : void
{
    $this->pushInQueueReport($delayReport);
    $this->delayReportRepository->updateStatus($delayReport, DelayReport::STATUS['IN_QUEUE']);
}

public function updateStatus($delayReport, $status)
{
    /*** @var DelayReport $delayReport*/
    $delayReport->setStatus($status);
    $this->getEntityManager()->flush();
}

The problem is that after I have another object and almost the same database operation, it seems that $this->getEntityManager()->flush() no longer works, database Nothing happens. This has to do with $this->managerRegistry->resetManager()

What is the solution to this problem?

Answer 1

The problem is that resetManager(), not all services that directly reference the entity manager will automatically update to new instances.

In the updateStatus() method you can easily check if the entity is managed by the entity manager.

$uow = $this->getEntityManager()->getUnitOfWork();
if($uow->getEntityState($delayReport) !== UnitOfWork::STATE_MANAGED) {
    // not managed
}

Not sure if reassignment helps here, like $this->getEntityManager()->merge($delayReport).

But it's better to avoid closing the manager and validating the data before validating it.

edit:

Not tested, if you will get the reset EntityManager through the Registry. But it's worth a try.

$entityManager = $managerRegistry->getManagerForClass(get_class($delayReport));