mar/doctrine-xtensions
Composer 安装命令：
composer require mar/doctrine-xtensions
包简介
A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL and Oracle.
关键字：
README 文档
README
A set of extensions to Doctrine 2 that add support for functions available in MySQL, Oracle, PostgreSQL and SQLite.
| DB | Functions |
|---|---|
| MySQL | ACOS, AES_DECRYPT, AES_ENCRYPT, ANY_VALUE, ASCII, ASIN, ATAN, ATAN2, BINARY, BIT_COUNT, BIT_XOR, CAST, CEIL, CHAR_LENGTH, COLLATE, CONCAT_WS, CONVERT_TZ, COS, COT, COUNTIF, CRC32, DATE, DATE_FORMAT, DATEADD, DATEDIFF, DATESUB, DAY, DAYNAME, DAYOFWEEK, DAYOFYEAR, DEGREES, DIV, EXP, EXTRACT, FIELD, FIND_IN_SET, FLOOR, FROM_UNIXTIME, GREATEST, GROUP_CONCAT, HEX, HOUR, IFELSE, IFNULL, INET_ATON, INET_NTOA, INET6_ATON, INET6_NTOA, INSTR, IS_IPV4, IS_IPV4_COMPAT, IS_IPV4_MAPPED, IS_IPV6, LAST_DAY, LEAST, LOG, LOG10, LOG2, LPAD, MATCH, MD5, MINUTE, MONTH, MONTHNAME, NOW, NULLIF, PERIOD_DIFF, PI, POWER, QUARTER, RADIANS, RAND, REGEXP, REPLACE, ROUND, RPAD, SECOND, SECTOTIME, SHA1, SHA2, SIN, SOUNDEX, STD, STDDEV, STRTODATE, STR_TO_DATE, SUBSTRING_INDEX, TAN, TIME, TIMEDIFF, TIMESTAMPADD, TIMESTAMPDIFF, TIMETOSEC, UNHEX, UNIX_TIMESTAMP, UTC_TIMESTAMP, UUID_SHORT, VARIANCE, WEEK, WEEKDAY, YEAR, YEARMONTH, YEARWEEK |
| Oracle | DAY, LISTAGG, MONTH, NVL, TO_CHAR, TO_DATE, TRUNC, YEAR |
| Sqlite | DATE, MINUTE, HOUR, DAY, WEEK, WEEKDAY, MONTH, YEAR, STRFTIME, DATE_FORMAT*, CASE WHEN THEN ELSE END, IFNULL, REPLACE, ROUND |
| PostgreSQL | TO_DATE, TO_CHAR, AT_TIME_ZONE, COUNT_FILTER, STRING_AGG |
Note: Sqlite date functions are implemented as
strftime(format, value). Sqlite only supports the most common formats, sodate_formatwill convert the mysql substitutions to the closest available sqlite substitutions. This meansdate_format(field, '%b %D %Y') -> Jan 1st 2015becomesstrftime('%m %d %Y', field) -> 01 01 2015.
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 phpunit:
make test
If you want to run php-cs-fixer:
make fix # (or make lint for a dry-run)
Usage
If you are using DoctrineExtensions with Symfony, you should read their documentation on How to Register custom DQL Functions.
You can find example Symfony configuration for using DoctrineExtensions custom DQL functions in config.
If you are using DoctrineExtensions standalone, you might want to fire up the autoloader:
<?php $classLoader = new \Doctrine\Common\ClassLoader('DoctrineExtensions', '/path/to/extensions'); $classLoader->register();
For more information check out the documentation of Doctrine DQL User Defined Functions.
统计信息
- 总下载量： 9
- 月度下载量： 0
- 日度下载量： 0
- 收藏数： 0
- 点击次数： 3
- 依赖项目数： 0
- 推荐数： 0
其他信息
- 授权协议： BSD-3-Clause
- 更新时间： 2018-11-16