rjX% ddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z d d l m Z d d l m Z d d lmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dl m!Z!d dl"m#Z#d dl$m%Z%d dl&m'Z'e rd dlm(Z(d dlm)Z)d dlm*Z*d dlm+Z+d d l$m,Z,d!Z-d+d#Z.Gd$d"eeZ/d,d&Z0Gd'd%eZGd(d)eeZ1e eeefeee2efeeeffZ3y*)-) annotations)Any)Dict)List)Mapping)Optional)Tuple) TYPE_CHECKING)Union)exc)util) coercions)roles)_DMLTableArgument)_exclusive_against)ColumnCollection)ReadOnlyColumnCollection)SyntaxExtensionInsert) ClauseElement)KeyedColumnElement)alias)NamedFromClause)NULLTYPE)InternalTraversal)Self)_LimitOffsetType)Delete)Update) ColumnElement)_TraverseInternalsType)rinsertDMLLimitClausect|S)zapply a LIMIT to an UPDATE or DELETE statement e.g.:: stmt = t.update().values(q="hi").ext(limit(5)) this supersedes the previous approach of using ``mysql_limit`` for update/delete statements. .. versionadded:: 2.1 )r%)limits h/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/dml.pyr'r'.s %  cVeZdZUdZdZdej fgZded<d dZ d dZ d dZ y ) r%mysqlmysql_dml_limit_clause _limit_clauser#_traverse_internalsc\tjtj|dd|_y)N)nametype_)rexpectrLimitOffsetRoler-)selfr's r(__init__zDMLLimitClause.__init__Fs$&--  ! !5t4 r)c<|j|jdyN post_criteriaapply_syntax_extension_pointappend_replacing_same_type)r4 update_stmts r(apply_to_updatezDMLLimitClause.apply_to_updateK00  + +_ r)c<|j|jdyr7r9)r4 delete_stmts r(apply_to_deletezDMLLimitClause.apply_to_deletePr>r)N)r'r)r<r!returnNone)r@r rBrC) __name__ __module__ __qualname__stringify_dialect__visit_name__rdp_clauseelementr.__annotations__r5r=rAr)r(r%r%>s=-N +<<=3/   r)rct|S)a(Construct 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)tables r(r$r$Vs %=r)czeZdZdZdZdZe d dZejd dZ e dddid d Z y )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. r+Tc.|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. .. 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_aliascolumnsr4s r(insertedzInsert.insertedvs@""***r)c0t|jdS)NrS)r0)rrMrRs r(rPzInsert.inserted_aliassTZZj11r)_post_values_clausezDThis Insert construct already has an ON DUPLICATE KEY clause present)msgsc|r|rtjd|r)t|dkDrtjd|d}n|}|jt |j |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:`_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"), ] ) .. 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)r ArgumentErrorlenextOnDuplicateClauserP)r4argskwvaluess r(on_duplicate_key_updatezInsert.on_duplicate_key_updatesu` B##K  4y1}''0!WFFxx)$*=*=vFGGr)N)rBz6ReadOnlyColumnCollection[str, KeyedColumnElement[Any]])rBr)r] _UpdateArgr^rrBr) rDrErF__doc__rG inherit_cachepropertyrSrmemoized_propertyrPrr`rKr)r(rrist M + ?++B 22 !$5 8H8Hr)ceZdZUdZdZded<ded<dZdejfdejfgZ d dZ d d Z y) r\r`NzOptional[List[str]]_parameter_orderingzDict[str, ColumnElement[Any]]updater+c ||_t|tr:|r8t|dtr%|Dcgc]\}}| c}}|_t |}t|t r |s2t dt|tr t |}n t d|jDcic]1\}}|tjtj|td3c}}|_ycc}}wcc}}w)Nrz-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 objectT)r1is_crud)rP isinstancelisttuplergdict ValueErrorritemsrr2rExpressionElementRolerrh)r4rPrhkeyvaluekvs r(r5zOnDuplicateClause.__init__s- fd # z&)U3>D'E U'ED $&\F fd # C 0 1&\F$    1 y++Qh   #(F" s C))6C/c<|j|jdy)N post_valuesr9)r4 insert_stmts r(apply_to_insertz!OnDuplicateClause.apply_to_inserts00  + +] r))rPrrhrarBrC)rxStandardInsertrBrC) rDrErFrHrgrJrGrdp_string_list dp_dml_valuesr.r5ryrKr)r(r\r\sj.N/3,3 ))  1 @ @A $223 " -" 7A" " H r)r\N)r'rrBr%)rMrrBr)4 __future__rtypingrrrrrr r r r rsqlrr sql._typingrsql.baserrrrsql.dmlrrz sql.elementsrrsql.expressionrsql.selectabler sql.sqltypesr sql.visitorsr util.typingrrr r!r"r#__all__r'r%r$r\strrarKr)r(rs# ,*(0'/).#-$-/!!-6  !  _m 0&rH^rHj4 4 n CHtE#s(O,.>sCx.HH r)