public function DatabaseConnection_sqlsrv::query_direct in Drupal driver for SQL Server and SQL Azure 7.2

Same name and namespace in other branches

1. 7.3 sqlsrv/database.inc \DatabaseConnection_sqlsrv::query_direct()

Like query but with no insecure detection or query preprocessing. The caller is sure that his query is MS SQL compatible! Used internally from the schema class, but could be called from anywhere.

Parameters

mixed $query:

array $args:

mixed $options:

Return value

mixed

Throws

PDOException

4 calls to DatabaseConnection_sqlsrv::query_direct()

DatabaseConnection_sqlsrv::nextId in sqlsrv/database.inc

Override of DatabaseConnection::nextId().

DatabaseConnection_sqlsrv::popCommittableTransactions in sqlsrv/database.inc

Internal function: commit all the transaction layers that can commit.

DatabaseConnection_sqlsrv::pushTransaction in sqlsrv/database.inc

Summary of pushTransaction

DatabaseConnection_sqlsrv::rollback in sqlsrv/database.inc

Overriden.

File

sqlsrv/database.inc, line 514

Database interface code for Microsoft SQL Server.

Class

DatabaseConnection_sqlsrv

Summary of DatabaseConnection_sqlsrv

Code

public function query_direct($query, array $args = array(), $options = array()) {

  // Use default values if not already set.
  $options += $this
    ->defaultOptions();
  $stmt = NULL;
  try {

    // Bypass query preprocessing and use direct queries.
    $ctx = new \DatabaseContext($this, TRUE, TRUE);

    // Prepare the statement and execute it.
    $stmt = $this
      ->prepareQuery($query, $options);
    $stmt
      ->execute($args, $options);

    // Reset the context settings.
    unset($ctx);

    // Depending on the type of query we may need to return a different value.
    // See DatabaseConnection::defaultOptions() for a description of each
    // value.
    switch ($options['return']) {
      case Database::RETURN_STATEMENT:
        return $stmt;
      case Database::RETURN_AFFECTED:
        return $stmt
          ->rowCount();
      case Database::RETURN_INSERT_ID:
        return $this
          ->lastInsertId();
      case Database::RETURN_NULL:
        return NULL;
      default:
        throw new PDOException('Invalid return directive: ' . $options['return']);
    }
  } catch (PDOException $e) {

    // Most database drivers will return NULL here, but some of them
    // (e.g. the SQLite driver) may need to re-run the query, so the return
    // value will be the same as for static::query().
    return $this
      ->handleQueryException($e, $stmt, $args, $options);
  }
}