Default value in Doctrine

Question

How do I set a default value in Doctrine 2

User · Accepted Answer

Database default values are not  portably  supported  The only way to use database default values is through the columnDefinition mapping attribute where you specify the SQL snippet  DEFAULT cause inclusive  for the column the field is mapped to   You can use    lt  php         Entity     class myEntity                   var string                Column name  myColumn   type  string   length  50               private  myColumn    myDefaultValue               PHP-level default values are preferred as these are also properly available on newly created and persisted objects  Doctrine will not go back to the database after persisting a new object to get the default values

User · Answer

The workaround I used was a LifeCycleCallback  Still waiting to see if there is any more  native  method  for instance  Column type  string   default  hello default value             Entity  Table name  posts    HasLifeCycleCallbacks     class Post implements Node   Zend Acl Resource Interface                 PrePersist     function onPrePersist            set default date      this- gt dtPosted   date  Y-m-d H m s

User · Answer

lt  php         Entity     class myEntity                   var string                ORM Column name  myColumn   type  integer   options   default    0               private  myColumn              Note that this uses SQL DEFAULT  which is not supported for some fields like BLOB and TEXT

User · Answer

Set up a constructor in your entity and set the default value there

User · Answer

If you use yaml definition for your entity  the following works for me on a postgresql database   Entity Entity name      type  entity     table  table name     fields           field name              type  boolean             nullable  false             options                  default  false

User · Answer

Here is how I solved it for myself  Below is an Entity example with default value for MySQL  However  this also requires the setup of a constructor in your entity  and for you to set the default value there   Entity Example    type  entity   table  example   fields      id        type  integer       id  true       generator          strategy  AUTO     label        type  string       columnDefinition  varchar 255  NOT NULL DEFAULT  default value  COMMENT  This is column comment

User · Answer

Adding to  romanb brilliant answer   This adds a little overhead in migration  because you obviously cannot create a field with not null constraint and with no default value      this up   migration is autogenerated  please modify it to your needs  this- gt abortIf  this- gt connection- gt getDatabasePlatform  - gt getName       postgresql       lets add property without not null contraint          this- gt addSql  ALTER TABLE tablename ADD property BOOLEAN       get the default value for property         object   new Object     defaultValue    menuItem- gt getProperty      true   false     this- gt addSql  UPDATE tablename SET property     defaultValue        not you can add constraint  this- gt addSql  ALTER TABLE tablename ALTER property SET NOT NULL      With this answer  I encourage you to think why do you need the default value in the database in the first place  And usually it is to allow creating objects with not null constraint

User · Answer

Be careful when setting default values on property definition  Do it in constructor instead  to keep it problem-free  If you define it on property definition  then persist the object to the database  then make a partial load  then not loaded properties will again have the default value  That is dangerous if you want to persist the object again

User · Answer

Update  One more reason why read the documentation for Symfony will never go out of trend  There is a simple solution for my specific case and is to set the field type option empty data to a default value   Again  this solution is only for the scenario where an empty input in a form sets the DB field to null   Background  None of the previous answers helped me with my specific scenario but I found a solution   I had a form field that needed to behave as follow    Not required  could be left blank   Used  required     false  If left blank  it should default to a given value  For better user experience  I did not set the default value on the input field but rather used the html attribute  placeholder  since it is less obtrusive    I then tried all the recommendations given in here  Let me list them    Set a default value when for the entity property     lt  php         Entity     class myEntity                   var string                Column name  myColumn   type  string   length  50               private  myColumn    myDefaultValue                Use the options annotation     ORM Column name  foo   options   default   foo bar       Set the default value on the constructor            Entity     class myEntity               public function   construct                  this- gt myColumn    myDefaultValue                     None of it worked and all because of how Symfony uses your Entity class   IMPORTANT  Symfony form fields override default values set on the Entity class   Meaning  your schema for your DB can have a default value defined but if you leave a non-required field empty when submitting your form  the form- gt handleRequest   inside your form- gt isValid   method will override those default values on your Entity class and set them to the input field values  If the input field values are blank  then it will set the Entity property to null   http   symfony com doc current book forms html handling-form-submissions  My Workaround  Set the default value on your controller after form- gt handleRequest   inside your form- gt isValid   method       if   myEntity- gt getMyColumn       null         myEntity- gt setMyColumn  myDefaultValue            Not a beautiful solution but it works  I could probably make a validation group but there may be people that see this issue as a data transformation rather than data validation  I leave it to you to decide     Override Setter  Does Not Work   I also tried to override the Entity setter this way              Set myColumn        param string  myColumn        return myEntity     public function setMyColumn  myColumn         this- gt myColumn     myColumn     null     myColumn            myDefaultValue     myColumn       return  this          This  even though it looks cleaner  it doesn t work  The reason being that the evil form- gt handleRequest   method does not use the Model s setter methods to update the data  dig into form- gt setData   for more details

User · Answer

None of this worked for me  I found some documentation on doctrine s site that says to set the value directly to set a default value   https   www doctrine-project org projects doctrine-orm en 2 6 reference faq html how-can-i-add-default-values-to-a-column  private  default   0    This inserted the value I wanted

User · Answer

I struggled with the same problem  I wanted to have the default value from the database into the entities  automatically   Guess what  I did it      lt  php        Created by JetBrains PhpStorm     User  Steffen    Date  27-6-13    Time  15 36    To change this template use File   Settings   File Templates       require once  bootstrap php     em- gt getConfiguration  - gt setMetadataDriverImpl      new  Doctrine ORM Mapping Driver DatabaseDriver           em- gt getConnection  - gt getSchemaManager              driver   new  Doctrine ORM Mapping Driver DatabaseDriver  em- gt getConnection  - gt getSchemaManager      driver- gt setNamespace  Models        em- gt getConfiguration  - gt setMetadataDriverImpl  driver     cmf   new  Doctrine ORM Tools DisconnectedClassMetadataFactory     cmf- gt setEntityManager  em    metadata    cmf- gt getAllMetadata        Little hack to have default values for your entities    foreach   metadata as  k   gt   t        foreach   t- gt getFieldNames   as  fieldName                 correctFieldName    Doctrine Common Util Inflector  tableize  fieldName             columns    tan    em- gt getConnection  - gt getSchemaManager  - gt listTableColumns  t- gt getTableName             foreach   columns as  column                        if   column- gt getName       correctFieldName                                   We skip DateTime  because this needs to be a DateTime object                  if   column- gt getType       DateTime                                          metadata  k - gt fieldMappings  fieldName   default      column- gt getDefault                                      break                                      GENERATE PHP ENTITIES   entityGenerator   new  Doctrine ORM Tools EntityGenerator     entityGenerator- gt setGenerateAnnotations true    entityGenerator- gt setGenerateStubMethods true    entityGenerator- gt setRegenerateEntityIfExists true    entityGenerator- gt setUpdateEntityIfExists false    entityGenerator- gt generate  metadata    DIR      echo  Entities created

User · Answer

You can do it using xml as well    lt field name  acmeOne  type  string  column  acmeOne  length  36  gt       lt options gt           lt option name  comment  gt Your SQL field comment goes here  lt  option gt           lt option name  default  gt Default Value lt  option gt       lt  options gt   lt  field gt

User · Answer

While setting the value in the constructor would work  using the Doctrine Lifecycle events might be a better solution   By leveraging the prePersist Lifecycle Event  you could set your default value on your entity only on initial persist

User · Answer

Works for me on a mysql database also   Entity Entity name      type  entity     table  table name     fields           field name              type  integer             nullable  true             options                  default  1

User · Answer

Use    options   default   foo bar     and not    options   default   foo bar     For instance          ORM Column name  foo   type  smallint   options   default  0      private  foo

[php] Default value in Doctrine

Examples related to php

Examples related to orm

Examples related to doctrine-orm