a
    •˜ëjW  ã                   @  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Z dddœdd„Z!G dd„ deƒZG dd„ deƒZ"e	eeef eee#ef  eeef f Z$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   Úinsertr   r   )ÚtableÚreturnc                 C  s   t | ƒ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   ú\/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/dml.pyr   "   s    r   c                   @  sd   e Zd ZdZdZdZeddœdd„ƒZej	ddœd	d
„ƒZ
eedddid�ddddœdd„ƒƒZdS )r   a  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

    ÚmysqlFz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]])r   c                 C  s   | j j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©Úselfr   r   r   ÚinsertedD   s     zInsert.insertedr   c                 C  s   t | jdd�S )Nr#   )Úname)r   r   r!   r   r   r   r   f   s    zInsert.inserted_aliasÚ_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)ZmsgsÚ
_UpdateArgr   r   )ÚargsÚkwr   c                 O  sL   |r|rt  d¡‚|r6t|ƒdkr,t  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(   Úvaluesr   r   r   Úon_duplicate_key_updatej   s    8ÿÿ
ÿzInsert.on_duplicate_key_updateN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ústringify_dialectZinherit_cacheÚpropertyr#   r   Zmemoized_propertyr   r   r   r.   r   r   r   r   r   5   s   !ÿþc                   @  s<   e Zd ZU dZdZded< ded< dZdd	d
dœdd„ZdS )r,   r.   NzOptional[List[str]]Ú_parameter_orderingzDict[str, Any]Úupdater   r   r&   ÚNone)r   r6   r   c                 C  sx   || _ t|tƒr:|r:t|d tƒr:dd„ |D ƒ| _t|ƒ}t|tƒrR|sntdƒ‚nt|tƒrft|ƒ}ntdƒ‚|| _d S )Nr   c                 S  s   g | ]\}}|‘qS r   r   )Ú.0ÚkeyÚvaluer   r   r   Ú
<listcomp>Ë   ó    z.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Útupler5   ÚdictÚ
ValueErrorr   r6   )r"   r   r6   r   r   r   Ú__init__¿   s&    
ÿÿ
ÿ

ÿzOnDuplicateClause.__init__)r/   r0   r1   Z__visit_name__r5   Ú__annotations__r3   rB   r   r   r   r   r,   ·   s
   
r,   N)%Ú
__future__r   Útypingr   r   r   r   r   r   r	   Ú r   r   Zsql._typingr   Zsql.baser   r   r   r   Zsql.dmlr   ZStandardInsertZsql.elementsr   r   Zsql.expressionr   Zsql.selectabler   Zutil.typingr   Ú__all__r   r,   Ústrr&   r   r   r   r   Ú<module>   s8    '$ÿ