?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/__pycache__/dml.cpython-39.pyc
???????
a ��JhX � @ 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 l mZ d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dl m Z d dl m Z dZ ddd�dd �Z!G d d� de�ZG d d � d e�Z"e eeef eee#ef eeef 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 �R/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/dml.pyr # s r c @ sd e Zd ZdZdZdZedd�dd��Zej dd�d d ��Z e e d d d id �dddd�dd���Z dS )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 jS )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 �insertedE s zInsert.insertedr c C s t | jdd�S )Nr# )�name)r r r! r r r r g s zInsert.inserted_alias�_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)Zmsgs� _UpdateArgr r )�args�kwr c O sL |r|rt �d��|r6t|�dkr,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_updatek s 8� � �z Insert.on_duplicate_key_updateN)�__name__� __module__� __qualname__�__doc__�stringify_dialectZ inherit_cache�propertyr# r Zmemoized_propertyr r r r. r r r r r 6 s !��c @ s< e Zd ZU dZdZded< ded< dZdd d d �d d �ZdS )r, r. NzOptional[List[str]]�_parameter_orderingzDict[str, Any]�updater r r& �None)r r6 r c C sx || _ t|t�r:|r:t|d t�r:dd� |D �| _t|�}t|t�rR|sntd��n t|t�rft|�}ntd��|| _d S )Nr c S s g | ] \}}|�qS 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& � � � �zOnDuplicateClause.__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 Zsql.baser r r r Zsql.dmlr ZStandardInsertZ sql.elementsr r Zsql.expressionr Zsql.selectabler Z util.typingr �__all__r r, �strr& r r r r �<module> s8 '$�
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????