?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/__pycache__/ext.cpython-39.pyc
???????
a ��Jh�C � @ s� d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d d l m Z d d l m Z d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ e�r>d dlm Z d dl m Z d dl m Z d dl m!Z! d dl"m#Z# d dlm$Z$ d d lm%Z% e d ed �Z&G d d � d ej e& �Z'G d!d"� d"e�Z(d#d$� Z)G d%d&� d&ej*e& �Z+G d'd(� d(e+�Z,G d)d*� d*e+�Z-G d+d,� d,e+�Z.G d-d.� d.e+�Z/G d/d0� d0e+�Z0G d1d2� d2e+�Z1d3S )4� )� annotations)�Any)�Iterable)�List)�Optional)�overload)� TYPE_CHECKING)�TypeVar� )�types)�ARRAY� )� coercions)�elements)� expression)� functions)�roles)�schema)�ColumnCollectionConstraint)�TEXT)�InternalTraversal)�_ColumnExpressionArgument)� ClauseElement)� ColumnElement)� OperatorType)� FromClause)�_CloneCallableType)�_TraverseInternalsType�_T)�boundc @ s� e Zd ZU dZd ZdZdejfdejfdejfgZ de d< e dd d �d d ��Z e d d d �dd ��Z d d d �dd �Z d$ddd�dd�Z ddd�dd�Zejfddd d �d d �Zed d!�d"d#��ZdS )%�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: .. sourcecode:: sql 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: .. sourcecode:: sql SELECT string_agg(a, ',' ORDER BY a) FROM table; .. versionchanged:: 1.2.13 - the ORDER BY argument may be multiple terms .. seealso:: :class:`_functions.array_agg` � postgresql�target�type�order_byr �_traverse_internalszColumnElement[_T]z _ColumnExpressionArgument[Any]�r" r$ c G s d S �N� ��selfr" r$ r( r( �W/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/ext.py�__init__X s zaggregate_order_by.__init__z _ColumnExpressionArgument[_T]c G s d S r' r( r) r( r( r+ r, _ s c G sn t �tj|�| _| jj| _t|�}| |dkr8td��n2|dkrVt �tj|d �| _nt j |dtji�| _d S )Nr z)at least one ORDER BY element is requiredr Z_literal_as_text_role) r �expectr �ExpressionElementRoler" r# �len� TypeErrorr$ r Z ClauseList)r* r" r$ Z_lobr( r( r+ r, f s" � ���NzOptional[OperatorType]r )�against�returnc C s | S r' r( )r* r1 r( r( r+ � self_group} s z aggregate_order_by.self_groupr zIterable[ClauseElement])�kwargsr2 c K s | j | jfS r' r& )r* r4 r( r( r+ � get_children� s z aggregate_order_by.get_childrenr �None)�clone�kwr2 c K s, || j fi |��| _ || jfi |��| _d S r' r& )r* r7 r8 r( r( r+ �_copy_internals� s z"aggregate_order_by._copy_internalszList[FromClause])r2 c C s | j j| jj S r' )r" � _from_objectsr$ �r* r( r( r+ r: � s z aggregate_order_by._from_objects)N)�__name__� __module__� __qualname__�__doc__�__visit_name__Zstringify_dialectr Zdp_clauseelementZdp_typer% �__annotations__r r, r3 r5 r Z_cloner9 �propertyr: r( r( r( r+ r * s& $� ��r c sP e Zd ZdZdZdZdZdZe� ddd�d d � �Z � fd d �Z dd d�Z � Z S )�ExcludeConstraintz�A 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 Zexclude_constraintNFr! �wherez:class:`.ExcludeConstraint`z$:paramref:`.ExcludeConstraint.where`c O s� g }g }i | _ t|� \}}tt�tj|�|�D ]V\\}}} } } | durP|�| � |dur^|jn| } | durt| | j | < |�|| | f� q.|| _t j | g|�R |� d�|� d�|� d�d�� |� dd�| _ |� d�} | dur�t� tj| �| _|� d i �| _dS ) 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"}, ) ) The exclude constraint defined in this example requires the ``btree_gist`` extension, that can be created using the command ``CREATE EXTENSION btree_gist;``. :param \*elements: A sequence of two tuples of the form ``(column, operator)`` where "column" is either a :class:`_schema.Column` object, or a SQL expression element (e.g. ``func.int8range(table.from, table.to)``) or the name of a column as string, and "operator" is a string containing the operator to use (e.g. `"&&"` or `"="`). 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. The ``column`` may also be a string SQL expression when passed as :func:`_expression.literal_column` or :func:`_expression.text` :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)rE rF rG �usingZgistrD �ops)� operators�zipr Z expect_col_expression_collectionr ZDDLConstraintColumnRole�appendrE � _render_exprsr r, �getrH r- ZStatementOptionRolerD rI )r* r r8 �columnsZ render_exprsZ expressionsrJ �expr�columnZstrnameZ add_element�operatorrE rD r( r( r+ r, � s> _ �� ��� zExcludeConstraint.__init__c s& t � �� � � fdd�| jD �| _d S )Nc s0 g | ](\}}}t |t�s |n� j| ||f�qS r( )� isinstance�str�c)�.0rP rE rR ��tabler( r+ � <listcomp>* s ��z1ExcludeConstraint._set_parent.<locals>.<listcomp>)�super� _set_parentrM )r* rX r8 �� __class__rW r+ r[ ' s �z ExcludeConstraint._set_parentc sJ � �fdd�� j D �}� j|� j� j� j� j� jd��}|j�� j� |S )Nc s& g | ] \}}}t �|� j��|f�qS r( )r Z_copy_expression�parent)rV rP �_rR �r* � target_tabler( r+ rY 4 s ��z+ExcludeConstraint._copy.<locals>.<listcomp>)rE rF rG rD rH ) rM r] rE rF rG rD rH �dispatch�_update)r* ra r8 r rU r( r` r+ �_copy3 s ��zExcludeConstraint._copy)N)r< r= r> r? r@ rD � inherit_cacheZ create_drop_stringify_dialectr Z_document_text_coercionr, r[ rd � __classcell__r( r( r\ r+ rC � s � rC 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. Z_default_array_type)r r �func� array_agg)�argr8 r( r( r+ rh G s rh c s e Zd ZdZ� fdd�Z� ZS )� _regconfig_fnTc sr t |�}t|�dkrBtjtj|�d�t� dd �� tj d�}|g}ng }� fdd�|D �}t � j || i |�� d S )Nr r rE )rE �apply_propagate_attrs�type_c s( g | ] }t jtj|t� d d�� d��qS �rE N)rE rk �r r- r r. �getattr�rV rU r; r( r+ rY c s � �z*_regconfig_fn.__init__.<locals>.<listcomp>) �listr/ r r- r r. �popro r � REGCONFIGrZ r, )r* �argsr4 � initial_arg� addtl_argsr\ r; r+ r, U s � � z_regconfig_fn.__init__)r< r= r> re r, rf r( r( r\ r+ rj R s rj c @ s e Zd ZdZdZejZdS )� to_tsvectora� The PostgreSQL ``to_tsvector`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_postgresql.TSVECTOR`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.to_tsvector` will be used automatically when invoking ``sqlalchemy.func.to_tsvector()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 TN)r< r= r> r? re r ZTSVECTORr# r( r( r( r+ rw o s rw c @ s e Zd ZdZdZejZdS )� to_tsquerya� The PostgreSQL ``to_tsquery`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_postgresql.TSQUERY`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.to_tsquery` will be used automatically when invoking ``sqlalchemy.func.to_tsquery()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 TN�r< r= r> r? re r �TSQUERYr# r( r( r( r+ rx � s rx c @ s e Zd ZdZdZejZdS )�plainto_tsquerya� The PostgreSQL ``plainto_tsquery`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_postgresql.TSQUERY`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.plainto_tsquery` will be used automatically when invoking ``sqlalchemy.func.plainto_tsquery()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 TNry r( r( r( r+ r{ � s r{ c @ s e Zd ZdZdZejZdS )�phraseto_tsquerya� The PostgreSQL ``phraseto_tsquery`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_postgresql.TSQUERY`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.phraseto_tsquery` will be used automatically when invoking ``sqlalchemy.func.phraseto_tsquery()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 TNry r( r( r( r+ r| � s r| c @ s e Zd ZdZdZejZdS )�websearch_to_tsquerya� The PostgreSQL ``websearch_to_tsquery`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_postgresql.TSQUERY`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.websearch_to_tsquery` will be used automatically when invoking ``sqlalchemy.func.websearch_to_tsquery()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 TNry r( r( r( r+ r} � s r} c s( e Zd ZdZdZeZ� fdd�Z� ZS )� ts_headlinea� The PostgreSQL ``ts_headline`` SQL function. This function applies automatic casting of the REGCONFIG argument to use the :class:`_postgresql.REGCONFIG` datatype automatically, and applies a return type of :class:`_types.TEXT`. Assuming the PostgreSQL dialect has been imported, either by invoking ``from sqlalchemy.dialects import postgresql``, or by creating a PostgreSQL engine using ``create_engine("postgresql...")``, :class:`_postgresql.ts_headline` will be used automatically when invoking ``sqlalchemy.func.ts_headline()``, ensuring the correct argument and return type handlers are used at compile and execution time. .. versionadded:: 2.0.0rc1 Tc s� t |�}t|�dk rd}n,t|d tj�rB|d jjtju rBd}nd}|rxt j t j |� d�� t� dd �tjd�}|g}ng }� fdd �|D �}t� j|| i |�� d S ) N� Fr Tr rE )rk rE rl c s( g | ] }t jtj|t� d d�� d��qS rm rn rp r; r( r+ rY s � �z(ts_headline.__init__.<locals>.<listcomp>)rq r/ rS r r r# Z_type_affinityr rz r r- r r. rr ro rs rZ r, )r* rt r4 Z has_regconfigru rv r\ r; r+ r, � s. �� � � zts_headline.__init__) r< r= r> r? re r r# r, rf r( r( r\ r+ r~ � s r~ N)2� __future__r �typingr r r r r r r � r �arrayr Zsqlr r r r r r Z sql.schemar Z sql.sqltypesr Z sql.visitorsr Z sql._typingr Z sql.elementsr r Z sql.operatorsr Zsql.selectabler r r r r rC rh ZGenericFunctionrj rw rx r{ r| r} r~ r( r( r( r+ �<module> sL f 8
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????