avkluchko / postgres-doctrine-extensions
Doctrine extensions for working with PostgreSQL database
Installs: 339
Dependents: 0
Suggesters: 0
Security: 0
Stars: 1
Watchers: 2
Forks: 0
Open Issues: 0
Type:symfony-bundle
Requires
- php: ^7.1.3
Requires (Dev)
- symfony/phpunit-bridge: ^4.3
- symfony/test-pack: ^1.0
This package is auto-updated.
Last update: 2024-10-29 05:53:49 UTC
README
Doctrine extensions for working with PostgreSQL database
Requirements
Installation
composer require avkluchko/postgres-doctrine-extensions
Add the necessary extensions in the doctrine.yaml:
doctrine: orm: dql: string_functions: cast: AVKluchko\PostgresDoctrineExtensions\DQL\Cast date_part: AVKluchko\PostgresDoctrineExtensions\DQL\DatePart make_date: AVKluchko\PostgresDoctrineExtensions\DQL\MakeDate to_char: AVKluchko\PostgresDoctrineExtensions\DQL\ToChar
Usage
// src/Filters/SomeFilter.php public class SomeFilter { // ... protected function createCondition(string $year, string $field, string $operator, string $parameterName): string { return sprintf( 'make_date(%s, cast(date_part(\'month\', %s) as integer), cast(date_part(\'day\', %s) as integer)) %s :%s', $year, $field, $field, $operator, $parameterName ); } }