ddmaster / postgre-search-bundle
Tools to use full-text search PostgreSQL in Doctrine.
Installs: 71 728
Dependents: 0
Suggesters: 0
Security: 0
Stars: 13
Watchers: 2
Forks: 34
Open Issues: 0
Type:symfony-bundle
Requires
- php: >=5.3.3
- doctrine/orm: >=2.2.3
- symfony/framework-bundle: >=2.1
This package is not auto-updated.
Last update: 2024-04-13 11:41:04 UTC
README
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.php public function registerBundles() { $bundles = array( // ... new Ddmaster\PostgreSearchBundle\PostgreSearchBundle(), ); }
Step 3: Configure
Add in your config.yml:
# Doctrine Configuration doctrine: dbal: types: tsvector: Ddmaster\PostgreSearchBundle\Dbal\TsvectorType mapping_types: tsvector: tsvector orm: entity_managers: default: dql: string_functions: TSQUERY: Ddmaster\PostgreSearchBundle\DQL\TsqueryFunction TSRANK: 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 ) )