1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\Ticket;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\Type;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\Tests\OrmTestCase;
use function method_exists;
use function sprintf;
/** @group GH8061 */
final class GH8061Test extends OrmTestCase
{
public static function setUpBeforeClass(): void
{
Type::addType('GH8061Type', GH8061Type::class);
}
public function testConvertToPHPValueSQLForNewObjectExpression(): void
{
$dql = 'SELECT NEW ' . GH8061Class::class . '(e.field) FROM ' . GH8061Entity::class . ' e';
$entityManager = $this->getTestEntityManager();
$query = $entityManager->createQuery($dql);
self::assertMatchesRegularExpression('/SELECT DatabaseFunction\(\w+\.field\) AS /', $query->getSQL());
}
}
/** @Entity */
final class GH8061Entity
{
/**
* @var int
* @Id
* @Column(type="integer")
* @GeneratedValue
*/
public $id;
/**
* @var mixed
* @Column(type="GH8061Type", length=255)
*/
public $field;
}
final class GH8061Type extends Type
{
public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform): string
{
if (method_exists($platform, 'getStringTypeDeclarationSQL')) {
return $platform->getStringTypeDeclarationSQL($fieldDeclaration);
}
return $platform->getVarcharTypeDeclarationSQL($fieldDeclaration);
}
public function getName(): string
{
return 'GH8061';
}
public function canRequireSQLConversion(): bool
{
return true;
}
public function convertToPHPValueSQL($sqlExpr, $platform): string
{
return sprintf('DatabaseFunction(%s)', $sqlExpr);
}
}
final class GH8061Class
{
/** @var string */
public $field;
public function __construct(string $field)
{
$this->field = $field;
}
}
|
