How do I set enum data type in doctrine 2

Question

In annotation based mapping, as per the documentation of doctrine, we can do as shown below:

/** @Column(type="string", columnDefinition="ENUM('visible', 'invisible')") */

My question is how do I represent this in yaml meta data file for doctrine?

I want to do something like this:

fields:
status:
  type: string
  columnDefinition: ....

I am using symfony 2 as framework

i dont know how to convert ENUM('visible','invisible') into yaml expression, i m new to yaml — sonam, Sep 17 '12 at 10:00

score 13 · Accepted Answer · answered Sep 17 '12 at 10:11

13

Just use:

fields:
status:
  type: string
  columnDefinition: ENUM('visible', 'invisible')

answered Sep 17 '12 at 10:11

Carlos Granados

I guess this works for MySQL only, right? Because in Postgres you will have to actually `CREATE TYPE` – Vladislav Rastrusny Apr 30 '17 at 16:11

score 1 · Answer 2 · edited Dec 04 '18 at 10:04

1

status:
    type: enum
    values: ['visible', 'invisible']

edited Dec 04 '18 at 10:04

Rob Bricheno

answered Jan 23 '18 at 20:27

Serghei Niculaev

2 Answers2