darklow / TsvectorType.php

Created July 17, 2012


    
    View TsvectorType.php 
  
  
      TsvectorType.php
    
    
        Raw
      
    
    File suppressed. Click to show.
  
  
            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;