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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é   )Ú_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 )aW  Construct a sqlite-specific variant :class:`_sqlite.Insert`
    construct.

    .. container:: inherited_member

        The :func:`sqlalchemy.dialects.sqlite.insert` function creates
        a :class:`sqlalchemy.dialects.sqlite.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:`_sqlite.Insert` construct includes additional methods
    :meth:`_sqlite.Insert.on_conflict_do_update`,
    :meth:`_sqlite.Insert.on_conflict_do_nothing`.

    r   )r    © r"   ú]/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/sqlite/dml.pyr   '   s    r   c                	   @  sx   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„ƒƒZee
dddddœdd„ƒƒZdS )r   a?  SQLite-specific implementation of INSERT.

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

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

    .. versionadded:: 1.4

    .. seealso::

        :ref:`sqlite_on_conflict_insert`

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

        SQLite'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:`_sqlite.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.

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

        :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 or unique constraint.

        :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:`_sqlite.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).

        )ÚOnConflictDoUpdater)   ©r(   r*   r+   r,   r-   r"   r"   r#   Úon_conflict_do_updaten   s    0ÿzInsert.on_conflict_do_update)r*   r+   r!   c                 C  s   t ||ƒ| _| S )aµ  
        Specifies a DO NOTHING action for ON CONFLICT clause.

        :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 or unique constraint.

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

        )ÚOnConflictDoNothingr)   ©r(   r*   r+   r"   r"   r#   Úon_conflict_do_nothing£   s    ÿzInsert.on_conflict_do_nothing)NNNN)NN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ústringify_dialectZinherit_cacher   Zmemoized_propertyr%   r   Z_on_conflict_exclusiver   r0   r3   r"   r"   r"   r#   r   ;   s,   ÿþ    û3  ýc                   @  s4   e Zd ZU dZded< ded< dddd	œd
d„ZdS )ÚOnConflictClauser$   z.Optional[List[Union[str, schema.Column[Any]]]]Úinferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]Úinferred_target_whereclauseNr	   r
   ©r*   r+   c                 C  sF   |d ur6dd„ |D ƒ| _ |d ur.t tj|¡nd | _nd  | _ | _d S )Nc                 S  s   g | ]}t  tj|¡‘qS r"   )r   Úexpectr   ZDDLConstraintColumnRole)Ú.0Úcolumnr"   r"   r#   Ú
<listcomp>Ì   s   ÿz-OnConflictClause.__init__.<locals>.<listcomp>)r:   r   r=   r   ÚWhereHavingRoler;   r2   r"   r"   r#   Ú__init__Æ   s    þ	üþúþÿzOnConflictClause.__init__)NN)r4   r5   r6   r8   Ú__annotations__rB   r"   r"   r"   r#   r9   ¾   s   
  ýr9   c                   @  s   e Zd ZdZdS )r1   r3   N)r4   r5   r6   Ú__visit_name__r"   r"   r"   r#   r1   Þ   s   r1   c                      s@   e Zd ZU dZded< ded< dddd	d
dœ‡ fdd„Z‡  ZS )r.   r0   z0List[Tuple[Union[schema.Column[Any], str], Any]]Úupdate_values_to_setzOptional[ColumnElement[Any]]Úupdate_whereclauseNr	   r
   r   r   )r*   r+   r,   r-   c                   sx   t ƒ j||d� t|tƒr(|sDtdƒ‚nt|tƒr<t|ƒ}ntdƒ‚dd„ | ¡ D ƒ| _|d urnt 	t
j|¡nd | _d S )Nr<   z*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   r=   r   ZDMLColumnRole)r>   ÚkeyÚvaluer"   r"   r#   r@   ÿ   s   ÿz/OnConflictDoUpdate.__init__.<locals>.<listcomp>)ÚsuperrB   Ú
isinstanceÚdictÚ
ValueErrorr   ÚitemsrE   r   r=   r   rA   rF   r/   ©Ú	__class__r"   r#   rB   è   s&    þ



ÿþÿýzOnConflictDoUpdate.__init__)NNNN)r4   r5   r6   rD   rC   rB   Ú__classcell__r"   r"   rN   r#   r.   â   s   
    ûr.   N)+Ú
__future__r   Útypingr   r   r   r   r   Ú_typingr	   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   r9   r1   r.   r"   r"   r"   r#   Ú<module>   s@     