Skip navigation
Help

DatabaseCondition::mapConditionOperator

7 query.inc protected DatabaseCondition::mapConditionOperator($operator)

Gets any special processing requirements for the condition operator.

Some condition types require special processing, such as IN, because the value data they pass in is not a simple value. This is a simple overridable lookup function.

Parameters

$operator: The condition operator, such as "IN", "BETWEEN", etc. Case-sensitive.

Return value

The extra handling directives for the specified operator, or NULL.

1 call to DatabaseCondition::mapConditionOperator()

File

drupal/includes/database/query.inc, line 1836
Non-specific Database query code. Used by all engines.

Code

protected function mapConditionOperator($operator) {
  // $specials does not use drupal_static as its value never changes.
  static $specials = array(
    'BETWEEN' => array('delimiter' => ' AND '), 
    'IN' => array(
      'delimiter' => ', ',
      'prefix' => ' (',
      'postfix' => ')',
    ), 
    'NOT IN' => array(
      'delimiter' => ', ',
      'prefix' => ' (',
      'postfix' => ')',
    ), 
    'EXISTS' => array(
      'prefix' => ' (',
      'postfix' => ')',
    ), 
    'NOT EXISTS' => array(
      'prefix' => ' (',
      'postfix' => ')',
    ), 
    'IS NULL' => array('use_value' => FALSE), 
    'IS NOT NULL' => array('use_value' => FALSE),
    // Use backslash for escaping wildcard characters. 
    'LIKE' => array('postfix' => " ESCAPE '\\\\'"), 
    'NOT LIKE' => array('postfix' => " ESCAPE '\\\\'"),
    // These ones are here for performance reasons. 
    '=' => array(), 
    '<' => array(), 
    '>' => array(), 
    '>=' => array(), 
    '<=' => array(),
  );
  if (isset($specials[$operator])) {
    $return = $specials[$operator];
  }
  else {
    // We need to upper case because PHP index matches are case sensitive but
    // do not need the more expensive drupal_strtoupper because SQL statements are ASCII.
    $operator = strtoupper($operator);
    $return = isset($specials[$operator]) ? $specials[$operator] : array();
  }

  $return += array('operator' => $operator);

  return $return;
}