public function Truncate::__toString in Drupal driver for SQL Server and SQL Azure 4.0.x

Same name and namespace in other branches

1. 4.2.x src/Driver/Database/sqlsrv/Truncate.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Truncate::__toString()
2. 3.1.x src/Driver/Database/sqlsrv/Truncate.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Truncate::__toString()
3. 4.1.x src/Driver/Database/sqlsrv/Truncate.php \Drupal\sqlsrv\Driver\Database\sqlsrv\Truncate::__toString()

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

Return value

string The prepared statement.

Overrides Truncate::__toString

File

src/Driver/Database/sqlsrv/Truncate.php, line 24

Class

Truncate

General class for an abstracted TRUNCATE operation.

Namespace

Drupal\sqlsrv\Driver\Database\sqlsrv

Code

public function __toString() {

  // Create a sanitized comment string to prepend to the query.
  $comments = $this->connection
    ->makeComment($this->comments);

  // In most cases, TRUNCATE is not a transaction safe statement as it is a
  // DDL statement which results in an implicit COMMIT. When we are in a
  // transaction, fallback to the slower, but transactional, DELETE.
  // PostgreSQL also locks the entire table for a TRUNCATE strongly reducing
  // the concurrency with other transactions.
  if ($this->connection
    ->inTransaction()) {
    return $comments . 'DELETE FROM {' . $this->connection
      ->escapeTable($this->table) . '}';
  }
  else {
    return $comments . 'TRUNCATE TABLE {' . $this->connection
      ->escapeTable($this->table) . '} ';
  }
}