class SqliteDateSqlTest

Same name in other branches
  1. 9 core/modules/views/tests/src/Unit/Plugin/views/query/SqliteDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\SqliteDateSqlTest
  2. 10 core/modules/views/tests/src/Unit/Plugin/views/query/SqliteDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\SqliteDateSqlTest
  3. 11.x core/modules/views/tests/src/Unit/Plugin/views/query/SqliteDateSqlTest.php \Drupal\Tests\views\Unit\Plugin\views\query\SqliteDateSqlTest

Tests the MySQL-specific date query handler.

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

@group views

Hierarchy

Expanded class hierarchy of SqliteDateSqlTest

File

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

Namespace

Drupal\Tests\views\Unit\Plugin\views\query
View source
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

Title Sort descending Deprecated Modifiers Object type Summary Overriden Title 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.

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