Version 1

[yaffs-website] / web / core / modules / views / tests / src / Kernel / Handler / SortDateTest.php

diff --git a/web/core/modules/views/tests/src/Kernel/Handler/SortDateTest.php b/web/core/modules/views/tests/src/Kernel/Handler/SortDateTest.php
new file mode 100644 (file)
index 0000000..2d1a2fc
--- /dev/null
+++ b/web/core/modules/views/tests/src/Kernel/Handler/SortDateTest.php
@@ -0,0 +1,203 @@
+<?php
+
+namespace Drupal\Tests\views\Kernel\Handler;
+
+use Drupal\Component\Utility\SafeMarkup;
+use Drupal\Tests\views\Kernel\ViewsKernelTestBase;
+use Drupal\views\Views;
+
+/**
+ * Tests for core Drupal\views\Plugin\views\sort\Date handler.
+ *
+ * @group views
+ */
+class SortDateTest extends ViewsKernelTestBase {
+
+  /**
+   * Views used by this test.
+   *
+   * @var array
+   */
+  public static $testViews = ['test_view'];
+
+  protected function expectedResultSet($granularity, $reverse = TRUE) {
+    $expected = [];
+    if (!$reverse) {
+      switch ($granularity) {
+        case 'second':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+            ['name' => 'Ringo'],
+            ['name' => 'George'],
+          ];
+          break;
+        case 'minute':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'Paul'],
+            ['name' => 'Ringo'],
+            ['name' => 'Meredith'],
+            ['name' => 'George'],
+          ];
+          break;
+        case 'hour':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+            ['name' => 'George'],
+          ];
+          break;
+        case 'day':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+            ['name' => 'George'],
+          ];
+          break;
+        case 'month':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+          ];
+          break;
+        case 'year':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+          ];
+          break;
+      }
+    }
+    else {
+      switch ($granularity) {
+        case 'second':
+          $expected = [
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Meredith'],
+            ['name' => 'Paul'],
+            ['name' => 'John'],
+          ];
+          break;
+        case 'minute':
+          $expected = [
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Meredith'],
+            ['name' => 'Paul'],
+            ['name' => 'John'],
+           ];
+          break;
+        case 'hour':
+          $expected = [
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+            ['name' => 'John'],
+          ];
+          break;
+        case 'day':
+          $expected = [
+            ['name' => 'George'],
+            ['name' => 'John'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+          ];
+          break;
+        case 'month':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+          ];
+          break;
+        case 'year':
+          $expected = [
+            ['name' => 'John'],
+            ['name' => 'George'],
+            ['name' => 'Ringo'],
+            ['name' => 'Paul'],
+            ['name' => 'Meredith'],
+          ];
+          break;
+      }
+    }
+
+    return $expected;
+  }
+
+  /**
+   * Tests numeric ordering of the result set.
+   */
+  public function testDateOrdering() {
+    foreach (['second', 'minute', 'hour', 'day', 'month', 'year'] as $granularity) {
+      foreach ([FALSE, TRUE] as $reverse) {
+        $view = Views::getView('test_view');
+        $view->setDisplay();
+
+        // Change the fields.
+        $view->displayHandlers->get('default')->overrideOption('fields', [
+          'name' => [
+            'id' => 'name',
+            'table' => 'views_test_data',
+            'field' => 'name',
+            'relationship' => 'none',
+          ],
+          'created' => [
+            'id' => 'created',
+            'table' => 'views_test_data',
+            'field' => 'created',
+            'relationship' => 'none',
+          ],
+        ]);
+
+        // Change the ordering
+        $view->displayHandlers->get('default')->overrideOption('sorts', [
+          'created' => [
+            'id' => 'created',
+            'table' => 'views_test_data',
+            'field' => 'created',
+            'relationship' => 'none',
+            'granularity' => $granularity,
+            'order' => $reverse ? 'DESC' : 'ASC',
+          ],
+          'id' => [
+            'id' => 'id',
+            'table' => 'views_test_data',
+            'field' => 'id',
+            'relationship' => 'none',
+            'order' => 'ASC',
+          ],
+        ]);
+
+        // Execute the view.
+        $this->executeView($view);
+
+        // Verify the result.
+        $this->assertEqual(count($this->dataSet()), count($view->result), 'The number of returned rows match.');
+        $this->assertIdenticalResultset($view, $this->expectedResultSet($granularity, $reverse), [
+          'views_test_data_name' => 'name',
+        ], SafeMarkup::format('Result is returned correctly when ordering by granularity @granularity, @reverse.', ['@granularity' => $granularity, '@reverse' => $reverse ? 'reverse' : 'forward']));
+        $view->destroy();
+        unset($view);
+      }
+    }
+  }
+
+}