/** * Use jsonb for PostgreSQL, this means we require PostgreSQL 9.4 * * @param array $fieldDeclaration The field declaration * @param \Doctrine\DBAL\Platforms\AbstractPlatform $platform The currently used database platform * @return string */ public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform) { switch ($platform->getName()) { case 'postgresql': return 'jsonb'; default: return $platform->getJsonTypeDeclarationSQL($fieldDeclaration); } }
/** * {@inheritdoc} */ public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform) { return $platform->getJsonTypeDeclarationSQL($fieldDeclaration); }
/** * @group DBAL-553 */ public function testReturnsJsonTypeDeclarationSQL() { $column = array('length' => 666, 'notnull' => true, 'type' => Type::getType('json_array')); $this->assertSame($this->_platform->getClobTypeDeclarationSQL($column), $this->_platform->getJsonTypeDeclarationSQL($column)); }