)f LddlmZddlmZddlmZddlmZddlmZddlmZdd l m Z dd l m Z dd l m Z dd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZdZd!dZ GddeZGddeZ!Gdde!Z"Gdde!Z#y )") annotations)Any)_OnConflictIndexElementsT)_OnConflictIndexWhereT)_OnConflictSetT)_OnConflictWhereT)util) coercions)roles)_DMLTableArgument)_exclusive_against) _generative)ColumnCollection)ReadOnlyColumnCollectionInsert) ClauseElement)KeyedColumnElement)alias)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 [/var/www/html/flask-app/venv/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/dml.pyrr s" %=ceZdZdZdZdZej d dZe dddiZ e e d d d Z e e d dd Z 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` sqliteFcDt|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)rrcolumns)selfs rr!zInsert.excludedGs,TZZj1999r_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc,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_whereset_wheres ron_conflict_do_updatezInsert.on_conflict_do_updategs"b$6 Ku$   rc(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*s ron_conflict_do_nothingzInsert.on_conflict_do_nothings*$7 K$   r)returnz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]NNNN) r)rr*rr+rr,r r2rNN)r)rr*rr2r)__name__ __module__ __qualname____doc__stringify_dialect inherit_cacher memoized_propertyr!r_on_conflict_exclusiverr-r1rrrr4s !M : ?::.0 !$0 59.2 $#' 212,2 2 ! 2  22h59.21,  rcDeZdZUdZded<ded<ded< d d d Zy) OnConflictClauserNoneconstraint_targetrinferred_target_elementsrinferred_target_whereclauseNc^|d|_||_||_ydx|_x|_|_y)N)rArBrCr0s r__init__zOnConflictClause.__init__sA  %%)D ",:D )/:D , D " T%B0rr4)r)rr*r)r5r6r7r9__annotations__rEr=rrr?r?s9 77!7759.2 1 , rr?ceZdZdZy)r/r1N)r5r6r7__visit_name__r=rrr/r/s-Nrr/c<eZdZdZ d dfd ZxZS)r(r-cbt|||t|tr |s2t dt|t r t|}n t d|j Dcgc]+\}}tjtj||f-c}}|_ ||_ ycc}}w)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 object) superrE isinstancedict ValueErrorritemsr expectr DMLColumnRoleupdate_values_to_setupdate_whereclause)r$r)r*r+r,keyvalue __class__s rrEzOnConflictDoUpdate.__init__s )#  dD ! !MNN . /:D$ #jjl% U  e113 7 ?% !#( % s*0B+r3)r)rr*rr+rr,r )r5r6r7rHrE __classcell__)rVs@rr(r(sF,N59.2 $#' (1(,( ( ! ((rr(N)rrr2r)$ __future__rtypingr_typingrrrr r sqlr r sql._typingrsql.baserrrrsql.dmlrStandardInsert sql.elementsrrsql.expressionr util.typingr__all__rr?r/r(r=rrres#/,%',*#(0/).# (A^AH},.*.()(r