Doctrine ORM - how to map jsonb / yaml?

Question

In my project I'm using Doctrine doctrine 2.5.4/postgres 9.5. I'm trying to add a jsonb field using yaml:

fields:
  obj: json_array

This gets converted to json (and not jsonb). The specification notes about picking up json or jsonb:

Chosen if the column definition contains the jsonb option inside the platformOptions attribute array and is set to true.

But platformOptions doesn't seems to work (tried to add it below obj, at the top... with no success). How can I add a jsonb field?

thanks, dan

Answer 1

This is supported by doctrine/dbal v2.6+ (it requires PHP 7.1). All you need to do is use json_array and set options={"jsonb"=true} I tested this on doctrine/dbal v2.6.3

This is what it looks like in PHP format

/**
 * @ORM\Column(type="json_array",nullable=true,options={"jsonb"=true})
 */
private $details;

and it creates query such as (for existing talble):

ALTER TABLE mytable ADD details JSONB NOT NULL;

more details about type mapping can be found at Doctrine mapping matrix.

Answer 2

Use boldtrn/jsonb-bundle, it provides a jsonb doctrine type as well as custom functions to access the special operators provided by the PostgreSQL jsonb data type.