,h#SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SS KJ r SS KJ r SS KJ r S S K Jr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJ r S SKJ!r! S SK"J#r# S SK$J%r% Sr&S(Sjr'"S S\5r"S!S"\5r("S#S$\(5r)"S%S&\(5r*g'))) annotations)Any)List)Optional)Tuple)Union)_OnConflictIndexElementsT)_OnConflictIndexWhereT)_OnConflictSetT)_OnConflictWhereT)util) coercions)roles)schema)_DMLTableArgument)_exclusive_against) _generative)ColumnCollection)ReadOnlyColumnCollectionInsert) ClauseElement) ColumnElement)KeyedColumnElement) TextClause)alias)Self)rinsertrc[U5$)a+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)tables V/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/dialects/sqlite/dml.pyr r 's" %=c\rSrSrSrSrSr\RS Sj5r \ "SSS0S9r \ \ SSS jj55r \ \ SSS jj55rS rg )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>[URSS9R$)ajProvide 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)rr"columns)selfs r#r)Insert.excludedNs,TZZj1999r$_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc([XX45UlU$)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,index_elements index_whereset_wheres r#on_conflict_do_updateInsert.on_conflict_do_updatens`$6 $   r$c&[X5UlU$)am 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,r2r3s r#on_conflict_do_nothingInsert.on_conflict_do_nothings*$7 $   r$)r.)returnz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]NNNN) r2r r3r r4r r5r r<rNN)r2r r3r r<r)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachermemoized_propertyr)r_on_conflict_exclusiverr6r:__static_attributes__r$r#rr;s !M : ?::.0 !$0 59.2 $#' 111,1 1 ! 1  11f59.21,  r$cF\rSrSr%SrS\S'S\S'S S SjjrS rg) OnConflictClauser'z.Optional[List[Union[str, schema.Column[Any]]]]inferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]inferred_target_whereclauseNcUbkUVs/sH(n[R"[RU5PM* snUlUb%[R"[R U5OSUlgS=UlUlgs snf)N)rexpectrDDLConstraintColumnRolerMWhereHavingRolerN)r,r2r3columns r#__init__OnConflictClause.__init__s  %--,F  !>!>G,-D )*   ))   , D )0-s/A>)rMrNr>)r2r r3r )r?r@rArBrD__annotations__rTrHrIr$r#rKrKs< LL" 59.21,r$rKc\rSrSrSrSrg)r9r:rIN)r?r@rArB__visit_name__rHrIr$r#r9r9s-Nr$r9c`^\rSrSr%SrS\S'S\S'S S U4SjjjrSrU=r$) r1r6z0List[Tuple[Union[schema.Column[Any], str], Any]]update_values_to_setzOptional[ColumnElement[Any]]update_whereclausec>[TU]UUS9 [U[5(aU(d [ S5eO,[U[ 5(a [U5nO [ S5eUR 5VVs/sH,upV[R"[RU5U4PM. snnUl Ub+[R"[RU5Ul gSUl gs snnf)N)r2r3z*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 object)superrT isinstancedict ValueErrorritemsrrPr DMLColumnRoler\rRr])r,r2r3r4r5keyvalue __class__s r#rTOnConflictDoUpdate.__init__s )#  dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !     U22E :   % s73C))r\r]r=)r2r r3r r4r r5r ) r?r@rArBrYrVrTrH __classcell__)rgs@r#r1r1sR,NJJ4459.2 $#'  1 ,   !   r$r1N)r"rr<r)+ __future__rtypingrrrrr_typingr r r r rsqlrrr sql._typingrsql.baserrrrsql.dmlrStandardInsert sql.elementsrrrrsql.expressionr util.typingr__all__r rKr9r1rIr$r#rws#/,%',*#(0/)).&# (@^@F}@.*.% )% r$