iakumai/doctrine-functions

Doctrine DQL Functions for Mysql

Doctrine Functions

This package contains some doctrine functions, _(*1)

String functions

• INSTR(exp1, exp2) - documentation
• FIELD(exp1, exp2, exp3, exp4...) - documentation

DateTime functions

• DATE_FORMAT(field, '%format%') - documentation
• DATE(field) - documentation

Math functions

• RAND() - documentation. Remember, you can not use parameters in this function.
• RANDP(12345) - documentation. This is still RAND() MySQL function, but you must use a number parameter in it.

Installation

Just add the package to your composer.json, _(*2)

{
    "require": {
        "iakumai/doctrine-functions": "dev-master"
    }
}

Integration

1) Doctrine Only

According to the Doctrine documentation you can register the functions in this package this way., _(*3)

<?php
$config = new \Doctrine\ORM\Configuration();
$config->addCustomDatetimeFunction('instr', 'IAkumaI\DQL\Str\Instr');
?>

2) Using Symfony 2

With symfony 2 you can register yout functions in the config.yml file., _(*4)

doctrine:
    orm:
        entity_managers:
            default:
                dql:
                    datetime_functions:
                        instr: IAkumaI\DQL\Str\Instr

Usage

Simple example, usage a DateFormat function:, _(*5)

createQuery("SELECT DATE_FORMAT(e.date, '%d.%m.%Y') as df FROM YourBundle:Ent e");
?>

This way you can use DQL function in ORDER statement. For example, order by RAND():, _(*6)

createQuery("SELECT e, RAND() as HIDDEN rand FROM YourBundle:Ent e ORDER BY rand");
?>