؄_ddlmZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z dZGd d eZe ed d ZGd de ZdS))exc)util) _generative)Insert) ClauseElement)alias)public_factory)rinsertc^eZdZdZedZejdZe dZ dS)ra MySQL-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 c|jjS)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. .. seealso:: :ref:`mysql_insert_on_duplicate_key_update` - example of how to use :attr:`_expression.Insert.inserted` )inserted_aliascolumnsselfs b/var/www/book.euthymeo.com/html/venv/lib/python3.11/site-packages/sqlalchemy/dialects/mysql/dml.pyinsertedzInsert.inserteds$"**c.t|jdS)Nr)name)rtablers rr zInsert.inserted_alias-sTZj1111rc|r|rtjd|r0t|dkrtjd|d}n|}t|dd}t |||_|S)aE 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:`updates_order_parameters`:: 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 N)r ArgumentErrorlengetattrOnDuplicateClause_post_values_clause)rargskwvaluesr s ron_duplicate_key_updatezInsert.on_duplicate_key_update1sZ  B #K   4yy1}}'0!WFFF '7>>#4^V#L#L  rN) __name__ __module__ __qualname____doc__propertyrrmemoized_propertyr rr"rrrr ss  ++X+& 222==[===rrz.dialects.mysql.insertz.dialects.mysql.InsertceZdZdZdZdZdS)rr"Nc||_t|tr=|r;t|dtr d|D|_t |}|rt|t st d||_dS)Nrcg|]\}}|Sr)r)).0keyvalues r z.OnDuplicateClause.__init__..s'E'E'E U'E'E'Erz/update parameter must be a non-empty dictionary)r isinstancelisttuple_parameter_orderingdict ValueErrorupdate)rr r7s r__init__zOnDuplicateClause.__init__|s, fd # # "  "!&)U33 "(F'Ef'E'E'ED $&\\F PZ55 PNOO O r)r#r$r%__visit_name__r4r8r)rrrrws..NrrN)rrsql.basersql.dmlrStandardInsert sql.elementsrsql.expressionrutil.langhelpersr __all__r rr)rrrBs ######//////))))))######...... bbbbb^bbbJ  $&>    r