3 namespace Drupal\Tests\views\Unit\Plugin\views\query;
5 use Drupal\Core\Database\Connection;
6 use Drupal\Tests\UnitTestCase;
7 use Drupal\views\Plugin\views\query\SqliteDateSql;
10 * Tests the MySQL-specific date query handler.
12 * @coversDefaultClass \Drupal\views\Plugin\views\query\SqliteDateSql
16 class SqliteDateSqlTest extends UnitTestCase {
19 * The mocked database service.
21 * @var \Drupal\Core\Database\Connection
28 public function setUp() {
30 $this->database = $this->prophesize(Connection::class)->reveal();
34 * Tests the getDateField method.
36 * @covers ::getDateField
38 public function testGetDateField() {
39 $date_sql = new SqliteDateSql($this->database);
41 $expected = "strftime('%s', foo.field)";
42 $this->assertEquals($expected, $date_sql->getDateField('foo.field', TRUE));
44 $expected = 'foo.field';
45 $this->assertEquals($expected, $date_sql->getDateField('foo.field', FALSE));
49 * Tests date formatting replacement.
51 * @covers ::getDateFormat
53 * @dataProvider providerTestGetDateFormat
55 public function testGetDateFormat($field, $format, $expected) {
56 $date_sql = new SqliteDateSql($this->database);
58 $this->assertEquals($expected, $date_sql->getDateFormat($field, $format));
62 * Provider for date formatting test.
64 public function providerTestGetDateFormat() {
66 ['foo.field', 'Y-y-M-m', "strftime('%Y-%Y-%m-%m', foo.field, 'unixepoch')"],
67 ['bar.field', 'n-F D d l', "strftime('%m-%m %d %d %d', bar.field, 'unixepoch')"],
68 ['baz.bar_field', 'j/W/H-h i s A', "strftime('%d/%W/%H-%H %M %S ', baz.bar_field, 'unixepoch')"],
69 ['foo.field', 'W', "CAST(((strftime('%j', date(strftime('%Y-%m-%d', foo.field, 'unixepoch'), '-3 days', 'weekday 4')) - 1) / 7 + 1) AS NUMERIC)"]
74 * Tests timezone offset formatting.
76 * @covers ::setFieldTimezoneOffset
78 public function testSetFieldTimezoneOffset() {
79 $date_sql = new SqliteDateSql($this->database);
81 $field = 'foobar.field';
82 $date_sql->setFieldTimezoneOffset($field, 42);
83 $this->assertEquals("(foobar.field + 42)", $field);
87 * Tests setting the database offset.
89 * @covers ::setTimezoneOffset
91 public function testSetTimezoneOffset() {
92 $database = $this->prophesize(Connection::class);
93 $database->query()->shouldNotBeCalled();
94 $date_sql = new SqliteDateSql($database->reveal());
95 $date_sql->setTimezoneOffset(42);