public
Created

Doctrine2 PostgreSQL tsvector type class

  • Download Gist
TsvectorType.php
PHP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
<?php
namespace Acme\AcmeBundle\Dbal;
 
use Doctrine\DBAL\Types\Type;
use Doctrine\DBAL\Platforms\AbstractPlatform;
 
class TsvectorType extends Type
{
public function getName()
{
return 'tsvector';
}
 
public function canRequireSQLConversion()
{
return true;
}
 
public function getSqlDeclaration(array $fieldDeclaration, AbstractPlatform $platform)
{
return "TSVECTOR";
}
 
public function convertToPHPValue($value, AbstractPlatform $platform)
{
return $value;
}
 
public function convertToDatabaseValueSQL($sqlExpr, AbstractPlatform $platform)
{
return sprintf('to_tsvector(%s)', $sqlExpr);
}
 
public function convertToDatabaseValue($value, AbstractPlatform $platform)
{
if (is_array($value)) {
$value = implode(" ", $value);
}
return $value;
}
}
 
/** Config YML
doctrine:
dbal:
types:
tsvector: Acme\AcmeBundle\Dbal\TsvectorType
connections:
default:
mapping_types:
tsvector: tsvector
**/
 
// Entity column definition
 
/**
* @var array|string $tsv
* @ORM\Column(name="tsv", type="tsvector", nullable=true)
*/
private $tsv;

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.