DoctrineExtensions

A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL and Oracle.

DB	Functions
MySQL	ACOS, ASCII, ASIN, ATAN, ATAN2, BINARY, CEIL, CHAR_LENGTH, CONCAT_WS, COS, COT, COUNTIF, CRC32, DATE, DATE_FORMAT, DATEADD, DATEDIFF, DATESUB, DAY, DAYNAME, DEGREES, FIELD, FIND_IN_SET, FLOOR, FROM_UNIXTIME, GROUP_CONCAT, HOUR, IFELSE, IFNULL, LAST_DAY, MATCH_AGAINST, MD5, MINUTE, MONTH, MONTHNAME, NULLIF, PI, POWER, QUARTER, RADIANS, RAND, REGEXP, REPLACE, ROUND, SECOND, SHA1, SHA2, SIN, SOUNDEX, STD, STRTODATE, SUBSTRING_INDEX, TAN, TIME, TIMESTAMPADD, TIMESTAMPDIFF, UUID_SHORT, WEEK, WEEKDAY, YEAR
Oracle	DAY, MONTH, NVL, TODATE, TRUNC, YEAR
Sqlite	DATE, MINUTE, HOUR, DAY, WEEK, WEEKDAY, MONTH, YEAR, STRFTIME*

Note: Sqlite date functions are implemented as strftime(formatter, value).

Installation

To install this library, run the command below and you will get the latest version:

composer require beberlei/DoctrineExtensions

If you want to run the tests:

vendor/bin/phpunit

To include the DoctrineExtensions you should fire up an autoloader, for example:

<?php

$classLoader = new \Doctrine\Common\ClassLoader('DoctrineExtensions', '/path/to/extensions');
$classLoader->register();

You can find an example configuration for using the additional MySQL functions in Symfony2 in config/mysql.yml.

Legacy versions

If you're still using Paginator, LargeCollections, Phing, PHPUnit or Versionable behaviours available in 0.1–0.3, you're welcome to use 0.3 – but do note, this functionality is now available in Doctrine core, no longer supported in this library, and was removed in 1.0.

Whilst pull requests for bugfixes to this functionality will be considered for 0.x releases, you are encouraged to switch out your implementations and upgrade to ~1.0.