gesdinet/doctrine-functions-psql

Doctrine DQL Functions for PostgreSQL

v0.1.0 2014-10-22 10:13 UTC

Requires

• php: >=5.3.0
• doctrine/orm: >=2.2.3

Requires (Dev)

• phpunit/phpunit: 3.7.*

MIT

• Marcos Gómez Vilches

• database
• postgresql
• dql
• psql

README

This package contains doctrine functions for PostgreSQL.

List of available functions:

• DAYOFWEEK(expr)
• WEEK(expr)
• DAYOFMONTH(expr)
• DAYOFYEAR(expr)
• HOUR(expr)
• MINUTE(expr)
• MONTH(expr)
• QUARTER(expr)
• SECOND(expr)
• YEAR(expr)

Edit this file in your pull request to add your functions to the list.

Install

Via Composer

$ composer require gesdinet/doctrine-functions-psql

Usage

1) Doctrine Only

According to the Doctrine documentation you can register the functions in this package this way.

<?php
$config = new \Doctrine\ORM\Configuration();
$config->addCustomDatetimeFunction('year', 'Gesdinet\DQL\Datetime\Year');

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

2) Using Symfony 2

With Symfony 2 you can register your functions directly in the config.yml file.

doctrine:
    orm:
        dql:
            datetime_functions:
                month:     Gesdinet\DQL\Datetime\Month
                year:      Gesdinet\DQL\Datetime\Year
                # etc

Contributing

Feel free to make a PR with new functions and tests

Credits

• markitosgv
• gesdinet
• All Contributors

Based on luxifer doctrine-functions for MySQL

• luxifer

License

The MIT License (MIT). Please see License File for more information.