Custom Doctrine DBAL type 'tinyint' for Symfony

Tinyint.php

<?php

namespace AppBundle\Doctrine\DBAL\Types;

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

class Tinyint extends Type
{
    const TINYINT = 'tinyint';

    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform)
    {
        $fieldDeclaration = array_merge([
            'length' => 1,
        ], $fieldDeclaration);

        return sprintf("TINYINT(%d)",
                $fieldDeclaration['length']
            );
    }

    public function convertToPHPValue($value, AbstractPlatform $platform)
    {
        return (int) $value;
    }

    public function convertToDatabaseValue($value, AbstractPlatform $platform)
    {
        return (int) $value;
    }

    public function getName()
    {
        return self::TINYINT;
    }

    public function getBindingType()
    {
        return \PDO::PARAM_INT;
    }
}

config.yml for Symfony (2.3):

    doctrine:
        dbal:
            types:
                tinyint:
                    class: AppBundle\Doctrine\DBAL\Types\Tinyint
                    commented: true

Entity declaration:

    /**
     * @var integer
     *
     * @ORM\Column(name="status", type="tinyint", options={"default" = 0}, length=1)
     * @Assert\NotBlank()
     */
    private $status;

@elenakondrateva It generates always the same migration in Symfony 5. Did you get also this issue?

If someone else runs into issue, make sure that you add your custom type to the mapping_types see following thread on stackoverflow: https://stackoverflow.com/questions/33260367/doctrine-doctrineschemaupdate-command-produces-the-same-set-of-queries-again-a

Which one is right for you?

public function getBindingType()
{
    return ParameterType::INTEGER;
}

OR

public function getBindingType()
{
    return \PDO::PARAM_INT;
}

@muratcakmaksoftware probably using Doctrine\DBAL\ParameterType would be better option here.
I'm sorry I haven't been working with Symfony or Doctrine for ages now.