README

Symfony2 bundle，提供在Doctrine 2中使用全文搜索PostgreSQL的工具全文搜索PostgreSQL。

添加了'tsvector'类型，用于映射。

添加了'to_tsquery'、'plainto_tsquery'和'ts_rank'函数，用于DQL。

步骤1：使用composer下载PostgreSearchBundle

在composer.json中添加PostgreSearchBundle

{
    "require": {
        "alsatian/postgres-search-bundle": "dev-master"
    }
}

现在运行以下命令让composer下载该包：

$ php composer.phar update alsatian/postgres-search-bundle

步骤2：启用该包

在kernel中启用该包

<?php
// app/AppKernel.php

public function registerBundles()
{
    $bundles = array(
        // ...
        new Alsatian\PostgresSearchBundle\AlsatianPostgresSearchBundle(),
    );
}

步骤3：映射示例

/**
 * @var string
 *
 * @ORM\Column(name="search_fts", type="tsvector", options={"customSchemaOptions": {"searchFields":{"name", "genre"}}}, nullable=true)
 */
protected $searchFts;

步骤4：在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, \'simple\' ) = true
        GROUP BY b.id
        ORDER BY rank DESC')
    ->setParameter('searchQuery', $searchQuery)
;
$result = $query->getArrayResult();

结果示例

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