camelot/doctrine-postgres-bundle

PostgreSQL specific functionality for Pentangle

v2.2.0 2023-05-11 07:42 UTC

This package is auto-updated.

Last update: 2024-04-23 07:56:19 UTC


README

NOTE: For legacy PHP support (7.2+) please use the 1.0 branch.

This bundle provides Doctrine support for some specific PostgreSQL 9.4+ features for Symfony projects:

  • Support of JSONB and some array data-types (at present only integers, TEXT and JSONB)
  • Implementation of the most commonly used functions and operators when working with array and JSON data-types Functions for text search

Libraries used:

Installation

Applications that use Symfony Flex

Open a command console, enter your project directory and execute:

composer require camelot/doctrine-postgres-bundle

Applications that don't use Symfony Flex

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 camelot/doctrine-postgres-bundle

This command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation.

Step 2: Enable the Bundle

Then, enable the bundle by adding it to the list of registered bundles in the config/bundles.php file of your project:

// config/bundles.php

return [
    // ...
    Camelot\DoctrinePostgres\CamelotDoctrinePostgresBundle::class => ['all' => true],
];

Using

Available DBAL Types

  • jsonb
  • jsonb[]
  • smallint[]
  • integer[]
  • bigint[]
  • text[]

Available String Functions

  • ALL_OF
  • ANY_OF
  • ARRAY_APPEND
  • ARRAY_CARDINALITY
  • ARRAY_CAT
  • ARRAY_DIMENSIONS
  • ARRAY_LENGTH
  • ARRAY_NUMBER_OF_DIMENSIONS
  • ARRAY_PREPEND
  • ARRAY_REMOVE
  • ARRAY_REPLACE
  • ARRAY_TO_JSON
  • ARRAY_TO_STRING
  • CAST()
  • CONTAINS
  • DATE_PART()
  • GREATEST
  • ILIKE
  • IN_ARRAY
  • IS_CONTAINED_BY
  • JSON_ARRAY_LENGTH
  • JSONB_ARRAY_ELEMENTS
  • JSONB_ARRAY_ELEMENTS_TEXT
  • JSONB_ARRAY_LENGTH
  • JSONB_EACH
  • JSONB_EACH_TEXT
  • JSONB_EXISTS
  • JSONB_INSERT
  • JSONB_OBJECT_KEYS
  • JSONB_SET
  • JSONB_STRIP_NULLS
  • JSON_EACH
  • JSON_EACH_TEXT
  • JSON_GET_FIELD
  • JSON_GET_FIELD_AS_INTEGER
  • JSON_GET_FIELD_AS_TEXT
  • JSON_GET_OBJECT
  • JSON_GET_OBJECT_AS_TEXT
  • JSON_OBJECT_KEYS
  • JSON_STRIP_NULLS
  • LEAST
  • MAKE_DATE()
  • OVERLAPS
  • STRING_TO_ARRAY
  • TO_CHAR()
  • TO_JSON
  • TO_JSONB
  • TO_TSQUERY
  • TO_TSVECTOR
  • TSMATCH

See Common errors when using ILIKE, CONTAINS, IS_CONTAINED_BY and other operator-like functions for tip(s) on using the functions.