o

���gX�@
sX
dd
lm
Z

ddlmZ
ddlmZ
ddlmZ
ddlmZ
ddlmZ
ddlmZ
ddlm	Z	
d	d
l
mZ
d	dl
mZ
d	dl
mZ
d	d
lmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
d	dlmZ
dZ d"dd�Z!Gdd�de�ZGdd �d e�Z"e	eeefeee#efeeeffZ$d!S)#�)
�annotations)
�Any)
�Dict)
�List)
�Mapping)
�Optional)
�Tuple)
�Union�)
�exc)
�util)
�_DMLTableArgument)
�_exclusive_against)
�_generative)
�ColumnCollection)
�ReadOnlyColumnCollection�
�Insert)
�
ClauseElement)
�KeyedColumnElement)
�alias)
�NamedFromClause)
�Self)r�insert�tabler
�returnrc

C
st|�
S)
a(Construct a MySQL/MariaDB-specific variant :class:`_mysql.Insert`
    construct.

    .. container:: inherited_member

        The :func:`sqlalchemy.dialects.mysql.insert` function creates
        a :class:`sqlalchemy.dialects.mysql.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:`_mysql.Insert` construct includes additional methods
    :meth:`_mysql.Insert.on_duplicate_key_update`.

    r)
r�r�H/usr/local/lib/python3.10/dist-packages/sqlalchemy/dialects/mysql/dml.pyr#src@
sTeZ
dZd
ZdZdZeddd��
Zej	dd	d
��
Z
eedddi
d
�ddd��
�
Z
dS)ra
MySQL-specific implementation of INSERT.

    Adds methods for MySQL-specific syntaxes such as ON DUPLICATE KEY UPDATE.

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

    .. versionadded:: 1.2

    �mysqlFr�6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]c


C
s|jj
S)
a�Provide the "inserted" namespace for an ON DUPLICATE KEY UPDATE
        statement

        MySQL's ON DUPLICATE KEY UPDATE clause allows reference to the row
        that would be inserted, via a special function called ``VALUES()``.
        This attribute provides all columns in this row to be referenceable
        such that they will render within a ``VALUES()`` function inside the
        ON DUPLICATE KEY UPDATE clause.    The attribute is named ``.inserted``
        so as not to conflict with the existing
        :meth:`_expression.Insert.values` method.

        .. tip::  The :attr:`_mysql.Insert.inserted` 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.inserted.some_column``), but special names and
            dictionary method names should be accessed using indexed access,
            such as ``stmt.inserted["column name"]`` or
            ``stmt.inserted["values"]``.  See the docstring for
            :class:`_expression.ColumnCollection` for further examples.

        .. seealso::

            :ref:`mysql_insert_on_duplicate_key_update` - example of how
            to use :attr:`_expression.Insert.inserted`

        )�inserted_alias�columns�
�selfrrr�insertedEs zInsert.insertedrc

C
st|j
d
d�S)Nr$)
�name)rrr"rrrr gszInsert.inserted_alias�_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)
�msgs�args�
_UpdateArg�kwrrc
O
sL|
r	|r	t�
d
�
�
|
rt|
�
dkrt�
d�
�
|
d}n|}t|j|�|_|S)a�
        Specifies the ON DUPLICATE KEY UPDATE clause.

        :param \**kw:  Column keys linked to UPDATE values.  The
         values may be any SQL expression or supported literal Python
         values.

        .. 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 DUPLICATE KEY UPDATE
           style of UPDATE, unless values are manually specified here.

        :param \*args: As an alternative to passing key/value parameters,
         a dictionary or list of 2-tuples can be passed as a single positional
         argument.

         Passing a single dictionary is equivalent to the keyword argument
         form::

            insert().on_duplicate_key_update({"name": "some name"})

         Passing a list of 2-tuples indicates that the parameter assignments
         in the UPDATE clause should be ordered as sent, in a manner similar
         to that described for the :class:`_expression.Update`
         construct overall
         in :ref:`tutorial_parameter_ordered_updates`::

            insert().on_duplicate_key_update(
                [
                    ("name", "some name"),
                    ("value", "some value"),
                ]
            )

         .. versionchanged:: 1.3 parameters can be specified as a dictionary
            or list of 2-tuples; the latter form provides for parameter
            ordering.


        .. versionadded:: 1.2

        .. seealso::

            :ref:`mysql_insert_on_duplicate_key_update`

        z9Can't pass kwargs and positional arguments simultaneously�
zDOnly a single dictionary or list of tuples is accepted positionally.r
)r�
ArgumentError�len�OnDuplicateClauser r&)r#r(r*�valuesrrr�on_duplicate_key_updateks8

�


�

�zInsert.on_duplicate_key_updateN)rr)rr)r(r)r*rrr)�__name__�
__module__�__qualname__�__doc__�stringify_dialect�
inherit_cache�propertyr$r�memoized_propertyr rrr0rrrrr6s


!


��c@
s4eZ
dZUd
ZdZded<ded<dZdd
d�ZdS)r.r0NzOptional[List[str]]�_parameter_orderingzDict[str, Any]�updaterr rr)r�NonecC
sx|
|_t
|t�r|rt
|d
t�rdd�|D�
|_t|�
}t
|t�r)|s(td�
�
nt
|t�r3t|�
}ntd�
�
||_dS)Nr
c
S
sg|]\}
}|
�qSrr)�.0�key�valuerrr�
<listcomp>�sz.OnDuplicateClause.__init__.<locals>.<listcomp>z-update parameter dictionary must not be emptyztupdate parameter must be a non-empty dictionary or a ColumnCollection such as the `.c.` collection of a Table object)	r �
isinstance�list�tupler9�dict�
ValueErrorrr:)r#r r:rrr�__init__�s(

�
�




��



�
zOnDuplicateClause.__init__)r rr:r)rr;)r1r2r3�__visit_name__r9�__annotations__r5rErrrrr.�s


r.N)rr
rr)%�
__future__r�typingrrrrrrr	�rr�sql._typingr
�sql.baserrrr�sql.dmlr�StandardInsert�sql.elementsrr�sql.expressionr�sql.selectabler�util.typingr�__all__rr.�strr)rrrr�<module>
s:


















'$
�