-h!SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SS KJ r SS K J r SS K Jr "S S \R5r"SS\ 5rSrg))ARRAY)util) coercions)elements) expression) functions)roles)schema)ColumnCollectionConstraint)InternalTraversalc\rSrSrSrSrSrS\R4S\R4S\R4/r Sr SS jr S r \R4S jr\S 5rS rg)aggregate_order_byaRepresent a PostgreSQL aggregate order by expression. E.g.:: from sqlalchemy.dialects.postgresql import aggregate_order_by expr = func.array_agg(aggregate_order_by(table.c.a, table.c.b.desc())) stmt = select(expr) would represent the expression:: SELECT array_agg(a ORDER BY b DESC) FROM table; Similarly:: expr = func.string_agg( table.c.a, aggregate_order_by(literal_column("','"), table.c.a) ) stmt = select(expr) Would represent:: SELECT string_agg(a, ',' ORDER BY a) FROM table; .. versionadded:: 1.1 .. versionchanged:: 1.2.13 - the ORDER BY argument may be multiple terms .. seealso:: :class:`_functions.array_agg` postgresqltargettypeorder_byc[R"[RU5UlURR Ul[ U5nUS:Xa [S5eUS:Xa.[R"[RUS5Ulg[R"US[R06Ulg)Nz)at least one ORDER BY element is requiredr_literal_as_text_role) rexpectr ExpressionElementRolerrlen TypeErrorrr ClauseList)selfrr_lobs wC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/postgresql/ext.py__init__aggregate_order_by.__init__@s&&u'B'BFK KK$$ 8} 19GH H QY%,,++Xa[DM%//161L1LDMNcU$N)ragainsts r self_groupaggregate_order_by.self_groupPs r"c 2URUR4$r$rr)rkwargss r get_childrenaggregate_order_by.get_childrenSs{{DMM))r"c dU"UR40UD6UlU"UR40UD6Ulgr$r*)rclonekws r_copy_internals"aggregate_order_by._copy_internalsVs,DKK.2. dmm2r2 r"c\URRURR-$r$)r _from_objectsr)rs rr4 aggregate_order_by._from_objectsZs!{{((4==+F+FFFr")rrrr$)__name__ __module__ __qualname____firstlineno____doc____visit_name__stringify_dialectr dp_clauseelementdp_type_traverse_internalsr r'r,r_cloner1propertyr4__static_attributes__r%r"rrrs} D*N$ $556 "**+ &778  *%-OO3GGr"rcz^\rSrSrSrSrSrSrSr\ R"SSS 5S 5r U4S jr SS jr S rU=r$)ExcludeConstraint_zA table-level EXCLUDE constraint. Defines an EXCLUDE constraint as described in the `PostgreSQL documentation`__. __ https://www.postgresql.org/docs/current/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE exclude_constraintNFrwherez:class:`.ExcludeConstraint`z$:paramref:`.ExcludeConstraint.where`c/n/n0Ul[U6upV[[R"[R U5U5HRuupxpn U bUR U 5 Ub UROU n U bXRU 'UR X|U 45 MT X@l[R"U/UQ7URS5URS5URS5S.6 URSS5Ul URS5n U b*[R"[RU 5UlURS 05Ulg) a: Create an :class:`.ExcludeConstraint` object. E.g.:: const = ExcludeConstraint( (Column('period'), '&&'), (Column('group'), '='), where=(Column('group') != 'some group'), ops={'group': 'my_operator_class'} ) The constraint is normally embedded into the :class:`_schema.Table` construct directly, or added later using :meth:`.append_constraint`:: some_table = Table( 'some_table', metadata, Column('id', Integer, primary_key=True), Column('period', TSRANGE()), Column('group', String) ) some_table.append_constraint( ExcludeConstraint( (some_table.c.period, '&&'), (some_table.c.group, '='), where=some_table.c.group != 'some group', name='some_table_excl_const', ops={'group': 'my_operator_class'} ) ) :param \*elements: A sequence of two tuples of the form ``(column, operator)`` where "column" is a SQL expression element or a raw SQL string, most typically a :class:`_schema.Column` object, and "operator" is a string containing the operator to use. In order to specify a column name when a :class:`_schema.Column` object is not available, while ensuring that any necessary quoting rules take effect, an ad-hoc :class:`_schema.Column` or :func:`_expression.column` object should be used. :param name: Optional, the in-database name of this constraint. :param deferrable: Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when issuing DDL for this constraint. :param initially: Optional string. If set, emit INITIALLY when issuing DDL for this constraint. :param using: Optional string. If set, emit USING when issuing DDL for this constraint. Defaults to 'gist'. :param where: Optional SQL expression construct or literal SQL string. If set, emit WHERE when issuing DDL for this constraint. :param ops: Optional dictionary. Used to define operator classes for the elements; works the same way as that of the :ref:`postgresql_ops ` parameter specified to the :class:`_schema.Index` construct. .. versionadded:: 1.3.21 .. seealso:: :ref:`postgresql_operator_classes` - general description of how PostgreSQL operator classes are specified. Nname deferrable initially)rIrJrKusinggistrGops) operatorszipr expect_col_expression_collectionr DDLConstraintColumnRoleappendrI _render_exprsr r getrLrStatementOptionRolerGrN)rrr0columns render_exprs expressionsrOexprcolumnstrname add_elementoperatorrIrGs rr ExcludeConstraint.__init__ps@n !$h >A  6 6--{   ? : 0T7( &{+"("46;;'D'/t$   X 6 7? "*"++   vvl+ff[)  VVGV, w  "))%*C*CUKDJ66%$r"c >[[U] U5 [R"UR UR 5VVVVs/sH.uup4pV[U[R5(aUOUUU4PM0 snnnnUlgs snnnnfr$) superrD _set_parentr zip_longestrTrW isinstancer ClauseElement)rtabler0rZrIr^colexpr __class__s rrbExcludeConstraint._set_parents 259483C3C""DLL4  4/&X #4)?)?@@g  4    s5B c URVs/sH=n[R"X0RU5URUR 4PM? nnUR "UUR URURURURS.6nURRUR5 U$s snf)N)rIrJrKrGrL) rWr _copy_expressionparentrOrIrhrJrKrGrLdispatch_update)r target_tabler0rZrcs r_copyExcludeConstraint._copys   %''kk<Htyy) %   NN nn****   4==)! sAC)rTrOrNrLrGr$)r6r7r8r9r:r;rG inherit_cachecreate_drop_stringify_dialectr_document_text_coercionr rbrqrB __classcell__)rhs@rrDrD_sW*N EM$0! %%%. w%  w%r  r"rDcT[US'[RR"U0UD6$)zPostgreSQL-specific form of :class:`_functions.array_agg`, ensures return type is :class:`_postgresql.ARRAY` and not the plain :class:`_types.ARRAY`, unless an explicit ``type_`` is passed. .. versionadded:: 1.1 _default_array_type)rr func array_agg)argr0s rrzrzs)!&B >> # #S /B //r"N)arrayrrsqlrrrr r r sql.schemar sql.visitorsr ColumnElementrrDrzr%r"rrsQ4-HG11HGVn2nb 0r"