pfilsx/postgresql-doctrine

Extended Doctrine DBAL and Doctrine migrations classes for postgresql specific features support

v1.8.0 2023-06-16 20:56 UTC

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
• symfony/property-info: >=5.4
• symfony/serializer: >=5.4

MIT

• Pavel Filimonov

• migrations
• doctrine
• postgresql
• doctrine-dbal
• enum
• doctrine-migrations
• php8

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:

1. Register PostgreSQLDriverMiddleware.php as driver middleware
2. Register OrmSchemaProvider.php as Doctrine\Migrations\Provider\SchemaProvider in Doctrine\Migrations\DependencyFactory
3. Register types and functions on your needs

For Symfony integration see PostgreSQLDoctrineBundle

Documentation

• Enums
• Functions
• Types

License

This bundle is released under the MIT license.