protected function DatabaseCondition::mapConditionOperator

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.:

File

includes/database/query.inc, line 1955

Non-specific Database query code. Used by all engines.

Class

DatabaseCondition

Generic class for a series of conditions in a query.

Code

protected function mapConditionOperator($operator) {
  // $specials does not use backdrop_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 backdrop_strtoupper because SQL statements are ASCII.
    $operator = strtoupper($operator);
    $return = isset($specials[$operator]) ? $specials[$operator] : array();
  }

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

  return $return;
}