View source
<?php
namespace Drupal\KernelTests\Core\Entity;
use Drupal\Core\Database\Database;
use Drupal\entity_test\Entity\EntityTest;
use Drupal\entity_test\Entity\EntityTestMulRev;
use Drupal\field\Entity\FieldConfig;
use Drupal\field\Entity\FieldStorageConfig;
use Drupal\language\Entity\ConfigurableLanguage;
use Drupal\taxonomy\Entity\Term;
use Drupal\taxonomy\Entity\Vocabulary;
use Drupal\Tests\field\Traits\EntityReferenceTestTrait;
use Symfony\Component\HttpFoundation\Request;
class EntityQueryTest extends EntityKernelTestBase {
use EntityReferenceTestTrait;
public static $modules = [
'field_test',
'language',
];
protected $queryResults;
protected $bundles;
public $greetings;
public $figures;
protected $storage;
protected function setUp() {
parent::setUp();
$this
->installEntitySchema('entity_test_mulrev');
$this
->installConfig([
'language',
]);
$figures = mb_strtolower($this
->randomMachineName());
$greetings = mb_strtolower($this
->randomMachineName());
foreach ([
$figures => 'shape',
$greetings => 'text',
] as $field_name => $field_type) {
$field_storage = FieldStorageConfig::create([
'field_name' => $field_name,
'entity_type' => 'entity_test_mulrev',
'type' => $field_type,
'cardinality' => 2,
]);
$field_storage
->save();
$field_storages[] = $field_storage;
}
$bundles = [];
for ($i = 0; $i < 2; $i++) {
do {
$bundle = $this
->randomMachineName();
} while ($bundles && strtolower($bundles[0]) >= strtolower($bundle));
entity_test_create_bundle($bundle);
foreach ($field_storages as $field_storage) {
FieldConfig::create([
'field_storage' => $field_storage,
'bundle' => $bundle,
])
->save();
}
$bundles[] = $bundle;
}
$units[] = [
$figures,
'en',
[
'color' => 'red',
'shape' => 'triangle',
],
];
$units[] = [
$figures,
'en',
[
'color' => 'blue',
'shape' => 'circle',
],
];
$units[] = [
$greetings,
'tr',
[
'value' => 'merhaba',
'format' => 'format-tr',
],
];
$units[] = [
$greetings,
'pl',
[
'value' => 'siema',
'format' => 'format-pl',
],
];
ConfigurableLanguage::createFromLangcode('tr')
->save();
ConfigurableLanguage::createFromLangcode('pl')
->save();
for ($i = 1; $i <= 15; $i++) {
$entity = EntityTestMulRev::create([
'type' => $bundles[$i & 1],
'name' => $this
->randomMachineName(),
'langcode' => 'en',
]);
foreach ([
'tr',
'pl',
] as $langcode) {
$entity
->addTranslation($langcode)->name = $this
->randomMachineName();
}
foreach (array_reverse(str_split(decbin($i))) as $key => $bit) {
if ($bit) {
$entity
->getTranslation($units[$key][1])->{$units[$key][0]}[] = $units[$key][2];
}
}
$entity
->save();
}
$this->bundles = $bundles;
$this->figures = $figures;
$this->greetings = $greetings;
$this->storage = $this->container
->get('entity_type.manager')
->getStorage('entity_test_mulrev');
}
public function testEntityQuery() {
$greetings = $this->greetings;
$figures = $this->figures;
$this->queryResults = $this->storage
->getQuery()
->exists($greetings, 'tr')
->condition("{$figures}.color", 'red')
->sort('id')
->execute();
$this
->assertResult(5, 7, 13, 15);
$query = $this->storage
->getQuery('OR')
->exists($greetings, 'tr')
->condition("{$figures}.color", 'red')
->sort('id');
$count_query = clone $query;
$this
->assertEqual(12, $count_query
->count()
->execute());
$this->queryResults = $query
->execute();
$this
->assertResult(1, 3, 4, 5, 6, 7, 9, 11, 12, 13, 14, 15);
$query = $this->storage
->getQuery()
->condition("{$figures}.color", 'red')
->sort('id');
$cloned_query = clone $query;
$cloned_query
->condition("{$figures}.shape", 'circle');
$this->queryResults = $query
->execute();
$this
->assertResult(1, 3, 5, 7, 9, 11, 13, 15);
$this->queryResults = $cloned_query
->execute();
$this
->assertResult();
$query = $this->storage
->getQuery();
$group = $query
->orConditionGroup()
->exists($greetings, 'tr')
->condition("{$figures}.color", 'red');
$this->queryResults = $query
->condition($group)
->condition("{$greetings}.value", 'sie', 'STARTS_WITH')
->sort('revision_id')
->execute();
$this
->assertResult(9, 11, 12, 13, 14, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.color", 'blue')
->condition("{$figures}.color", 'red')
->sort('id')
->execute();
$this
->assertResult();
$query = $this->storage
->getQuery();
$group_blue = $query
->andConditionGroup()
->condition("{$figures}.color", 'blue');
$group_red = $query
->andConditionGroup()
->condition("{$figures}.color", 'red');
$this->queryResults = $query
->condition($group_blue)
->condition($group_red)
->sort('revision_id')
->execute();
$this
->assertResult(3, 7, 11, 15);
$query = $this->storage
->getQuery();
$group_blue = $query
->andConditionGroup()
->condition("{$figures}.color", [
'blue',
], 'IN');
$group_red = $query
->andConditionGroup()
->condition("{$figures}.color", [
'red',
], 'IN');
$this->queryResults = $query
->condition($group_blue)
->condition($group_red)
->sort('id')
->execute();
$this
->assertResult(3, 7, 11, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.color", [
'blue',
'red',
], 'IN')
->sort('id')
->execute();
$this
->assertResult(1, 2, 3, 5, 6, 7, 9, 10, 11, 13, 14, 15);
$this->queryResults = $this->storage
->getQuery()
->exists("{$figures}.color")
->notExists("{$greetings}.value")
->sort('id')
->execute();
$this
->assertResult(1, 2, 3);
$ids = $this->storage
->getQuery()
->condition("{$greetings}.value", 'merhaba')
->sort('id')
->execute();
$entities = EntityTestMulRev::loadMultiple($ids);
$first_entity = reset($entities);
$old_name = $first_entity->name->value;
foreach ($entities as $entity) {
$entity
->setNewRevision();
$entity
->getTranslation('tr')->{$greetings}->value = 'xsiemax';
$entity->name->value .= 'x';
$entity
->save();
}
$this->queryResults = $this->storage
->getQuery()
->condition('revision_id', $first_entity
->getRevisionId())
->allRevisions()
->execute();
$this
->assertCount(1, $this->queryResults);
$this
->assertEquals($first_entity
->getRevisionId(), key($this->queryResults));
$this->queryResults = $this->storage
->getQuery()
->condition('name.value', $old_name)
->execute();
$this
->assertResult();
$this->queryResults = $this->storage
->getQuery()
->condition('name.value', $old_name)
->allRevisions()
->sort('revision_id')
->execute();
$this
->assertRevisionResult([
$first_entity
->id(),
], [
$first_entity
->id(),
]);
$this->queryResults = $this->storage
->getQuery()
->condition("{$greetings}.value", 'merhaba')
->execute();
$this
->assertResult();
$this->queryResults = $this->storage
->getQuery()
->condition("{$greetings}.value", 'merhaba')
->allRevisions()
->sort('revision_id')
->execute();
$this
->assertRevisionResult([
4,
5,
6,
7,
12,
13,
14,
15,
], [
4,
5,
6,
7,
12,
13,
14,
15,
]);
$results = $this->storage
->getQuery()
->condition("{$greetings}.value", 'siema', 'CONTAINS')
->sort('id')
->execute();
$assert = [
16 => '4',
17 => '5',
18 => '6',
19 => '7',
8 => '8',
9 => '9',
10 => '10',
11 => '11',
20 => '12',
21 => '13',
22 => '14',
23 => '15',
];
$this
->assertIdentical($results, $assert);
$results = $this->storage
->getQuery()
->condition("{$greetings}.value", 'siema', 'STARTS_WITH')
->sort('revision_id')
->execute();
$this
->assertIdentical($results, array_slice($assert, 4, 8, TRUE));
$results = $this->storage
->getQuery()
->condition("{$greetings}.value", 'a', 'ENDS_WITH')
->sort('revision_id')
->execute();
$this
->assertIdentical($results, array_slice($assert, 4, 8, TRUE));
$results = $this->storage
->getQuery()
->condition("{$greetings}.value", 'a', 'ENDS_WITH')
->allRevisions()
->sort('id')
->sort('revision_id')
->execute();
$assert = [
4 => '4',
5 => '5',
6 => '6',
7 => '7',
8 => '8',
9 => '9',
10 => '10',
11 => '11',
12 => '12',
20 => '12',
13 => '13',
21 => '13',
14 => '14',
22 => '14',
15 => '15',
23 => '15',
];
$this
->assertIdentical($results, $assert);
$results = $this->storage
->getQuery()
->latestRevision()
->sort('id')
->sort('revision_id')
->execute();
$expected = [
1 => '1',
2 => '2',
3 => '3',
16 => '4',
17 => '5',
18 => '6',
19 => '7',
8 => '8',
9 => '9',
10 => '10',
11 => '11',
20 => '12',
21 => '13',
22 => '14',
23 => '15',
];
$this
->assertSame($expected, $results);
}
public function testSort() {
$greetings = $this->greetings;
$figures = $this->figures;
$this->queryResults = $this->storage
->getQuery()
->sort('id')
->execute();
$this
->assertResult(range(1, 15));
$this->queryResults = $this->storage
->getQuery()
->sort('id', 'DESC')
->execute();
$this
->assertResult(range(15, 1));
$query = $this->storage
->getQuery()
->sort("{$figures}.color")
->sort("{$greetings}.format")
->sort('id');
$count_query = clone $query;
$this
->assertEqual(15, $count_query
->count()
->execute());
$this->queryResults = $query
->execute();
$this
->assertResult(8, 12, 4, 2, 3, 10, 11, 14, 15, 6, 7, 1, 9, 13, 5);
$request = Request::createFromGlobals();
$request->query
->replace([
'page' => '0,2',
]);
\Drupal::getContainer()
->get('request_stack')
->push($request);
$this->queryResults = $this->storage
->getQuery()
->sort("{$figures}.color")
->sort("{$greetings}.format")
->sort('id')
->pager(4, 1)
->execute();
$this
->assertResult(15, 6, 7, 1);
$query = $this->storage
->getQuery()
->sort("{$figures}.color", 'DESC')
->sort("{$greetings}.format", 'DESC')
->sort('id', 'DESC');
$count_query = clone $query;
$this
->assertEqual(15, $count_query
->count()
->execute());
$this->queryResults = $query
->execute();
$this
->assertResult(15, 13, 7, 5, 11, 9, 3, 1, 14, 6, 10, 2, 12, 4, 8);
}
public function testTableSort() {
$request = Request::createFromGlobals();
$request->query
->replace([
'sort' => 'asc',
'order' => 'Type',
]);
\Drupal::getContainer()
->get('request_stack')
->push($request);
$header = [
'id' => [
'data' => 'Id',
'specifier' => 'id',
],
'type' => [
'data' => 'Type',
'specifier' => 'type',
],
];
$this->queryResults = array_values($this->storage
->getQuery()
->tableSort($header)
->execute());
$this
->assertBundleOrder('asc');
$request->query
->add([
'sort' => 'desc',
]);
\Drupal::getContainer()
->get('request_stack')
->push($request);
$header = [
'id' => [
'data' => 'Id',
'specifier' => 'id',
],
'type' => [
'data' => 'Type',
'specifier' => 'type',
],
];
$this->queryResults = array_values($this->storage
->getQuery()
->tableSort($header)
->execute());
$this
->assertBundleOrder('desc');
$request->query
->add([
'order' => 'Id',
]);
\Drupal::getContainer()
->get('request_stack')
->push($request);
$this->queryResults = $this->storage
->getQuery()
->tableSort($header)
->execute();
$this
->assertResult(range(15, 1));
}
public function testCount() {
$field_name = $this->figures;
$field_storage = FieldStorageConfig::create([
'field_name' => $field_name,
'entity_type' => 'entity_test',
'type' => 'shape',
'cardinality' => 2,
'translatable' => TRUE,
]);
$field_storage
->save();
$bundle = $this
->randomMachineName();
FieldConfig::create([
'field_storage' => $field_storage,
'bundle' => $bundle,
])
->save();
$entity = EntityTest::create([
'id' => 1,
'type' => $bundle,
]);
$entity
->enforceIsNew();
$entity
->save();
$count = $this->container
->get('entity_type.manager')
->getStorage('entity_test')
->getQuery()
->exists("{$field_name}.color")
->count()
->execute();
$this
->assertEquals(0, $count);
}
public function testNestedConditionGroups() {
$query = $this->storage
->getQuery();
$first_and = $query
->andConditionGroup()
->condition($this->figures . '.color', 'red')
->condition($this->figures . '.shape', 'triangle');
$second_and = $query
->andConditionGroup()
->condition($this->greetings . '.value', 'merhaba')
->condition($this->greetings . '.format', 'format-tr');
$or = $query
->orConditionGroup()
->condition($first_and)
->condition($second_and);
$this->queryResults = $query
->condition($or)
->condition('type', reset($this->bundles))
->sort('id')
->execute();
$this
->assertResult(4, 6, 12, 14);
}
public function testConditionCount() {
$query = $this->storage
->getQuery();
$and_condition_group = $query
->andConditionGroup()
->condition($this->figures . '.color', 'red')
->condition($this->figures . '.shape', 'triangle');
$this
->assertEqual($and_condition_group
->count(), 2);
$or_condition_group = $query
->orConditionGroup()
->condition($this->figures . '.color', 'red')
->condition($this->figures . '.shape', 'triangle');
$this
->assertEqual($or_condition_group
->count(), 2);
}
public function testDelta() {
$figures = $this->figures;
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.0.color", 'red')
->sort('id')
->execute();
$this
->assertResult(1, 3, 5, 7, 9, 11, 13, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.1.color", 'red')
->sort('id')
->execute();
$this
->assertResult();
$query = $this->storage
->getQuery();
$or = $query
->andConditionGroup()
->condition("{$figures}.0.color", 'red')
->condition("{$figures}.1.color", 'blue');
$this->queryResults = $query
->condition($or)
->sort('id')
->execute();
$this
->assertResult(3, 7, 11, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.%delta.color", [
'blue',
'red',
], 'IN')
->condition("{$figures}.%delta", [
0,
1,
], 'IN')
->sort('id')
->execute();
$this
->assertResult(1, 2, 3, 5, 6, 7, 9, 10, 11, 13, 14, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("{$figures}.%delta", 1)
->sort('id')
->execute();
$this
->assertResult(3, 7, 11, 15);
$this->queryResults = $this->storage
->getQuery()
->condition("id.0.value", [
1,
3,
5,
], 'IN')
->sort('id')
->execute();
$this
->assertResult(1, 3, 5);
$this->queryResults = $this->storage
->getQuery()
->condition("id.1.value", [
1,
3,
5,
], 'IN')
->sort('id')
->execute();
$this
->assertResult();
$this->queryResults = $this->storage
->getQuery()
->condition("id.%delta.value", [
1,
3,
5,
], 'IN')
->sort('id')
->execute();
$this
->assertResult(1, 3, 5);
$this->queryResults = $this->storage
->getQuery()
->condition("id.%delta.value", [
1,
3,
5,
], 'IN')
->condition("id.%delta", 0, '=')
->sort('id')
->execute();
$this
->assertResult(1, 3, 5);
$this->queryResults = $this->storage
->getQuery()
->condition("id.%delta.value", [
1,
3,
5,
], 'IN')
->condition("id.%delta", 1, '=')
->sort('id')
->execute();
$this
->assertResult();
}
protected function assertResult() {
$assert = [];
$expected = func_get_args();
if ($expected && is_array($expected[0])) {
$expected = $expected[0];
}
foreach ($expected as $binary) {
$assert[$binary] = strval($binary);
}
$this
->assertIdentical($this->queryResults, $assert);
}
protected function assertRevisionResult($keys, $expected) {
$assert = [];
foreach ($expected as $key => $binary) {
$assert[$keys[$key]] = strval($binary);
}
$this
->assertIdentical($this->queryResults, $assert);
return $assert;
}
protected function assertBundleOrder($order) {
for ($i = 1; $i <= 15; $i += 2) {
$ok = TRUE;
$index1 = array_search($i, $this->queryResults);
$this
->assertNotIdentical($index1, FALSE, "{$i} found at {$index1}.");
for ($j = 2; $j <= 15; $j += 2) {
if ($ok) {
if ($order == 'asc') {
$ok = $index1 > array_search($j, $this->queryResults);
}
else {
$ok = $index1 < array_search($j, $this->queryResults);
}
}
}
$this
->assertTrue($ok, "{$i} is after all entities in bundle2");
}
}
public function testMetaData() {
$query = $this->storage
->getQuery();
$query
->addTag('efq_metadata_test')
->addMetaData('foo', 'bar')
->execute();
global $efq_test_metadata;
$this
->assertEqual($efq_test_metadata, 'bar', 'Tag and metadata propagated to the SQL query object.');
}
public function testCaseSensitivity() {
$bundle = $this
->randomMachineName();
$field_storage = FieldStorageConfig::create([
'field_name' => 'field_ci',
'entity_type' => 'entity_test_mulrev',
'type' => 'string',
'cardinality' => 1,
'translatable' => FALSE,
'settings' => [
'case_sensitive' => FALSE,
],
]);
$field_storage
->save();
FieldConfig::create([
'field_storage' => $field_storage,
'bundle' => $bundle,
])
->save();
$field_storage = FieldStorageConfig::create([
'field_name' => 'field_cs',
'entity_type' => 'entity_test_mulrev',
'type' => 'string',
'cardinality' => 1,
'translatable' => FALSE,
'settings' => [
'case_sensitive' => TRUE,
],
]);
$field_storage
->save();
FieldConfig::create([
'field_storage' => $field_storage,
'bundle' => $bundle,
])
->save();
$fixtures = [];
for ($i = 0; $i < 2; $i++) {
$string = $this
->randomMachineName(7) . 'a';
$fixtures[] = [
'original' => $string,
'uppercase' => mb_strtoupper($string),
'lowercase' => mb_strtolower($string),
];
}
EntityTestMulRev::create([
'type' => $bundle,
'name' => $this
->randomMachineName(),
'langcode' => 'en',
'field_ci' => $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
'field_cs' => $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
])
->save();
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'])
->execute();
$this
->assertCount(1, $result, 'Case insensitive, lowercase');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'])
->execute();
$this
->assertCount(1, $result, 'Case insensitive, uppercase');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'])
->execute();
$this
->assertCount(1, $result, 'Case insensitive, mixed.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[0]['lowercase'] . $fixtures[1]['lowercase'])
->execute();
$this
->assertCount(0, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[0]['uppercase'] . $fixtures[1]['uppercase'])
->execute();
$this
->assertCount(0, $result, 'Case sensitive, uppercase.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[0]['uppercase'] . $fixtures[1]['lowercase'])
->execute();
$this
->assertCount(1, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_ci', [
$fixtures[0]['lowercase'] . $fixtures[1]['lowercase'],
], 'IN')
->execute();
$this
->assertCount(1, $result, 'Case insensitive, lowercase');
$result = $this->storage
->getQuery()
->condition('field_ci', [
$fixtures[0]['uppercase'] . $fixtures[1]['uppercase'],
], 'IN')
->execute();
$this
->assertCount(1, $result, 'Case insensitive, uppercase');
$result = $this->storage
->getQuery()
->condition('field_ci', [
$fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
], 'IN')
->execute();
$this
->assertCount(1, $result, 'Case insensitive, mixed');
$result = $this->storage
->getQuery()
->condition('field_cs', [
$fixtures[0]['lowercase'] . $fixtures[1]['lowercase'],
], 'IN')
->execute();
$this
->assertCount(0, $result, 'Case sensitive, lowercase');
$result = $this->storage
->getQuery()
->condition('field_cs', [
$fixtures[0]['uppercase'] . $fixtures[1]['uppercase'],
], 'IN')
->execute();
$this
->assertCount(0, $result, 'Case sensitive, uppercase');
$result = $this->storage
->getQuery()
->condition('field_cs', [
$fixtures[0]['uppercase'] . $fixtures[1]['lowercase'],
], 'IN')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, mixed');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[0]['lowercase'], 'STARTS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[0]['uppercase'], 'STARTS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[0]['lowercase'], 'STARTS_WITH')
->execute();
$this
->assertCount(0, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[0]['uppercase'], 'STARTS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[1]['lowercase'], 'ENDS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_ci', $fixtures[1]['uppercase'], 'ENDS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[1]['lowercase'], 'ENDS_WITH')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_cs', $fixtures[1]['uppercase'], 'ENDS_WITH')
->execute();
$this
->assertCount(0, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_ci', mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8), 'CONTAINS')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_ci', mb_strtolower(mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8)), 'CONTAINS')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, exact match.');
$result = $this->storage
->getQuery()
->condition('field_cs', mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8), 'CONTAINS')
->execute();
$this
->assertCount(1, $result, 'Case sensitive, lowercase.');
$result = $this->storage
->getQuery()
->condition('field_cs', mb_strtolower(mb_substr($fixtures[0]['uppercase'] . $fixtures[1]['lowercase'], 4, 8)), 'CONTAINS')
->execute();
$this
->assertCount(0, $result, 'Case sensitive, exact match.');
}
public function testBaseFieldMultipleColumns() {
$this
->enableModules([
'taxonomy',
]);
$this
->installEntitySchema('taxonomy_term');
Vocabulary::create([
'vid' => 'tags',
]);
$term1 = Term::create([
'name' => $this
->randomMachineName(),
'vid' => 'tags',
'description' => [
'value' => $this
->randomString(),
'format' => 'format1',
],
]);
$term1
->save();
$term2 = Term::create([
'name' => $this
->randomMachineName(),
'vid' => 'tags',
'description' => [
'value' => $this
->randomString(),
'format' => 'format2',
],
]);
$term2
->save();
$ids = $this->container
->get('entity_type.manager')
->getStorage('taxonomy_term')
->getQuery()
->condition('description.format', 'format1')
->execute();
$this
->assertCount(1, $ids);
$this
->assertEqual($term1
->id(), reset($ids));
}
public function testPendingRevisions() {
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->execute();
$this
->assertCount(1, $result);
$entity = EntityTestMulRev::load(14);
$current_values = $entity->{$this->figures}
->getValue();
$entity
->setNewRevision(TRUE);
$entity
->isDefaultRevision(FALSE);
$entity->{$this->figures}
->setValue([
'color' => 'red',
'shape' => 'square',
]);
$entity
->save();
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->execute();
$this
->assertCount(1, $result);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->condition("{$this->figures}.color", $current_values[0]['color'])
->execute();
$this
->assertEqual($result, [
14 => '14',
]);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->condition("{$this->figures}.color", 'red')
->allRevisions()
->execute();
$this
->assertEqual($result, [
16 => '14',
]);
$entity
->setNewRevision(TRUE);
$entity
->isDefaultRevision(FALSE);
$entity->{$this->figures}
->setValue([
'color' => 'red',
'shape' => 'square',
]);
$entity
->save();
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->execute();
$this
->assertCount(1, $result);
$this
->assertSame([
14 => '14',
], $result);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->latestRevision()
->execute();
$this
->assertCount(1, $result);
$this
->assertSame([
17 => '14',
], $result);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->condition("{$this->figures}.color", $current_values[0]['color'])
->execute();
$this
->assertSame([
14 => '14',
], $result);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->condition("{$this->figures}.color", 'red')
->allRevisions()
->execute();
$this
->assertSame([
16 => '14',
17 => '14',
], $result);
$result = $this->storage
->getQuery()
->condition('id', [
14,
], 'IN')
->condition("{$this->figures}.color", 'red')
->latestRevision()
->execute();
$this
->assertSame([
17 => '14',
], $result);
}
public function testInjectionInCondition() {
$this
->expectException(\Exception::class);
$this->queryResults = $this->storage
->getQuery()
->condition('1 ; -- ', [
0,
1,
], 'IN')
->sort('id')
->execute();
}
public function testWithTwoEntityReferenceFieldsToSameEntityType() {
$this
->createEntityReferenceField('entity_test', 'entity_test', 'ref1', $this
->randomMachineName(), 'entity_test');
$this
->createEntityReferenceField('entity_test', 'entity_test', 'ref2', $this
->randomMachineName(), 'entity_test');
$storage = $this->container
->get('entity_type.manager')
->getStorage('entity_test');
$ref1 = EntityTest::create([
'type' => 'entity_test',
]);
$ref1
->save();
$ref2 = EntityTest::create([
'type' => 'entity_test',
]);
$ref2
->save();
$entity = EntityTest::create([
'type' => 'entity_test',
'ref1' => $ref1
->id(),
'ref2' => $ref2
->id(),
]);
$entity
->save();
$result = $storage
->getQuery()
->condition('type', 'entity_test')
->condition('ref1', $ref1
->id())
->condition('ref2', $ref2
->id())
->execute();
$this
->assertCount(1, $result);
$this
->assertEquals($entity
->id(), reset($result));
$result = $storage
->getQuery()
->condition('type', 'entity_test')
->condition('ref1.target_id', $ref1
->id())
->condition('ref2.target_id', $ref2
->id())
->execute();
$this
->assertCount(1, $result);
$this
->assertEquals($entity
->id(), reset($result));
$result = $storage
->getQuery()
->condition('type', 'entity_test')
->condition('ref1.entity.id', $ref1
->id())
->condition('ref2.entity.id', $ref2
->id())
->execute();
$this
->assertCount(1, $result);
$this
->assertEquals($entity
->id(), reset($result));
}
public function testConditionOnRevisionMetadataKeys() {
$this
->installModule('entity_test_revlog');
$this
->installEntitySchema('entity_test_revlog');
$entity_type_manager = $this->container
->get('entity_type.manager');
$entity_type = $entity_type_manager
->getDefinition('entity_test_revlog');
$storage = $entity_type_manager
->getStorage('entity_test_revlog');
$revision_created_timestamp = time();
$revision_created_field_name = $entity_type
->getRevisionMetadataKey('revision_created');
$entity = $storage
->create([
'type' => 'entity_test',
$revision_created_field_name => $revision_created_timestamp,
]);
$entity
->save();
$result = $storage
->getQuery()
->condition($revision_created_field_name, $revision_created_timestamp)
->execute();
$this
->assertCount(1, $result);
$this
->assertEquals($entity
->id(), reset($result));
$result = $storage
->getQuery()
->condition($revision_created_field_name, $revision_created_timestamp)
->allRevisions()
->execute();
$this
->assertCount(1, $result);
$this
->assertEquals($entity
->id(), reset($result));
}
public function testToString() {
$query = $this->storage
->getQuery();
$group_blue = $query
->andConditionGroup()
->condition("{$this->figures}.color", [
'blue',
], 'IN');
$group_red = $query
->andConditionGroup()
->condition("{$this->figures}.color", [
'red',
], 'IN');
$null_group = $query
->andConditionGroup()
->notExists("{$this->figures}.color");
$this->queryResults = $query
->condition($group_blue)
->condition($group_red)
->condition($null_group)
->sort('id');
$figures = $this->figures;
$connection = Database::getConnection();
$expected = $connection
->select("entity_test_mulrev", "base_table");
$expected
->addField("base_table", "revision_id", "revision_id");
$expected
->addField("base_table", "id", "id");
$expected
->join("entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}.entity_id = base_table.id");
$expected
->join("entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}_2", "entity_test_mulrev__{$figures}_2.entity_id = base_table.id");
$expected
->addJoin("LEFT", "entity_test_mulrev__{$figures}", "entity_test_mulrev__{$figures}_3", "entity_test_mulrev__{$figures}_3.entity_id = base_table.id");
$expected
->condition("entity_test_mulrev__{$figures}.{$figures}_color", [
"blue",
], "IN");
$expected
->condition("entity_test_mulrev__{$figures}_2.{$figures}_color", [
"red",
], "IN");
$expected
->isNull("entity_test_mulrev__{$figures}_3.{$figures}_color");
$expected
->orderBy("base_table.id");
$expected_string = \Drupal::database()
->prefixTables((string) $expected);
$quoted = [];
foreach ($expected
->getArguments() as $key => $value) {
$quoted[$key] = $connection
->quote($value);
}
$expected_string = strtr($expected_string, $quoted);
$this
->assertSame($expected_string, (string) $query);
}
}