PHP Doctrine：如何在insert / update上保留表默认值

Question

I have a table with default values for some columns, i. e. a **creationDate** column that holds the creation date of the record and for that reason should only be set on initial creation but not on updating the record.
I would love to let mysql set the creation date but when inserting a record with doctrine this value would be overwritten with NULL even if I don't have a getter or setter within the entity class. The only way to prevent this is to also remove the corresponding (protected) property. But if I do so I can't access the value of the **creationDate** field at all.

If I let php create the current date and use this as the default it would also be set on update with the current timestamp. So it would be more an updateDate than a creationDate.

How can I make doctrine to omit these kind off fields when creating the insert/update sql without removing the properties within the entity class?

Would be thankful for any suggestion.

Answer 1

Set the creationDate in __construct. That way it would not be updated when you update your entity.

public function __construct(){
    $this->creationDate = new \DateTime();
}

<kbd>UPDATE (Raw SQL using Connection)</kbd>

Question I answered that uses Raw SQL via Connection