3 namespace Wallabag\CoreBundle\Event\Subscriber
;
5 use Doctrine\Bundle\DoctrineBundle\Registry
;
6 use Doctrine\Common\EventSubscriber
;
7 use Doctrine\ORM\Event\LifecycleEventArgs
;
8 use Wallabag\CoreBundle\Entity\Entry
;
11 * SQLite doesn't care about cascading remove, so we need to manually remove associated stuf for an Entry.
12 * Foreign Key Support can be enabled by running `PRAGMA foreign_keys = ON;` at runtime (AT RUNTIME !).
13 * But it needs a compilation flag that not all SQLite instance has ...
15 * @see https://www.sqlite.org/foreignkeys.html#fk_enable
17 class SQLiteCascadeDeleteSubscriber
implements EventSubscriber
21 public function __construct(Registry
$doctrine)
23 $this->doctrine
= $doctrine;
29 public function getSubscribedEvents()
37 * We removed everything related to the upcoming removed entry because SQLite can't handle it on it own.
38 * We do it in the preRemove, because we can't retrieve tags in the postRemove (because the entry id is gone).
40 public function preRemove(LifecycleEventArgs
$args)
42 $entity = $args->getEntity();
43 if (!$this->doctrine
->getConnection()->getDatabasePlatform() instanceof \Doctrine\DBAL\Platforms\SqlitePlatform
44 || !$entity instanceof Entry
) {
48 $em = $this->doctrine
->getManager();
50 if (null !== $entity->getTags()) {
51 foreach ($entity->getTags() as $tag) {
52 $entity->removeTag($tag);
56 if (null !== $entity->getAnnotations()) {
57 foreach ($entity->getAnnotations() as $annotation) {
58 $em->remove($annotation);