U
|
¸ý°d ã @ sÈ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dl m
|
Z d dl m Z d d lmZ d d
|
lmZ d Zd d ZG dd de Z
|
G dd de ZG dd deZG dd deZdS )é )Úutil)Ú coercions)Úroles)Ú_exclusive_against)Ú _generative)ÚColumnCollection©ÚInsert)Ú ClauseElement)Úalias)ÚSelf)r Úinsertc 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 )Útable© r úUd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/dialects/sqlite/dml.pyr s r c @ sf e Zd ZdZdZdZejdd Ze dddidZ
|
e e
|
de d
|
d d Z e e
|
de d
|
d dZd 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`
|
|
ÚsqliteFc C s t | jddjS )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 ? s zInsert.excludedÚ_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)ZmsgsN)Úreturnc 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. If present, can be a literal SQL
|
string or an acceptable expression for 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 Úindex_elementsÚ index_whereÚset_Úwherer r r Úon_conflict_do_update] s 1 ÿz Insert.on_conflict_do_updatec 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 Zmemoized_propertyr r Z_on_conflict_exclusiver r r r! r r r r r , s6
|
ÿþ ûú4 ÿþr c @ s e Zd ZdZdddZdS )ÚOnConflictClauser Nc C s2 |d k r d | _ || _|| _nd | _ | _| _d S )N)Zconstraint_targetZinferred_target_elementsZinferred_target_whereclauser r r r Ú__init__¯ s þþzOnConflictClause.__init__)NN)r" r# r$ r& r( r r r r r' ¬ s r' c @ s e Zd ZdZdS )r r! N)r" r# r$ Ú__visit_name__r r r r r » s r c s" e Zd ZdZd fdd Z ZS )r r Nc sb t j||d t|tr(|sDtdn t|tr<t|}ntddd | ¡ D | _|| _d S )N)r r 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 tj|¡|fqS r )r Úexpectr Z DMLColumnRole)Ú.0ÚkeyÚvaluer r r Ú
|
<listcomp>Ù s ÿz/OnConflictDoUpdate.__init__.<locals>.<listcomp>) Úsuperr( Ú
|
isinstanceÚdictÚ
|
ValueErrorr ÚitemsZupdate_values_to_setZupdate_whereclauser ©Ú __class__r r r( Â s þ
|
|
|
|
ÿþzOnConflictDoUpdate.__init__)NNNN)r" r# r$ r) r( Ú __classcell__r r r4 r r ¿ s ûr N)Ú r Zsqlr r Zsql.baser r r Zsql.dmlr ZStandardInsertZ sql.elementsr
|
Zsql.expressionr Z util.typingr Ú__all__r r' r r r r r r Ú<module> s
|
