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;
use Doctrine\DBAL\Cache\QueryCacheProfile;
use Doctrine\Tests\Models\Cms\CmsUser;
use Doctrine\Tests\OrmFunctionalTestCase;
use PHPUnit\Framework\Attributes\Group;
use Symfony\Component\Cache\Adapter\ArrayAdapter;
#[Group('DDC-1766')]
class HydrationCacheTest extends OrmFunctionalTestCase
{
protected function setUp(): void
{
$this->useModelSet('cms');
parent::setUp();
$user = new CmsUser();
$user->name = 'Benjamin';
$user->username = 'beberlei';
$user->status = 'active';
$this->_em->persist($user);
$this->_em->flush();
$this->_em->clear();
}
public function testHydrationCache(): void
{
$cache = new ArrayAdapter();
$dql = 'SELECT u FROM Doctrine\Tests\Models\Cms\CmsUser u';
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, null, $cache))
->getResult();
$this->getQueryLog()->reset()->enable();
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, null, $cache))
->getResult();
$this->assertQueryCount(0, 'Should not execute query. Its cached!');
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, null, $cache))
->getArrayResult();
$this->assertQueryCount(1, 'Hydration is part of cache key.');
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, null, $cache))
->getArrayResult();
$this->assertQueryCount(1, 'Hydration now cached');
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, 'cachekey', $cache))
->getArrayResult();
self::assertTrue($cache->hasItem('cachekey'), 'Explicit cache key');
$this->_em->createQuery($dql)
->setHydrationCacheProfile(new QueryCacheProfile(0, 'cachekey', $cache))
->getArrayResult();
$this->assertQueryCount(2, 'Hydration now cached');
}
public function testHydrationParametersSerialization(): void
{
$cache = new ArrayAdapter();
$dql = 'SELECT u FROM Doctrine\Tests\Models\Cms\CmsUser u WHERE u.id = ?1';
$query = $this->_em->createQuery($dql)
->setParameter(1, 1)
->setHydrationCacheProfile(new QueryCacheProfile(0, null, $cache));
$query->getResult();
$this->getQueryLog()->reset()->enable();
$query->getResult();
$this->assertQueryCount(0, 'Should not execute query. Its cached!');
}
}
|
