class DeleteQuery_sqlite

SQLite specific implementation of DeleteQuery.

Hierarchy

Expanded class hierarchy of DeleteQuery_sqlite

Related topics

File

drupal/includes/database/sqlite/query.inc, line 103
Query code for SQLite embedded database engine.

View source
class DeleteQuery_sqlite extends DeleteQuery {
  public function execute() {

    // When the WHERE is omitted from a DELETE statement and the table being
    // deleted has no triggers, SQLite uses an optimization to erase the entire
    // table content without having to visit each row of the table individually.
    // Prior to SQLite 3.6.5, SQLite does not return the actual number of rows
    // deleted by that optimized "truncate" optimization. But we want to return
    // the number of rows affected, so we calculate it directly.
    if (!count($this->condition)) {
      $total_rows = $this->connection
        ->query('SELECT COUNT(*) FROM {' . $this->connection
        ->escapeTable($this->table) . '}')
        ->fetchField();
      parent::execute();
      return $total_rows;
    }
    else {
      return parent::execute();
    }
  }

}

Members

Name Modifierssort descending Type Description Overrides
DeleteQuery::$table protected property The table from which to delete.
DeleteQuery::$condition protected property The condition object for this query.
Query::$connection protected property The connection object on which to run this query.
Query::$connectionTarget protected property The target of the connection object.
Query::$connectionKey protected property The key of the connection object.
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::$nextPlaceholder protected property The placeholder counter.
Query::$comments protected property An array of comments that can be prepended to a query.
DeleteQuery_sqlite::execute public function Executes the DELETE query. Overrides DeleteQuery::execute
DeleteQuery::__construct public function Constructs a DeleteQuery object. Overrides Query::__construct
DeleteQuery::condition public function Implements QueryConditionInterface::condition(). Overrides QueryConditionInterface::condition
DeleteQuery::isNull public function Implements QueryConditionInterface::isNull(). Overrides QueryConditionInterface::isNull
DeleteQuery::isNotNull public function Implements QueryConditionInterface::isNotNull(). Overrides QueryConditionInterface::isNotNull
DeleteQuery::exists public function Implements QueryConditionInterface::exists(). Overrides QueryConditionInterface::exists
DeleteQuery::notExists public function Implements QueryConditionInterface::notExists(). Overrides QueryConditionInterface::notExists
DeleteQuery::conditions public function Implements QueryConditionInterface::conditions(). Overrides QueryConditionInterface::conditions
DeleteQuery::arguments public function Implements QueryConditionInterface::arguments(). Overrides QueryConditionInterface::arguments
DeleteQuery::where public function Implements QueryConditionInterface::where(). Overrides QueryConditionInterface::where
DeleteQuery::compile public function Implements QueryConditionInterface::compile(). Overrides QueryConditionInterface::compile
DeleteQuery::compiled public function Implements QueryConditionInterface::compiled(). Overrides QueryConditionInterface::compiled
DeleteQuery::__toString public function Implements PHP magic __toString method to convert the query to a string. Overrides Query::__toString
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.
Query::__clone public function Implements the magic __clone function. 1
Query::uniqueIdentifier public function Returns a unique identifier for this object. Overrides QueryPlaceholderInterface::uniqueIdentifier
Query::nextPlaceholder public function Gets the next placeholder value for this query object. Overrides QueryPlaceholderInterface::nextPlaceholder
Query::comment public function Adds a comment to the query.
Query::getComments public function Returns a reference to the comments array for the query.