Via Composer:
$ composer require nepada/birth-number-doctrineRegister the type in your bootstrap:
\Doctrine\DBAL\Types\Type::addType(
\Nepada\BirthNumberDoctrine\BirthNumberType::NAME,
\Nepada\BirthNumberDoctrine\BirthNumberType::class
);In Nette with nettrine/dbal integration, you can register the types in your configuration:
dbal:
connection:
types:
Nepada\BirthNumber\BirthNumber: Nepada\BirthNumberDoctrine\BirthNumberTypeBirthNumberType maps database value to Birth number value object (see nepada/birth-number for further details) and back. The Birth number is stored as fixed string without the slash (e.g. 0001010009).
Example usage in the entity:
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Entity;
use Nepada\BirthNumber\BirthNumber;
#[Entity]
class Person
{
#[Column(type: BirthNumber::class, nullable: false)]
private BirthNumber $birthNumber;
public function getBirthNumber(): BirthNumber
{
return $this->birthNumber;
}
}Example usage in query builder:
$result = $repository->createQueryBuilder('foo')
->select('foo')
->where('foo.birthNumber = :birthNumber')
// the parameter value is automatically normalized to '0001010009'
->setParameter('birthNumber', '000101 / 0009', BirthNumberType::NAME)
->getQuery()
->getResult();
