-hDSSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSK J r SSK J r SS KJr S r"S S \ 5r\"\S S5r"SS\ 5rg))exc)util)_exclusive_against) _generative)ColumnCollection)Insert) ClauseElement)alias)public_factory)rinsertc|\rSrSrSrSrSr\S5r\ RS5r \ \ "SSS0S 9S 55rS rg ) 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 mysqlFc.URR$)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 rC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/mysql/dml.pyinsertedInsert.inserted$s<""***c*[URSS9$)Nr)name)r tablers rrInsert.inserted_aliasDsTZZj11r_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)msgscU(aU(a[R"S5eU(a+[U5S:a[R"S5eUSnOUn[USS5n[ XC5Ulg)ag 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.rN)r ArgumentErrorlengetattrOnDuplicateClauser)rargskwvaluesrs ron_duplicate_key_updateInsert.on_duplicate_key_updateHsth B##K  4y1}''0!WFF '7>#4^#L r)rN)__name__ __module__ __qualname____firstlineno____doc__stringify_dialect inherit_cachepropertyrrmemoized_propertyrrrr)__static_attributes__rrrrss  M ++> 22 !$5 <M<Mrrz.dialects.mysql.insertz.dialects.mysql.Insertc&\rSrSrSrSrSrSrSrg)r%r)NrcXl[U[5(aFU(a?[US[5(a'UVVs/sHup4UPM snnUl[ U5n[U[ 5(aU(d [ S5eO,[U[5(a [ U5nO [ S5eX lgs snnf)Nr!z-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 object) r isinstancelisttuple_parameter_orderingdict ValueErrorrupdate)rrr?keyvalues r__init__OnDuplicateClause.__init__s, fd # # z&)U33>D'Ef f'ED $&\F fd # # C 0 1 1&\F$   !(FsB=)r<rr?) r+r,r-r.__visit_name__r<r0rBr4r5rrr%r%s.Nrr%N)rrsql.baserrrsql.dmlrStandardInsert sql.elementsr sql.expressionr util.langhelpersr __all__r r%r5rrrMs[*#(/)#. wM^wMt  $&>  ! !r