o y¬´\ñã@sjddlmZddlmZddlmZddlmZddlmZGdd„dejƒZ Gd d „d eƒZ d d „Z d S)é)ÚARRAYé)Úelements)Ú expression)Ú functions)ÚColumnCollectionConstraintc@sHeZdZdZdZdd„Zd dd„Zdd„Zej fd d „Z e d d „ƒZ dS)Úaggregate_order_byaõRepresent 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:`.array_agg` cGsXt |¡|_t|ƒ}|dkrtdƒ‚|dkr t |d¡|_dStj|dtjiŽ|_dS)Néz)at least one ORDER BY element is requiredrÚ_literal_as_text)rÚ_literal_as_bindsÚtargetÚlenÚ TypeErrorÚorder_byÚ ClauseList)Úselfr rÚ_lob©rúT/var/www/html/env/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/ext.pyÚ__init__4s ÿ ÿzaggregate_order_by.__init__NcCs|S©Nr)rÚagainstrrrÚ self_groupAszaggregate_order_by.self_groupcKs |j|jfSr©r r)rÚkwargsrrrÚ get_childrenDs zaggregate_order_by.get_childrencKs,||jfi|¤Ž|_||jfi|¤Ž|_dSrr)rÚcloneÚkwrrrÚ_copy_internalsGsz"aggregate_order_by._copy_internalscCs|jj|jjSr)r Ú _from_objectsr©rrrrrKsz aggregate_order_by._from_objectsr) Ú__name__Ú __module__Ú __qualname__Ú__doc__Ú__visit_name__rrrrÚ_clonerÚpropertyrrrrrrs" rc@s(eZdZdZdZdZdd„Zdd„ZdS)ÚExcludeConstraintzÝA table-level EXCLUDE constraint. Defines an EXCLUDE constraint as described in the `postgres documentation`__. __ http://www.postgresql.org/docs/9.0/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE Úexclude_constraintNcOsôg}g}i|_t|Ž\}}t| |¡|ƒD]0\\}}} } } | dur&| | ¡|dur-|jn| } | dur8| |j| <t |¡}| || | f¡q||_tj |g|¢R|  d¡|  d¡|  d¡dœŽ|  dd¡|_ |  d¡} | durxt | ¡|_ dSdS) aÍ Create an :class:`.ExcludeConstraint` object. E.g.:: const = ExcludeConstraint( (Column('period'), '&&'), (Column('group'), '='), where=(Column('group') != 'some group') ) The constraint is normally embedded into the :class:`.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' ) ) :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:`.Column` object, and "operator" is a string containing the operator to use. .. note:: A plain string passed for the value of "column" is interpreted as an arbitrary SQL expression; when passing a plain string, any necessary quoting and escaping syntaxes must be applied manually. In order to specify a column name when a :class:`.Column` object is not available, while ensuring that any necessary quoting rules take effect, an ad-hoc :class:`.Column` or :func:`.sql.expression.column` object may 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. .. note:: A plain string passed here is interpreted as an arbitrary SQL expression; when passing a plain string, any necessary quoting and escaping syntaxes must be applied manually. NÚnameÚ deferrableÚ initially)r*r+r,ÚusingÚgistÚwhere) Ú operatorsÚzipÚ"_extract_col_expression_collectionÚappendr*rr Ú _render_exprsrrÚgetr-r/)rrrÚcolumnsÚ render_exprsÚ expressionsr0ÚexprÚcolumnÚstrnameÚ add_elementÚoperatorr*r/rrrr^s:K  ÿ   ÿþû ÿzExcludeConstraint.__init__c sL‡fdd„ˆj ¡Dƒ}ˆj|ˆjˆjˆjˆjˆjdœŽ}|j  ˆj¡|S)Ncsg|] }|ˆj|f‘qSr)r0)Ú.0Úcolr rrÚ Ísz*ExcludeConstraint.copy..)r*r+r,r/r-) r6ÚkeysÚ __class__r*r+r,r/r-ÚdispatchÚ_update)rrrÚcrr rÚcopyÌsúzExcludeConstraint.copy)r!r"r#r$r%r/rrFrrrrr(Ps   nr(cOst|d<tjj|i|¤ŽS)zàPostgreSQL-specific form of :class:`.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)ÚargrrrrrIÚs rIN) ÚarrayrÚsqlrrrÚ sql.schemarÚ ColumnElementrr(rIrrrrÚs     A