umanit/sonata-admin-postgresql-search-bundle

Better search behaviour with Sonata admin and PostgreSQL

0.1 2018-06-15 12:23 UTC

Requires

• php: >=5.6
• doctrine/doctrine-bundle: ~1.6
• sonata-project/admin-bundle: ~3.9
• sonata-project/doctrine-orm-admin-bundle: ~3.1
• symfony/framework-bundle: >=2.3

MIT

• UmanIT

• symfony
• sonata
• doctrine
• postgresql
• sonataAdmin

README

This bundle overrides Sonata Admin search behaviour when using PostgreSQL. It makes all search case insensitive and unaccented.

Install

Register the bundle to your app/AppKernel.php

    // ...
    public function registerBundles()
    {
        $bundles = [
            // ...
            new Umanit\SonataAdminPostgreSQLSearchBundle\UmanitSonataAdminPostgreSQLSearchBundle(),
        ];
        // ...
    }

Create UNACCENT extension in your database.

CREATE EXTENSION IF NOT EXISTS UNACCENT;

That was it!