123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389 |
- <?php
- namespace Gedmo\SoftDeleteable;
- use Tool\BaseTestCaseORM;
- use Doctrine\Common\EventManager;
- use Doctrine\Common\Util\Debug,
- SoftDeleteable\Fixture\Entity\Article,
- SoftDeleteable\Fixture\Entity\Comment,
- SoftDeleteable\Fixture\Entity\User,
- SoftDeleteable\Fixture\Entity\Page,
- SoftDeleteable\Fixture\Entity\MegaPage,
- SoftDeleteable\Fixture\Entity\Module,
- SoftDeleteable\Fixture\Entity\OtherArticle,
- SoftDeleteable\Fixture\Entity\OtherComment,
- SoftDeleteable\Fixture\Entity\Child,
- Gedmo\SoftDeleteable\SoftDeleteableListener;
- /**
- * These are tests for SoftDeleteable behavior
- *
- * @author Gustavo Falco <comfortablynumb84@gmail.com>
- * @author Gediminas Morkevicius <gediminas.morkevicius@gmail.com>
- * @author Patrik Votoček <patrik@votocek.cz>
- * @link http://www.gediminasm.org
- * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
- */
- class SoftDeleteableEntityTest extends BaseTestCaseORM
- {
- const ARTICLE_CLASS = 'SoftDeleteable\Fixture\Entity\Article';
- const COMMENT_CLASS = 'SoftDeleteable\Fixture\Entity\Comment';
- const PAGE_CLASS = 'SoftDeleteable\Fixture\Entity\Page';
- const MEGA_PAGE_CLASS = 'SoftDeleteable\Fixture\Entity\MegaPage';
- const MODULE_CLASS = 'SoftDeleteable\Fixture\Entity\Module';
- const OTHER_ARTICLE_CLASS = 'SoftDeleteable\Fixture\Entity\OtherArticle';
- const OTHER_COMMENT_CLASS = 'SoftDeleteable\Fixture\Entity\OtherComment';
- const USER_CLASS = 'SoftDeleteable\Fixture\Entity\User';
- const MAPPED_SUPERCLASS_CHILD_CLASS = 'SoftDeleteable\Fixture\Entity\Child';
- const SOFT_DELETEABLE_FILTER_NAME = 'soft-deleteable';
- private $softDeleteableListener;
- protected function setUp()
- {
- parent::setUp();
- $evm = new EventManager();
- $this->softDeleteableListener = new SoftDeleteableListener();
- $evm->addEventSubscriber($this->softDeleteableListener);
- $config = $this->getMockAnnotatedConfig();
- $config->addFilter(self::SOFT_DELETEABLE_FILTER_NAME, 'Gedmo\SoftDeleteable\Filter\SoftDeleteableFilter');
- $this->em = $this->getMockSqliteEntityManager($evm, $config);
- $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- }
- /**
- * @test
- */
- public function shouldBeAbleToHardDeleteSoftdeletedItems()
- {
- $repo = $this->em->getRepository(self::USER_CLASS);
- $newUser = new User();
- $newUser->setUsername($username = 'test_user');
- $this->em->persist($newUser);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user->getDeletedAt());
- $this->em->remove($user);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user);
- }
- /**
- * @test
- */
- public function shouldSoftlyDeleteIfColumnNameDifferFromPropertyName()
- {
- $repo = $this->em->getRepository(self::USER_CLASS);
- $newUser = new User();
- $username = 'test_user';
- $newUser->setUsername($username);
- $this->em->persist($newUser);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user->getDeletedAt());
- $this->em->remove($user);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user, "User should be filtered out");
- // now deatcivate filter and attempt to hard delete
- $this->em->getFilters()->disable(self::SOFT_DELETEABLE_FILTER_NAME);
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNotNull($user, "User should be fetched when filter is disabled");
- $this->em->remove($user);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user, "User is still available after hard delete");
- }
- public function testSoftDeleteable()
- {
- $repo = $this->em->getRepository(self::ARTICLE_CLASS);
- $commentRepo = $this->em->getRepository(self::COMMENT_CLASS);
- $comment = new Comment();
- $commentField = 'comment';
- $commentValue = 'Comment 1';
- $comment->setComment($commentValue);
- $art0 = new Article();
- $field = 'title';
- $value = 'Title 1';
- $art0->setTitle($value);
- $art0->addComment($comment);
- $this->em->persist($art0);
- $this->em->flush();
- $art = $repo->findOneBy(array($field => $value));
- $this->assertNull($art->getDeletedAt());
- $this->assertNull($comment->getDeletedAt());
- $this->em->remove($art);
- $this->em->flush();
- $art = $repo->findOneBy(array($field => $value));
- $this->assertNull($art);
- $comment = $commentRepo->findOneBy(array($commentField => $commentValue));
- $this->assertNull($comment);
- // Now we deactivate the filter so we test if the entity appears in the result
- $this->em->getFilters()->disable(self::SOFT_DELETEABLE_FILTER_NAME);
- $art = $repo->findOneBy(array($field => $value));
- $this->assertTrue(is_object($art));
- $this->assertTrue(is_object($art->getDeletedAt()));
- $this->assertTrue($art->getDeletedAt() instanceof \DateTime);
- $comment = $commentRepo->findOneBy(array($commentField => $commentValue));
- $this->assertTrue(is_object($comment));
- $this->assertTrue(is_object($comment->getDeletedAt()));
- $this->assertTrue($comment->getDeletedAt() instanceof \DateTime);
- $this->em->createQuery('UPDATE '.self::ARTICLE_CLASS.' a SET a.deletedAt = NULL')->execute();
- $this->em->refresh($art);
- $this->em->refresh($comment);
- // Now we try with a DQL Delete query
- $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- $dql = sprintf('DELETE FROM %s a WHERE a.%s = :%s',
- self::ARTICLE_CLASS, $field, $field);
- $query = $this->em->createQuery($dql);
- $query->setParameter($field, $value);
- $query->setHint(
- \Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER,
- 'Gedmo\SoftDeleteable\Query\TreeWalker\SoftDeleteableWalker'
- );
- $query->execute();
- $art = $repo->findOneBy(array($field => $value));
- $this->assertNull($art);
- // Now we deactivate the filter so we test if the entity appears in the result
- $this->em->getFilters()->disable(self::SOFT_DELETEABLE_FILTER_NAME);
- $this->em->clear();
- $art = $repo->findOneBy(array($field => $value));
- $this->assertTrue(is_object($art));
- $this->assertTrue(is_object($art->getDeletedAt()));
- $this->assertTrue($art->getDeletedAt() instanceof \DateTime);
- // Inheritance tree DELETE DQL
- $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- $megaPageRepo = $this->em->getRepository(self::MEGA_PAGE_CLASS);
- $module = new Module();
- $module->setTitle('Module 1');
- $page = new MegaPage();
- $page->setTitle('Page 1');
- $page->addModule($module);
- $module->setPage($page);
- $this->em->persist($page);
- $this->em->persist($module);
- $this->em->flush();
- $dql = sprintf('DELETE FROM %s p',
- self::PAGE_CLASS);
- $query = $this->em->createQuery($dql);
- $query->setHint(
- \Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER,
- 'Gedmo\SoftDeleteable\Query\TreeWalker\SoftDeleteableWalker'
- );
- $query->execute();
- $p = $megaPageRepo->findOneBy(array('title' => 'Page 1'));
- $this->assertNull($p);
- // Now we deactivate the filter so we test if the entity appears in the result
- $this->em->getFilters()->disable(self::SOFT_DELETEABLE_FILTER_NAME);
- $this->em->clear();
- $p = $megaPageRepo->findOneBy(array('title' => 'Page 1'));
- $this->assertTrue(is_object($p));
- $this->assertTrue(is_object($p->getDeletedAt()));
- $this->assertTrue($p->getDeletedAt() instanceof \DateTime);
- // Test of #301
- $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- $otherArticleRepo = $this->em->getRepository(self::OTHER_ARTICLE_CLASS);
- $otherCommentRepo = $this->em->getRepository(self::OTHER_COMMENT_CLASS);
- $otherArt = new OtherArticle();
- $otherComment = new OtherComment();
- $otherArt->setTitle('Page 1');
- $otherComment->setComment('Comment');
- $otherArt->addComment($otherComment);
- $otherComment->setArticle($otherArt);
- $this->em->persist($otherArt);
- $this->em->persist($otherComment);
- $this->em->flush();
- $this->em->refresh($otherArt);
- $this->em->refresh($otherComment);
- $artId = $otherArt->getId();
- $commentId = $otherComment->getId();
- $this->em->remove($otherArt);
- $this->em->flush();
- $foundArt = $otherArticleRepo->findOneBy(array('id' => $artId));
- $foundComment = $otherCommentRepo->findOneBy(array('id' => $commentId));
- $this->assertNull($foundArt);
- $this->assertTrue(is_object($foundComment));
- $this->assertInstanceOf(self::OTHER_COMMENT_CLASS, $foundComment);
- $this->em->getFilters()->disable(self::SOFT_DELETEABLE_FILTER_NAME);
- $foundArt = $otherArticleRepo->findOneById($artId);
- $foundComment = $otherCommentRepo->findOneById($commentId);
- $this->assertTrue(is_object($foundArt));
- $this->assertTrue(is_object($foundArt->getDeletedAt()));
- $this->assertTrue($foundArt->getDeletedAt() instanceof \DateTime);
- $this->assertTrue(is_object($foundComment));
- $this->assertInstanceOf(self::OTHER_COMMENT_CLASS, $foundComment);
- }
- /**
- * Make sure that soft delete also works when configured on a mapped superclass
- */
- public function testMappedSuperclass()
- {
- $child = new Child();
- $child->setTitle('test title');
- $this->em->persist($child);
- $this->em->flush();
- $this->em->remove($child);
- $this->em->flush();
- $this->em->clear();
- $repo = $this->em->getRepository(self::MAPPED_SUPERCLASS_CHILD_CLASS);
- $this->assertNull($repo->findOneById($child->getId()));
- $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- $this->assertNotNull($repo->findById($child->getId()));
- }
- public function testSoftDeleteableFilter()
- {
- $filter = $this->em->getFilters()->enable(self::SOFT_DELETEABLE_FILTER_NAME);
- $filter->disableForEntity(self::USER_CLASS);
- $repo = $this->em->getRepository(self::USER_CLASS);
- $newUser = new User();
- $username = 'test_user';
- $newUser->setUsername($username);
- $this->em->persist($newUser);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user->getDeletedAt());
- $this->em->remove($user);
- $this->em->flush();
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNotNull($user->getDeletedAt());
- $filter->enableForEntity(self::USER_CLASS);
- $user = $repo->findOneBy(array('username' => $username));
- $this->assertNull($user);
- }
- public function testPostSoftDeleteEventIsDispatched()
- {
- $subscriber = $this->getMock(
- "Doctrine\Common\EventSubscriber",
- array(
- "getSubscribedEvents",
- "preSoftDelete",
- "postSoftDelete"
- )
- );
- $subscriber->expects($this->once())
- ->method("getSubscribedEvents")
- ->will($this->returnValue(array(SoftDeleteableListener::PRE_SOFT_DELETE, SoftDeleteableListener::POST_SOFT_DELETE)));
- $subscriber->expects($this->exactly(2))
- ->method("preSoftDelete")
- ->with($this->anything());
- $subscriber->expects($this->exactly(2))
- ->method("postSoftDelete")
- ->with($this->anything());
- $this->em->getEventManager()->addEventSubscriber($subscriber);
- $repo = $this->em->getRepository(self::ARTICLE_CLASS);
- $commentRepo = $this->em->getRepository(self::COMMENT_CLASS);
- $comment = new Comment();
- $commentField = 'comment';
- $commentValue = 'Comment 1';
- $comment->setComment($commentValue);
- $art0 = new Article();
- $field = 'title';
- $value = 'Title 1';
- $art0->setTitle($value);
- $art0->addComment($comment);
- $this->em->persist($art0);
- $this->em->flush();
- $art = $repo->findOneBy(array($field => $value));
- $this->assertNull($art->getDeletedAt());
- $this->assertNull($comment->getDeletedAt());
- $this->em->remove($art);
- $this->em->flush();
- }
- protected function getUsedEntityFixtures()
- {
- return array(
- self::ARTICLE_CLASS,
- self::PAGE_CLASS,
- self::MEGA_PAGE_CLASS,
- self::MODULE_CLASS,
- self::COMMENT_CLASS,
- self::USER_CLASS,
- self::OTHER_ARTICLE_CLASS,
- self::OTHER_COMMENT_CLASS,
- self::MAPPED_SUPERCLASS_CHILD_CLASS,
- );
- }
- }
|