MCPcopy Create free account
hub / github.com/sqlalchemy/sqlalchemy / over

Method over

lib/sqlalchemy/sql/elements.py:4399–4422  ·  view source on GitHub ↗

Produce an OVER clause against this :class:`.WithinGroup` construct. This function has the same signature as that of :meth:`.FunctionElement.over`.

(
        self,
        *,
        partition_by: Optional[_ByArgument] = None,
        order_by: Optional[_ByArgument] = None,
        rows: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
        range_: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
        groups: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
    )

Source from the content-addressed store, hash-verified

4397 )
4398
4399 def over(
4400 self,
4401 *,
4402 partition_by: Optional[_ByArgument] = None,
4403 order_by: Optional[_ByArgument] = None,
4404 rows: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
4405 range_: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
4406 groups: Optional[typing_Tuple[Optional[int], Optional[int]]] = None,
4407 ) -> Over[_T]:
4408 """Produce an OVER clause against this :class:`.WithinGroup`
4409 construct.
4410
4411 This function has the same signature as that of
4412 :meth:`.FunctionElement.over`.
4413
4414 """
4415 return Over(
4416 self,
4417 partition_by=partition_by,
4418 order_by=order_by,
4419 range_=range_,
4420 rows=rows,
4421 groups=groups,
4422 )
4423
4424 @overload
4425 def filter(self) -> Self: ...

Calls 1

OverClass · 0.85