public function ConditionTest::dataProviderTestCompileWithKnownOperators in Zircon Profile 8

Same name and namespace in other branches

1. 8.0 core/tests/Drupal/Tests/Core/Database/ConditionTest.php \Drupal\Tests\Core\Database\ConditionTest::dataProviderTestCompileWithKnownOperators()

Provides a list of known operations and the expected output.

Return value

array

File

core/tests/Drupal/Tests/Core/Database/ConditionTest.php, line 99

Contains \Drupal\Tests\Core\Database\ConditionTest.

Class

ConditionTest

@coversDefaultClass \Drupal\Core\Database\Query\Condition

Namespace

Drupal\Tests\Core\Database

Code

public function dataProviderTestCompileWithKnownOperators() {

  // Below are a list of commented out test cases, which should work but
  // aren't directly supported by core, but instead need manual handling with
  // prefix/suffix at the moment.
  $data = [];
  $data[] = [
    ' (name = :db_condition_placeholder_0) ',
    'name',
    'value',
    '=',
  ];
  $data[] = [
    ' (name != :db_condition_placeholder_0) ',
    'name',
    'value',
    '!=',
  ];
  $data[] = [
    ' (name <> :db_condition_placeholder_0) ',
    'name',
    'value',
    '<>',
  ];
  $data[] = [
    ' (name >= :db_condition_placeholder_0) ',
    'name',
    'value',
    '>=',
  ];
  $data[] = [
    ' (name > :db_condition_placeholder_0) ',
    'name',
    'value',
    '>',
  ];
  $data[] = [
    ' (name <= :db_condition_placeholder_0) ',
    'name',
    'value',
    '<=',
  ];
  $data[] = [
    ' (name < :db_condition_placeholder_0) ',
    'name',
    'value',
    '<',
  ];

  // $data[] = [' ( GREATEST (1, 2, 3) ) ', '', [1, 2, 3], 'GREATEST'];
  $data[] = [
    ' (name IN  (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2)) ',
    'name',
    [
      '1',
      '2',
      '3',
    ],
    'IN',
  ];
  $data[] = [
    ' (name NOT IN  (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2)) ',
    'name',
    [
      '1',
      '2',
      '3',
    ],
    'NOT IN',
  ];

  // $data[] = [' ( INTERVAL (1, 2, 3) ) ', '', [1, 2, 3], 'INTERVAL'];
  $data[] = [
    ' (name IS NULL ) ',
    'name',
    NULL,
    'IS NULL',
  ];
  $data[] = [
    ' (name IS NOT NULL ) ',
    'name',
    NULL,
    'IS NOT NULL',
  ];
  $data[] = [
    ' (name IS :db_condition_placeholder_0) ',
    'name',
    'TRUE',
    'IS',
  ];

  // $data[] = [' ( LEAST (1, 2, 3) ) ', '', [1, 2, 3], 'LEAST'];
  $data[] = [
    " (name LIKE :db_condition_placeholder_0 ESCAPE '\\\\') ",
    'name',
    '%muh%',
    'LIKE',
    [
      ':db_condition_placeholder_0' => '%muh%',
    ],
  ];
  $data[] = [
    " (name NOT LIKE :db_condition_placeholder_0 ESCAPE '\\\\') ",
    'name',
    '%muh%',
    'NOT LIKE',
    [
      ':db_condition_placeholder_0' => '%muh%',
    ],
  ];
  $data[] = [
    " (name BETWEEN :db_condition_placeholder_0 AND :db_condition_placeholder_1) ",
    'name',
    [
      1,
      2,
    ],
    'BETWEEN',
    [
      ':db_condition_placeholder_0' => 1,
      ':db_condition_placeholder_1' => 2,
    ],
  ];

  // $data[] = [" (name NOT BETWEEN :db_condition_placeholder_0 AND :db_condition_placeholder_1) ", 'name', [1, 2], 'NOT BETWEEN', [':db_condition_placeholder_0' => 1, ':db_condition_placeholder_1' => 2]];
  // $data[] = [' ( STRCMP (name, :db_condition_placeholder_0) ) ', '', ['test-string'], 'STRCMP', [':db_condition_placeholder_0' => 'test-string']];
  // $data[] = [' (EXISTS ) ', '', NULL, 'EXISTS'];
  // $data[] = [' (name NOT EXISTS ) ', 'name', NULL, 'NOT EXISTS'];
  return $data;
}