class SqliteDateSqlTest in Drupal 8

Tests the MySQL-specific date query handler.

@coversDefaultClass \Drupal\views\Plugin\views\query\SqliteDateSql

@group views

Hierarchy

• class \Drupal\Tests\UnitTestCase extends \PHPUnit\Framework\TestCase uses PhpunitCompatibilityTrait
  • class \Drupal\Tests\views\Unit\Plugin\views\query\SqliteDateSqlTest

File

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

Namespace

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

class SqliteDateSqlTest extends UnitTestCase {

  /**
   * The mocked database service.
   *
   * @var \Drupal\Core\Database\Connection
   */
  protected $database;

  /**
   * {@inheritdoc}
   */
  public function setUp() {
    parent::setUp();
    $this->database = $this
      ->prophesize(Connection::class)
      ->reveal();
  }

  /**
   * Tests the getDateField method.
   *
   * @covers ::getDateField
   */
  public function testGetDateField() {
    $date_sql = new SqliteDateSql($this->database);
    $expected = "strftime('%s', foo.field)";
    $this
      ->assertEquals($expected, $date_sql
      ->getDateField('foo.field', TRUE));
    $expected = '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) {
    $date_sql = new SqliteDateSql($this->database);
    $this
      ->assertEquals($expected, $date_sql
      ->getDateFormat($field, $format));
  }

  /**
   * Provider for date formatting test.
   */
  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)",
      ],
    ];
  }

  /**
   * Tests timezone offset formatting.
   *
   * @covers ::setFieldTimezoneOffset
   */
  public function testSetFieldTimezoneOffset() {
    $date_sql = new SqliteDateSql($this->database);
    $field = 'foobar.field';
    $date_sql
      ->setFieldTimezoneOffset($field, 42);
    $this
      ->assertEquals("(foobar.field + 42)", $field);
  }

  /**
   * Tests setting the database offset.
   *
   * @covers ::setTimezoneOffset
   */
  public function testSetTimezoneOffset() {
    $database = $this
      ->prophesize(Connection::class);
    $database
      ->query()
      ->shouldNotBeCalled();
    $date_sql = new SqliteDateSql($database
      ->reveal());
    $date_sql
      ->setTimezoneOffset(42);
  }

}

Members

Name	Modifiers	Type	Description	Overrides
PhpunitCompatibilityTrait::getMock Deprecated	public	function	Returns a mock object for the specified class using the available method.
PhpunitCompatibilityTrait::setExpectedException Deprecated	public	function	Compatibility layer for PHPUnit 6 to support PHPUnit 4 code.
SqliteDateSqlTest::$database	protected	property	The mocked database service.
SqliteDateSqlTest::providerTestGetDateFormat	public	function	Provider for date formatting test.
SqliteDateSqlTest::setUp	public	function	Overrides UnitTestCase::setUp
SqliteDateSqlTest::testGetDateField	public	function	Tests the getDateField method.
SqliteDateSqlTest::testGetDateFormat	public	function	Tests date formatting replacement.
SqliteDateSqlTest::testSetFieldTimezoneOffset	public	function	Tests timezone offset formatting.
SqliteDateSqlTest::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	protected	function	Asserts if two arrays are equal by sorting them first.
UnitTestCase::getBlockMockWithMachineName Deprecated	protected	function	Mocks a block with a block plugin.	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::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.