function UpdateQuery::__toString

Implements PHP magic __toString method to convert the query to a string.

Return value

string The prepared statement.

Overrides Query::__toString

File

includes/database/query.inc, line 1192

Class

UpdateQuery

General class for an abstracted UPDATE operation.

Code

public function __toString() {
    // Create a sanitized comment string to prepend to the query.
    $comments = $this->connection
        ->makeComment($this->comments);
    // Expressions take priority over literal fields, so we process those first
    // and remove any literal fields that conflict.
    $fields = $this->fields;
    $update_fields = array();
    foreach ($this->expressionFields as $field => $data) {
        $update_fields[] = $field . '=' . $data['expression'];
        unset($fields[$field]);
    }
    $max_placeholder = 0;
    foreach ($fields as $field => $value) {
        $update_fields[] = $field . '=:db_update_placeholder_' . $max_placeholder++;
    }
    $query = $comments . 'UPDATE {' . $this->connection
        ->escapeTable($this->table) . '} SET ' . implode(', ', $update_fields);
    if (count($this->condition)) {
        try {
            $this->condition
                ->compile($this->connection, $this);
        } catch (InvalidQueryConditionOperatorException $e) {
            drupal_trigger_fatal_error($e->getMessage());
        }
        // There is an implicit string cast on $this->condition.
        $query .= "\nWHERE " . $this->condition;
    }
    return $query;
}