A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL and Oracle.
A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL, Oracle, Sqlite and PostgreSQL.
Note: Sqlite date functions are implemented as
strftime(format, value). Sqlite only supports the most common formats, so
date_formatwill convert the mysql substitutions to the closest available sqlite substitutions. This means
date_format(field, '%b %D %Y') -> Jan 1st 2015becomes
strftime('%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:
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.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.