This library allows to
- re-fetch Doctrine ORM objects after clear the object manager
- detach all entities attached since a snapshot
To install doctrine-orm-refetch with Composer just run :
$ composer require ecommit/doctrine-orm-refetchCreate the utility ($entityManager is the Doctrine ORM entity manager):
use Ecommit\DoctrineOrmRefetch\RefetchManager; $refetchManager = RefetchManager::create($entityManager);$myObject = $refetchManager->getFetchedObject($myObject); //or $refetchManager->refreshObject($myObject);Example:
use Ecommit\DoctrineOrmRefetch\RefetchManager; $refetchManager = RefetchManager::create($entityManager); $author = $entityManager->getRepository(Author::class)->find(1); $queryBuilder = $entityManager->getRepository(Book::class)->createQueryBuilder('b'); $queryBuilder->select('b') ->andWhere('b.bookId != :bookId') ->setParameter('bookId', 7); $iterableResult = $queryBuilder->getQuery()->iterate(); $i = 0; foreach ($iterableResult as $row) { ++$i; $book = current($row); if (!$book->getAuthors()->contains($author)) { $book->addAuthor($author); } if (0 === $i % 20) { //$author is managed $entityManager->flush(); $entityManager->clear(); //$author is not managed $author = $refetchManager->getObject($author); //$author is managed } } $entityManager->flush(); $entityManager->clear();$collection = $refetchManager->getCollectionFromCriteria($criteria, 'MyClass');Example:
use Doctrine\Common\Collections\Criteria; use Ecommit\DoctrineOrmRefetch\RefetchManager; $refetchManager = RefetchManager::create($entityManager); $ctiteria = Criteria::create() ->andWhere(Criteria::expr()->gt('authorId', 2)); $authors = $refetchManager->getCollectionFromCriteria($ctiteria, Author::class); $queryBuilder = $entityManager->getRepository(Book::class)->createQueryBuilder('b'); $queryBuilder->select('b') ->andWhere('b.bookId != :bookId') ->setParameter('bookId', 9); $iterableResult = $queryBuilder->getQuery()->iterate(); $i = 0; foreach ($iterableResult as $row) { ++$i; $book = current($row); foreach ($authors as $author) { if (!$book->getAuthors()->contains($author)) { $book->addAuthor($author); } } if (0 === $i % 20) { $entityManager->flush(); $entityManager->clear(); $authors = $refetchManager->getCollectionFromCriteria($ctiteria, Author::class); } } $entityManager->flush(); $entityManager->clear();Detach all entities attached since a snapshot (entities attached before the snapshot are kept)
use Ecommit\DoctrineOrmRefetch\SnapshotManager; $snapshotManager = SnapshotManager::create($entityManager); $author = $entityManager->getRepository(Author::class)->find(1); $snapshotManager->snapshot(); $queryBuilder = $entityManager->getRepository(Book::class)->createQueryBuilder('b'); $queryBuilder->select('b') ->andWhere('b.bookId != :bookId') ->setParameter('bookId', 7); $iterableResult = $queryBuilder->getQuery()->iterate(); $i = 0; foreach ($iterableResult as $row) { ++$i; /** @var Book $book */ $book = current($row); if (!$book->getAuthors()->contains($author)) { $book->addAuthor($author); } if (0 === $i % 2) { // $author and $book are managed $entityManager->flush(); $snapshotManager->clear(); // Detach all entities attached since the snapshot // Only $author is managed } } $entityManager->flush(); $snapshotManager->clear();This librairy is under the MIT license. See the complete license in LICENSE file.