3 namespace Drupal\Tests\views\Kernel\Handler;
5 use Drupal\Tests\views\Kernel\ViewsKernelTestBase;
6 use Drupal\views\Views;
9 * Tests the core Drupal\views\Plugin\views\filter\StringFilter handler.
13 class FilterStringTest extends ViewsKernelTestBase {
15 public static $modules = ['system'];
18 * Views used by this test.
22 public static $testViews = ['test_view'];
29 protected $columnMap = [
30 'views_test_data_name' => 'name',
33 public function viewsData() {
34 $data = parent::viewsData();
35 $data['views_test_data']['name']['filter']['allow empty'] = TRUE;
36 $data['views_test_data']['job']['filter']['allow empty'] = FALSE;
37 $data['views_test_data']['description'] = $data['views_test_data']['name'];
42 protected function schemaDefinition() {
43 $schema = parent::schemaDefinition();
44 $schema['views_test_data']['fields']['description'] = [
45 'description' => "A person's description",
55 * An extended test dataset.
57 protected function dataSet() {
58 $dataset = parent::dataSet();
59 $dataset[0]['description'] = 'John Winston Ono Lennon, MBE (9 October 1940 – 8 December 1980) was an English musician and singer-songwriter who rose to worldwide fame as one of the founding members of The Beatles, one of the most commercially successful and critically acclaimed acts in the history of popular music. Along with fellow Beatle Paul McCartney, he formed one of the most successful songwriting partnerships of the 20th century.';
60 $dataset[1]['description'] = 'George Harrison,[1] MBE (25 February 1943 – 29 November 2001)[2] was an English rock guitarist, singer-songwriter, actor and film producer who achieved international fame as lead guitarist of The Beatles.';
61 $dataset[2]['description'] = 'Richard Starkey, MBE (born 7 July 1940), better known by his stage name Ringo Starr, is an English musician, singer-songwriter, and actor who gained worldwide fame as the drummer for The Beatles.';
62 $dataset[3]['description'] = 'Sir James Paul McCartney, MBE (born 18 June 1942) is an English musician, singer-songwriter and composer. Formerly of The Beatles (1960–1970) and Wings (1971–1981), McCartney is the most commercially successful songwriter in the history of popular music, according to Guinness World Records.[1]';
63 $dataset[4]['description'] = NULL;
69 * Build and return a Page view of the views_test_data table.
73 protected function getBasicPageView() {
74 $view = Views::getView('test_view');
76 // In order to test exposed filters, we have to disable
77 // the exposed forms cache.
78 \Drupal::service('views.exposed_form_cache')->reset();
80 $view->newDisplay('page', 'Page', 'page_1');
84 public function testFilterStringEqual() {
85 $view = Views::getView('test_view');
88 // Change the filtering
89 $view->displayHandlers->get('default')->overrideOption('filters', [
92 'table' => 'views_test_data',
94 'relationship' => 'none',
100 $this->executeView($view);
106 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
109 public function testFilterStringGroupedExposedEqual() {
110 $filters = $this->getGroupedExposedFilters();
111 $view = $this->getBasicPageView();
113 // Filter: Name, Operator: =, Value: Ringo
114 $filters['name']['group_info']['default_group'] = 1;
115 $view->setDisplay('page_1');
116 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
118 $this->container->get('router.builder')->rebuild();
120 $this->executeView($view);
128 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
131 public function testFilterStringNotEqual() {
132 $view = Views::getView('test_view');
135 // Change the filtering
136 $view->displayHandlers->get('default')->overrideOption('filters', [
139 'table' => 'views_test_data',
141 'relationship' => 'none',
147 $this->executeView($view);
159 'name' => 'Meredith',
162 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
165 public function testFilterStringGroupedExposedNotEqual() {
166 $filters = $this->getGroupedExposedFilters();
167 $view = $this->getBasicPageView();
169 // Filter: Name, Operator: !=, Value: Ringo
170 $filters['name']['group_info']['default_group'] = '2';
172 $view->setDisplay('page_1');
173 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
175 $this->container->get('router.builder')->rebuild();
177 $this->executeView($view);
190 'name' => 'Meredith',
194 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
197 public function testFilterStringContains() {
198 $view = Views::getView('test_view');
201 // Change the filtering
202 $view->displayHandlers->get('default')->overrideOption('filters', [
205 'table' => 'views_test_data',
207 'relationship' => 'none',
208 'operator' => 'contains',
213 $this->executeView($view);
219 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
223 public function testFilterStringGroupedExposedContains() {
224 $filters = $this->getGroupedExposedFilters();
225 $view = $this->getBasicPageView();
227 // Filter: Name, Operator: contains, Value: ing
228 $filters['name']['group_info']['default_group'] = '3';
229 $view->setDisplay('page_1');
230 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
232 $this->container->get('router.builder')->rebuild();
234 $this->executeView($view);
242 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
246 public function testFilterStringWord() {
247 $view = Views::getView('test_view');
250 // Change the filtering
251 $view->displayHandlers->get('default')->overrideOption('filters', [
253 'id' => 'description',
254 'table' => 'views_test_data',
255 'field' => 'description',
256 'relationship' => 'none',
257 'operator' => 'word',
262 $this->executeView($view);
271 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
274 $view = Views::getView('test_view');
277 // Change the filtering
278 $view->displayHandlers->get('default')->overrideOption('filters', [
280 'id' => 'description',
281 'table' => 'views_test_data',
282 'field' => 'description',
283 'relationship' => 'none',
284 'operator' => 'allwords',
285 'value' => 'Richard Starkey',
289 $this->executeView($view);
295 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
298 $view = Views::getView('test_view');
301 // Change the filtering to a sting containing only illegal characters.
302 $view->displayHandlers->get('default')->overrideOption('filters', [
304 'id' => 'description',
305 'table' => 'views_test_data',
306 'field' => 'description',
307 'relationship' => 'none',
308 'operator' => 'allwords',
313 $this->executeView($view);
328 'name' => 'Meredith',
331 $this->assertIdenticalResultset($view, $resultset);
335 public function testFilterStringGroupedExposedWord() {
336 $filters = $this->getGroupedExposedFilters();
337 $view = $this->getBasicPageView();
339 // Filter: Name, Operator: contains, Value: ing
340 $filters['name']['group_info']['default_group'] = '3';
341 $view->setDisplay('page_1');
342 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
344 $this->container->get('router.builder')->rebuild();
346 $this->executeView($view);
354 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
357 $filters = $this->getGroupedExposedFilters();
358 $view = $this->getBasicPageView();
360 // Filter: Description, Operator: contains, Value: actor
361 $filters['description']['group_info']['default_group'] = '1';
362 $view->setDisplay('page_1');
363 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
365 $this->executeView($view);
374 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
377 public function testFilterStringStarts() {
378 $view = Views::getView('test_view');
381 // Change the filtering
382 $view->displayHandlers->get('default')->overrideOption('filters', [
384 'id' => 'description',
385 'table' => 'views_test_data',
386 'field' => 'description',
387 'relationship' => 'none',
388 'operator' => 'starts',
393 $this->executeView($view);
399 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
402 public function testFilterStringGroupedExposedStarts() {
403 $filters = $this->getGroupedExposedFilters();
404 $view = $this->getBasicPageView();
406 // Filter: Name, Operator: starts, Value: George
407 $filters['description']['group_info']['default_group'] = 2;
408 $view->setDisplay('page_1');
409 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
411 $this->container->get('router.builder')->rebuild();
413 $this->executeView($view);
420 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
423 public function testFilterStringNotStarts() {
424 $view = Views::getView('test_view');
427 // Change the filtering
428 $view->displayHandlers->get('default')->overrideOption('filters', [
430 'id' => 'description',
431 'table' => 'views_test_data',
432 'field' => 'description',
433 'relationship' => 'none',
434 'operator' => 'not_starts',
439 $this->executeView($view);
450 // There is no Meredith returned because his description is empty
452 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
455 public function testFilterStringGroupedExposedNotStarts() {
456 $filters = $this->getGroupedExposedFilters();
457 $view = $this->getBasicPageView();
459 // Filter: Name, Operator: not_starts, Value: George
460 $filters['description']['group_info']['default_group'] = 3;
461 $view->setDisplay('page_1');
462 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
464 $this->container->get('router.builder')->rebuild();
466 $this->executeView($view);
478 // There is no Meredith returned because his description is empty
480 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
483 public function testFilterStringEnds() {
484 $view = Views::getView('test_view');
487 // Change the filtering
488 $view->displayHandlers->get('default')->overrideOption('filters', [
490 'id' => 'description',
491 'table' => 'views_test_data',
492 'field' => 'description',
493 'relationship' => 'none',
494 'operator' => 'ends',
495 'value' => 'Beatles.',
499 $this->executeView($view);
508 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
511 public function testFilterStringGroupedExposedEnds() {
512 $filters = $this->getGroupedExposedFilters();
513 $view = $this->getBasicPageView();
515 // Filter: Description, Operator: ends, Value: Beatles
516 $filters['description']['group_info']['default_group'] = 4;
517 $view->setDisplay('page_1');
518 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
520 $this->container->get('router.builder')->rebuild();
522 $this->executeView($view);
532 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
535 public function testFilterStringNotEnds() {
536 $view = Views::getView('test_view');
539 // Change the filtering
540 $view->displayHandlers->get('default')->overrideOption('filters', [
542 'id' => 'description',
543 'table' => 'views_test_data',
544 'field' => 'description',
545 'relationship' => 'none',
546 'operator' => 'not_ends',
547 'value' => 'Beatles.',
551 $this->executeView($view);
559 // There is no Meredith returned because his description is empty
561 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
564 public function testFilterStringGroupedExposedNotEnds() {
565 $filters = $this->getGroupedExposedFilters();
566 $view = $this->getBasicPageView();
568 // Filter: Description, Operator: not_ends, Value: Beatles
569 $filters['description']['group_info']['default_group'] = 5;
570 $view->setDisplay('page_1');
571 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
573 $this->container->get('router.builder')->rebuild();
575 $this->executeView($view);
584 // There is no Meredith returned because his description is empty
586 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
589 public function testFilterStringNot() {
590 $view = Views::getView('test_view');
593 // Change the filtering
594 $view->displayHandlers->get('default')->overrideOption('filters', [
596 'id' => 'description',
597 'table' => 'views_test_data',
598 'field' => 'description',
599 'relationship' => 'none',
601 'value' => 'Beatles.',
605 $this->executeView($view);
613 // There is no Meredith returned because his description is empty
615 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
619 public function testFilterStringGroupedExposedNot() {
620 $filters = $this->getGroupedExposedFilters();
621 $view = $this->getBasicPageView();
623 // Filter: Description, Operator: not (does not contains), Value: Beatles
624 $filters['description']['group_info']['default_group'] = 6;
625 $view->setDisplay('page_1');
626 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
628 $this->container->get('router.builder')->rebuild();
630 $this->executeView($view);
639 // There is no Meredith returned because his description is empty
641 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
645 public function testFilterStringShorter() {
646 $view = Views::getView('test_view');
649 // Change the filtering
650 $view->displayHandlers->get('default')->overrideOption('filters', [
653 'table' => 'views_test_data',
655 'relationship' => 'none',
656 'operator' => 'shorterthan',
661 $this->executeView($view);
670 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
673 public function testFilterStringGroupedExposedShorter() {
674 $filters = $this->getGroupedExposedFilters();
675 $view = $this->getBasicPageView();
677 // Filter: Name, Operator: shorterthan, Value: 5
678 $filters['name']['group_info']['default_group'] = 4;
679 $view->setDisplay('page_1');
680 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
682 $this->container->get('router.builder')->rebuild();
684 $this->executeView($view);
693 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
696 public function testFilterStringLonger() {
697 $view = Views::getView('test_view');
700 // Change the filtering
701 $view->displayHandlers->get('default')->overrideOption('filters', [
704 'table' => 'views_test_data',
706 'relationship' => 'none',
707 'operator' => 'longerthan',
712 $this->executeView($view);
715 'name' => 'Meredith',
718 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
721 public function testFilterStringGroupedExposedLonger() {
722 $filters = $this->getGroupedExposedFilters();
723 $view = $this->getBasicPageView();
725 // Filter: Name, Operator: longerthan, Value: 4
726 $filters['name']['group_info']['default_group'] = 5;
727 $view->setDisplay('page_1');
728 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
730 $this->container->get('router.builder')->rebuild();
732 $this->executeView($view);
735 'name' => 'Meredith',
738 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
742 public function testFilterStringEmpty() {
743 $view = Views::getView('test_view');
746 // Change the filtering
747 $view->displayHandlers->get('default')->overrideOption('filters', [
749 'id' => 'description',
750 'table' => 'views_test_data',
751 'field' => 'description',
752 'relationship' => 'none',
753 'operator' => 'empty',
757 $this->executeView($view);
760 'name' => 'Meredith',
763 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
766 public function testFilterStringGroupedExposedEmpty() {
767 $filters = $this->getGroupedExposedFilters();
768 $view = $this->getBasicPageView();
770 // Filter: Description, Operator: empty, Value:
771 $filters['description']['group_info']['default_group'] = 7;
772 $view->setDisplay('page_1');
773 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
775 $this->container->get('router.builder')->rebuild();
777 $this->executeView($view);
780 'name' => 'Meredith',
783 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
786 protected function getGroupedExposedFilters() {
790 'plugin_id' => 'string',
791 'table' => 'views_test_data',
793 'relationship' => 'none',
796 'operator' => 'name_op',
798 'identifier' => 'name',
800 'is_grouped' => TRUE,
803 'identifier' => 'name',
804 'default_group' => 'All',
807 'title' => 'Is Ringo',
812 'title' => 'Is not Ringo',
817 'title' => 'Contains ing',
818 'operator' => 'contains',
822 'title' => 'Shorter than 5 letters',
823 'operator' => 'shorterthan',
827 'title' => 'Longer than 7 letters',
828 'operator' => 'longerthan',
835 'id' => 'description',
836 'plugin_id' => 'string',
837 'table' => 'views_test_data',
838 'field' => 'description',
839 'relationship' => 'none',
842 'operator' => 'description_op',
843 'label' => 'description',
844 'identifier' => 'description',
846 'is_grouped' => TRUE,
848 'label' => 'description',
849 'identifier' => 'description',
850 'default_group' => 'All',
853 'title' => 'Contains the word: Actor',
854 'operator' => 'word',
858 'title' => 'Starts with George',
859 'operator' => 'starts',
863 'title' => 'Not Starts with: George',
864 'operator' => 'not_starts',
868 'title' => 'Ends with: Beatles',
869 'operator' => 'ends',
870 'value' => 'Beatles.',
873 'title' => 'Not Ends with: Beatles',
874 'operator' => 'not_ends',
875 'value' => 'Beatles.',
878 'title' => 'Does not contain: Beatles',
880 'value' => 'Beatles.',
883 'title' => 'Empty description',
884 'operator' => 'empty',