glauberkyves/mysql-functions-doctrine2

MySQL Function for Doctrine : CONCAT_WS

MySQL functions Doctrine2

This library provides you MySQL functions for Doctrine2., _(*1)

At the moment are supported, _(*2)

• CONCAT_WS
• GEO
• DATE
• YEAR
• MONTH
• DAY

Feel free to fork and add other functions., _(*3)

Installation

Get the bundle

Add this in your composer.json, _(*4)

{
    "require": {
        "glauberkyves/mysql-functions-doctrine2": "1.*"
    }
}

and then run, _(*5)

php composer.phar update

or, _(*6)

composer update

if you installed composer globally., _(*7)

Add the classes to your configuration

$config = new \Doctrine\ORM\Configuration();
$config->addCustomStringFunction('concat_ws', 'GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlRand');

$em = EntityManager::create($dbParams, $config);

You can of course pick just the functions you need., _(*8)

Use with Symfony2

If you install the library in a Symfony2 application, you can add this in your config.yml, _(*9)

# app/config/config.yml
doctrine:
    orm:
        # ...
        entity_managers:
            default:
                # ...
                dql:
                    string_functions:
                        concat_ws: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlConcatWs
                        month: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlMonth
                    numeric_functions:
                        geo: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlGeo
                    datetime_functions:
                        date: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlDate
                        day: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlDay
                        year: GlauberKyves\MysqlDoctrineFunctions\DQL\MysqlYear

Usage

You can now use the functions in your DQL Query, _(*10)

$query = 'SELECT CONCAT_WS('string', 'string') FROM ...';
$em->createQuery($query);

$query = 'SELECT GEO(-15.5656, -47.5656, t.latitude, t.longitude) FROM tb_address t ...';
$em->createQuery($query);