Int4Range.php

<?php

namespace Types;

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

class Int4Range extends Type
{
    const INT_4_RANGE = "int4range";

    public function getSQLDeclaration(array $column, AbstractPlatform $platform): string
    {
        return "int4range";
    }

    public function canRequireSQLConversion(): bool
    {
        return true;
    }

    public function convertToPHPValue($value, AbstractPlatform $platform)
    {

        $separatorPosition = strpos($value, ",");
        $min = (int)substr($value, 1, $separatorPosition);
        $isMinIncluded = "[" == substr($value, 0, 1 );
        $max = (int)substr($value, $separatorPosition+1,-1);
        $isMaxIncluded = "]" == substr($value, -1);
        return [
            $isMinIncluded ? $min : $min + 1,
            $isMaxIncluded ? $max : $max - 1,
        ];

    }

    public function getName(): string
    {
        return self::INT_4_RANGE;
    }
}