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
91
92
93
94
95
|
<?php
namespace Civi\Test\Api4\Action;
use Civi\Api4\Contact;
use Civi\Api4\CustomField;
use Civi\Api4\CustomGroup;
use Civi\Test\Api4\Traits\QueryCounterTrait;
/**
* @group headless
*/
class CustomValuePerformanceTest extends BaseCustomValueTest {
use QueryCounterTrait;
public function testQueryCount() {
$this->markTestIncomplete();
$customGroupId = CustomGroup::create()
->setCheckPermissions(FALSE)
->addValue('name', 'MyContactFields')
->addValue('title', 'MyContactFields')
->addValue('extends', 'Contact')
->execute()
->first()['id'];
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavColor')
->addValue('custom_group_id', $customGroupId)
->addValue('options', ['r' => 'Red', 'g' => 'Green', 'b' => 'Blue'])
->addValue('html_type', 'Select')
->addValue('data_type', 'String')
->execute();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavAnimal')
->addValue('custom_group_id', $customGroupId)
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavLetter')
->addValue('custom_group_id', $customGroupId)
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavFood')
->addValue('custom_group_id', $customGroupId)
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
$this->beginQueryCount();
Contact::create()
->setCheckPermissions(FALSE)
->addValue('first_name', 'Red')
->addValue('last_name', 'Tester')
->addValue('contact_type', 'Individual')
->addValue('MyContactFields.FavColor', 'r')
->addValue('MyContactFields.FavAnimal', 'Sheep')
->addValue('MyContactFields.FavLetter', 'z')
->addValue('MyContactFields.FavFood', 'Coconuts')
->execute();
Contact::get()
->setCheckPermissions(FALSE)
->addSelect('display_name')
->addSelect('MyContactFields.FavColor.label')
->addSelect('MyContactFields.FavColor.weight')
->addSelect('MyContactFields.FavColor.is_default')
->addSelect('MyContactFields.FavAnimal')
->addSelect('MyContactFields.FavLetter')
->addWhere('MyContactFields.FavColor', '=', 'r')
->addWhere('MyContactFields.FavFood', '=', 'Coconuts')
->addWhere('MyContactFields.FavAnimal', '=', 'Sheep')
->addWhere('MyContactFields.FavLetter', '=', 'z')
->execute()
->first();
// FIXME: This count is artificially high due to the line
// $this->entity = Tables::getBriefName(Tables::getClassForTable($targetTable));
// In class Joinable. TODO: Investigate why.
}
}
|
