class Subquery

Attributes
Methods

from django.db.models.expressions import Subquery

An explicit subquery. It may contain OuterRef() references to the outer
query which will be resolved when it is applied to that query.

Ancestors (MRO)

builtins.object
django.db.models.expressions.Combinable
django.db.models.expressions.BaseExpression
django.db.models.expressions.Subquery

Attributes

Attribute	Value	Defined in
`ADD`	`+`	django.db.models.expressions.Combinable
`BITAND`	`&`	django.db.models.expressions.Combinable
`BITLEFTSHIFT`	`<<`	django.db.models.expressions.Combinable
`BITOR`	`\|`	django.db.models.expressions.Combinable
`BITRIGHTSHIFT`	`>>`	django.db.models.expressions.Combinable
`BITXOR`	`#`	django.db.models.expressions.Combinable
`DIV`	`/`	django.db.models.expressions.Combinable
`MOD`	`%%`	django.db.models.expressions.Combinable
`MUL`	`*`	django.db.models.expressions.Combinable
`POW`	`^`	django.db.models.expressions.Combinable
`SUB`	`-`	django.db.models.expressions.Combinable
`allowed_default`	`False`	django.db.models.expressions.BaseExpression
`contains_aggregate`	`False`	django.db.models.expressions.Subquery
`empty_result_set_value`	`None`	django.db.models.expressions.Subquery
`empty_result_set_value`	`NotImplemented`	django.db.models.expressions.BaseExpression
`filterable`	`True`	django.db.models.expressions.BaseExpression
`is_summary`	`False`	django.db.models.expressions.BaseExpression
`subquery`	`True`	django.db.models.expressions.Subquery
`template`	`(%(subquery)s)`	django.db.models.expressions.Subquery
`window_compatible`	`False`	django.db.models.expressions.BaseExpression

Methods

def as_sql(self, compiler, connection, template=None, **extra_context)

django.db.models.expressions.Subquery

Responsible for returning a (sql, [params]) tuple to be included
in the current query.

Different backends can provide their own implementation, by
providing an `as_{vendor}` method and patching the Expression:

```
def override_as_sql(self, compiler, connection):
    # custom logic
    return super().as_sql(compiler, connection)
setattr(Expression, 'as_' + connection.vendor, override_as_sql)
```

Arguments:
 * compiler: the query compiler responsible for generating the query.
   Must have a compile method, returning a (sql, [params]) tuple.
   Calling compiler(value) will return a quoted `value`.

 * connection: the database connection used for the current query.

Return: (sql, params)
  Where `sql` is a string containing ordered sql parameters to be
  replaced with the elements of the list `params`.

    def as_sql(self, compiler, connection, template=None, **extra_context):
        connection.ops.check_expression_support(self)
        template_params = {**self.extra, **extra_context}
        subquery_sql, sql_params = self.query.as_sql(compiler, connection)
        template_params["subquery"] = subquery_sql[1:-1]

        template = template or template_params.get("template", self.template)
        sql = template % template_params
        return sql, sql_params

django.db.models.expressions.BaseExpression

Responsible for returning a (sql, [params]) tuple to be included
in the current query.

Different backends can provide their own implementation, by
providing an `as_{vendor}` method and patching the Expression:

```
def override_as_sql(self, compiler, connection):
    # custom logic
    return super().as_sql(compiler, connection)
setattr(Expression, 'as_' + connection.vendor, override_as_sql)
```

Arguments:
 * compiler: the query compiler responsible for generating the query.
   Must have a compile method, returning a (sql, [params]) tuple.
   Calling compiler(value) will return a quoted `value`.

 * connection: the database connection used for the current query.

Return: (sql, params)
  Where `sql` is a string containing ordered sql parameters to be
  replaced with the elements of the list `params`.

    def as_sql(self, compiler, connection):
        """
        Responsible for returning a (sql, [params]) tuple to be included
        in the current query.

        Different backends can provide their own implementation, by
        providing an `as_{vendor}` method and patching the Expression:

        ```
        def override_as_sql(self, compiler, connection):
            # custom logic
            return super().as_sql(compiler, connection)
        setattr(Expression, 'as_' + connection.vendor, override_as_sql)
        ```

        Arguments:
         * compiler: the query compiler responsible for generating the query.
           Must have a compile method, returning a (sql, [params]) tuple.
           Calling compiler(value) will return a quoted `value`.

         * connection: the database connection used for the current query.

        Return: (sql, params)
          Where `sql` is a string containing ordered sql parameters to be
          replaced with the elements of the list `params`.
        """
        raise NotImplementedError("Subclasses must implement as_sql()")

def asc(self, **kwargs)

django.db.models.expressions.BaseExpression

    def asc(self, **kwargs):
        return OrderBy(self, **kwargs)

def bitand(self, other)

django.db.models.expressions.Combinable

    def bitand(self, other):
        return self._combine(other, self.BITAND, False)

def bitleftshift(self, other)

django.db.models.expressions.Combinable

    def bitleftshift(self, other):
        return self._combine(other, self.BITLEFTSHIFT, False)

def bitor(self, other)

django.db.models.expressions.Combinable

    def bitor(self, other):
        return self._combine(other, self.BITOR, False)

def bitrightshift(self, other)

django.db.models.expressions.Combinable

    def bitrightshift(self, other):
        return self._combine(other, self.BITRIGHTSHIFT, False)

def bitxor(self, other)

django.db.models.expressions.Combinable

    def bitxor(self, other):
        return self._combine(other, self.BITXOR, False)

def conditional(self)

django.db.models.expressions.BaseExpression

def contains_aggregate(self)

django.db.models.expressions.BaseExpression

def contains_column_references(self)

django.db.models.expressions.BaseExpression

def contains_over_clause(self)

django.db.models.expressions.BaseExpression

def contains_subquery(self)

django.db.models.expressions.BaseExpression

def convert_value(self)

django.db.models.expressions.BaseExpression

Expressions provide their own converters because users have the option
of manually specifying the output_field which may be a different type
from the one the database returns.

def copy(self)

django.db.models.expressions.Subquery

    def copy(self):
        clone = super().copy()
        clone.query = clone.query.clone()
        return clone

django.db.models.expressions.BaseExpression

    def copy(self):
        return copy.copy(self)

def desc(self, **kwargs)

django.db.models.expressions.BaseExpression

    def desc(self, **kwargs):
        return OrderBy(self, descending=True, **kwargs)

def external_aliases(self)

django.db.models.expressions.Subquery

def field(self)

django.db.models.expressions.BaseExpression

def flatten(self)

django.db.models.expressions.BaseExpression

Recursively yield this expression and all subexpressions, in
depth-first order.

    def flatten(self):
        """
        Recursively yield this expression and all subexpressions, in
        depth-first order.
        """
        yield self
        for expr in self.get_source_expressions():
            if expr:
                if hasattr(expr, "flatten"):
                    yield from expr.flatten()
                else:
                    yield expr

def get_db_converters(self, connection)

django.db.models.expressions.BaseExpression

    def get_db_converters(self, connection):
        return (
            []
            if self.convert_value is self._convert_value_noop
            else [self.convert_value]
        ) + self.output_field.get_db_converters(connection)

def get_external_cols(self)

django.db.models.expressions.Subquery

    def get_external_cols(self):
        return self.query.get_external_cols()

def get_group_by_cols(self)

django.db.models.expressions.Subquery

    def get_group_by_cols(self):
        return self.query.get_group_by_cols(wrapper=self)

django.db.models.expressions.BaseExpression

    def get_group_by_cols(self):
        if not self.contains_aggregate:
            return [self]
        cols = []
        for source in self.get_source_expressions():
            cols.extend(source.get_group_by_cols())
        return cols

def get_lookup(self, lookup)

django.db.models.expressions.BaseExpression

    def get_lookup(self, lookup):
        return self.output_field.get_lookup(lookup)

def get_refs(self)

django.db.models.expressions.BaseExpression

    def get_refs(self):
        refs = set()
        for expr in self.get_source_expressions():
            refs |= expr.get_refs()
        return refs

def get_source_expressions(self)

django.db.models.expressions.Subquery

    def get_source_expressions(self):
        return [self.query]

django.db.models.expressions.BaseExpression

    def get_source_expressions(self):
        return []

def get_source_fields(self)

django.db.models.expressions.BaseExpression

Return the underlying field types used by this aggregate.

    def get_source_fields(self):
        """Return the underlying field types used by this aggregate."""
        return [e._output_field_or_none for e in self.get_source_expressions()]

def get_transform(self, name)

django.db.models.expressions.BaseExpression

    def get_transform(self, name):
        return self.output_field.get_transform(name)

def output_field(self)

django.db.models.expressions.BaseExpression

Return the output type of this expressions.

def prefix_references(self, prefix)

django.db.models.expressions.BaseExpression

    def prefix_references(self, prefix):
        clone = self.copy()
        clone.set_source_expressions(
            [
                (
                    F(f"{prefix}{expr.name}")
                    if isinstance(expr, F)
                    else expr.prefix_references(prefix)
                )
                for expr in self.get_source_expressions()
            ]
        )
        return clone

def relabeled_clone(self, change_map)

django.db.models.expressions.BaseExpression

    def relabeled_clone(self, change_map):
        clone = self.copy()
        clone.set_source_expressions(
            [
                e.relabeled_clone(change_map) if e is not None else None
                for e in self.get_source_expressions()
            ]
        )
        return clone

def replace_expressions(self, replacements)

django.db.models.expressions.BaseExpression

    def replace_expressions(self, replacements):
        if replacement := replacements.get(self):
            return replacement
        clone = self.copy()
        source_expressions = clone.get_source_expressions()
        clone.set_source_expressions(
            [
                expr.replace_expressions(replacements) if expr else None
                for expr in source_expressions
            ]
        )
        return clone

def resolve_expression(self, query=None, allow_joins=True, reuse=None, summarize=False, for_save=False)

django.db.models.expressions.BaseExpression

Provide the chance to do any preprocessing or validation before being
added to the query.

Arguments:
 * query: the backend query implementation
 * allow_joins: boolean allowing or denying use of joins
   in this query
 * reuse: a set of reusable joins for multijoins
 * summarize: a terminal aggregate clause
 * for_save: whether this expression about to be used in a save or update

Return: an Expression to be added to the query.

    def resolve_expression(
        self, query=None, allow_joins=True, reuse=None, summarize=False, for_save=False
    ):
        """
        Provide the chance to do any preprocessing or validation before being
        added to the query.

        Arguments:
         * query: the backend query implementation
         * allow_joins: boolean allowing or denying use of joins
           in this query
         * reuse: a set of reusable joins for multijoins
         * summarize: a terminal aggregate clause
         * for_save: whether this expression about to be used in a save or update

        Return: an Expression to be added to the query.
        """
        c = self.copy()
        c.is_summary = summarize
        c.set_source_expressions(
            [
                (
                    expr.resolve_expression(query, allow_joins, reuse, summarize)
                    if expr
                    else None
                )
                for expr in c.get_source_expressions()
            ]
        )
        return c

def reverse_ordering(self)

django.db.models.expressions.BaseExpression

    def reverse_ordering(self):
        return self

def select_format(self, compiler, sql, params)

django.db.models.expressions.BaseExpression

Custom format for select clauses. For example, EXISTS expressions need
to be wrapped in CASE WHEN on Oracle.

    def select_format(self, compiler, sql, params):
        """
        Custom format for select clauses. For example, EXISTS expressions need
        to be wrapped in CASE WHEN on Oracle.
        """
        if hasattr(self.output_field, "select_format"):
            return self.output_field.select_format(compiler, sql, params)
        return sql, params

def set_source_expressions(self, exprs)

django.db.models.expressions.Subquery

    def set_source_expressions(self, exprs):
        self.query = exprs[0]

django.db.models.expressions.BaseExpression

    def set_source_expressions(self, exprs):
        assert not exprs