Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/__pycache__/ext.cpython-39.pyc
Ðазад
a _�h; � @ sv d dl mZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ G dd � d ej �Z G d d � d e�Z d d � Z dS )� )�ARRAY� )�elements)� expression)� functions)�schema)�ColumnCollectionConstraintc @ sH e Zd ZdZd Zdd� 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:`_functions.array_agg` c G sb t �|�| _| jj| _t|�}|dkr0td��n.|dkrJt �|d �| _nt j|dt ji�| _d S )N� z)at least one ORDER BY element is requiredr �_literal_as_text)r Z_literal_as_binds�target�type�len� TypeError�order_byZ ClauseList)�selfr r Z_lob� r ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/ext.py�__init__5 s ��zaggregate_order_by.__init__Nc C s | S �Nr )r Zagainstr r r � self_groupC s z aggregate_order_by.self_groupc K s | j | jfS r �r r )r �kwargsr r r � get_childrenF s z aggregate_order_by.get_childrenc K s, || j fi |��| _ || jfi |��| _d S r r )r �clone�kwr r r �_copy_internalsI s z"aggregate_order_by._copy_internalsc C s | j j| jj S r )r � _from_objectsr )r r r r r M s z aggregate_order_by._from_objects)N) �__name__� __module__� __qualname__�__doc__�__visit_name__r r r r Z_cloner �propertyr r r r r r s " r c @ s8 e Zd ZdZdZdZe�ddd�dd� �Zd d d �Z dS ) �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 Zexclude_constraintN�wherez:class:`.ExcludeConstraint`z$:paramref:`.ExcludeConstraint.where`c O s g }g }i | _ t|� \}}t| �|�|�D ]`\\}}} } } | durL|�| � |durZ|jn| } | durp| | j | < t�|�}|�|| | f� q*|| _tj | g|�R |� d�|� d�|� d�d�� |� dd�| _ |� d�} | dur�tj | d d �| _ |� d i �| _dS ) a2 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 <value> when issuing DDL for this constraint. :param using: Optional string. If set, emit USING <index_method> when issuing DDL for this constraint. Defaults to 'gist'. :param where: Optional SQL expression construct or literal SQL string. If set, emit WHERE <predicate> 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 <postgresql_operator_classes>` 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. N�name� deferrable� initially)r& r' r( �usingZgistr% T)Zallow_coercion_to_text�ops)� operators�zipZ"_extract_col_expression_collection�appendr& r Z_literal_as_columnZ _render_exprsr r �getr) r r% r* )r r r �columnsZ render_exprsZ expressionsr+ �expr�columnZstrnameZ add_element�operatorr& r% r r r r ` s> W � ��� �zExcludeConstraint.__init__c sJ � �fdd�� j D �}� j|� j� j� j� j� jd��}|j�� j� |S )Nc s( g | ] }t �|� j��� j|j f�qS r )r Z_copy_expression�parentr+ r& )�.0r0 �r � target_tabler r � <listcomp>� s � �z*ExcludeConstraint.copy.<locals>.<listcomp>)r& r' r( r% r) ) r/ � __class__r& r' r( r% r) �dispatch�_update)r r6 r r �cr r5 r �copy� s ��zExcludeConstraint.copy)N) r r r r! r" r% r Z_document_text_coercionr r< r r r r r$ R s � zr$ c O s t |d< tjj| i |��S )z�PostgreSQL-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 Z_default_array_type)r r �func� array_agg)�argr r r r r> � s r> N) �arrayr �sqlr r r r Z sql.schemar Z ColumnElementr r$ r> r r r r �<module> s B "
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка