U
|
¸ý°d ã @ s d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dl
|
m Z d dl m Z d d lmZ d
|
Zd d ZG d d de ZG dd de ZdS )é )Úexc)Úutil)Ú_exclusive_against)Ú _generative)ÚColumnCollection©ÚInsert)Ú ClauseElement)Úalias)ÚSelf)r Úinsertc 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 )Útable© r úTd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/dialects/mysql/dml.pyr s r c @ sT e Zd ZdZdZdZedd Zej dd Z
|
e e ddd id
|
e d d d ZdS )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
|
|
ÚmysqlFc 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 Úinserted9 s zInsert.insertedc C s t | jddS )Nr )Úname)r
|
r r r r r r Y s zInsert.inserted_aliasÚ_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)Zmsgs)Úreturnc O sV |r|rt d¡|r6t|dkr,t d¡|d }n|}t| dd}t||| _| S )aO
|
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 N)r Ú ArgumentErrorÚlenÚgetattrÚOnDuplicateClauser )r ÚargsÚkwÚvaluesr r r r Úon_duplicate_key_update] s 4ÿ ÿ
|
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 r * s
|
|
ÿþr c @ s e Zd ZdZdZdZdd ZdS )r r" Nr c C sx || _ t|tr:|r:t|d tr:dd |D | _t|}t|trR|sntdn t|trft|}ntd|| _d S )Nr c S s g | ] \}}|qS r r )Ú.0ÚkeyÚvaluer r r Ú
|
<listcomp>¶ s 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ÚtupleÚ_parameter_orderingÚdictÚ
|
ValueErrorr Úupdate)r r r3 r r r Ú__init__¬ s&
|
ÿ ÿ
|
ÿ
|
|
ÿzOnDuplicateClause.__init__)r# r$ r% Z__visit_name__r0 r' r4 r r r r r ¥ s r N)Ú r r Zsql.baser r r Zsql.dmlr ZStandardInsertZ sql.elementsr Zsql.expressionr
|
Z util.typingr Ú__all__r r r r r r Ú<module> s {
|
