class TruncateQuery_sqlite in Drupal 7

SQLite specific implementation of TruncateQuery.

SQLite doesn't support TRUNCATE, but a DELETE query with no condition has exactly the effect (it is implemented by DROPing the table).

Hierarchy

• class \Query implements QueryPlaceholderInterface
  • class \TruncateQuery
    • class \TruncateQuery_sqlite

Related topics

Database abstraction layer

Allow the use of different database servers using the same code base.

File

includes/database/sqlite/query.inc, line 131

Query code for SQLite embedded database engine.

class TruncateQuery_sqlite extends TruncateQuery {
  public function __toString() {

    // Create a sanitized comment string to prepend to the query.
    $comments = $this->connection
      ->makeComment($this->comments);
    return $comments . 'DELETE FROM {' . $this->connection
      ->escapeTable($this->table) . '} ';
  }

}

Members

Name	Modifiers	Type	Description	Overrides
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.
TruncateQuery::$table	protected	property	The table to truncate.
TruncateQuery::compile	public	function	Implements QueryConditionInterface::compile().
TruncateQuery::compiled	public	function	Implements QueryConditionInterface::compiled().
TruncateQuery::execute	public	function	Executes the TRUNCATE query. Overrides Query::execute
TruncateQuery::__construct	public	function	Constructs a TruncateQuery object. Overrides Query::__construct
TruncateQuery_sqlite::__toString	public	function	Implements PHP magic __toString method to convert the query to a string. Overrides TruncateQuery::__toString