class SelectQueryExtender

The base extender class for Select queries.

Hierarchy

Expanded class hierarchy of SelectQueryExtender

3 string references to 'SelectQueryExtender'
DatabaseTaggingTestCase::testExtenderHasAllTags in modules/simpletest/tests/database_test.test
Test extended query tagging "has all of these tags" functionality.
DatabaseTaggingTestCase::testExtenderHasAnyTag in modules/simpletest/tests/database_test.test
Test extended query tagging "has at least one of these tags" functionality.
DatabaseTaggingTestCase::testExtenderHasTag in modules/simpletest/tests/database_test.test
Confirm that an extended query has a "tag" added to it.

File

includes/database/select.inc, line 536

View source
class SelectQueryExtender implements SelectQueryInterface {
    
    /**
     * The SelectQuery object we are extending/decorating.
     *
     * @var SelectQueryInterface
     */
    protected $query;
    
    /**
     * The connection object on which to run this query.
     *
     * @var DatabaseConnection
     */
    protected $connection;
    
    /**
     * A unique identifier for this query object.
     */
    protected $uniqueIdentifier;
    
    /**
     * The placeholder counter.
     */
    protected $placeholder = 0;
    public function __construct(SelectQueryInterface $query, DatabaseConnection $connection) {
        $this->uniqueIdentifier = uniqid('', TRUE);
        $this->query = $query;
        $this->connection = $connection;
    }
    
    /**
     * Implements QueryPlaceholderInterface::uniqueIdentifier().
     */
    public function uniqueIdentifier() {
        return $this->uniqueIdentifier;
    }
    
    /**
     * Implements QueryPlaceholderInterface::nextPlaceholder().
     */
    public function nextPlaceholder() {
        return $this->placeholder++;
    }
    
    /* Implementations of QueryAlterableInterface. */
    public function addTag($tag) {
        $this->query
            ->addTag($tag);
        return $this;
    }
    public function hasTag($tag) {
        return $this->query
            ->hasTag($tag);
    }
    public function hasAllTags() {
        $args = func_get_args();
        return call_user_func_array(array(
            $this->query,
            'hasAllTags',
        ), $args);
    }
    public function hasAnyTag() {
        $args = func_get_args();
        return call_user_func_array(array(
            $this->query,
            'hasAnyTag',
        ), $args);
    }
    public function addMetaData($key, $object) {
        $this->query
            ->addMetaData($key, $object);
        return $this;
    }
    public function getMetaData($key) {
        return $this->query
            ->getMetaData($key);
    }
    
    /* Implementations of QueryConditionInterface for the WHERE clause. */
    public function condition($field, $value = NULL, $operator = NULL) {
        $this->query
            ->condition($field, $value, $operator);
        return $this;
    }
    public function &conditions() {
        return $this->query
            ->conditions();
    }
    public function arguments() {
        return $this->query
            ->arguments();
    }
    public function where($snippet, $args = array()) {
        $this->query
            ->where($snippet, $args);
        return $this;
    }
    public function compile(DatabaseConnection $connection, QueryPlaceholderInterface $queryPlaceholder) {
        return $this->query
            ->compile($connection, $queryPlaceholder);
    }
    public function compiled() {
        return $this->query
            ->compiled();
    }
    
    /* Implementations of QueryConditionInterface for the HAVING clause. */
    public function havingCondition($field, $value = NULL, $operator = '=') {
        $this->query
            ->havingCondition($field, $value, $operator);
        return $this;
    }
    public function &havingConditions() {
        return $this->query
            ->havingConditions();
    }
    public function havingArguments() {
        return $this->query
            ->havingArguments();
    }
    public function having($snippet, $args = array()) {
        $this->query
            ->having($snippet, $args);
        return $this;
    }
    public function havingCompile(DatabaseConnection $connection) {
        return $this->query
            ->havingCompile($connection);
    }
    
    /* Implementations of QueryExtendableInterface. */
    public function extend($extender_name) {
        // The extender can be anywhere so this needs to go to the registry, which
        // is surely loaded by now.
        $class = $this->connection
            ->getDriverClass($extender_name, array(), TRUE);
        return new $class($this, $this->connection);
    }
    
    /* Alter accessors to expose the query data to alter hooks. */
    public function &getFields() {
        return $this->query
            ->getFields();
    }
    public function &getExpressions() {
        return $this->query
            ->getExpressions();
    }
    public function &getOrderBy() {
        return $this->query
            ->getOrderBy();
    }
    public function &getGroupBy() {
        return $this->query
            ->getGroupBy();
    }
    public function &getTables() {
        return $this->query
            ->getTables();
    }
    public function &getUnion() {
        return $this->query
            ->getUnion();
    }
    public function getArguments(QueryPlaceholderInterface $queryPlaceholder = NULL) {
        return $this->query
            ->getArguments($queryPlaceholder);
    }
    public function isPrepared() {
        return $this->query
            ->isPrepared();
    }
    public function preExecute(SelectQueryInterface $query = NULL) {
        // If no query object is passed in, use $this.
        if (!isset($query)) {
            $query = $this;
        }
        return $this->query
            ->preExecute($query);
    }
    public function execute() {
        // By calling preExecute() here, we force it to preprocess the extender
        // object rather than just the base query object.  That means
        // hook_query_alter() gets access to the extended object.
        if (!$this->preExecute($this)) {
            return NULL;
        }
        return $this->query
            ->execute();
    }
    public function distinct($distinct = TRUE) {
        $this->query
            ->distinct($distinct);
        return $this;
    }
    public function addField($table_alias, $field, $alias = NULL) {
        return $this->query
            ->addField($table_alias, $field, $alias);
    }
    public function fields($table_alias, array $fields = array()) {
        $this->query
            ->fields($table_alias, $fields);
        return $this;
    }
    public function addExpression($expression, $alias = NULL, $arguments = array()) {
        return $this->query
            ->addExpression($expression, $alias, $arguments);
    }
    public function join($table, $alias = NULL, $condition = NULL, $arguments = array()) {
        return $this->query
            ->join($table, $alias, $condition, $arguments);
    }
    public function innerJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) {
        return $this->query
            ->innerJoin($table, $alias, $condition, $arguments);
    }
    public function leftJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) {
        return $this->query
            ->leftJoin($table, $alias, $condition, $arguments);
    }
    public function rightJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) {
        return $this->query
            ->rightJoin($table, $alias, $condition, $arguments);
    }
    public function addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array()) {
        return $this->query
            ->addJoin($type, $table, $alias, $condition, $arguments);
    }
    public function orderBy($field, $direction = 'ASC') {
        $this->query
            ->orderBy($field, $direction);
        return $this;
    }
    public function orderRandom() {
        $this->query
            ->orderRandom();
        return $this;
    }
    public function range($start = NULL, $length = NULL) {
        $this->query
            ->range($start, $length);
        return $this;
    }
    public function union(SelectQueryInterface $query, $type = '') {
        $this->query
            ->union($query, $type);
        return $this;
    }
    public function groupBy($field) {
        $this->query
            ->groupBy($field);
        return $this;
    }
    public function forUpdate($set = TRUE) {
        $this->query
            ->forUpdate($set);
        return $this;
    }
    public function countQuery() {
        return $this->query
            ->countQuery();
    }
    function isNull($field) {
        $this->query
            ->isNull($field);
        return $this;
    }
    function isNotNull($field) {
        $this->query
            ->isNotNull($field);
        return $this;
    }
    public function exists(SelectQueryInterface $select) {
        $this->query
            ->exists($select);
        return $this;
    }
    public function notExists(SelectQueryInterface $select) {
        $this->query
            ->notExists($select);
        return $this;
    }
    public function __toString() {
        return (string) $this->query;
    }
    public function __clone() {
        $this->uniqueIdentifier = uniqid('', TRUE);
        // We need to deep-clone the query we're wrapping, which in turn may
        // deep-clone other objects.  Exciting!
        $this->query = clone $this->query;
    }
    
    /**
     * Magic override for undefined methods.
     *
     * If one extender extends another extender, then methods in the inner extender
     * will not be exposed on the outer extender.  That's because we cannot know
     * in advance what those methods will be, so we cannot provide wrapping
     * implementations as we do above.  Instead, we use this slower catch-all method
     * to handle any additional methods.
     */
    public function __call($method, $args) {
        $return = call_user_func_array(array(
            $this->query,
            $method,
        ), $args);
        // Some methods will return the called object as part of a fluent interface.
        // Others will return some useful value.  If it's a value, then the caller
        // probably wants that value.  If it's the called object, then we instead
        // return this object.  That way we don't "lose" an extender layer when
        // chaining methods together.
        if ($return instanceof SelectQueryInterface) {
            return $this;
        }
        else {
            return $return;
        }
    }

}

Members

Title Sort descending Modifiers Object type Summary Overriden Title Overrides
SelectQueryExtender::$connection protected property The connection object on which to run this query.
SelectQueryExtender::$placeholder protected property The placeholder counter.
SelectQueryExtender::$query protected property The SelectQuery object we are extending/decorating.
SelectQueryExtender::$uniqueIdentifier protected property A unique identifier for this query object.
SelectQueryExtender::addExpression public function Adds an expression to the list of "fields" to be SELECTed. Overrides SelectQueryInterface::addExpression
SelectQueryExtender::addField public function Adds a field to the list to be SELECTed. Overrides SelectQueryInterface::addField
SelectQueryExtender::addJoin public function Join against another table in the database. Overrides SelectQueryInterface::addJoin
SelectQueryExtender::addMetaData public function Adds additional metadata to the query. Overrides QueryAlterableInterface::addMetaData
SelectQueryExtender::addTag public function Adds a tag to a query. Overrides QueryAlterableInterface::addTag
SelectQueryExtender::arguments public function Gets a complete list of all values to insert into the prepared statement. Overrides QueryConditionInterface::arguments
SelectQueryExtender::compile public function Compiles the saved conditions for later retrieval. Overrides QueryConditionInterface::compile
SelectQueryExtender::compiled public function Check whether a condition has been previously compiled. Overrides QueryConditionInterface::compiled
SelectQueryExtender::condition public function Helper function: builds the most common conditional clauses. Overrides QueryConditionInterface::condition
SelectQueryExtender::conditions public function Gets a complete list of all conditions in this conditional clause. Overrides QueryConditionInterface::conditions
SelectQueryExtender::countQuery public function Get the equivalent COUNT query of this query as a new query object. Overrides SelectQueryInterface::countQuery 1
SelectQueryExtender::distinct public function Sets this query to be DISTINCT. Overrides SelectQueryInterface::distinct
SelectQueryExtender::execute public function 2
SelectQueryExtender::exists public function Sets a condition that the specified subquery returns values. Overrides QueryConditionInterface::exists
SelectQueryExtender::extend public function Enhance this object by wrapping it in an extender object. Overrides QueryExtendableInterface::extend
SelectQueryExtender::fields public function Add multiple fields from the same table to be SELECTed. Overrides SelectQueryInterface::fields
SelectQueryExtender::forUpdate public function Add FOR UPDATE to the query. Overrides SelectQueryInterface::forUpdate
SelectQueryExtender::getArguments public function Compiles and returns an associative array of the arguments for this prepared statement. Overrides SelectQueryInterface::getArguments
SelectQueryExtender::getExpressions public function Returns a reference to the expressions array for this query. Overrides SelectQueryInterface::getExpressions
SelectQueryExtender::getFields public function Returns a reference to the fields array for this query. Overrides SelectQueryInterface::getFields
SelectQueryExtender::getGroupBy public function Returns a reference to the group-by array for this query. Overrides SelectQueryInterface::getGroupBy
SelectQueryExtender::getMetaData public function Retrieves a given piece of metadata. Overrides QueryAlterableInterface::getMetaData
SelectQueryExtender::getOrderBy public function Returns a reference to the order by array for this query. Overrides SelectQueryInterface::getOrderBy
SelectQueryExtender::getTables public function Returns a reference to the tables array for this query. Overrides SelectQueryInterface::getTables
SelectQueryExtender::getUnion public function Returns a reference to the union queries for this query. This include
queries for UNION, UNION ALL, and UNION DISTINCT.
Overrides SelectQueryInterface::getUnion
SelectQueryExtender::groupBy public function Groups the result set by the specified field. Overrides SelectQueryInterface::groupBy
SelectQueryExtender::hasAllTags public function Determines if a given query has all specified tags. Overrides QueryAlterableInterface::hasAllTags
SelectQueryExtender::hasAnyTag public function Determines if a given query has any specified tag. Overrides QueryAlterableInterface::hasAnyTag
SelectQueryExtender::hasTag public function Determines if a given query has a given tag. Overrides QueryAlterableInterface::hasTag
SelectQueryExtender::having public function
SelectQueryExtender::havingArguments public function
SelectQueryExtender::havingCompile public function
SelectQueryExtender::havingCondition public function Helper function to build most common HAVING conditional clauses. Overrides SelectQueryInterface::havingCondition
SelectQueryExtender::havingConditions public function
SelectQueryExtender::innerJoin public function Inner Join against another table in the database. Overrides SelectQueryInterface::innerJoin
SelectQueryExtender::isNotNull function Sets a condition that the specified field be NOT NULL. Overrides QueryConditionInterface::isNotNull
SelectQueryExtender::isNull function Sets a condition that the specified field be NULL. Overrides QueryConditionInterface::isNull
SelectQueryExtender::isPrepared public function Indicates if preExecute() has already been called on that object. Overrides SelectQueryInterface::isPrepared
SelectQueryExtender::join public function Default Join against another table in the database. Overrides SelectQueryInterface::join
SelectQueryExtender::leftJoin public function Left Outer Join against another table in the database. Overrides SelectQueryInterface::leftJoin
SelectQueryExtender::nextPlaceholder public function Implements QueryPlaceholderInterface::nextPlaceholder(). Overrides QueryPlaceholderInterface::nextPlaceholder
SelectQueryExtender::notExists public function Sets a condition that the specified subquery returns no values. Overrides QueryConditionInterface::notExists
SelectQueryExtender::orderBy public function Orders the result set by a given field. Overrides SelectQueryInterface::orderBy
SelectQueryExtender::orderRandom public function Orders the result set by a random value. Overrides SelectQueryInterface::orderRandom
SelectQueryExtender::preExecute public function Generic preparation and validation for a SELECT query. Overrides SelectQueryInterface::preExecute
SelectQueryExtender::range public function Restricts a query to a given range in the result set. Overrides SelectQueryInterface::range
SelectQueryExtender::rightJoin public function Right Outer Join against another table in the database. Overrides SelectQueryInterface::rightJoin
SelectQueryExtender::union public function Add another Select query to UNION to this one. Overrides SelectQueryInterface::union
SelectQueryExtender::uniqueIdentifier public function Implements QueryPlaceholderInterface::uniqueIdentifier(). Overrides QueryPlaceholderInterface::uniqueIdentifier
SelectQueryExtender::where public function Adds an arbitrary WHERE clause to the query. Overrides QueryConditionInterface::where
SelectQueryExtender::__call public function Magic override for undefined methods.
SelectQueryExtender::__clone public function Clone magic method. Overrides SelectQueryInterface::__clone
SelectQueryExtender::__construct public function 2
SelectQueryExtender::__toString public function

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.