class MergeQuery_sqlsrv in Drupal driver for SQL Server and SQL Azure 7

SQL Server-specific implementation of the MERGE operation.

Hierarchy

• class \Query implements QueryPlaceholderInterface
  • class \MergeQuery implements QueryConditionInterface
    • class \MergeQuery_sqlsrv

File

sqlsrv/query.inc, line 321

class MergeQuery_sqlsrv extends MergeQuery {
  public function execute() {

    // We don't need INSERT or UPDATE queries to trigger additional transactions.
    $this->queryOptions['sqlsrv_skip_transactions'] = TRUE;
    return parent::execute();
  }

}

Members

Name	Modifiers	Type	Description	Overrides
MergeQuery::$conditionTable	protected	property	The table or subquery to be used for the condition.
MergeQuery::$defaultFields	protected	property	An array of fields which should be set to their database-defined defaults.
MergeQuery::$expressionFields	protected	property	Array of fields to update to an expression in case of a duplicate record.
MergeQuery::$insertFields	protected	property	An array of fields on which to insert.
MergeQuery::$insertValues	protected	property	An array of values to be inserted.
MergeQuery::$needsUpdate	protected	property	Flag indicating whether an UPDATE is necessary.
MergeQuery::$table	protected	property	The table to be used for INSERT and UPDATE.
MergeQuery::$updateFields	protected	property	An array of fields that will be updated.
MergeQuery::arguments	public	function	Implements QueryConditionInterface::arguments(). Overrides QueryConditionInterface::arguments
MergeQuery::compile	public	function	Implements QueryConditionInterface::compile(). Overrides QueryConditionInterface::compile
MergeQuery::compiled	public	function	Implements QueryConditionInterface::compiled(). Overrides QueryConditionInterface::compiled
MergeQuery::condition	public	function	Implements QueryConditionInterface::condition(). Overrides QueryConditionInterface::condition
MergeQuery::conditions	public	function	Implements QueryConditionInterface::conditions(). Overrides QueryConditionInterface::conditions
MergeQuery::conditionTable	protected	function	Sets the table or subquery to be used for the condition.
MergeQuery::exists	public	function	Implements QueryConditionInterface::exists(). Overrides QueryConditionInterface::exists
MergeQuery::expression	public	function	Specifies fields to be updated as an expression.
MergeQuery::fields	public	function	Sets common field-value pairs in the INSERT and UPDATE query parts.
MergeQuery::insertFields	public	function	Adds a set of field->value pairs to be inserted.
MergeQuery::isNotNull	public	function	Implements QueryConditionInterface::isNotNull(). Overrides QueryConditionInterface::isNotNull
MergeQuery::isNull	public	function	Implements QueryConditionInterface::isNull(). Overrides QueryConditionInterface::isNull
MergeQuery::key	public	function	Sets the key field(s) to be used as conditions for this query.
MergeQuery::notExists	public	function	Implements QueryConditionInterface::notExists(). Overrides QueryConditionInterface::notExists
MergeQuery::STATUS_INSERT		constant	Returned by execute() if an INSERT query has been executed.
MergeQuery::STATUS_UPDATE		constant	Returned by execute() if an UPDATE query has been executed.
MergeQuery::updateFields	public	function	Adds a set of field->value pairs to be updated.
MergeQuery::useDefaults	public	function	Specifies fields for which the database-defaults should be used.
MergeQuery::where	public	function	Implements QueryConditionInterface::where(). Overrides QueryConditionInterface::where
MergeQuery::__construct	public	function	Constructs a MergeQuery object. Overrides Query::__construct
MergeQuery::__toString	public	function	Implements PHP magic __toString method to convert the query to a string. Overrides Query::__toString
MergeQuery_sqlsrv::execute	public	function	Runs the query against the database. Overrides MergeQuery::execute
Query::$comments	protected	property	An array of comments that can be prepended to a query.
Query::$connection	protected	property	The connection object on which to run this query.
Query::$connectionKey	protected	property	The key of the connection object.
Query::$connectionTarget	protected	property	The target of the connection object.
Query::$nextPlaceholder	protected	property	The placeholder counter.
Query::$queryOptions	protected	property	The query options to pass on to the connection object.
Query::$uniqueIdentifier	protected	property	A unique identifier for this query object.
Query::comment	public	function	Adds a comment to the query.
Query::getComments	public	function	Returns a reference to the comments array for the query.
Query::nextPlaceholder	public	function	Gets the next placeholder value for this query object. Overrides QueryPlaceholderInterface::nextPlaceholder
Query::uniqueIdentifier	public	function	Returns a unique identifier for this object. Overrides QueryPlaceholderInterface::uniqueIdentifier
Query::__clone	public	function	Implements the magic __clone function.	1
Query::__sleep	public	function	Implements the magic __sleep function to disconnect from the database.
Query::__wakeup	public	function	Implements the magic __wakeup function to reconnect to the database.