<?php namespace Doctrine\DBAL\Tests\Types; use DateTime; use DateTimeImmutable; use Doctrine\DBAL\ParameterType; use Doctrine\DBAL\Platforms\AbstractPlatform; use Doctrine\DBAL\Types\ConversionException; use Doctrine\DBAL\Types\DateTimeImmutableType; use Doctrine\DBAL\Types\Type; use PHPUnit\Framework\MockObject\MockObject; use PHPUnit\Framework\TestCase; use function get_class; class DateTimeImmutableTypeTest extends TestCase { /** @var AbstractPlatform|MockObject */ private $platform; /** @var DateTimeImmutableType */ private $type; protected function setUp(): void { $this->type = Type::getType('datetime_immutable'); $this->platform = $this->getMockBuilder(AbstractPlatform::class)->getMock(); } public function testFactoryCreatesCorrectType(): void { self::assertSame(DateTimeImmutableType::class, get_class($this->type)); } public function testReturnsName(): void { self::assertSame('datetime_immutable', $this->type->getName()); } public function testReturnsBindingType(): void { self::assertSame(ParameterType::STRING, $this->type->getBindingType()); } public function testConvertsDateTimeImmutableInstanceToDatabaseValue(): void { $date = $this->getMockBuilder(DateTimeImmutable::class)->getMock(); $this->platform->expects(self::once()) ->method('getDateTimeFormatString') ->willReturn('Y-m-d H:i:s'); $date->expects(self::once()) ->method('format') ->with('Y-m-d H:i:s') ->willReturn('2016-01-01 15:58:59'); self::assertSame( '2016-01-01 15:58:59', $this->type->convertToDatabaseValue($date, $this->platform) ); } public function testConvertsNullToDatabaseValue(): void { self::assertNull($this->type->convertToDatabaseValue(null, $this->platform)); } public function testDoesNotSupportMutableDateTimeToDatabaseValueConversion(): void { $this->expectException(ConversionException::class); $this->type->convertToDatabaseValue(new DateTime(), $this->platform); } public function testConvertsDateTimeImmutableInstanceToPHPValue(): void { $date = new DateTimeImmutable(); self::assertSame($date, $this->type->convertToPHPValue($date, $this->platform)); } public function testConvertsNullToPHPValue(): void { self::assertNull($this->type->convertToPHPValue(null, $this->platform)); } public function testConvertsDateTimeStringToPHPValue(): void { $this->platform->expects(self::once()) ->method('getDateTimeFormatString') ->willReturn('Y-m-d H:i:s'); $date = $this->type->convertToPHPValue('2016-01-01 15:58:59', $this->platform); self::assertInstanceOf(DateTimeImmutable::class, $date); self::assertSame('2016-01-01 15:58:59', $date->format('Y-m-d H:i:s')); } public function testConvertsDateTimeStringWithMicrosecondsToPHPValue(): void { $this->platform->expects(self::any()) ->method('getDateTimeFormatString') ->willReturn('Y-m-d H:i:s'); $date = $this->type->convertToPHPValue('2016-01-01 15:58:59.123456', $this->platform); self::assertSame('2016-01-01 15:58:59', $date->format('Y-m-d H:i:s')); } public function testThrowsExceptionDuringConversionToPHPValueWithInvalidDateTimeString(): void { $this->platform->expects(self::atLeastOnce()) ->method('getDateTimeFormatString') ->willReturn('Y-m-d H:i:s'); $this->expectException(ConversionException::class); $this->type->convertToPHPValue('invalid datetime string', $this->platform); } public function testRequiresSQLCommentHint(): void { self::assertTrue($this->type->requiresSQLCommentHint($this->platform)); } }