class PostgresqlDateSqlTest
Same name and namespace in other branches
- 11.x core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest
- 10 core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest
- 8.9.x core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest
Tests the PostgreSQL-specific date query handler.
@coversDefaultClass \Drupal\views\Plugin\views\query\PostgresqlDateSql
@group views
Hierarchy
- class \Drupal\Tests\UnitTestCase uses \Drupal\Tests\Traits\PhpUnitWarnings, \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait extends \PHPUnit\Framework\TestCase
- class \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest extends \Drupal\Tests\UnitTestCase
Expanded class hierarchy of PostgresqlDateSqlTest
File
-
core/
modules/ views/ tests/ src/ Unit/ Plugin/ views/ query/ PostgresqlDateSqlTest.php, line 16
Namespace
Drupal\Tests\views\Unit\Plugin\views\queryView source
class PostgresqlDateSqlTest extends UnitTestCase {
/**
* The mocked database service.
*
* @var \Drupal\Core\Database\Connection
*/
protected $database;
/**
* {@inheritdoc}
*/
public function setUp() : void {
parent::setUp();
$this->database = $this->prophesize(Connection::class)
->reveal();
}
/**
* Tests the getDateField method.
*
* @covers ::getDateField
*/
public function testGetDateField() {
$date_sql = new PostgresqlDateSql($this->database);
$expected = "TO_TIMESTAMP(foo.field, 'YYYY-MM-DD\"T\"HH24:MI:SS')";
$this->assertEquals($expected, $date_sql->getDateField('foo.field', TRUE));
$expected = 'TO_TIMESTAMP(foo.field)';
$this->assertEquals($expected, $date_sql->getDateField('foo.field', FALSE));
}
/**
* Tests date formatting replacement.
*
* @covers ::getDateFormat
*
* @dataProvider providerTestGetDateFormat
*/
public function testGetDateFormat($field, $format, $expected_format) {
$date_sql = new PostgresqlDateSql($this->database);
$this->assertEquals("TO_CHAR({$field}, '{$expected_format}')", $date_sql->getDateFormat($field, $format));
}
/**
* Provider for date formatting test.
*/
public function providerTestGetDateFormat() {
return [
[
'foo.field',
'Y-y-M-m',
'YYYY-YY-Mon-MM',
],
[
'bar.field',
'n-F D d l',
'MM-Month Dy DD Day',
],
[
'baz.bar_field',
'j/W/H-h i s A',
'DD/IW/HH24-HH12 MI SS AM',
],
];
}
/**
* Tests timezone offset formatting.
*
* @covers ::setFieldTimezoneOffset
*/
public function testSetFieldTimezoneOffset() {
$date_sql = new PostgresqlDateSql($this->database);
$field = 'foobar.field';
$date_sql->setFieldTimezoneOffset($field, 42);
$this->assertEquals("(foobar.field + INTERVAL '42 SECONDS')", $field);
}
/**
* Tests setting the database offset.
*
* @covers ::setTimezoneOffset
*/
public function testSetTimezoneOffset() {
$database = $this->prophesize(Connection::class);
$database->query("SET TIME ZONE INTERVAL '42' HOUR TO MINUTE")
->shouldBeCalledTimes(1);
$date_sql = new PostgresqlDateSql($database->reveal());
$date_sql->setTimezoneOffset(42);
}
}
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.