public function DatabaseCondition::compile

Compiles the saved conditions for later retrieval.

This method does not return anything. It only prepares data to be retrieved via __toString() and arguments().

Parameters

DatabaseConnection $connection: The database connection for which to compile the conditionals.

QueryPlaceholderInterface $queryPlaceholder: The query this condition belongs to. If not given, the current query is used.

Overrides QueryConditionInterface::compile

File

core/includes/database/query.inc, line 1856

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

Class

DatabaseCondition

Generic class for a series of conditions in a query.

Code

public function compile(DatabaseConnection $connection, QueryPlaceholderInterface $queryPlaceholder) {
  // Re-compile if this condition changed or if we are compiled against a
  // different query placeholder object.
  if ($this->changed || isset($this->queryPlaceholderIdentifier) && ($this->queryPlaceholderIdentifier != $queryPlaceholder->uniqueIdentifier())) {
    $this->queryPlaceholderIdentifier = $queryPlaceholder->uniqueIdentifier();

    $condition_fragments = array();
    $arguments = array();

    $conditions = $this->conditions;
    $conjunction = $conditions['#conjunction'];
    unset($conditions['#conjunction']);
    foreach ($conditions as $condition) {
      if (empty($condition['operator'])) {
        // This condition is a literal string, so let it through as is.
        $condition_fragments[] = ' (' . $condition['field'] . ') ';
        $arguments += $condition['value'];
      }
      else {
        // It's a structured condition, so parse it out accordingly.
        // Note that $condition['field'] will only be an object for a
        // dependent DatabaseCondition object, not for a dependent subquery.
        if ($condition['field'] instanceof QueryConditionInterface) {
          // Compile the sub-condition recursively and add it to the list.
          $condition['field']->compile($connection, $queryPlaceholder);
          $condition_fragments[] = '(' . (string) $condition['field'] . ')';
          $arguments += $condition['field']->arguments();
        }
        else {
          // For simplicity, treat all operators as the same data structure.
          // In the typical degenerate case, this won't get changed.
          $operator_defaults = array(
            'prefix' => '',
            'postfix' => '',
            'delimiter' => '',
            'operator' => $condition['operator'],
            'use_value' => TRUE,
          );
          $operator = $connection->mapConditionOperator($condition['operator']);
          if (!isset($operator)) {
            $operator = $this->mapConditionOperator($condition['operator']);
          }
          $operator += $operator_defaults;

          $placeholders = array();
          if ($condition['value'] instanceof SelectQueryInterface) {
            $operator = $this->ensureBrackets($operator);
            $condition['value']->compile($connection, $queryPlaceholder);
            $placeholders[] = (string) $condition['value'];
            $arguments += $condition['value']->arguments();
            // Subqueries are the actual value of the operator, we don't
            // need to add another below.
            $operator['use_value'] = FALSE;
          }
          // We assume that if there is a delimiter, then the value is an
          // array. If not, it is a scalar. For simplicity, we first convert
          // to an array so that placeholders can be built in the same way.
          elseif (!$operator['delimiter']) {
            $condition['value'] = array($condition['value']);
          }
          if ($operator['use_value']) {
            foreach ($condition['value'] as $value) {
              $placeholder = ':db_condition_placeholder_' . $queryPlaceholder->nextPlaceholder();
              $arguments[$placeholder] = $value;
              $placeholders[] = $placeholder;
            }
          }
          $condition_fragments[] = ' (' . $connection->escapeField($condition['field']) . ' ' . $operator['operator'] . ' ' . $operator['prefix'] . implode($operator['delimiter'], $placeholders) . $operator['postfix'] . ') ';
        }
      }
    }

    $this->changed = FALSE;
    $this->stringVersion = implode($conjunction, $condition_fragments);
    $this->arguments = $arguments;
  }
}