fsa/doctrine-postgres-types

Provide some common postgres types for doctrine

dev-main 2024-03-29 08:50 UTC

Requires

• php: >=8.1
• doctrine/dbal: 2.*|3.*|4.*

Requires (Dev)

• phpunit/phpunit: 4.*|5.*

MIT

• Richard Fullmer

README

Provides Doctrine Type classes for common postgres types

Installation

composer require opensoft/doctrine-postgres-types

Usage

Using with Symfony2 Doctrine Configuration

# Doctrine Configuration
doctrine:
    dbal:
        types:
            text_array: "Doctrine\\DBAL\\PostgresTypes\\TextArrayType"
            int_array: "Doctrine\\DBAL\\PostgresTypes\\IntArrayType"
            ts_vector: "Doctrine\\DBAL\\PostgresTypes\\TsvectorType"
            ts_query: "Doctrine\\DBAL\\PostgresTypes\\TsqueryType"
            xml: "Doctrine\\DBAL\\PostgresTypes\\XmlType"
            inet: "Doctrine\\DBAL\\PostgresTypes\\InetType"
            macaddr: "Doctrine\\DBAL\\PostgresTypes\\MacAddrType"
        mapping_types:
            _text: text_array
            _int4: int_array
            tsvector: ts_vector
            tsquery: ts_query
            xml: xml
            inet: inet
            macaddr: macaddr

Using with Doctrine

<?php

use Doctrine\DBAL\Types\Type;

Type::addType('text_array', "Doctrine\\DBAL\\PostgresTypes\\TextArrayType");
Type::addType('int_array', "Doctrine\\DBAL\\PostgresTypes\\IntArrayType");
Type::addType('tsvector', "Doctrine\\DBAL\\PostgresTypes\\TsvectorType");
Type::addType('tsquery', "Doctrine\\DBAL\\PostgresTypes\\TsqueryType");
Type::addType('xml', "Doctrine\\DBAL\\PostgresTypes\\XmlType");
Type::addType('inet', "Doctrine\\DBAL\\PostgresTypes\\InetType");
Type::addType('macaddr', "Doctrine\\DBAL\\PostgresTypes\\MacAddrType");

License

Licensed under the MIT License