Created

Embed URL

HTTPS clone URL

SSH clone URL

You can clone with HTTPS or SSH.

Download Gist

Doctrine2 PostgreSQL tsvector type class

View TsvectorType.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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.