Truncate.php in Drupal driver for SQL Server and SQL Azure 4.1.x

Namespace

Drupal\sqlsrv\Driver\Database\sqlsrv

File

src/Driver/Database/sqlsrv/Truncate.php

<?php

namespace Drupal\sqlsrv\Driver\Database\sqlsrv;

use Drupal\Core\Database\Query\Truncate as QueryTruncate;

/**
 * General class for an abstracted TRUNCATE operation.
 *
 * Can the execute function be removed? It's identical to the parent.
 */
class Truncate extends QueryTruncate {

  /**
   * {@inheritdoc}
   */
  public function execute() {
    return $this->connection
      ->query((string) $this, [], $this->queryOptions);
  }

  /**
   * {@inheritdoc}
   */
  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) . '} ';
    }
  }

}

Classes

Name	Description
Truncate	General class for an abstracted TRUNCATE operation.