rj,ddlmZddlmZddlmZddlmZddlmZddlmZddlmZdd l m Z dd l m Z dd l m Z dd l m Z d dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlm Z d dlm!Z!d dlm"Z"d dlm#Z#d dl$m%Z%d dl&m'Z'd dl(m)Z)d d l*m+Z+d!Z,d,d#Z-Gd$d"eZGd%d&ee Z.Gd'd(e.Z/Gd)d*e.Z0y+)-) annotations)Any)Dict)List)Optional)Sequence)Union)_OnConflictIndexElementsT)_OnConflictIndexWhereT)_OnConflictSetT)_OnConflictWhereT)exc)util) coercions)roles)schema)_DMLTableArgument)ColumnCollection)ReadOnlyColumnCollection)SyntaxExtension)_DMLColumnElementInsert) ClauseElement) ColumnElement)KeyedColumnElement) TextClause)alias)NULLTYPE)InternalTraversal)Self)rinsertrct|S)aWConstruct 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)tables i/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/dml.pyr$r$+s" %=c~eZdZdZdZdZej ddZ d d dZ d d dZ y) ra?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` sqliteTcDt|jdjS)aProvide 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)selfs r'r,zInsert.excludedRs,TZZj1999r(Nc<|jt||||S)af Specifies a DO UPDATE SET action for ON CONFLICT clause. This method may be invoked more than once against the same :class:`_sqlite.Insert` construct, where each ``ON CONFLICT`` clause renders in the order in which it was established. .. versionadded:: 2.1 Multiple ``ON CONFLICT`` clauses may be established on a single :class:`_sqlite.Insert` construct. .. seealso:: :ref:`sqlite_on_conflict_multiple` :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). )extOnConflictDoUpdate)r/index_elements index_whereset_wheres r'on_conflict_do_updatezInsert.on_conflict_do_updatejs$rxx ~{D% H  r(c8|jt||S)a Specifies a DO NOTHING action for ON CONFLICT clause. This method may be invoked more than once against the same :class:`_sqlite.Insert` construct, and may be combined with :meth:`_sqlite.Insert.on_conflict_do_update`, where each ``ON CONFLICT`` clause renders in the order in which it was established. As SQLite allows only the last ``ON CONFLICT`` clause of a statement to omit its conflict target, a call that omits :paramref:`_sqlite.Insert.on_conflict_do_nothing.index_elements` must be the last clause established, else :class:`.InvalidRequestError` is raised. .. versionadded:: 2.1 Multiple ``ON CONFLICT`` clauses may be established on a single :class:`_sqlite.Insert` construct. .. seealso:: :ref:`sqlite_on_conflict_multiple` :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. )r1OnConflictDoNothing)r/r3r4s r'on_conflict_do_nothingzInsert.on_conflict_do_nothingsHxx+NKHIIr()returnz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]NNNN) r3r r4r r5r r6rr;r#NN)r3r r4r r;r#) __name__ __module__ __qualname____doc__stringify_dialect inherit_cachermemoized_propertyr,r7r:r(r'rr?s !M : ?::259.2 $#' ; 1; ,;  ; ! ;  ; ~59.2$J1$J,$J  $Jr(ceZdZUdZded<ded<dej fdejfgZ d d dZ d dZ d d Z y)OnConflictClauser*z.Optional[List[Union[str, schema.Column[Any]]]]inferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]inferred_target_whereclauseNc|k|Dcgc]&}tjtj|(c}|_|*tjtj ||_yd|_ydx|_|_ycc}w)N)rexpectrDDLConstraintColumnRolerHWhereHavingRolerI)r/r3r4columns r'__init__zOnConflictClause.__init__s  %--  !>!>G-D )*   ))  ,   , D )0-s+A=c~|r6|d}t|tr!|jtjdg||S)NzThis Insert construct already has an ON CONFLICT clause that omits a conflict target; such a clause must be the last ON CONFLICT clause in the statement) isinstancerGrHrInvalidRequestError)r/existinglasts r'_append_to_existingz$OnConflictClause._append_to_existingsR Br?r@rB__annotations__r" dp_multi_listdp_clauseelement_traverse_internalsrOrVr[rEr(r'rGrGsy LL" $%6%D%DE &(9(J(JK59.21,.!/! !  r(rGceZdZdZdZy)r9r:TN)r>r?r@__visit_name__rCrEr(r'r9r9s -NMr(r9ceZdZUdZded<ded<ej dejfdejfgzZ d dfd Z xZ S) r2r7z+Dict[_DMLColumnElement, ColumnElement[Any]]update_values_to_setzOptional[ColumnElement[Any]]update_whereclausec  t|||t|tr |s2t dt|t r t|}n t d|j Dcic]S\}}tjtj|tjtj|tdUc}}|_ |*tjtj||_yd|_ycc}}w)N)r3r4z*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 objectT)type_is_crud)superrOrRdict ValueErrorritemsrrKr DMLColumnRoleExpressionElementRoler!rfrMrg)r/r3r4r5r6kv __class__s r'rOzOnConflictDoUpdate.__init__s )#  dD ! !MNN . /:D$  % 1   U00! 4i6F6F++Qh7 % !    U22E :   % s*AC?r<)r3r r4r r5r r6r) r>r?r@rdr_rGrbr" dp_dml_valuesrarO __classcell__)rss@r'r2r2s,NEE44*>> !2!@!@A 0AABB59.2 $#' ! 1! ,!  ! ! ! ! r(r2N)r&rr;r)1 __future__rtypingrrrrrr _typingr r r rrrsqlrrr sql._typingrsql.baserrrsql.dmlrrr] sql.elementsrrrrsql.expressionr sql.sqltypesr! sql.visitorsr" util.typingr#__all__r$rGr9r2rEr(r'rs#/,%',(0'(/)).&#$- (LJ^LJ^7  7 t* , ), r(