Django 5.1.dev 文档

up

django.contrib.postgres.aggregates.general 源代码

from django.contrib.postgres.fields import ArrayField
from django.db.models import Aggregate, BooleanField, JSONField, TextField, Value

from .mixins import OrderableAggMixin

__all__ = [
    "ArrayAgg",
    "BitAnd",
    "BitOr",
    "BitXor",
    "BoolAnd",
    "BoolOr",
    "JSONBAgg",
    "StringAgg",
]




[文档]
class ArrayAgg(OrderableAggMixin, Aggregate):
    function = "ARRAY_AGG"
    template = "%(function)s(%(distinct)s%(expressions)s %(ordering)s)"
    allow_distinct = True

    @property
    def output_field(self):
        return ArrayField(self.source_expressions[0].output_field)






[文档]
class BitAnd(Aggregate):
    function = "BIT_AND"






[文档]
class BitOr(Aggregate):
    function = "BIT_OR"






[文档]
class BitXor(Aggregate):
    function = "BIT_XOR"






[文档]
class BoolAnd(Aggregate):
    function = "BOOL_AND"
    output_field = BooleanField()






[文档]
class BoolOr(Aggregate):
    function = "BOOL_OR"
    output_field = BooleanField()






[文档]
class JSONBAgg(OrderableAggMixin, Aggregate):
    function = "JSONB_AGG"
    template = "%(function)s(%(distinct)s%(expressions)s %(ordering)s)"
    allow_distinct = True
    output_field = JSONField()






[文档]
class StringAgg(OrderableAggMixin, Aggregate):
    function = "STRING_AGG"
    template = "%(function)s(%(distinct)s%(expressions)s %(ordering)s)"
    allow_distinct = True
    output_field = TextField()

    def __init__(self, expression, delimiter, **extra):
        delimiter_expr = Value(str(delimiter))
        super().__init__(expression, delimiter_expr, **extra)
up