/
opt
/
alt
/
python27
/
lib64
/
python2.7
/
site-packages
/
sqlalchemy
/
dialects
/
mysql
/
up file
home
� 1��fc @ s� d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d Z d e f d � � YZ e e d d � Z d e f d � � YZ d S( i ( t exc( t util( t _exclusive_against( t _generative( t ColumnCollection( t Insert( t ClauseElement( t alias( t public_factoryR t insertc B sc e Z d Z d Z e Z e d � � Z e j d � � Z e e d d i d d 6�d � � � Z RS( s 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 t mysqlc C s | j j S( s� Provide 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` ( t inserted_aliast columns( t self( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyt inserted$ s c C s t | j d d �S( Nt nameR ( R t table( R ( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyR D s t _post_values_clauset msgssD This Insert construct already has an ON DUPLICATE KEY clause presentc O s� | r | r t j d � � n | rU t | � d k rH t j d � � n | d } n | } t | d d � } t | | � | _ d S( sO 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` s9 Can't pass kwargs and positional arguments simultaneouslyi sD Only a single dictionary or list of tuples is accepted positionally.i R N( R t ArgumentErrort lent getattrt Nonet OnDuplicateClauseR ( R t argst kwt valuesR ( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyt on_duplicate_key_updateH s 4 ( t __name__t __module__t __doc__t stringify_dialectt Falset inherit_cachet propertyR R t memoized_propertyR R R R ( ( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyR s s .dialects.mysql.inserts .dialects.mysql.InsertR c B s# e Z d Z d Z d Z d � Z RS( R R c C s� | | _ t | t � rb | rb t | d t � rb g | D] \ } } | ^ q8 | _ t | � } n t | t � r� | s� t d � � q� n* t | t � r� t | � } n t d � � | | _ d S( Ni s- update parameter dictionary must not be emptyst update parameter must be a non-empty dictionary or a ColumnCollection such as the `.c.` collection of a Table object( R t isinstancet listt tuplet _parameter_orderingt dictt ValueErrorR t update( R R R* t keyt value( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyt __init__� s " N( R R t __visit_name__R R' R R- ( ( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyR � s N( R R ( t R R t sql.baseR R R t sql.dmlR t StandardInsertt sql.elementsR t sql.expressionR t util.langhelpersR t __all__R R ( ( ( sP /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/dml.pyt <module> s z