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();
}
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);
$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);
$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);
}