A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL, Oracle, Sqlite and PostgreSQL.
DB | Functions |
---|---|
MySQL | ACOS, ASCII, ASIN, ATAN, ATAN2, BINARY, BIT_COUNT, BIT_XOR, CEIL, CHAR_LENGTH, CONCAT_WS, COS, COT, COUNTIF, CRC32, DATE, DATE_FORMAT, DATEADD, DATEDIFF, DATESUB, DAY, DAYNAME, DAYOFWEEK, DAYOFYEAR, DEGREES, DIV, FIELD, FIND_IN_SET, FLOOR, FROM_UNIXTIME, GREATEST, GROUP_CONCAT, HOUR, IFELSE, IFNULL, LAST_DAY, LEAST, LPAD, MATCH_AGAINST, MD5, MINUTE, MONTH, MONTHNAME, NOW, NULLIF, PI, POWER, QUARTER, RADIANS, RAND, REGEXP, REPLACE, ROUND, RPAD, SECOND, SHA1, SHA2, SIN, SOUNDEX, STD, STDDEV, STRTODATE, SUBSTRING_INDEX, TAN, TIME, TIMEDIFF, TIMESTAMPADD, TIMESTAMPDIFF, TIMETOSEC, UNIX_TIMESTAMP, UUID_SHORT, WEEK, WEEKDAY, YEAR, YEARWEEK |
Oracle | DAY, MONTH, NVL, TODATE, TRUNC, YEAR, LISTAGG |
Sqlite | DATE, MINUTE, HOUR, DAY, WEEK, WEEKDAY, MONTH, YEAR, STRFTIME, DATE_FORMAT*, IFNULL, REPLACE, ROUND |
PostgreSQL | TO_DATE, TO_CHAR, AT_TIME_ZONE, COUNT_FILTER |
Note: Sqlite date functions are implemented as
strftime(format, value)
. Sqlite only supports the most common formats, sodate_format
will convert the mysql substitutions to the closest available sqlite substitutions. This meansdate_format(field, '%b %D %Y') -> Jan 1st 2015
becomesstrftime('%m %d %Y', field) -> 01 01 2015
.
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.
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.