o y\w @szddlmZddlmZddlmZddlmZddl m Z ddl m Z dZ Gdd d eZe ed ZGd d d eZd S))util) _generative)Insert) ClauseElement)alias)public_factory)rinsertc@s6eZdZdZeddZejddZe ddZ dS) rzMySQL-specific implementation of INSERT. Adds methods for MySQL-specific syntaxes such as ON DUPLICATE KEY UPDATE. .. versionadded:: 1.2 cCs|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:`.Insert.values` method. .. seealso:: :ref:`mysql_insert_on_duplicate_key_update` - example of how to use :attr:`.Insert.inserted` )inserted_aliascolumnsselfr O/var/www/html/env/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/dml.pyinsertedszInsert.insertedcCst|jddS)Nr)name)rtabler r r rr 'szInsert.inserted_aliascKst|dd}t|||_|S)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:`.Column.onupdate`. These values will not be exercised for an ON DUPLICATE KEY UPDATE style of UPDATE, unless values are manually specified here. .. versionadded:: 1.2 .. seealso:: :ref:`mysql_insert_on_duplicate_key_update` r N)getattrOnDuplicateClause_post_values_clause)r kwr r r ron_duplicate_key_update+s  zInsert.on_duplicate_key_updateN) __name__ __module__ __qualname____doc__propertyrrmemoized_propertyr rrr r r rr s  rz.dialects.mysql.insertc@seZdZdZddZdS)rrcCs&||_|r t|tstd||_dS)Nz/update parameter must be a non-empty dictionary)r isinstancedict ValueErrorupdate)r r r r r r__init__Ls zOnDuplicateClause.__init__N)rrr__visit_name__r!r r r rrIs rN)rsql.basersql.dmlrStandardInsert sql.elementsrsql.expressionrutil.langhelpersr__all__rrr r r rs      ;