class PostgresqlDateSqlTest

Same name and namespace in other branches
  1. 9 core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest
  2. 8.9.x core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\PostgresqlDateSqlTest
  3. 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

Expanded class hierarchy of PostgresqlDateSqlTest

File

core/modules/views/tests/src/Unit/Plugin/views/query/PostgresqlDateSqlTest.php, line 18

Namespace

Drupal\Tests\views\Unit\Plugin\views\query
View source
class PostgresqlDateSqlTest extends UnitTestCase {
  
  /**
   * The mocked database service.
   *
   * @var \Drupal\Core\Database\Connection
   */
  protected $database;
  
  /**
   * {@inheritdoc}
   */
  protected function setUp() : void {
    parent::setUp();
    $this->database = $this->prophesize(Connection::class)
      ->reveal();
  }
  
  /**
   * Tests the getDateField method.
   *
   * @covers ::getDateField
   */
  public function testGetDateField() : void {
    $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) : void {
    $date_sql = new PostgresqlDateSql($this->database);
    $this->assertEquals("TO_CHAR({$field}, '{$expected_format}')", $date_sql->getDateFormat($field, $format));
  }
  
  /**
   * Provider for date formatting test.
   */
  public static 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() : void {
    $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() : void {
    $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 static function Provider for date formatting test.
PostgresqlDateSqlTest::setUp protected 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.
RandomGeneratorTrait::getRandomGenerator protected function Gets the random generator for the utility methods.
RandomGeneratorTrait::randomMachineName protected function Generates a unique random string containing letters and numbers.
RandomGeneratorTrait::randomObject public function Generates a random PHP object.
RandomGeneratorTrait::randomString public function Generates a pseudo-random string of ASCII characters of codes 32 to 126.
RandomGeneratorTrait::randomStringValidate Deprecated public function Callback for random string validation.
UnitTestCase::$root protected property The app root. 1
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::getStringTranslationStub public function Returns a stub translation manager that just returns the passed string.
UnitTestCase::setUpBeforeClass public static function
UnitTestCase::__get public function

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.