SelectQuery_sqlite

  1. drupal
    1. 8
    2. 7

SQLite specific query builder for SELECT statements.

Hierarchy

Properties

NameDescription
Query::$commentsAn array of comments that can be prepended to a query.
Query::$connectionThe connection object on which to run this query.
Query::$connectionKeyThe key of the connection object.
Query::$connectionTargetThe target of the connection object.
Query::$queryOptionsThe query options to pass on to the connection object.
SelectQuery::$expressionsThe expressions to SELECT as virtual fields.
SelectQuery::$groupThe fields by which to group.
SelectQuery::$orderThe fields by which to order this query.
SelectQuery::$preparedIndicates if preExecute() has already been called.
SelectQuery::$tablesThe tables against which to JOIN.

Functions & methods

NameDescription
Query::commentAdds a comment to the query.
Query::getCommentsReturns a reference to the comments array for the query.
Query::nextPlaceholderGets the next placeholder value for this query object. Overrides QueryPlaceholderInterface::nextPlaceholder
Query::uniqueIdentifierReturns a unique identifier for this object. Overrides QueryPlaceholderInterface::uniqueIdentifier
Query::__sleepImplements the magic __sleep function to disconnect from the database.
Query::__wakeupImplements the magic __wakeup function to reconnect to the database.
SelectQuery::addExpressionAdds an expression to the list of "fields" to be SELECTed. Overrides SelectQueryInterface::addExpression
SelectQuery::addFieldAdds a field to the list to be SELECTed. Overrides SelectQueryInterface::addField
SelectQuery::addJoinJoin against another table in the database. Overrides SelectQueryInterface::addJoin
SelectQuery::addMetaData
SelectQuery::addTag
SelectQuery::arguments
SelectQuery::compile
SelectQuery::compiled
SelectQuery::condition
SelectQuery::conditions
SelectQuery::countQueryGet the equivalent COUNT query of this query as a new query object. Overrides SelectQueryInterface::countQuery
SelectQuery::distinctSets this query to be DISTINCT. Overrides SelectQueryInterface::distinct
SelectQuery::executeRuns the query against the database. Overrides Query::execute
SelectQuery::exists
SelectQuery::extend
SelectQuery::fieldsAdd multiple fields from the same table to be SELECTed. Overrides SelectQueryInterface::fields
SelectQuery::getArgumentsCompiles and returns an associative array of the arguments for this prepared statement. Overrides SelectQueryInterface::getArguments
SelectQuery::getExpressionsReturns a reference to the expressions array for this query. Overrides SelectQueryInterface::getExpressions
SelectQuery::getFieldsReturns a reference to the fields array for this query. Overrides SelectQueryInterface::getFields
SelectQuery::getGroupByReturns a reference to the group-by array for this query. Overrides SelectQueryInterface::getGroupBy
SelectQuery::getMetaData
SelectQuery::getOrderByReturns a reference to the order by array for this query. Overrides SelectQueryInterface::getOrderBy
SelectQuery::getTablesReturns a reference to the tables array for this query. Overrides SelectQueryInterface::getTables
SelectQuery::getUnionReturns a reference to the union queries for this query. This include queries for UNION, UNION ALL, and UNION DISTINCT. Overrides SelectQueryInterface::getUnion
SelectQuery::groupByGroups the result set by the specified field. Overrides SelectQueryInterface::groupBy
SelectQuery::hasAllTags
SelectQuery::hasAnyTag
SelectQuery::hasTag
SelectQuery::having
SelectQuery::havingArguments
SelectQuery::havingCompile
SelectQuery::havingConditionHelper function to build most common HAVING conditional clauses. Overrides SelectQueryInterface::havingCondition
SelectQuery::havingConditions
SelectQuery::havingExists
SelectQuery::havingIsNotNull
SelectQuery::havingIsNull
SelectQuery::havingNotExists
SelectQuery::innerJoinInner Join against another table in the database. Overrides SelectQueryInterface::innerJoin
SelectQuery::isNotNull
SelectQuery::isNull
SelectQuery::isPreparedIndicates if preExecute() has already been called on that object. Overrides SelectQueryInterface::isPrepared
SelectQuery::joinDefault Join against another table in the database. Overrides SelectQueryInterface::join
SelectQuery::leftJoinLeft Outer Join against another table in the database. Overrides SelectQueryInterface::leftJoin
SelectQuery::notExists
SelectQuery::orderByOrders the result set by a given field. Overrides SelectQueryInterface::orderBy
SelectQuery::orderRandomOrders the result set by a random value. Overrides SelectQueryInterface::orderRandom
SelectQuery::preExecuteGeneric preparation and validation for a SELECT query. Overrides SelectQueryInterface::preExecute
SelectQuery::rangeRestricts a query to a given range in the result set. Overrides SelectQueryInterface::range
SelectQuery::rightJoinRight Outer Join against another table in the database. Overrides SelectQueryInterface::rightJoin
SelectQuery::unionAdd another Select query to UNION to this one. Overrides SelectQueryInterface::union
SelectQuery::where
SelectQuery::__cloneImplements the magic __clone function. Overrides Query::__clone
SelectQuery::__constructConstructs a Query object. Overrides Query::__construct
SelectQuery::__toStringImplements PHP magic __toString method to convert the query to a string. Overrides Query::__toString
SelectQuery_sqlite::forUpdateAdd FOR UPDATE to the query. Overrides SelectQuery::forUpdate

includes/database/sqlite/select.inc, line 16

View source
<?php
class SelectQuery_sqlite extends SelectQuery {
  public function forUpdate($set = TRUE) {
    // SQLite does not support FOR UPDATE so nothing to do.
    return $this;
  }
}
?>

Related topics