flecomte / postgresqltypebundle Goto Github PK

    {
        $em = $this->container->get('doctrine.orm.default_entity_manager');
        $this->defineType($em);
    }

    public function defineType (EntityManager $em)
    {
        $conn = $em->getConnection();

        if (!Type::hasType('cidr')) {
            Type::addType('cidr', 'FLE\Bundle\PostgresqlTypeBundle\Doctrine\DBAL\Types\Cidr');

     */
    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform)
    {
        return $platform->getDoctrineTypeMapping($this->getName());
    }
}

class DateTime extends DateTimeType
{
    protected static $format = 'Y-m-d H:i:s.u';

    public function convertToDatabaseValue ($value, AbstractPlatform $platform)
    {
        if ($value === null) {
            return null;
        } elseif ($value instanceof \DateTime) {
            return $value->format(self::$format);

<?php
namespace FLE\Bundle\PostgresqlTypeBundle\Doctrine\DBAL\Types;

use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\ConversionException;
use Doctrine\DBAL\Types\Type;

class DateInterval extends Type
{
    const INTERVAL = 'interval';

    public function getSQLDeclaration (array $fieldDeclaration, AbstractPlatform $platform)
    {
        return $platform->getDoctrineTypeMapping('text[]');
    }

    private function array_to_pg_array(array $array)
    {
        $convertArray = [];
        foreach ($array as $key => $value) {
            if (is_array($value)) {
                throw new \Exception('multidimentional array!');