public function Update::__toString in Drupal driver for SQL Server and SQL Azure 8.2

Same name and namespace in other branches

1. 8 drivers/lib/Drupal/Driver/Database/sqlsrv/Update.php \Drupal\Driver\Database\sqlsrv\Update::__toString()

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

Return value

string The prepared statement.

Overrides Update::__toString

File

drivers/lib/Drupal/Driver/Database/sqlsrv/Update.php, line 84

Definition of Drupal\Driver\Database\sqlsrv\Update

Class

Update

Namespace

Drupal\Driver\Database\sqlsrv

Code

public function __toString() {

  // Create a sanitized comment string to prepend to the query.
  $prefix = $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 = [];
  foreach ($this->expressionFields as $field => $data) {
    $update_fields[] = $this->connection
      ->quoteIdentifier($field) . '=' . $data['expression'];
    unset($fields[$field]);
  }
  $max_placeholder = 0;
  foreach ($fields as $field => $value) {
    $update_fields[] = $this->connection
      ->quoteIdentifier($field) . '=:db_update_placeholder_' . $max_placeholder++;
  }
  $query = $prefix . 'UPDATE {' . $this->connection
    ->escapeTable($this->table) . '} SET ' . implode(', ', $update_fields);
  if (count($this->condition)) {
    $this->condition
      ->compile($this->connection, $this);

    // There is an implicit string cast on $this->condition.
    $query .= "\nWHERE " . $this->condition;
  }
  return $query;
}