+ i9^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^R I H t ^R I H t ^R I Ht^R IHt^R IHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHt^RIHtRt RRlt!!RR]4t!RR]4t"] ]]]3,]]]#]3,,]]]3,3,t$R#)) annotations)Any)Dict)List)Mapping)Optional)Tuple)Union)exc)util)_DMLTableArgument)_exclusive_against) _generative)ColumnCollection)ReadOnlyColumnCollectionInsert) ClauseElement)KeyedColumnElement)alias)NamedFromClause)Selfrc V^8dQhRRRR/#)tabler returnr)formats"wC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/dialects/mysql/dml.py __annotate__r #s#c\V4#)aConstruct a MySQL/MariaDB-specific variant :class:`_mysql.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy.dialects.mysql.insert` function creates a :class:`sqlalchemy.dialects.mysql.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:`_mysql.Insert` construct includes additional methods :meth:`_mysql.Insert.on_duplicate_key_update`. r)rs&rinsertr##s %=r!c]tRt^6tRtRtRt]RRl4t] PRRl4t ] ] !RRR /R 7R R l44tR tR#)rzMySQL-specific implementation of INSERT. Adds methods for MySQL-specific syntaxes such as ON DUPLICATE KEY UPDATE. The :class:`~.mysql.Insert` object is created using the :func:`sqlalchemy.dialects.mysql.insert` function. .. versionadded:: 1.2 mysqlFcV^8dQhRR/#)rrz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]]r)rs"rr Insert.__annotate__Fs++ ?+r!c .VPP#)aProvide the "inserted" namespace for an ON DUPLICATE KEY UPDATE statement MySQL's ON DUPLICATE KEY UPDATE clause allows reference to the row that would be inserted, via a special function called ``VALUES()``. This attribute provides all columns in this row to be referenceable such that they will render within a ``VALUES()`` function inside the ON DUPLICATE KEY UPDATE clause. The attribute is named ``.inserted`` so as not to conflict with the existing :meth:`_expression.Insert.values` method. .. tip:: The :attr:`_mysql.Insert.inserted` 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.inserted.some_column``), but special names and dictionary method names should be accessed using indexed access, such as ``stmt.inserted["column name"]`` or ``stmt.inserted["values"]``. See the docstring for :class:`_expression.ColumnCollection` for further examples. .. seealso:: :ref:`mysql_insert_on_duplicate_key_update` - example of how to use :attr:`_expression.Insert.inserted` )inserted_aliascolumnsselfs&rinsertedInsert.insertedEs@""***r!cV^8dQhRR/#)rrrr)rs"rr r'hs222r!c 0\VPRR7#)r-)name)rrr+s&rr)Insert.inserted_aliasgsTZZj11r!_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)msgsc$V^8dQhRRRRRR/#)rargs _UpdateArgkwrrrr)rs"rr r'ss&BBZBsBtBr!c V'dV'd\P!R4hV'd1\V4^8d\P!R4hV^,pMTp\VPV4VnV#)a Specifies the ON DUPLICATE KEY UPDATE clause. :param \**kw: Column keys linked to UPDATE values. The values may be any SQL expression or supported literal Python values. .. 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 DUPLICATE KEY UPDATE style of UPDATE, unless values are manually specified here. :param \*args: As an alternative to passing key/value parameters, a dictionary or list of 2-tuples can be passed as a single positional argument. Passing a single dictionary is equivalent to the keyword argument form:: insert().on_duplicate_key_update({"name": "some name"}) Passing a list of 2-tuples indicates that the parameter assignments in the UPDATE clause should be ordered as sent, in a manner similar to that described for the :class:`_expression.Update` construct overall in :ref:`tutorial_parameter_ordered_updates`:: insert().on_duplicate_key_update( [ ("name", "some name"), ("value", "some value"), ] ) .. versionchanged:: 1.3 parameters can be specified as a dictionary or list of 2-tuples; the latter form provides for parameter ordering. .. versionadded:: 1.2 .. seealso:: :ref:`mysql_insert_on_duplicate_key_update` z9Can't pass kwargs and positional arguments simultaneouslyzDOnly a single dictionary or list of tuples is accepted positionally.)r ArgumentErrorlenOnDuplicateClauser)r3)r,r6r8valuess&*, ron_duplicate_key_updateInsert.on_duplicate_key_updatekswp B##K  4y1}''0!WFF#4   $   r!)r3N)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachepropertyr-r memoized_propertyr)rrr>__static_attributes__rr!rrr6st  M ++B 22 !$5 BBr!cD]tRt^t$RtRtR]R&R]R&RtRR ltR t R#) r<r>NzOptional[List[str]]_parameter_orderingzDict[str, Any]updater%c$V^8dQhRRRRRR/#)rr)rrLr7rNoner)rs"rr OnDuplicateClause.__annotate__s$-7A r!c Wn\V\4'dLV'dD\V^,\4'd'VUUu.uFwr4VNK uppVn\ V4p\V\ 4'dV'g \ R4hM-\V\4'd \ V4pM \ R4hW nR#uuppi)rz-update parameter dictionary must not be emptyztupdate parameter must be a non-empty dictionary or a ColumnCollection such as the `.c.` collection of a Table objectN) r) isinstancelisttuplerKdict ValueErrorrrL)r,r)rLkeyvalues&&& r__init__OnDuplicateClause.__init__s- fd # # z&)U33>D'Ef f'ED $&\F fd # # C 0 1 1&\F$   !(Fs C)rKr)rL) r@rArBrC__visit_name__rK__annotations__rErXrIrr!rr<r<s).N/3,3 r!r<N)rr#)% __future__rtypingrrrrrr r r r sql._typingr sql.baserrrrsql.dmlrStandardInsert sql.elementsrrsql.expressionrsql.selectabler util.typingr__all__r#r<strr7rr!rris#,*#(0/).#- &^D$ $N CHtE#s(O,.>sCx.HH r!