function Query::__toString

Implements the magic __toString method.

File

core/lib/Drupal/Core/Entity/Query/Sql/Query.php, line 337

Class

Query

The SQL storage entity query class.

Namespace

Code

public function __toString() {
  // Clone the query so the prepare and compile doesn't get repeated.
  $clone = clone $this;
  $clone->prepare()
    ->compile()
    ->addSort()
    ->finish();
  // Quote arguments so query is able to be run.
  $quoted = [];
  foreach ($clone->sqlQuery
    ->getArguments() as $key => $value) {
    $quoted[$key] = is_null($value) ? 'NULL' : $this->connection
      ->quote($value);
  }
  // Replace table name brackets.
  $sql = $clone->connection
    ->prefixTables((string) $clone->sqlQuery);
  $sql = $clone->connection
    ->quoteIdentifiers($sql);
  return strtr($sql, $quoted);
}