pfilsx / postgresql-doctrine
Extended Doctrine DBAL and Doctrine migrations classes for postgresql specific features support
Installs: 2 382
Dependents: 1
Suggesters: 0
Security: 0
Stars: 3
Watchers: 1
Forks: 1
Open Issues: 0
Requires
- php: ^8.1
- doctrine/dbal: ^3.5.1
- doctrine/migrations: ^3.5.2
Requires (Dev)
- doctrine/orm: ^2.13
- friendsofphp/php-cs-fixer: ^3.13
- phpunit/phpunit: ^10.0
- symfony/property-access: >=5.4
- symfony/property-info: >=5.4
- symfony/serializer: >=5.4
README
Description
Provides extended Doctrine and Doctrine migrations PostgreSQL support with specific features such as enums, arrays and aggregate and JSON(B) functions.
Features
- PostgreSQL enums support in DBAL, ORM and migrations
- PHP8 enum support
- Fix creating default schema in down migrations for pgsql
- JSON(B) functions (in progress)
- JSON(B) types based on object models (in progress, requires symfony/serializer)
- Trait for easy use of SELECT EXISTS(...) in your entity repositories
- Aggregate functions with filter condition support
- Array types
- Text Search support
Requirement
- PHP ^8.1
- doctrine/dbal ^3.5.1
- doctrine/migrations ^3.5.2
- symfony/serializer >=5.4.* (optional for json models)
- symfony/property-info >=5.4.* (optional for json models)
Installation
Open a command console, enter your project directory and execute the following command to download the latest version of this bundle:
composer require pfilsx/postgresql-doctrine
Usage
Please refer Doctrine DBAL and Doctrine Migrations for instructions on how to override the default doctrine classes in your project.
Required steps:
- Register PostgreSQLDriverMiddleware.php as driver middleware
- Register OrmSchemaProvider.php as Doctrine\Migrations\Provider\SchemaProvider in Doctrine\Migrations\DependencyFactory
- Register types and functions on your needs
For Symfony integration see PostgreSQLDoctrineBundle
Documentation
License
This bundle is released under the MIT license.