simplymove / pgsql-function-bundle
There is no license information available for the latest version (dev-master) of this package.
Add functions of pgsql at doctrine
dev-master
2017-10-12 07:49 UTC
Requires
- php: ^5.3.9|~7.0
- doctrine/doctrine-bundle: ~1.3
- doctrine/orm: ~2.3
- symfony/framework-bundle: ~2.7|~3.0
This package is not auto-updated.
Last update: 2020-06-18 06:07:28 UTC
README
Installation
Step 1: Download the Bundle
Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:
$ composer require "SimplyMove/DoctrinePgsqlBundle:dev-master"
Step 2: Add the new Types and Functions to the Config
# config.yml
doctrine:
dbal:
types:
jsonb: SimplyMove\DoctrinePgsqlBundle\Types\JsonbArrayType
mapping_types:
jsonb: jsonb
orm:
dql:
string_functions:
JSONB_AG: SimplyMove\DoctrinePgsqlBundle\Functions\JsonbAtGreater
JSONB_HGG: SimplyMove\DoctrinePgsqlBundle\Functions\JsonbHashGreater
JSONB_EX: SimplyMove\DoctrinePgsqlBundle\Functions\JsonbExistence
ILIKE: SimplyMove\DoctrinePgsqlBundle\Functions\ILIKE
SUBSTRING: SimplyMove\DoctrinePgsqlBundle\Functions\Substring
AT_TIME_ZONE: SimplyMove\DoctrinePgsqlBundle\Functions\AtTimeZoneFunction
COUNT_FILTER: SimplyMove\DoctrinePgsqlBundle\Functions\CountFilterFunction
TO_CHAR: SimplyMove\DoctrinePgsqlBundle\Functions\DateFormat
TO_DATE: SimplyMove\DoctrinePgsqlBundle\Functions\StrToDate
STRING_AGG: SimplyMove\DoctrinePgsqlBundle\Functions\StringAgg