ReservedWordTest.php in Drupal 9
File
core/tests/Drupal/KernelTests/Core/Database/ReservedWordTest.php
View source
<?php
namespace Drupal\KernelTests\Core\Database;
class ReservedWordTest extends DatabaseTestBase {
public function testSelectReservedWordTableCount() {
$query = $this->connection
->select('virtual');
$num_records = $query
->countQuery()
->execute()
->fetchField();
$this
->assertSame('1', $num_records);
}
public function testSelectReservedWordTableSpecificField() {
$query = $this->connection
->select('virtual');
$query
->addField('virtual', 'function');
$rows = $query
->execute()
->fetchCol();
$this
->assertSame('Function value 1', $rows[0]);
}
public function testSelectReservedWordTableAllFields() {
$query = $this->connection
->select('virtual');
$query
->fields('virtual');
$result = $query
->execute()
->fetchObject();
$this
->assertSame('Function value 1', $result->function);
}
public function testSelectReservedWordAliasCount() {
$query = $this->connection
->select('test', 'character');
$num_records = $query
->countQuery()
->execute()
->fetchField();
$this
->assertSame('4', $num_records);
}
public function testSelectReservedWordAliasSpecificFields() {
$query = $this->connection
->select('test', 'high_priority');
$query
->addField('high_priority', 'name');
$query
->addField('high_priority', 'age', 'age');
$query
->condition('age', 27);
$record = $query
->execute()
->fetchObject();
$this
->assertSame('George', $record->name);
$this
->assertSame('27', $record->age);
}
public function testSelectReservedWordAliasAllFields() {
$record = $this->connection
->select('test', 'signal')
->fields('signal')
->condition('age', 27)
->execute()
->fetchObject();
$this
->assertSame('George', $record->name);
$this
->assertSame('27', $record->age);
}
}