Default value in Doctrine for in relations columns

Question

I know there is this question Default value in Doctrine

My question is how do I set a default value=0 in Doctrine2/Symfony2, when column has ManyToOne relation?

Column product_id in DB is not null, I can't change it!

If I do setProductId(0), it is somehow overridden by setProduct(null) and I get.

Integrity constraint violation: 1048 Column 'product_id' cannot be null

If I default $product = 0; or $productId = 0; or both, as suggested by doctrine-faqs, I get

Expected value of type "Entity\Product" ...

I want to set it = 0 if its not set!

Is it OK Or even allowed to have $productId and $product properties pointing to same database column?

Code almost look like this:

class ShopLog { /** * @var integer * * @ORM\Column(name="product_id", type="integer", nullable=false) // , columnDefinition="DEFAULT 0" does not work */ private $productId; /** * @var Entity\Product * * @ORM\ManyToOne(targetEntity="Entity\Product") * @ORM\JoinColumns({ * @ORM\JoinColumn(name="product_id", referencedColumnName="id", nullable=false) // , columnDefinition="DEFAULT 0" does not work * }) */ private $product; /** * Set productId * * @param integer $productId * @return ShopLog */ public function setProductId($productId) { $this->productId = $productId; return $this; } /** * Set product * * @param \Entity\Product $product * @return ShopLog */ public function setProduct(\Entity\Product $product = null) { $this->product = $product; return $this; }

why you dont want to add nullable=true into the annotation? — Marius
– Marius, Commented May 25, 2016 at 9:53
@Marius Column product_id in mysql DB is not null, I can't change it! — Shahid
– Shahid, Commented May 25, 2016 at 12:49

scandel · Accepted Answer · 2016-05-25 11:09:24Z

There are two questions in your question.

First, you can't have $product and $productId properties pointing on the same database column.

You should have only a $product property, and if you need to access the $id property of a product, do something like this:

$productId = $shoplog->getProduct()->getId();

Second, to allow the database column product_id to accept null values, just set it in the annotation, like Marius said in its comment (and after, don't forget to update the database with php app/console doctrine:schema:update).

So, your whole code should look like:

class ShopLog { /** * @var Entity\Product * * @ORM\ManyToOne(targetEntity="Entity\Product") * @ORM\JoinColumn(name="product_id", referencedColumnName="id", nullable=true) * }) */ private $product; /** * Set product * * @param \Entity\Product $product * @return ShopLog */ public function setProduct(\Entity\Product $product = null) { $this->product = $product; return $this; } }

One point is clear now thanks! we should not have both $product and $productId... Other was product_id is NOT NULL field, and i don't want to set null there... I want default value set to 0. sorry for late reply...

Collectives™ on Stack Overflow

Default value in Doctrine for in relations columns

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related