a
    •˜ëj]/  ã                   @  s¨  d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ddlm	Z	 d	d
l
mZ d	dl
mZ d	dl
mZ d	dl
mZ d	dl
mZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z  ddlm!Z! ddlm"Z" ddlm#Z# ddl$m%Z% ddl&m'Z' d Z(d!d"d#œd$d%„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,d-S ).é    )Úannotations)ÚAny)ÚList)ÚOptional)ÚTuple)ÚUnioné   )Úexté   )Ú_OnConflictConstraintT)Ú_OnConflictIndexElementsT)Ú_OnConflictIndexWhereT)Ú_OnConflictSetT)Ú_OnConflictWhereTé   )Úutil)Ú	coercions)Úroles)Úschema)Ú_DMLTableArgument)Ú_exclusive_against)Ú_generative)ÚColumnCollection)ÚReadOnlyColumnCollection©ÚInsert)ÚClauseElement)ÚColumnElement)ÚKeyedColumnElement)Ú
TextClause)Úalias)ÚSelf)r   Úinsertr   r   )ÚtableÚreturnc                 C  s   t | ƒS )as  Construct a PostgreSQL-specific variant :class:`_postgresql.Insert`
    construct.

    .. container:: inherited_member

        The :func:`sqlalchemy.dialects.postgresql.insert` function creates
        a :class:`sqlalchemy.dialects.postgresql.Insert`.  This class is based
        on the dialect-agnostic :class:`_sql.Insert` construct which may
        be constructed using the :func:`_sql.insert` function in
        SQLAlchemy Core.

    The :class:`_postgresql.Insert` construct includes additional methods
    :meth:`_postgresql.Insert.on_conflict_do_update`,
    :meth:`_postgresql.Insert.on_conflict_do_nothing`.

    r   )r#   © r%   úa/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/dml.pyr"   )   s    r"   c                
   @  s|   e Zd ZdZdZdZejddœdd„ƒZe	ddd	id
�Z
ee
ddddddddœdd„ƒƒZee
ddddddœdd„ƒƒZdS )r   zðPostgreSQL-specific implementation of INSERT.

    Adds methods for PG-specific syntaxes such as ON CONFLICT.

    The :class:`_postgresql.Insert` object is created using the
    :func:`sqlalchemy.dialects.postgresql.insert` function.

    Ú
postgresqlFz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]])r$   c                 C  s   t | jdd�jS )ak  Provide the ``excluded`` namespace for an ON CONFLICT statement

        PG's ON CONFLICT clause allows reference to the row that would
        be inserted, known as ``excluded``.  This attribute provides
        all columns in this row to be referenceable.

        .. tip::  The :attr:`_postgresql.Insert.excluded` attribute is an
            instance of :class:`_expression.ColumnCollection`, which provides
            an interface the same as that of the :attr:`_schema.Table.c`
            collection described at :ref:`metadata_tables_and_columns`.
            With this collection, ordinary names are accessible like attributes
            (e.g. ``stmt.excluded.some_column``), but special names and
            dictionary method names should be accessed using indexed access,
            such as ``stmt.excluded["column name"]`` or
            ``stmt.excluded["values"]``.   See the docstring for
            :class:`_expression.ColumnCollection` for further examples.

        .. seealso::

            :ref:`postgresql_insert_on_conflict` - example of how
            to use :attr:`_expression.Insert.excluded`

        Úexcluded)Úname)r    r#   Úcolumns)Úselfr%   r%   r&   r(   J   s    zInsert.excludedÚ_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)ZmsgsNr   r   r   r   r   r!   )Ú
constraintÚindex_elementsÚindex_whereÚset_Úwherer$   c                 C  s   t |||||ƒ| _| S )a$  
        Specifies a DO UPDATE SET action for ON CONFLICT clause.

        Either the ``constraint`` or ``index_elements`` argument is
        required, but only one of these can be specified.

        :param constraint:
         The name of a unique or exclusion constraint on the table,
         or the constraint object itself if it has a .name attribute.

        :param index_elements:
         A sequence consisting of string column names, :class:`_schema.Column`
         objects, or other column expression objects that will be used
         to infer a target index.

        :param index_where:
         Additional WHERE criterion that can be used to infer a
         conditional target index.

        :param set\_:
         A dictionary or other mapping object
         where the keys are either names of columns in the target table,
         or :class:`_schema.Column` objects or other ORM-mapped columns
         matching that of the target table, and expressions or literals
         as values, specifying the ``SET`` actions to take.

         .. versionadded:: 1.4 The
            :paramref:`_postgresql.Insert.on_conflict_do_update.set_`
            parameter supports :class:`_schema.Column` objects from the target
            :class:`_schema.Table` as keys.

         .. warning:: This dictionary does **not** take into account
            Python-specified default UPDATE values or generation functions,
            e.g. those specified using :paramref:`_schema.Column.onupdate`.
            These values will not be exercised for an ON CONFLICT style of
            UPDATE, unless they are manually specified in the
            :paramref:`.Insert.on_conflict_do_update.set_` dictionary.

        :param where:
         Optional argument. An expression object representing a ``WHERE``
         clause that restricts the rows affected by ``DO UPDATE SET``. Rows not
         meeting the ``WHERE`` condition will not be updated (effectively a
         ``DO NOTHING`` for those rows).


        .. seealso::

            :ref:`postgresql_insert_on_conflict`

        )ÚOnConflictDoUpdater,   ©r+   r-   r.   r/   r0   r1   r%   r%   r&   Úon_conflict_do_updateo   s    <
ÿzInsert.on_conflict_do_update)r-   r.   r/   r$   c                 C  s   t |||ƒ| _| S )a	  
        Specifies a DO NOTHING action for ON CONFLICT clause.

        The ``constraint`` and ``index_elements`` arguments
        are optional, but only one of these can be specified.

        :param constraint:
         The name of a unique or exclusion constraint on the table,
         or the constraint object itself if it has a .name attribute.

        :param index_elements:
         A sequence consisting of string column names, :class:`_schema.Column`
         objects, or other column expression objects that will be used
         to infer a target index.

        :param index_where:
         Additional WHERE criterion that can be used to infer a
         conditional target index.

        .. seealso::

            :ref:`postgresql_insert_on_conflict`

        )ÚOnConflictDoNothingr,   ©r+   r-   r.   r/   r%   r%   r&   Úon_conflict_do_nothing°   s     ÿzInsert.on_conflict_do_nothing)NNNNN)NNN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ústringify_dialectZinherit_cacher   Zmemoized_propertyr(   r   Z_on_conflict_exclusiver   r4   r7   r%   r%   r%   r&   r   =   s0   	ÿþ     ú?   üc                   @  s>   e Zd ZU dZded< ded< ded< dd	d
ddœdd„ZdS )ÚOnConflictClauser'   zOptional[str]Úconstraint_targetz.Optional[List[Union[str, schema.Column[Any]]]]Úinferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]Úinferred_target_whereclauseNr   r   r   ©r-   r.   r/   c                 C  s.  |d ur2t |tƒs2t |tjtjfƒr2t|dƒp0|}|d ur¼|d urJtdƒ‚t |tƒrh|| _d | _	d | _
nTt |tjƒrŒ|j}|jd  d¡}n0t |tjƒr¦|j}|j}n|j}|jd  d¡}|d u�rd | _dd„ |D ƒ| _	|d u�rt t |tjƒrütjntj|¡nd | _
n|d u �r*d  | _ | _	| _
d S )Nr)   z8'constraint' and 'index_elements' are mutually exclusiver'   r1   c                 S  s   g | ]}t  tj|¡‘qS r%   )r   Úexpectr   ZDDLConstraintColumnRole)Ú.0Úcolumnr%   r%   r&   Ú
<listcomp>  s   ÿz-OnConflictClause.__init__.<locals>.<listcomp>)Ú
isinstanceÚstrr   Z
Constraintr	   ZExcludeConstraintÚgetattrÚ
ValueErrorr>   r?   r@   ÚIndexZexpressionsZdialect_optionsÚgetr*   r1   r   rB   r   ZStatementOptionRoleÚWhereHavingRoler6   r%   r%   r&   Ú__init__ß   s\    
þÿ

ÿ
ÿ
þø
ÿú	ö
þÿzOnConflictClause.__init__)NNN)r8   r9   r:   r<   Ú__annotations__rM   r%   r%   r%   r&   r=   Ö   s   
   ür=   c                   @  s   e Zd ZdZdS )r5   r7   N)r8   r9   r:   Ú__visit_name__r%   r%   r%   r&   r5     s   r5   c                      sB   e Zd ZU dZded< ded< dddd	d
ddœ‡ fdd„Z‡  ZS )r2   r4   z0List[Tuple[Union[schema.Column[Any], str], Any]]Úupdate_values_to_setzOptional[ColumnElement[Any]]Úupdate_whereclauseNr   r   r   r   r   )r-   r.   r/   r0   r1   c                   s–   t ƒ j|||d� | jd u r.| jd u r.tdƒ‚t|tƒrF|sbtdƒ‚nt|tƒrZt|ƒ}ntdƒ‚dd„ | ¡ D ƒ| _	|d urŒt
 tj|¡nd | _d S )NrA   zVEither constraint or index_elements, but not both, must be specified unless DO NOTHINGz*set parameter dictionary must not be emptyzqset parameter must be a non-empty dictionary or a ColumnCollection such as the `.c.` collection of a Table objectc                 S  s"   g | ]\}}t  tj|¡|f‘qS r%   )r   rB   r   ZDMLColumnRole)rC   ÚkeyÚvaluer%   r%   r&   rE   J  s   ÿz/OnConflictDoUpdate.__init__.<locals>.<listcomp>)ÚsuperrM   r?   r>   rI   rF   Údictr   ÚitemsrP   r   rB   r   rL   rQ   r3   ©Ú	__class__r%   r&   rM   (  s6    ýÿþÿ



ÿþÿýzOnConflictDoUpdate.__init__)NNNNN)r8   r9   r:   rO   rN   rM   Ú__classcell__r%   r%   rW   r&   r2   "  s   
     úr2   N)-Ú
__future__r   Útypingr   r   r   r   r   Ú r	   Ú_typingr   r   r   r   r   r   Zsqlr   r   r   Zsql._typingr   Zsql.baser   r   r   r   Zsql.dmlr   ZStandardInsertZsql.elementsr   r   r   r   Zsql.expressionr    Zutil.typingr!   Ú__all__r"   r=   r5   r2   r%   r%   r%   r&   Ú<module>   sD    H