+ i$^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RIH t ^R IH t ^R IH t ^R I Ht^R IHt^R IHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RIH!t!^RI"H#t#^RI$H%t%R&t&RRlt'!RR]4t!RR ]4t(!R!R"](4t)!R#R$](4t*R%#)') 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)Selfrc V^8dQhRRRR/#)tablerreturnr)formats"ڇC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO CLAUDE\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy\dialects\sqlite\dml.py __annotate__r%'s#c\V4#)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)r s&r$insertr('s" %=r&c]tRt^;tRtRtRt]PRRl4t ] !RRR/R7t ] ] RR R ll44t ] ] RR R ll44tRtR #)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` sqliteFcV^8dQhRR/#)rr!z6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]r")r#s"r$r%Insert.__annotate__Os:: ?:r&c D\VPRR7P#)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 ,V^8dQhRRRRRRRRR R /#) rindex_elementsr index_wherer set_r wherer r!rr")r#s"r$r%r,ps<1111,1 1 ! 1  1r&c (\WW44VnV#)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). )OnConflictDoUpdater3)r1r6r7r8r9s&&&&&r$on_conflict_do_updateInsert.on_conflict_do_updatens`$6 $   r&c$V^8dQhRRRRRR/#)rr6r r7r r!rr")r#s"r$r%r,s(1,  r&c &\W4VnV#)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. )OnConflictDoNothingr3)r1r6r7s&&&r$on_conflict_do_nothingInsert.on_conflict_do_nothings*$7 $   r&)r3NNNNNN)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cacher memoized_propertyr.r_on_conflict_exclusiverr<rA__static_attributes__r"r&r$rr;s !M ::.0 !$0 11fr&c@]tRt^t$RtR]R&R]R&R RRlltR tR#) OnConflictClauser*z.Optional[List[Union[str, schema.Column[Any]]]]inferred_target_elementsz/Optional[Union[ColumnElement[Any], TextClause]]inferred_target_whereclauseNc V^8dQhRRRR/#)rr6r r7r r")r#s"r$r%OnConflictClause.__annotate__s1,r&c VemVUu.uF(p\P!\PV4NK* upVnVe&\P!\P V4MRVnR#R;VnVnR#uupi)N)rexpectrDDLConstraintColumnRolerQWhereHavingRolerR)r1r6r7columns&&& r$__init__OnConflictClause.__init__s  %--,F  !>!>G,-D )*   ))   , D )0-s.B)rQrRrD)rErFrGrHrJ__annotations__rZrNr"r&r$rPrPs" LL"r&rPc]tRt^tRtRtR#)r@rAr"N)rErFrGrH__visit_name__rNr"r&r$r@r@s-Nr&r@cLa]tRt^t$RtR]R&R]R&R RV3RllltRtV;t#) r;r<z0List[Tuple[Union[schema.Column[Any], str], Any]]update_values_to_setzOptional[ColumnElement[Any]]update_whereclausec(V^8dQhRRRRRRRR/#) rr6r r7r r8r r9r r")r#s"r$r%OnConflictDoUpdate.__annotate__s2  1 ,   !  r&c <\SV`VVR7\V\4'dV'g \ R4hM-\V\ 4'd \V4pM \ R4hVP 4UUu.uF,wrV\P!\PV4V3NK. uppVn Ve-\P!\PV4Vn R#RVn R#uuppi))r6r7z*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 objectN)superrZ isinstancedict ValueErrorritemsrrVr DMLColumnRoler`rXra)r1r6r7r8r9keyvalue __class__s&&&&& r$rZOnConflictDoUpdate.__init__s )#  dD ! ! !MNN . / /:D$ #jjl% *   e113 7 ?*% !     U22E :   % s=2C1)r`rarC) rErFrGrHr^r\rZrN __classcell__)rms@r$r;r;s#,NJJ44   r&r;N)rr()+ __future__rtypingrrrrr_typingr r r r r sqlrrr sql._typingrsql.baserrrrsql.dmlrStandardInsert sql.elementsrrrrsql.expressionr util.typingr__all__r(rPr@r;r"r&r$r}s#/,%',*#(0/)).&# (@^@F}@.*.% )% r&