class PostgresqlDateSqlTest
Same name in other branches
- 8.9.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
- 11.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 extends \PHPUnit\Framework\TestCase uses \Drupal\Tests\Traits\PhpUnitWarnings, \Drupal\Tests\PhpUnitCompatibilityTrait, \Symfony\Bridge\PhpUnit\ExpectDeprecationTrait
- 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);
}
}
Members
Title Sort descending | Deprecated | Modifiers | Object type | Summary | Overriden Title | Overrides |
---|---|---|---|---|---|---|
PhpUnitWarnings::$deprecationWarnings | private static | property | Deprecation warnings from PHPUnit to raise with @trigger_error(). | |||
PhpUnitWarnings::addWarning | public | function | Converts PHPUnit deprecation warnings to E_USER_DEPRECATED. | |||
PostgresqlDateSqlTest::$database | protected | property | The mocked database service. | |||
PostgresqlDateSqlTest::providerTestGetDateFormat | public | function | Provider for date formatting test. | |||
PostgresqlDateSqlTest::setUp | public | function | Overrides UnitTestCase::setUp | |||
PostgresqlDateSqlTest::testGetDateField | public | function | Tests the getDateField method. | |||
PostgresqlDateSqlTest::testGetDateFormat | public | function | Tests date formatting replacement. | |||
PostgresqlDateSqlTest::testSetFieldTimezoneOffset | public | function | Tests timezone offset formatting. | |||
PostgresqlDateSqlTest::testSetTimezoneOffset | public | function | Tests setting the database offset. | |||
UnitTestCase::$randomGenerator | protected | property | The random generator. | |||
UnitTestCase::$root | protected | property | The app root. | 1 | ||
UnitTestCase::assertArrayEquals | Deprecated | protected | function | Asserts if two arrays are equal by sorting them first. | ||
UnitTestCase::getClassResolverStub | protected | function | Returns a stub class resolver. | |||
UnitTestCase::getConfigFactoryStub | public | function | Returns a stub config factory that behaves according to the passed array. | |||
UnitTestCase::getConfigStorageStub | public | function | Returns a stub config storage that returns the supplied configuration. | |||
UnitTestCase::getContainerWithCacheTagsInvalidator | protected | function | Sets up a container with a cache tags invalidator. | |||
UnitTestCase::getRandomGenerator | protected | function | Gets the random generator for the utility methods. | |||
UnitTestCase::getStringTranslationStub | public | function | Returns a stub translation manager that just returns the passed string. | |||
UnitTestCase::randomMachineName | public | function | Generates a unique random string containing letters and numbers. | |||
UnitTestCase::setUpBeforeClass | public static | function |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.