-hSSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSK J r SSK J r SS KJr SS KJr S r"S S \ 5r \"\ SS5r"SS\ 5r"SS\5r"SS\5rg))util) coercions)roles)_exclusive_against) _generative)ColumnCollection)Insert) ClauseElement)alias)public_factory)r insertc\rSrSrSrSrSr\RS5r \ "SSS0S9r \ \ S S j55r \ \ SS j55rS 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)r tablecolumns)selfs sC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/sqlite/dml.pyrInsert.excluded*s(TZZj1999_post_values_clausezCThis Insert construct already has an ON CONFLICT clause established)msgsNc&[XX45Ulg)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). N)OnConflictDoUpdater)rindex_elements index_whereset_wheres ron_conflict_do_updateInsert.on_conflict_do_updateHsb$6 $  rc$[X5Ulg)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. N)OnConflictDoNothingrrrrs ron_conflict_do_nothingInsert.on_conflict_do_nothing}s"$7 $  r)rNNNNNN)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachermemoized_propertyrr_on_conflict_exclusiverr"r'__static_attributes__rrr r s !M ::*0 !$0   1 1 f  rr z.dialects.sqlite.insertz.dialects.sqlite.Insertc"\rSrSrSrSSjrSrg)OnConflictClauserNc\UbSUlXlX lgS=Ul=UlUlg)Nconstraint_targetinferred_target_elementsinferred_target_whereclauser&s r__init__OnConflictClause.__init__s<  %%)D ",: )/: ,48 8D " 8-0rr:r*)r+r,r-r.r0r>r4r5rrr7r7s   8rr7c\rSrSrSrSrg)r%r'r5N)r+r,r-r.__visit_name__r4r5rrr%r%s-Nrr%c8^\rSrSrSrSU4SjjrSrU=r$)rr"c>[[U] UUS9 [U[5(aU(d [ S5eO,[U[ 5(a [ U5nO [ S5eUR5VVs/sH,upV[R"[RU5U4PM. snnUl X@l gs snnf)N)rrz*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)superrr> isinstancedict ValueErrorritemsrexpectr DMLColumnRoleupdate_values_to_setupdate_whereclause)rrrr r!keyvalue __class__s rr>OnConflictDoUpdate.__init__s  $0)# 1 dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !#( % s;3B>)rMrNr))r+r,r-r.rBr>r4 __classcell__)rQs@rrrs ,N  ((rrN)rsqlrrsql.baserrrsql.dmlr StandardInsert sql.elementsr sql.expressionr util.langhelpersr __all__r r7r%rr5rrr]sv*#(/)#. y ^y x  %'@  8} 8.*.()(r