Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-824

EntityManager::remove($entity), EntityManager::flush() does not remove the entity from DB

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: 2.0-RC1
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None
    • Environment:
      PgSQL 8.4, current Doctrine 2 from Git

      Description

      Test.php
      /* 
       * @Entity
       * @Table(indexes={@Index(name="name", columns={"name"})})
       */
      class ProductAttribute
      {
      
          /**
           * ID
           * 
           * @Id @Column(type="integer") @GeneratedValue
           *
           * @var integer
           */
          protected $id;
          /**
           * Name
           *
           * @Column
           *
           * @var string
           */
          protected $name;
          /**
           * Values
           *
           * @OneToMany(targetEntity="ProductAttributeValue", mappedBy="attribute")
           *
           * @var array
           */
          protected $values;
      
          /**
           * Gets ID
           *
           * @return integer ID
           */
          public function getId()
          {
              return $this->id;
          }
      
          /**
           * Sets ID
           *
           * @param integer $id ID
           *
           * @return void
           */
          public function setId($id = null)
          {
              $this->id = $id;
          }
      
          /**
           * Gets name
           *
           * @return string Name
           */
          public function getName()
          {
              return $this->name;
          }
      
          /**
           * Sets name
           *
           * @param string $name Name
           *
           * @return void
           */
          public function setName($name = null)
          {
              $this->name = $name;
          }
      
          /**
           * Gets product attribute values
           *
           * @return array Product attribute values
           */
          public function getValues()
          {
              return $this->values;
          }
      
          /**
           * Adds product attribute value
           *
           * @param ProductAttributeValue $value Product attribute value
           * 
           * @return void
           */
          public function addValue(ProductAttributeValue $value)
          {
              $value->setAttribute($this);
              $this->values[] = $value;
          }
      
      }
      
      $attribute = $em->find('ProductAttribute', 1);
      $em->remove($attribute);
      $em->flush();
      

      The upper code won't remove the entity from the database.... Corresponding DQL (DELETE ProductAttribute a WHERE a.id = 1) will remove it from the database...

        Activity

        Petr Motejlek created issue -
        Petr Motejlek made changes -
        Field Original Value New Value
        Description /*
         * @Entity
         * @Table(indexes={@Index(name="name", columns={"name"})})
         */
        class ProductAttribute
        {

            /**
             * ID
             *
             * @Id @Column(type="integer") @GeneratedValue
             *
             * @var integer
             */
            protected $id;
            /**
             * Name
             *
             * @Column
             *
             * @var string
             */
            protected $name;
            /**
             * Values
             *
             * @OneToMany(targetEntity="ProductAttributeValue", mappedBy="attribute")
             *
             * @var array
             */
            protected $values;

            /**
             * Gets ID
             *
             * @return integer ID
             */
            public function getId()
            {
                return $this->id;
            }

            /**
             * Sets ID
             *
             * @param integer $id ID
             *
             * @return void
             */
            public function setId($id = null)
            {
                $this->id = $id;
            }

            /**
             * Gets name
             *
             * @return string Name
             */
            public function getName()
            {
                return $this->name;
            }

            /**
             * Sets name
             *
             * @param string $name Name
             *
             * @return void
             */
            public function setName($name = null)
            {
                $this->name = $name;
            }

            /**
             * Gets product attribute values
             *
             * @return array Product attribute values
             */
            public function getValues()
            {
                return $this->values;
            }

            /**
             * Adds product attribute value
             *
             * @param ProductAttributeValue $value Product attribute value
             *
             * @return void
             */
            public function addValue(ProductAttributeValue $value)
            {
                $value->setAttribute($this);
                $this->values[] = $value;
            }

        }

        $attribute = $em->find('ProductAttribute', 1);
        $em->remove($attribute);
        $em->flush();

        The upper code won't remove the entity from the database.... Corresponding DQL (DELETE ProductAttribute a WHERE a.id = 1) will remove it from the database...
        {code:title=Test.php|borderStyle=solid}
        /*
         * @Entity
         * @Table(indexes={@Index(name="name", columns={"name"})})
         */
        class ProductAttribute
        {

            /**
             * ID
             *
             * @Id @Column(type="integer") @GeneratedValue
             *
             * @var integer
             */
            protected $id;
            /**
             * Name
             *
             * @Column
             *
             * @var string
             */
            protected $name;
            /**
             * Values
             *
             * @OneToMany(targetEntity="ProductAttributeValue", mappedBy="attribute")
             *
             * @var array
             */
            protected $values;

            /**
             * Gets ID
             *
             * @return integer ID
             */
            public function getId()
            {
                return $this->id;
            }

            /**
             * Sets ID
             *
             * @param integer $id ID
             *
             * @return void
             */
            public function setId($id = null)
            {
                $this->id = $id;
            }

            /**
             * Gets name
             *
             * @return string Name
             */
            public function getName()
            {
                return $this->name;
            }

            /**
             * Sets name
             *
             * @param string $name Name
             *
             * @return void
             */
            public function setName($name = null)
            {
                $this->name = $name;
            }

            /**
             * Gets product attribute values
             *
             * @return array Product attribute values
             */
            public function getValues()
            {
                return $this->values;
            }

            /**
             * Adds product attribute value
             *
             * @param ProductAttributeValue $value Product attribute value
             *
             * @return void
             */
            public function addValue(ProductAttributeValue $value)
            {
                $value->setAttribute($this);
                $this->values[] = $value;
            }

        }

        $attribute = $em->find('ProductAttribute', 1);
        $em->remove($attribute);
        $em->flush();
        {code}

        The upper code won't remove the entity from the database.... Corresponding DQL (DELETE ProductAttribute a WHERE a.id = 1) will remove it from the database...
        Roman S. Borschel made changes -
        Assignee Roman S. Borschel [ romanb ] Benjamin Eberlei [ beberlei ]
        Roman S. Borschel made changes -
        Fix Version/s 2.0-RC1 [ 10091 ]
        Benjamin Eberlei made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Invalid [ 6 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 11975 ] jira-feedback [ 14595 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback [ 14595 ] jira-feedback2 [ 16459 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 16459 ] jira-feedback3 [ 18712 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Petr Motejlek
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: