PostgreSearchBundle

Symfony2 bundle with tools full-text search PostgreSQL in Doctrine 2.

Added type 'tsvector' to be used in the mapping.

Added functions 'to_tsquery' and 'ts_rank' to be used in the DQL.

Step 1: Download PostgreSearchBundle using composer

Add PostgreSearchBundle in your composer.json:

{"require": {"ddmaster/postgre-search-bundle": "dev-master"}}

Now tell composer to download the bundle by running the command:

$ php composer.phar update ddmaster/postgre-search-bundle

Composer will install the bundle to your project's vendor/ddmaster/postgre-search-bundle directory.

Step 2: Enable the bundle

Enable the bundle in the kernel:

<?php// app/AppKernel.phppublicfunctionregisterBundles()
{
$bundles = array(
// ...newDdmaster\PostgreSearchBundle\PostgreSearchBundle(),
);
}

Step 3: Configure

Add in your config.yml:

# Doctrine Configurationdoctrine:
dbal:
types:
tsvector: Ddmaster\PostgreSearchBundle\Dbal\TsvectorTypemapping_types:
tsvector: tsvectororm:
entity_managers:
default:
dql:
string_functions:
TSQUERY: Ddmaster\PostgreSearchBundle\DQL\TsqueryFunctionTSRANK: Ddmaster\PostgreSearchBundle\DQL\TsrankFunction

Step 4: Mapping example

/** * @var string * * @ORM\Column(name="search_fts", type="tsvector", nullable=true) */private$searchFts;

Step 5: Use in DQL

$searchQuery = 'family | history';
$em = $this->getDoctrine()->getManager();
$query = $em->createQuery(
'SELECT b.id, sum(TSRANK(b.searchFts, :searchQuery)) as rank  FROM DemoSearchBundle:Books b WHERE TSQUERY( b.searchFts, :searchQuery ) = true GROUP BY b.id ORDER BY rank DESC')
->setParameter('searchQuery', $searchQuery)
;
$result = $query->getArrayResult();

Result example:

Array([0] => Array([id] => 2[rank] => 0.0607927)[1] => Array([id] => 3[rank] => 0.0303964))