class DeleteQuery_sqlite
SQLite specific implementation of DeleteQuery.
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.
Hierarchy
- class \Query implements QueryPlaceholderInterface
- class \DeleteQuery implements QueryConditionInterface
- class \DeleteQuery_sqlite
- class \DeleteQuery implements QueryConditionInterface
Expanded class hierarchy of DeleteQuery_sqlite
Related topics
File
- drupal-7.x/
includes/ database/ sqlite/ query.inc, line 110 - Query code for SQLite embedded database engine.
View source
class DeleteQuery_sqlite extends DeleteQuery {
public function execute() {
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 | Modifiers | Type | Description |
---|---|---|---|
Query:: |
public | function | Implements the magic __wakeup function to reconnect to the database. |
Query:: |
public | function | Implements the magic __sleep function to disconnect from the database. |
Query:: |
public | function | Implements the magic __clone function. |
Query:: |
public | function |
Returns a unique identifier for this object. Overrides QueryPlaceholderInterface:: |
Query:: |
public | function |
Gets the next placeholder value for this query object. Overrides QueryPlaceholderInterface:: |
Query:: |
public | function | Returns a reference to the comments array for the query. |
Query:: |
public | function | Adds a comment to the query. |
Query:: |
protected | property | A unique identifier for this query object. |
Query:: |
protected | property | The query options to pass on to the connection object. |
Query:: |
protected | property | The placeholder counter. |
Query:: |
protected | property | The target of the connection object. |
Query:: |
protected | property | The key of the connection object. |
Query:: |
protected | property | The connection object on which to run this query. |
Query:: |
protected | property | An array of comments that can be prepended to a query. |
DeleteQuery_sqlite:: |
public | function |
Executes the DELETE query. Overrides DeleteQuery:: |
DeleteQuery:: |
public | function |
Implements PHP magic __toString method to convert the query to a string. Overrides Query:: |
DeleteQuery:: |
public | function |
Constructs a DeleteQuery object. Overrides Query:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::where(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::notExists(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::isNull(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::isNotNull(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::exists(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::conditions(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::condition(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::compiled(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::compile(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
public | function |
Implements QueryConditionInterface::arguments(). Overrides QueryConditionInterface:: |
DeleteQuery:: |
protected | property | The table from which to delete. |
DeleteQuery:: |
protected | property | The condition object for this query. |