riccardonar/doctrine-intrange

Supports postgres intrange in Doctrine DBAL.

Doctrine IntRange Type

Thanks to @Salamek, this is an adapt to https://github.com/Salamek/doctrine-daterange, _(*1)

Supports PostgreSQL DateRange in Doctrine DBAL., _(*2)

Summary

The IntRange library, _(*3)

• adds a intrange type to DBAL

Installation

Add it to your list of Composer dependencies:, _(*4)

composer require riccardonar/doctrine-intrange

Register it with Doctrine DBAL:, _(*5)

<?php

use Doctrine\DBAL\Types\Type;
use riccardonar\Doctrine\DBAL\Types\IntRangeType;

Type::addType(
    IntRangeType::INTRANGE,
    'riccardonar\\Doctrine\\DBAL\\Types\\IntRangeType'
);

When using Symfony2 with Doctrine you can do the same as above by only changing your configuration:, _(*6)

# app/config/config.yml

# Doctrine Configuration
doctrine:
    dbal:
        # ...
        mapping_types:
            intrange: intrange
        types:
            intrange:  riccardonar\Doctrine\DBAL\Types\IntRangeType

Usage

<?php

/**
 * @Entity()
 * @Table(name="jobs")
 */
class Job
{
    /**
     * @Column(type="integer")
     * @GeneratedValue(strategy="AUTO")
     * @Id()
     */
    private $id;

    /**
     * @Column(type="intrange")
     */
    private $range;

    /**
     * @return \riccardonar\IntRange
     */
    public function getRange()
    {
        return $this->range;
    }

    /**
     * @param \riccardonar\IntRange $range
     */
    public function setRange(array $range)
    {
        $this->range = $range;
    }
}

$annualJob = new Job();
$annualJob->setRange(new \riccardonar\IntRange(1, 6));

$entityManager->persist($annualJob);
$entityManager->flush();
$entityManager->clear();

$jobs = $entityManager->createQuery(
    "SELECT j FROM Jobs j"
)->getResult();

echo $jobs[0]->getRange()->getStartInt(); // 1
echo $jobs[0]->getRange()->getEndInt(); //  6