?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/sqlite/__pycache__/dml.cpython-39.pyc
???????
a ��Jh�# � @ s� d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ddlm Z dd lm Z dd lm Z dd lm Z d d l mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dl m Z d dl m Z d dl m Z d dl m!Z! d dl"m#Z# d d l$m%Z% d Z&d d d �d!d"�Z'G d#d � d e �ZG d$d%� d%e �Z(G d&d'� d'e(�Z)G d(d)� d)e(�Z*d*S )+� )� annotations)�Any)�List)�Optional)�Tuple)�Union� )�_OnConflictIndexElementsT)�_OnConflictIndexWhereT)�_OnConflictSetT)�_OnConflictWhereT� )�util)� coercions)�roles)�schema)�_DMLTableArgument)�_exclusive_against)� _generative)�ColumnCollection)�ReadOnlyColumnCollection��Insert)� ClauseElement)� ColumnElement)�KeyedColumnElement)� TextClause)�alias)�Self)r �insertr r )�table�returnc 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 )r � r" �S/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/sqlite/dml.pyr ' s r c @ sx e Zd ZdZdZdZejdd�dd��Ze ddd id �Z e e dd d dddd�dd���Z e e dd d dd�dd���Z d 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` �sqliteFz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]])r! c C s t | jdd�jS )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% N s zInsert.excluded�_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)ZmsgsNr r r r r )�index_elements� index_where�set_�wherer! c 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. An expression object representing 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( r* r+ r, r- r" r" r# �on_conflict_do_updaten s 0�z Insert.on_conflict_do_update)r* r+ r! c 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 r0 r3 r" r" r" r# r ; s, �� � 3 �c @ s4 e Zd ZU dZded< ded< d ddd �d d �ZdS ) �OnConflictClauser$ z.Optional[List[Union[str, schema.Column[Any]]]]�inferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]�inferred_target_whereclauseNr r �r* r+ c C sF |d ur6dd� |D �| _ |d ur.t�tj|�nd | _n d | _ | _d S )Nc S s g | ]}t �tj|��qS r" )r �expectr ZDDLConstraintColumnRole)�.0�columnr" r" r# � <listcomp>� s �z-OnConflictClause.__init__.<locals>.<listcomp>)r: r r= r �WhereHavingRoler; r2 r" r" r# �__init__� s � ��� ��zOnConflictClause.__init__)NN)r4 r5 r6 r8 �__annotations__rB r" r" r" r# r9 � s �r9 c @ s e Zd ZdZdS )r1 r3 N)r4 r5 r6 �__visit_name__r" r" r" r# r1 � s r1 c s@ e Zd ZU dZded< ded< dddd d d �� fd d � Z� ZS )r. r0 z0List[Tuple[Union[schema.Column[Any], str], Any]]�update_values_to_setz Optional[ColumnElement[Any]]�update_whereclauseNr r r r )r* r+ r, r- c sx t � j||d� t|t�r(|sDtd��n t|t�r<t|�}ntd��dd� |�� D �| _|d urnt� t j |�nd | _ d S )Nr< 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|�|f�qS r" )r r= r Z DMLColumnRole)r> �key�valuer" r" r# r@ � s �z/OnConflictDoUpdate.__init__.<locals>.<listcomp>) �superrB � isinstance�dict� ValueErrorr �itemsrE r r= r rA rF r/ �� __class__r" r# rB � s& � ����zOnConflictDoUpdate.__init__)NNNN)r4 r5 r6 rD rC rB � __classcell__r" r" rN r# r. � s �r. N)+� __future__r �typingr r r r r Z_typingr r r r � r Zsqlr r r Z sql._typingr Zsql.baser r r r Zsql.dmlr ZStandardInsertZ sql.elementsr r r r Zsql.expressionr Z util.typingr �__all__r r9 r1 r. r" r" r" r# �<module> s@
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????