public function SqliteDateSqlTest::providerTestGetDateFormat in Drupal 8

Same name and namespace in other branches

1. 9 core/modules/views/tests/src/Unit/Plugin/views/query/SqliteDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\SqliteDateSqlTest::providerTestGetDateFormat()

Provider for date formatting test.

File

core/modules/views/tests/src/Unit/Plugin/views/query/SqliteDateSqlTest.php, line 64

Class

SqliteDateSqlTest

Tests the MySQL-specific date query handler.

Namespace

Drupal\Tests\views\Unit\Plugin\views\query

Code

public function providerTestGetDateFormat() {
  return [
    [
      'foo.field',
      'Y-y-M-m',
      "strftime('%Y-%Y-%m-%m', foo.field, 'unixepoch')",
    ],
    [
      'bar.field',
      'n-F D d l',
      "strftime('%m-%m %d %d %d', bar.field, 'unixepoch')",
    ],
    [
      'baz.bar_field',
      'j/W/H-h i s A',
      "strftime('%d/%W/%H-%H %M %S ', baz.bar_field, 'unixepoch')",
    ],
    [
      'foo.field',
      'W',
      "CAST(((strftime('%j', date(strftime('%Y-%m-%d', foo.field, 'unixepoch'), '-3 days', 'weekday 4')) - 1) / 7 + 1) AS NUMERIC)",
    ],
  ];
}