Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/sql/__pycache__/compiler.cpython-39.pyc
Ðазад
a _�h�� � J @ sp d Z ddlZddlZddlZddlmZ ddlmZ ddlmZ ddlmZ ddlm Z dd lm Z dd lm Z dd lm Z d d lm Z d dlmZ eg d��Ze�dej�Ze�dej�Zdd� edd�D ��dg�Ze�dej�Ze�dej�Ze�dej�Ze�dej�Z e�dej�Z ddd d d d �Z ej d ej d!ej!d"ej"d#ej#d$ej$d%ej%d&ej&d%ej'd'ej(d(ej)d)ej*d*ej+d+ej,d,ej-d-ej.d.ej/d/ej0d0ej1d1ej2d2ej3d3ej4d4ej5d5ej6d6ej7d7ej8d8ej9d9ej:d:ej;d;ej<d<ej=d=ej>d>ej?d?ej@d@ejAdAejBdBejCdCi%ZDejEdDejFdEejGdFejHdGejIdHejJdIejKdJejLdKejMdLejNdMejOdNejPdOejQdPejRdQiZSdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`da�ZTe jUjVdbe jUjWdce jUjXdde jUjYdee jUjZdfe jUj[dgiZ\G dhdi� die]�Z^G djdk� dke�_ej`e]��ZaG dldm� dme jb�ZcG dndo� doed�ZeG dpdq� dqe^�ZfG drds� dsef�ZgG dtdu� due^�ZhG dvdw� dwea�ZiG dxdy� dyei�ZjG dzd{� d{e]�ZkdS )|a] Base SQL and DDL compiler implementations. Classes provided include: :class:`.compiler.SQLCompiler` - renders SQL strings :class:`.compiler.DDLCompiler` - renders DDL (data definition language) strings :class:`.compiler.GenericTypeCompiler` - renders type specification strings. To generate user-defined SQL strings, see :doc:`/ext/compiler`. � N� )�crud)�elements)� functions)� operators)�schema)� selectable)�sqltypes)�visitors� )�exc)�util)^�allZanalyseZanalyze�and�any�array�as�ascZ asymmetric� authorizationZbetween�binaryZboth�case�cast�check�collate�column� constraint�create�cross� current_dateZ current_role� current_time�current_timestamp� current_user�default� deferrable�descZdistinct�do�else�end�except�false�forZforeign�freeze�from�fullZgrant�groupZhavingZilike�in� initially�innerZ intersectZinto�isZisnull�join�leading�left�like�limit� localtime�localtimestampZnatural�new�notZnotnull�null�off�offset�old�on�only�or�order�outer�overlapsZplacing�primaryZ references�right�select� session_user�setZsimilarZsome� symmetric�tableZthen�toZtrailing�true�union�unique�user�using�verbose�when�wherez ^[A-Z0-9_$]+$z^[A-Z0-9_ $]+$c C s h | ] }t |��qS � )�str)�.0�xrV rV ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/sql/compiler.py� <setcomp>� � r[ � �$z5^(?:RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULT)$z^(?:DEFERRED|IMMEDIATE)$z%(?<![:\w\$\x5c]):([\w\$]+)(?![:\w\$])z\x5c(:[\w\$]*)(?![:\w\$])z %%(%(name)s)s�?z%%sz :[_POSITION]z :%(name)s)�pyformatZqmark�format�numeric�namedz AND z OR z + z * z - z / � % �-z < z <= z != z > z >= z = z IS DISTINCT FROM z IS NOT DISTINCT FROM z || z MATCH z NOT MATCH z IN z NOT IN �, z FROM � AS z IS z IS NOT z COLLATE zEXISTS � DISTINCT zNOT zANY zALL z DESCz ASCz NULLS FIRSTz NULLS LAST�coalesceZ CURRENT_DATEZ CURRENT_TIMEZCURRENT_TIMESTAMPZ CURRENT_USERZ LOCALTIMEZLOCALTIMESTAMP�random�sysdateZ SESSION_USER�USERZCUBEZROLLUPz GROUPING SETS�month�day�year�second�hour�doy�minute�quarter�dow�week�epoch� milliseconds� microseconds� timezone_hour�timezone_minute)rm rn ro rp rq rr rs rt ru rv rw rx ry rz r{ �UNIONz UNION ALL�EXCEPTz EXCEPT ALL� INTERSECTz INTERSECT ALLc @ s� e Zd ZdZdZdZe�� Zdde�� fdd�Z e� dd�dd� �Z d d � Z e d d � �Zd d� Zdd� Zddd�Ze dd� �Zdd� Zdd� ZdS )�Compileda Represent a compiled SQL or DDL expression. The ``__str__`` method of the ``Compiled`` object should produce the actual text of the statement. ``Compiled`` objects are specific to their underlying database dialect, and also may or may not be specific to the columns referenced within a particular set of bind parameters. In no case should the ``Compiled`` object be dependent on the actual values of those bind parameters, even though it may reference those values as defaults. Nc C sl || _ || _| j j| _|| _|r.| j�|�| _|durh|| _|j| _| jrR|j | _ | j | jfi |��| _ dS )a| Construct a new :class:`.Compiled` object. :param dialect: :class:`.Dialect` to compile against. :param statement: :class:`_expression.ClauseElement` to be compiled. :param bind: Optional Engine or Connection to compile this statement against. :param schema_translate_map: dictionary of schema names to be translated when forming the resultant SQL .. versionadded:: 1.1 .. seealso:: :ref:`schema_translating` :param compile_kwargs: additional kwargs that will be passed to the initial call to :meth:`.Compiled.process`. N) �dialect�bindZidentifier_preparer�preparer�schema_translate_map�_with_schema_translate� statementZsupports_execution� can_execute�_execution_options�execution_options�process�string)�selfr� r� r� r� �compile_kwargsrV rV rZ �__init__ s �zCompiled.__init__z0.7z�The :meth:`.Compiled.compile` method is deprecated and will be removed in a future release. The :class:`.Compiled` object now runs its compilation within the constructor, and this method does nothing.c C s dS )z;Produce the internal string representation of this element.NrV �r� rV rV rZ �compileD s zCompiled.compilec C s$ | j r|�| ||�S t�| j��d S �N)r� �_execute_compiledr ZObjectNotExecutableErrorr� )r� � connection� multiparams�paramsrV rV rZ �_execute_on_connectionO s z Compiled._execute_on_connectionc C s t � �dS )z�Return a Compiled that is capable of processing SQL expressions. If this compiler is one, it would likely just return 'self'. N��NotImplementedErrorr� rV rV rZ � sql_compilerU s zCompiled.sql_compilerc K s |j | fi |��S r� ��_compiler_dispatch)r� �obj�kwargsrV rV rZ r� _ s zCompiled.processc C s | j pdS )z3Return the string text of the generated SQL or DDL.� )r� r� rV rV rZ �__str__b s zCompiled.__str__c C s t � �dS )z�Return the bind params for this compiled object. :param params: a dict of string/object pairs whose values will override bind values compiled in to the statement. Nr� �r� r� rV rV rZ �construct_paramsg s zCompiled.construct_paramsc C s | � � S )z0Return the bind params for this compiled object.�r� r� rV rV rZ r� q s zCompiled.paramsc O s* | j }|du r tjddd��|�| ||�S )z Execute this compiled object.Nz>This Compiled object is not bound to any Engine or Connection.Z2afi��code)r� r ZUnboundExecutionErrorr� )r� r� r� �erV rV rZ �executev s �zCompiled.executec O s | j |i |���� S )zJExecute this compiled object and return the result's scalar value.)r� �scalar)r� r� r� rV rV rZ r� � s zCompiled.scalar)N)�__name__� __module__� __qualname__�__doc__Z_cached_metadatar� r � immutabledictr� r� � deprecatedr� r� �propertyr� r� r� r� r� r� r� rV rV rV rZ r � s. � 0� r c @ s$ e Zd ZdZdZdd� Zdd� ZdS )� TypeCompilerz2Produces DDL specification for TypeEngine objects.z visit_\w+c C s || _ d S r� )r� )r� r� rV rV rZ r� � s zTypeCompiler.__init__c K s |j | fi |��S r� r� �r� �type_�kwrV rV rZ r� � s zTypeCompiler.processN)r� r� r� r� Z ensure_kwargr� r� rV rV rV rZ r� � s r� c @ sB e Zd ZdZdZdZddd�Zedd� �Zed d � �Z d d � Z d S )� _CompileLabelz;lightweight label object which acts as an expression.Label.�label)�element�namerV c C s || _ || _|f| | _d S r� )r� r� � _alt_names)r� �colr� � alt_namesrV rV rZ r� � s z_CompileLabel.__init__c C s | j jS r� )r� � proxy_setr� rV rV rZ r� � s z_CompileLabel.proxy_setc C s | j jS r� )r� �typer� rV rV rZ r� � s z_CompileLabel.typec K s | S r� rV )r� r� rV rV rZ � self_group� s z_CompileLabel.self_groupN)rV ) r� r� r� r� �__visit_name__� __slots__r� r� r� r� r� rV rV rV rZ r� � s r� c @ s e Zd ZdZdd� ZdS )�prefix_anon_mapac A map that creates new keys for missing key access. Considers keys of the form "<ident> <name>" to produce new symbols "<name>_<index>", where "index" is an incrementing integer corresponding to <name>. Inlines the approach taken by :class:`sqlalchemy.util.PopulateDict` which is otherwise usually used for this type of operation. c C sD |� dd�\}}| �|d�}|d | |< |d t|� }|| |< |S )N� r �_)�split�getrW )r� �key�identZderivedZanonymous_counter�valuerV rV rZ � __missing__� s zprefix_anon_map.__missing__N)r� r� r� r� r� rV rV rV rZ r� � s r� c @ s� e Zd ZdZeZeZd Z Z Z dZ dZ dZ dZdZdZdZdZdZdZd ZZ�ddd�Zedd � �Zed d � �Zej d d � �Z e j dd� �Z dd� Z!ej"dd� �Z#dd� Z$edd� �Z%�ddd�Z&edd� �Z'e�(d �d d � �Z)d d � Z*�dd!d"�Z+�dd#d$�Z,�dd%d&�Z-�d d'd(�Z.d)d*� Z/�d d+d,�Z0d-d.� Z1d/d0� Z2d1d2� Z3d3d4� Z4d5d6� Z5d7d8� Z6d9d:� Z7�d d;d<�Z8d=d>� Z9d?d@� Z:dAdB� Z;dCdD� Z<dEdF� Z=dGdH� Z>dIdJ� Z?dKdL� Z@dMdN� ZAdOdP� ZBdQdR� ZCdSdT� ZD�d dUdV�ZEdWdX� ZFdYdZ� ZGd[d\� ZH�d d^d_�ZId`da� ZJdbdc� ZKddde� ZLdfdg� ZMdhdi� ZNdjdk� ZOdldm� ZPdndo� ZQdpdq� ZR�ddrds�ZSdtdu� ZTdvdw� ZUdxdy� ZVdzd{� ZWd|d}� ZX�dd~d�ZYd�d�� ZZd�d�� Z[ej"d�d�� �Z\d�d�� Z]d�d�� Z^d�d�� Z_d�d�� Z`d�d�� Zad�d�� Zbd�d�� Zcd�d�� Zdd�d�� Zed�d�� Zfd�d�� Zgd�d�� Zh�dd�d��Zid�d�� Zjd�d�� Zkd�d�� Zld�d�� Zmd�d�� Zn�dd�d��Zo�dd�d��Zp�dd�d��Zqd�d�� Zr�dd�d��Zsd�d�� Ztd�d�� Zu�dd�d��Zvd�d�� Zwd�d�� Zxd�d�� Zyd�d�� Zzd�dÄ Z{d�dń Z|d�dDŽ Z}e�~d�e� fd�e� fg�Z��dd�d˄Z��dd�d̈́Z�d�dτ Z�d�dф Z�d�dӄ Z�d�dՄ Z�d�dׄ Z�d�dل Z�d�dۄ Z�d�d݄ Z�d�d߄ Z�d�d� Z�d�d� Z�d�d� Z��dd�d�Z��dd�d�Z�d�d� Z��dd�d�Z�d�d� Z�d�d� Z�d�d� Z��dd�d��Z�ej"d�d�� �Z�d�d�� Z�d�d�� Z��d d�d��Z�d�d�� Z��d �d� Z��d�d� Z�dS ( � SQLCompilerz~Default implementation of :class:`.Compiled`. Compiles :class:`_expression.ClauseElement` objects into SQL strings. FNTrV c K s� || _ |pt|dd�| _i | _t�� | _g | _g | _|j | _ | j rTg | _ |j dk| _ t |j | _d| _|jpp|j| _t� | _i | _tj| ||fi |�� | js�| js�| jr�|jr�|j| _| j r�| j r�| � � dS )a Construct a new :class:`.SQLCompiler` object. :param dialect: :class:`.Dialect` to be used :param statement: :class:`_expression.ClauseElement` to be compiled :param column_keys: a list of column names to be compiled into an INSERT or UPDATE statement. :param inline: whether to generate INSERT statements as "inline", e.g. not formatted to return any generated defaults :param kwargs: additional keyword arguments to be consumed by the superclass. �inlineFrb N) � column_keys�getattrr� �bindsr Z column_dict� bind_names�stack�_result_columns� positional� positiontup� paramstyle�_numeric_binds�BIND_TEMPLATES� bindtemplate�ctes� label_length�max_identifier_lengthr� �anon_map�truncated_namesr r� �isinsert�isupdate�isdelete� _returning� returning�_apply_numbered_params)r� r� r� r� r� r� rV rV rZ r� s8 ����� zSQLCompiler.__init__c C sL z| j d d W S tyF } z tjtd�|d� W Y d}~n d}~0 0 dS )a� Return the current 'executable' that is being compiled. This is currently the :class:`_sql.Select`, :class:`_sql.Insert`, :class:`_sql.Update`, :class:`_sql.Delete`, :class:`_sql.CompoundSelect` object that is being compiled. Specifically it's assigned to the ``self.stack`` list of elements. When a statement like the above is being compiled, it normally is also assigned to the ``.statement`` attribute of the :class:`_sql.Compiler` object. However, all SQL constructs are ultimately nestable, and this attribute should never be consulted by a ``visit_`` method, as it is not guaranteed to be assigned nor guaranteed to correspond to the current statement being compiled. .. versionadded:: 1.3.21 For compatibility with previous versions, use the following recipe:: statement = getattr(self, "current_executable", False) if statement is False: statement = self.stack[-1]["selectable"] For versions 1.4 and above, ensure only .current_executable is used; the format of "self.stack" may change. ���r z$Compiler does not have a stack entry�Zreplace_contextN)r� � IndexErrorr �raise_)r� ZierV rV rZ �current_executableZ s �z SQLCompiler.current_executablec C s t | j| j �S r� )�list�insert_prefetch�update_prefetchr� rV rV rZ �prefetch� s zSQLCompiler.prefetchc C s& t �� | _i | _d| _| jr"i | _dS )z�Initialize collections related to CTEs only if a CTE is located, to save on the overhead of these collections otherwise. FN)r � OrderedDictr� � ctes_by_name�ctes_recursiver� �cte_positionalr� rV rV rZ �_init_cte_state� s zSQLCompiler._init_cte_statec c s� | j | j }}g d | _ | _zL| jr8| jd }d|d< nd}| j | jfV W |rZ|�d� || | _ | _n |rx|�d� || | _ | _0 dS )z;special API to support the use case of 'nested result sets'Fr� T�need_result_map_for_nestedN)r� �_ordered_columnsr� �pop)r� Zresult_columnsZordered_columns�entryrV rV rZ �_nested_result� s( � � � �zSQLCompiler._nested_resultc s( t �d�� t�d� fdd�| j�| _d S )Nr z \[_POSITION\]c s t t�� ��S r� )rW r �next��m�ZposcountrV rZ �<lambda>� r\ z4SQLCompiler._apply_numbered_params.<locals>.<lambda>)� itertools�count�re�subr� r� rV r� rZ r� � s �z"SQLCompiler._apply_numbered_paramsc s" t dd� � fdd�� jD �D ��S )Nc s s" | ]\}}|d ur||fV qd S r� rV )rX r� r� rV rV rZ � <genexpr>� s �z/SQLCompiler._bind_processors.<locals>.<genexpr>c 3 s& | ] }� j | |j�� j�fV qd S r� )r� r� Z_cached_bind_processorr� )rX � bindparamr� rV rZ r� � s � �)�dictr� r� rV r� rZ �_bind_processors� s ��z SQLCompiler._bind_processorsc C s t | j�dkS �Nr )�lenr� r� rV rV rZ � is_subquery� s zSQLCompiler.is_subqueryc C s | S r� rV r� rV rV rZ r� � s zSQLCompiler.sql_compilerc C s* |r�i }| j D ]�}| j | }|j|v r6||j ||< q||v rL|| ||< q|r�|jr�|rttjd|j|f dd��q�tjd|j dd��q|jr�|j||< q|j||< q|S i }| j D ]j}|r�|jr�|r�tjd|j|f dd��ntjd|j dd��|j�r|j|| j | < q�|j|| j | < q�|S dS )z5return a dictionary of bind parameter keys and valuesz@A value is required for bind parameter %r, in parameter group %dZcd3xr� z)A value is required for bind parameter %rN)r� r� �requiredr ZInvalidRequestError�callable�effective_valuer� )r� r� Z _group_number�_check�pdr� r� rV rV rZ r� � s\ ���� ����z SQLCompiler.construct_paramsc C s | j dd�S )zoReturn the bind param dictionary embedded into this compiled object, for those values that are present.F)r r� r� rV rV rZ r� � s zSQLCompiler.paramszsqlalchemy.engine.resultc C s |j �| j�S )z(utility method used for unit tests only.)ZResultMetaData�_create_result_mapr� )r� �resultrV rV rZ r s z SQLCompiler._create_result_mapc C s dS )z�Called when a SELECT statement has no froms, and no FROM clause is to be appended. Gives Oracle a chance to tack on a ``FROM DUAL`` to the string output. r� rV r� rV rV rZ � default_from s zSQLCompiler.default_fromc K s d|j j| fi |�� d S )N�(�)�r� r� )r� �grouping�asfromr� rV rV rZ �visit_grouping s zSQLCompiler.visit_groupingc K s� | j rl| jjrl| j d d }|j\}}}|r2|}n|}|jj} | d url| j|v rl| �|| j �rl|jj|d< | j|jfd|i|��S )Nr� r �render_label_as_label�within_columns_clause) r� r� Z supports_simple_order_by_label�_label_resolve_dictr� Z_order_by_label_elementr� Zshares_lineager� ) r� r� r r� r � with_cols� only_froms� only_colsZ resolve_dictZ order_by_elemrV rV rZ �visit_label_reference s4 ���� �����z!SQLCompiler.visit_label_referencec K s� | j s| �|j�S | j d d }|j\}}}z |r>||j }n ||j }W n: ty� } z"tj|jtj d| d� W Y d } ~ n(d } ~ 0 0 ||d< | j|fd|i|��S d S )Nr� r zECan't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.)�errr r ) r� r� Z _text_clauser r� �KeyErrorr Z_no_text_coercionr � CompileError) r� r� r r� r r r r r� ZkerV rV rZ � visit_textual_label_reference6 s. � ���z)SQLCompiler.visit_textual_label_referencec K s� |o| }||u }|s|r>t |jtj�r8| �d|j�} n|j} |r�|d urf|| |j|| f|j |j� |jj| fddd�|��t t j | j � || � S |r�| j � || �S |jj| fddi|��S d S )N�colidentT)r �within_label_clauser F)� isinstancer� r �_truncated_label�_truncated_identifierr� r� r� r� � OPERATORSr �as_r� � format_label) r� r� �add_to_result_mapr r r r� Zrender_label_with_asZrender_label_onlyZ labelnamerV rV rZ � visit_labelR sJ � ����� �� ���zSQLCompiler.visit_labelc C s t �d��d S )Nz:Cannot compile Column object until its 'name' is assigned.�r r �r� r rV rV rZ �_fallback_column_name� s �z!SQLCompiler._fallback_column_namec K s� |j }}|d u r | �|�}|j}|s>t|tj�r>| �d|�}|d ur^||||||jf|j� |rn| � |�}n | j � |�}|j }|d u s�|r�|j s�|S | j �|�} | r�| j �| �d } nd} |j } t| tj�r�| �d| �} | | j � | � d | S d S )Nr �.r� �alias)r� r( � is_literalr r r r r� r� �escape_literal_columnr� �quoterL Znamed_with_column�schema_for_object� quote_schema) r� r r$ � include_tabler� r� Z orig_namer+ rL �effective_schemaZ schema_prefixZ tablenamerV rV rZ � visit_column� s2 � � zSQLCompiler.visit_columnc K s | j �|j�S r� )r� �format_collation� collation)r� r� r� rV rV rZ �visit_collation� s zSQLCompiler.visit_collationc K s |j S r� �r� )r� Z fromclauser� rV rV rZ �visit_fromclause� s z SQLCompiler.visit_fromclausec K s |j S r� r6 )r� �indexr� rV rV rZ � visit_index� s zSQLCompiler.visit_indexc K s ||d< | j jj|jfi |��S )N�type_expression)r� � type_compilerr� r� )r� � typeclauser� rV rV rZ �visit_typeclause� s z SQLCompiler.visit_typeclausec C s | j jr|�dd�}|S �N�%�%%�r� �_double_percents�replace�r� �textrV rV rZ �post_process_text� s z SQLCompiler.post_process_textc C s | j jr|�dd�}|S r> rA rD rV rV rZ r, � s z!SQLCompiler.escape_literal_columnc s< � ��fdd�}�j s d�_t�dd� t�|���j���S )Nc sB | � d�}|�jv r,�j�j| fi � ��S �j|fi � ��S d S r )r. Z _bindparamsr� �bindparam_string)r� r� �r� r� � textclauserV rZ � do_bindparam� s z2SQLCompiler.visit_textclause.<locals>.do_bindparamTc S s | � d�S r )r. r� rV rV rZ r� � r\ z.SQLCompiler.visit_textclause.<locals>.<lambda>)r� � isplaintext�BIND_PARAMS_ESCr� � BIND_PARAMSrF rE )r� rI r� rJ rV rH rZ �visit_textclause� s ��z SQLCompiler.visit_textclausec K s� | j }|r| jn| j d }|p>|dkr4|�dd�p>|�dd�}|rp|j | _| _|jD ]} | j| d| jd� qX| j|j fi |��} |r�|r�d| } | S ) Nr� r � need_result_map_for_compoundFr� T�r r$ �(%s)) r� �_default_stack_entryr� r� r� �_textual_ordered_columnsZ column_argsr� �_add_to_result_mapr� ) r� Ztaf�compound_indexr �parensr� �toplevelr� �populate_result_map�crE rV rV rZ �visit_text_as_from� s, � � � �z SQLCompiler.visit_text_as_fromc K s dS )NZNULLrV �r� �exprr� rV rV rZ � visit_null� s zSQLCompiler.visit_nullc K s | j jr dS dS d S )NrN �1�r� �supports_native_booleanr[ rV rV rZ � visit_true� s zSQLCompiler.visit_truec K s | j jr dS dS d S )Nr) �0r_ r[ rV rV rZ � visit_false s zSQLCompiler.visit_falsec s^ |j }|d u rd}n t|j }|�dd� � �fdd�|jD �D ��}|jrZ�jjrZd| }|S )Nr� c s s | ]}|r|V qd S r� rV �rX �srV rV rZ r� s �z/SQLCompiler.visit_clauselist.<locals>.<genexpr>c 3 s | ]}|j �fi � ��V qd S r� r� �rX rY �r� r� rV rZ r� s zVALUES )�operatorr! r3 �clausesZ _tuple_valuesr� Ztuple_in_values)r� Z clauselistr� �seprE rV rg rZ �visit_clauselist s ��z SQLCompiler.visit_clauselistc K s� d}|j d ur*||j j| fi |��d 7 }|jD ]<\}}|d|j| fi |�� d |j| fi |�� d 7 }q0|jd ur�|d|jj| fi |�� d 7 }|d7 }|S )NzCASE r� zWHEN z THEN zELSE �END)r� r� ZwhensZelse_)r� �clauser� rY Zcondr rV rV rZ � visit_case s* ����� �zSQLCompiler.visit_casec K s |j j| fi |��S r� )Ztyped_expressionr� )r� Z type_coercer� rV rV rZ �visit_type_coerce. s z SQLCompiler.visit_type_coercec K s, d|j j| fi |��|jj| fi |��f S )NzCAST(%s AS %s))rm r� r< )r� r r� rV rV rZ � visit_cast1 s �zSQLCompiler.visit_castc K s� d|d t ju rdnd|d t ju r&dnR|d dk rXd| jt �t|d ��fi |��f n d| jt �|d �fi |��f |d t ju r�dnd|d t ju r�dnR|d dk r�d| jt �t|d ��fi |��f n d| jt �|d �fi |��f f S ) Nz %s AND %sr zUNBOUNDED PRECEDINGz CURRENT ROWz %s PRECEDINGz %s FOLLOWINGr zUNBOUNDED FOLLOWING)r ZRANGE_UNBOUNDEDZ RANGE_CURRENTr� �literal�abs)r� �range_r� rV rV rZ �_format_frame_clause7 s0 � � � � � � � � � ��z SQLCompiler._format_frame_clausec s� |j r d�j|j fi � �� }n$|jr@d�j|jfi � �� }nd }d|jj�fi � ��d�� �fdd�d|jfd|jffD �|r�|gng �f S ) NzRANGE BETWEEN %szROWS BETWEEN %sz %s OVER (%s)r� c s: g | ]2\}}|d urt |�rd||j�fi � ��f �qS )Nz%s BY %s)r r� )rX �wordrm �r� r� rV rZ � <listcomp>] s ��z*SQLCompiler.visit_over.<locals>.<listcomp>Z PARTITIONZORDER)rs rt �rowsr� r� r3 Z partition_by�order_by)r� Zoverr� rs rV rv rZ � visit_overN s2 �� �� �� ���zSQLCompiler.visit_overc K s, d|j j| fi |��|jj| fi |��f S )Nz %s WITHIN GROUP (ORDER BY %s))r� r� ry )r� Z withingroupr� rV rV rZ �visit_withingroupj s �z SQLCompiler.visit_withingroupc K s, d|j j| fi |��|jj| fi |��f S )Nz%s FILTER (WHERE %s))�funcr� � criterion)r� Z funcfilterr� rV rV rZ �visit_funcfilterp s �z SQLCompiler.visit_funcfilterc K s. | j �|j|j�}d||jj| fi |��f S )NzEXTRACT(%s FROM %s))� extract_mapr� �fieldr\ r� )r� �extractr� r� rV rV rZ � visit_extractv s �zSQLCompiler.visit_extractc s� |d ur ||j |j d|j� t�d|j �� d �}|rF||fi |��S t�|jd �� � rh|jr�� d7 � n6|j � �j� � �s�t � t j �r��j� � �n� � � d � d�� �fdd�|jD �� g �d�j|fi |��i S d S )NrV z visit_%s_funcz%(expr)sr) c s4 g | ],}�j �|�s t� tj�r,�j �|�n|�qS rV )r� � _requires_quotes_illegal_charsr r � quoted_namer- )rX �tok�r� r� rV rZ rw � s � � �z.SQLCompiler.visit_function.<locals>.<listcomp>r\ )r� r� r� �lower� FUNCTIONSr� � __class__Z _has_argsr� r� r r r� r- r3 Z packagenames�function_argspec)r� r| r$ r� �disprV r� rZ �visit_function} s4 � �� � �� �zSQLCompiler.visit_functionc K s | � |j�S r� )�visit_sequence�sequence)r� Z next_valuer� rV rV rZ �visit_next_value_func� s z!SQLCompiler.visit_next_value_funcc K s t d| jj ��d S )Nz2Dialect '%s' does not support sequence increments.�r� r� r� )r� r� r� rV rV rZ r� � s ��zSQLCompiler.visit_sequencec K s |j j| fi |��S r� )Z clause_exprr� )r� r| r� rV rV rZ r� � s z SQLCompiler.function_argspecr c s8 �j }|r�jn�j d }|p2|dko2|�dd�}�j �|d |d ||d�� �j�|j�} d| d �� ��fd d �t|j�D ��} | �j |fi t f d � i�����7 } | �j |fi ���7 } | |j d us�|j d ur�j|fi ���p�d 7 } �j�r |�r ��� | } �j �d� � �r0|�r0d | d S | S d S )Nr� r rO F�correlate_froms� asfrom_froms)r� r� r rO r� c 3 s, | ]$\}}|j �f� d |d����V qdS )F)r rV rU Nr� )rX �irY �r r� r� rV rZ r� � s ����z4SQLCompiler.visit_compound_select.<locals>.<genexpr>r r� r r )r� rR r� �append�compound_keywords�keywordr3 � enumerate�selects�group_by_clauser� �order_by_clause� _limit_clause�_offset_clause� limit_clauser� �_render_cte_clauser� ) r� �csr rV rU r� rW r� Zneed_result_mapr� rE rV r� rZ �visit_compound_select� sB ��� �� $�� z!SQLCompiler.visit_compound_selectc C s( d|j ||rd| ndf }t| |d �S )Nz visit_%s_%s%sr� r� )r� r� )r� � operator_Z qualifier1Z qualifier2�attrnamerV rV rZ �_get_operator_dispatch� s �z"SQLCompiler._get_operator_dispatchc K s� |j rZ|jrt�d��| �|j dd�}|r>|||j fi |��S | j|t|j fi |��S nT|jr�| �|jdd�}|r�|||jfi |��S | j|t|j fi |��S n t�d��d S )NzFUnary expression does not support operator and modifier simultaneously�unaryrh �modifierz,Unary expression has no operator or modifier)rh r� r r r� � _generate_generic_unary_operatorr! � _generate_generic_unary_modifier)r� r� r� r� rV rV rZ � visit_unary� s: �� ��� ���zSQLCompiler.visit_unaryc K s> |j s| jjr"| j|jfi |��S d| j|jfi |�� S d S )Nz%s = 1�Z_is_implicitly_booleanr� r` r� r� �r� r� rh r� rV rV rZ �visit_istrue_unary_operator s ��z'SQLCompiler.visit_istrue_unary_operatorc K sB |j s| jjr&d| j|jfi |�� S d| j|jfi |�� S d S )N�NOT %sz%s = 0r� r� rV rV rZ � visit_isfalse_unary_operator s ��z(SQLCompiler.visit_isfalse_unary_operatorc K s d| j |tjd� S )Nr� )�override_operator)� visit_binaryr �match_op�r� r rh r� rV rV rZ �visit_notmatch_op_binary s �z$SQLCompiler.visit_notmatch_op_binaryc C s t �d� d S )Nz�The IN-predicate was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate. Consider alternative strategies for improved performance.)r �warnr� rV rV rZ �_emit_empty_in_warning s �z"SQLCompiler._emit_empty_in_warningc K s2 | j jr dS | j jr | �� | �|j|jk�S d S )Nz1 != 1�r� Z_use_static_inZ_warn_on_empty_inr� r� r5 r� rV rV rZ �visit_empty_in_op_binary% s z$SQLCompiler.visit_empty_in_op_binaryc K s2 | j jr dS | j jr | �� | �|j|jk�S d S )Nz1 = 1r� r� rV rV rZ �visit_empty_notin_op_binary- s z'SQLCompiler.visit_empty_notin_op_binaryc C s t d| jj ��d S )Nz3Dialect '%s' does not support empty set expression.r� )r� Z element_typesrV rV rZ �visit_empty_set_expr5 s ��z SQLCompiler.visit_empty_set_exprc K s� | j r*t|jtj�r*t|jtj�r*d|d< |p2|j}| �|dd �}|rX|||fi |��S z t| }W n: t y� } z"t j t � | |�|d� W Y d }~n d }~0 0 | j||fi |��S d S )NT� literal_bindsr r� )�ansi_bind_rulesr r5 r Z BindParameterrG rh r� r! r r r� r ZUnsupportedCompilationError�_generate_generic_binary) r� r r� �eager_groupingr� r� r� �opstringr rV rV rZ r� ; s& � � � � zSQLCompiler.visit_binaryc K s | j |jfi |��S r� )r� Z sql_functionr� rV rV rZ �&visit_function_as_comparison_op_binaryV s z2SQLCompiler.visit_function_as_comparison_op_binaryc K sd | j jr4| j|jfi |��d | j|jfi |�� S | j|jfi |��d | j|jfi |�� S d S )Nz %% rd )r� rB r� r5 rG r� rV rV rZ �visit_mod_binaryY s ������z SQLCompiler.visit_mod_binaryc K s( |j |d< | j|d|j d fi |��S )Nr� r� )r� r� r� r� rV rV rZ �visit_custom_op_binaryg s ��z"SQLCompiler.visit_custom_op_binaryc K s | j ||jd fi |��S �Nr� )r� r� r� rV rV rZ � visit_custom_op_unary_operatorm s ��z*SQLCompiler.visit_custom_op_unary_operatorc K s | j |d|j fi |��S r� )r� r� r� rV rV rZ � visit_custom_op_unary_modifierr s ��z*SQLCompiler.visit_custom_op_unary_modifierc K s\ |� dd�}d|d< |jj| fd|i|��| |jj| fd|i|�� }|rX|rXd| }|S )N� _in_binaryFTr� rQ )r� r5 r� rG )r� r r� r� r� r� rE rV rV rZ r� w s. ��������� z$SQLCompiler._generate_generic_binaryc K s ||j j| fi |�� S r� r �r� r� r� r� rV rV rZ r� � s z,SQLCompiler._generate_generic_unary_operatorc K s |j j| fi |��| S r� r r� rV rV rZ r� � s z,SQLCompiler._generate_generic_unary_modifierc C s t jdtjd�S )Nz'%')r� )r Zliteral_columnr � STRINGTYPEr� rV rV rZ �_like_percent_literal� s z!SQLCompiler._like_percent_literalc K s6 |� � }| j}|�|j��|�|_| j||fi |��S r� ��_cloner� �__add__rG �visit_like_op_binary�r� r rh r� �percentrV rV rZ �visit_contains_op_binary� s z$SQLCompiler.visit_contains_op_binaryc K s6 |� � }| j}|�|j��|�|_| j||fi |��S r� �r� r� r� rG �visit_notlike_op_binaryr� rV rV rZ �visit_notcontains_op_binary� s z'SQLCompiler.visit_notcontains_op_binaryc K s0 |� � }| j}|�|j�|_| j||fi |��S r� )r� r� �__radd__rG r� r� rV rV rZ �visit_startswith_op_binary� s z&SQLCompiler.visit_startswith_op_binaryc K s0 |� � }| j}|�|j�|_| j||fi |��S r� )r� r� r� rG r� r� rV rV rZ � visit_notstartswith_op_binary� s z)SQLCompiler.visit_notstartswith_op_binaryc K s0 |� � }| j}|�|j�|_| j||fi |��S r� r� r� rV rV rZ �visit_endswith_op_binary� s z$SQLCompiler.visit_endswith_op_binaryc K s0 |� � }| j}|�|j�|_| j||fi |��S r� r� r� rV rV rZ �visit_notendswith_op_binary� s z'SQLCompiler.visit_notendswith_op_binaryc K sT |j �dd �}d|jj| fi |��|jj| fi |��f |rNd| �|tj� nd S )N�escapez %s LIKE %s� ESCAPE r� �� modifiersr� r5 r� rG �render_literal_valuer r� �r� r rh r� r� rV rV rZ r� � s ���z SQLCompiler.visit_like_op_binaryc K sT |j �dd �}d|jj| fi |��|jj| fi |��f |rNd| �|tj� nd S )Nr� z%s NOT LIKE %sr� r� r� r� rV rV rZ r� � s ���z#SQLCompiler.visit_notlike_op_binaryc K sT |j �dd �}d|jj| fi |��|jj| fi |��f |rNd| �|tj� nd S )Nr� zlower(%s) LIKE lower(%s)r� r� r� r� rV rV rZ �visit_ilike_op_binary� s ���z!SQLCompiler.visit_ilike_op_binaryc K sT |j �dd �}d|jj| fi |��|jj| fi |��f |rNd| �|tj� nd S )Nr� z lower(%s) NOT LIKE lower(%s)r� r� r� r� rV rV rZ �visit_notilike_op_binary� s ���z$SQLCompiler.visit_notilike_op_binaryc K s* |j �dd�}| j||r dndfi |��S )NrK Fz BETWEEN SYMMETRIC z BETWEEN �r� r� r� �r� r rh r� rK rV rV rZ �visit_between_op_binary� s ��z#SQLCompiler.visit_between_op_binaryc K s* |j �dd�}| j||r dndfi |��S )NrK Fz NOT BETWEEN SYMMETRIC z NOT BETWEEN r� r� rV rV rZ �visit_notbetween_op_binary� s ��z&SQLCompiler.visit_notbetween_op_binaryc K s& |s<|j �| j�}|jr<|�|�}| j|fd||d�|��S |sJ|r�| jr�|jd u rn|jd u rnt � d|j ��| j |fddi|��S | � |�}|| jv r�| j| } | |ur�| js�|jr�| j�|j�s�t � d|j ��n"| js�|jr�t � d|j |j f ��| | j|j < | j|< | j|fd|ji|��S )NT)�skip_bind_expressionr r� z@Bind parameter '%s' without a renderable value not allowed here.r zIBind parameter '%s' conflicts with unique bind parameter of the same namez�bindparam() name '%s' is reserved for automatic usage in the VALUES or SET clause of this insert/update statement. Please use a name other than column name when using bindparam() with insert() or update() (for example, 'b_%s').� expanding)r� � dialect_implr� Z_has_bind_expression�bind_expressionr� r� r� r r r r� �render_literal_bindparam�_truncate_bindparamr� rP r� � intersectionZ_is_crudrG r� ) r� r� r r� r� r� �implr� r� �existingrV rV rZ �visit_bindparam� sp �������� �� ��� �� ���zSQLCompiler.visit_bindparamc K s |j }| �||j�S r� )r r� r� )r� r� r� r� rV rV rZ r� 3 s z$SQLCompiler.render_literal_bindparamc C s( |� | j�}|r||�S td| ��dS )a Render the value of a bind parameter as a quoted literal. This is used for statement sections that do not accept bind parameters on the target driver/database. This should be implemented by subclasses using the quoting services of the DBAPI. z(Don't know how to literal-quote value %rN)Z_cached_literal_processorr� r� )r� r� r� � processorrV rV rZ r� 7 s �z SQLCompiler.render_literal_valuec C s@ || j v r| j | S |j}t|tj�r2| �d|�}|| j |< |S )Nr� )r� r� r r r r )r� r� Z bind_namerV rV rZ r� J s z SQLCompiler._truncate_bindparamc C s� ||f| j v r | j ||f S |�| j�}t|�| jd kr�| j �|d�}|dt| jd d�� d t|�dd � }|d | j |< n|}|| j ||f< |S )N� r r r� r )r� Z apply_mapr� r r� r� �max�hex)r� Z ident_classr� Zanonname�counterZ truncnamerV rV rZ r W s ���z!SQLCompiler._truncated_identifierc C s || j S r� )r� �r� r� rV rV rZ � _anonymizej s zSQLCompiler._anonymizec K sJ | j r&|d ur|�|� n | j�|� |r8d| _d| S | jd|i S d S )NTz([EXPANDING_%s])r� )r� r� r� � contains_expanding_parametersr� )r� r� �positional_namesr� r� rV rV rZ rG m s z SQLCompiler.bindparam_stringc s� � � � ||d< t|jtj�r.� �d|j�}n|j}d}d} |� jv r�� j| } || u } || jv sj|| u rpd}n"| |jv r�� j| = nt � d| ��|s�|r�|j d ur�|j } |j j} t| tj�rԈ �d| �} n|} d } |�rb|� j|< d|j j v �rd� jv�r� j�d|j j d i�� _| � jv�r6� j| fi |�� | �sb|� jv�rb|j�rVd� _� j�||�} |j�r�t|jtj��r�|j}n(t|jtj��r�|jjd }n d�s�J �dd � t�|j �D �}| d d � � fd d �|D �� 7 } � j �r�g |d< � j |< | d� j ||j!fi |��|jj"� fddi|��f 7 } |j#�rX| d� j ||j#fi |�� 7 } | � j|< |�r�|�s�| �r�� j�||�S | �r j�|| �} � j�$|��r�� j�%|�}| � �&|�7 } | S � j�||�S d S )N� visiting_cter* TFz5Multiple, unrelated CTEs found with the same name: %rZ autocommitr c S s g | ]}|d ur|�qS r� rV rf rV rV rZ rw � s �z)SQLCompiler.visit_cte.<locals>.<listcomp>rQ rf c 3 s | ]}� j �|�V qd S r� )r� � format_column)rX r� r� rV rZ r� � s �z(SQLCompiler.visit_cte.<locals>.<genexpr>r� z AS %s %sr r� )'r� r r� r r r r� Z _restatesr� r r Z _cte_aliasr� r� r� rO � visit_cte� recursiver� r� � format_alias�originalr �Select�CompoundSelectr� r Z unique_list� inner_columnsr3 r� r� �_generate_prefixes� _prefixesr� � _suffixes�_requires_quotesr- �get_render_as_alias_suffix)r� �cter �ashint� fromhintsr� r� Zcte_nameZ is_new_cteZ embedded_in_current_named_cteZ existing_cteZ pre_alias_cteZcte_pre_alias_namerE Z col_sourceZ recur_colsrV r� rZ r� { s� �� � ����� ��������� zSQLCompiler.visit_ctec K s� |s|r,t |jtj�r&| �d|j�}n|j}|r>| j�||�S |r�|jj| fddi|��| � | j�||�� }|r�||v r�| � |||| |�}|S |jj| fi |��S d S )Nr* r T) r r� r r r r� r� r� r� r �format_from_hint_text) r� r* r r �iscrudr r� Z alias_name�retrV rV rZ � visit_alias� s0 ��� �� �zSQLCompiler.visit_aliasc K s d|d< d| j |fi |�� S )NT�lateralz LATERAL %s)r )r� r r� rV rV rZ � visit_lateral s zSQLCompiler.visit_lateralc K sZ d| j |fddi|��|�� j| fi |��f }|jd urV|d|jj| fi |�� 7 }|S )Nz%s TABLESAMPLE %sr Tz REPEATABLE (%s))r Z _get_methodr� �seed)r� Z tablesampler r� rE rV rV rZ �visit_tablesample s � �z SQLCompiler.visit_tablesamplec C s d| S )Nrg rV )r� Zalias_name_textrV rV rZ r ) s z&SQLCompiler.get_render_as_alias_suffixc C s | j �||||f� d S r� )r� r� )r� �keynamer� �objectsr� rV rV rZ rT , s z SQLCompiler._add_to_result_mapc s� � j ��j�} | jr@|s |r@| �� �} |r:� �fdd�} qTd} n� } |rP�j} nd} |s`| } �nt� tj�r�| � ur�t | � j � j fd�} n| } n�|dur�|r�t | |� j fd�} n�|r�t� tj �r�� js�� jdur�t� jtj�s�t | t�� j �� jfd�} nvt� tj��sFt� tj��r � j�rFt� d��r8t� tj��rFt | � j�} n*| � u�rlt | t�� j �� jfd�} n| } |j|| d� | j �fi |��S )z.produce labeled columns present in a select().c s �� | |� f| |� d S r� )rT )r r� r r� �r r� rV rZ r$ E s �z;SQLCompiler._label_select_column.<locals>.add_to_result_mapN)r� r� rP ) r� r� r� Z_has_column_expressionZcolumn_expressionrT r r �Labelr� r� r� � _key_labelZ ColumnClauser+ rL r r� Z _as_truncatedr� Z TextClauseZUnaryExpressionZwraps_column_expression�hasattrr �FunctionZ anon_label�updater� ) r� rH r rX r �column_clause_argsr� r �need_column_expressionsr� Zcol_exprr$ Z result_exprrV r rZ �_label_select_column/ s� �� � �� ��� � � � ��� � ��z SQLCompiler._label_select_columnc C s | � ||�}|r |d| 7 }|S r� )�get_from_hint_text)r� �sqltextrL �hintr �hinttextrV rV rZ r � s z!SQLCompiler.format_from_hint_textc C s d S r� rV )r� ZbyfromsrV rV rZ �get_select_hint_text� s z SQLCompiler.get_select_hint_textc C s d S r� rV �r� rL rE rV rV rZ r � s z SQLCompiler.get_from_hint_textc C s d S r� rV r rV rV rZ �get_crud_hint_text� s z SQLCompiler.get_crud_hint_textc C s d� |�S r� �r3 )r� Z hint_textsrV rV rZ �get_statement_hint_text� s z#SQLCompiler.get_statement_hint_textc s" i � i g�� ��fdd���|�S )z�Rewrite any "a JOIN (b JOIN c)" expression as "a JOIN (select * from b JOIN c) AS anon", to support databases that can't parse a parenthesized join correctly (i.e. sqlite < 3.7.16). c s� | �d v r�d | S | � v r(� | S | � � }� | < |j�rb|j�rbt|jtj��rb|�� �|jfi |��|_�|jfi |��}tj |j gdd�� � }|j D ]}|j |_|j|_q�tt|jj j |j ��}|||j j< |||j j< |||jj j< |||jj j< t�d �� �D ]$\}}||v �r|| �d |< �q�d �|� ||_�|jfi |��|_n�|j�r�d|d< |jf d�i|�� nn|j�r�|j�r�|�dd �dk} | �r���i � d|d< |jf d�i|�� | �r��d= n|jf d�i|�� |S )Nr� T)� use_labelsZselect_containerZtransform_clue�cloneZ inside_select) r� Z is_selectableZ_is_joinr rG r Z FromGroupingZ_reset_exportedr5 r� r� r* rY r� r r� Z_labelr� �zipr� �itemsr �onclauseZ_is_from_containerZ_copy_internalsZ _is_selectr� r� ) r� r� ZnewelemrG Z selectable_rY Ztranslate_dict�k�vZbarrier_select�ZclonedZcolumn_translate�visitrV rZ r, � s^ �� �� � � z=SQLCompiler._transform_select_for_nested_joins.<locals>.visitrV )r� rH rV r+ rZ �"_transform_select_for_nested_joins� s Qz.SQLCompiler._transform_select_for_nested_joinsc sF t dd� |jD ���t �fdd�|jD ��� � fdd�| jD �| _d S )Nc s s | ]}|j |fV qd S r� �r rf rV rV rZ r� � s zESQLCompiler._transform_result_map_for_nested_joins.<locals>.<genexpr>c 3 s | ]}� |j |fV qd S r� r. rf )� inner_colrV rZ r� r\ c s2 g | ]*\}}}}||t � fd d�|D ��|f�qS )c s g | ]}� � ||��qS rV �r� )rX r� ��drV rZ rw r\ zQSQLCompiler._transform_result_map_for_nested_joins.<locals>.<listcomp>.<listcomp>��tuple)rX r� r� Zobjs�typr1 rV rZ rw s �zFSQLCompiler._transform_result_map_for_nested_joins.<locals>.<listcomp>)r� r� r� )r� rH �transformed_selectrV )r2 r/ rZ �&_transform_result_map_for_nested_joins� s � �z2SQLCompiler._transform_result_map_for_nested_joinsr� r� c C s\ | j }|r| jn| j d }|d }|d }|rJ|sJ|j|�|�dd�}n|j||d�}|S )Nr� r� r� rV �Zexplicit_correlate_fromsZimplicit_correlate_froms)r� rR �_get_display_froms� difference) r� rH r r rW r� r� r� �fromsrV rV rZ �_display_froms_for_select s ���z%SQLCompiler._display_froms_for_selectc s| �j o | o �j o �jj } | rJ����} �j| f� |||dd�| ��} �j } | r\�jn�jd }| p�|�dd�p�|�dd� ��|dkr�d��s�d| v r�| d= | r��r����| � | S �� �|� |�}| � � ��� ddd �� d } �j �r�� ��\}}|�r| |d 7 } nd }�j�r8| �j��jfi | ��7 } | �j�fi | ��7 } d d � � �����fdd ��jD �D �}��r�|d u�r�ttdd � �jD �dd � |jD �����fdd ��jD ��_��| �|||| �} �j�r �fdd ��jD �}|�r | d ��|� 7 } �j�r$| �r$��� | } �j�rJ| d �j��jfi | �� 7 } �j�d� � �sb|�rt|�rtd| d S | S d S )NT)r rV r rU �nested_join_translationr� rO Fr� r r$ )r r zSELECT r� c S s g | ]}|d ur|�qS r� rV rf rV rV rZ rw u s �z,SQLCompiler.visit_select.<locals>.<listcomp>c s( g | ] \}}�j �|�� �|�d ��qS ))r� r �r )rX r� r )r r r rX rH r� rV rZ rw w s ��c S s g | ] \}}|�qS rV rV �rX r� r� rV rV rZ rw � r\ c S s g | ] \}}|�qS rV rV r? rV rV rZ rw � s �c s2 g | ]*\}}}}||t � fd d�|D ��|f�qS )c 3 s | ]}� � ||�V qd S r� r0 )rX �o�� translaterV rZ r� � r\ z6SQLCompiler.visit_select.<locals>.<listcomp>.<genexpr>r3 )rX r� r� r� r� rA rV rZ rw � s �c s$ g | ] \}}|d � j jfv r|�qS ��*�r� r� )rX � dialect_nameZhtr� rV rZ rw � s �r r ) r$ r� r� Zsupports_right_nested_joinsr- � visit_selectrR r� r7 �_setup_select_stack�copyr �_hints�_setup_select_hintsr r �get_select_precolumnsZ_columns_plus_namesr� r& r� �_compose_select_bodyZ_statement_hintsr# r� r� r r� )r� rH r rV r rU r= Zselect_wraps_forr r� Zneeds_nested_translationr6 rE rW r� r; � hint_text�byfromr� Z per_dialectrV )r r r rX rH r� rB rZ rG % s� ������� � � �� ����� � � � �� zSQLCompiler.visit_selectc s. t � fdd�|j�� D ��}� �|�}||fS )Nc s> g | ]6\\}}}|d � j jfv r||d|j� dd�i f�qS )rD r� T)r �r� r� r� )rX �from_r� r r� rV rZ rw � s ���z3SQLCompiler._setup_select_hints.<locals>.<listcomp>)r� rJ r' r )r� rH rO rN rV r� rZ rK � s �� z SQLCompiler._setup_select_hintsc C sp |d }|d }|r.|s.|j |�|�dd�}n|j ||d�}ttj|� �}|�|�} || |d�} | j�| � |S )Nr� r� rV r8 )r� r� r )r9 r: rJ r � _from_objectsrO r� r� ) r� rH r� r r r� r� r; Znew_correlate_fromsZall_correlate_fromsZ new_entryrV rV rZ rH � s* ��� � z SQLCompiler._setup_select_stackc s\ |d� |�7 }|rb|d7 }|jrB|d� � ��fdd�|D ��7 }qn|d� ��fdd�|D ��7 }n |��� 7 }|jd ur�|jj�fi ���}|r�|d| 7 }|jjr�|�j|fi ���7 }|jd ur�|jj�fi ���}|r�|d| 7 }|j j�r|�j |fi ���7 }|j d u�s |j d u�r6|�j |fi ���7 }|jd u�rX|�j|fi ���7 }|S )Nrf z FROM c s$ g | ] }|j �fd � d�����qS )T�r r r� �rX �f�rO r� r� rV rZ rw � s ����z4SQLCompiler._compose_select_body.<locals>.<listcomp>c s" g | ]}|j �fd di� ���qS )r Tr� rT rv rV rZ rw � s �z WHERE z HAVING )r3 rJ r � _whereclauser� �_group_by_clauseri r� Z_having�_order_by_clauser� r� r� r� Z_for_update_arg�for_update_clause)r� rE rH r� r; rO r� �trV rV rZ rM � sF �� �� �� z SQLCompiler._compose_select_bodyc s* d� � �fdd�|D ��}|r&|d7 }|S )Nr� c 3 s8 | ]0\}}|d u s |�j jkr|j�fi � ��V qd S r� rP )rX �prefixrF rg rV rZ r� s �z1SQLCompiler._generate_prefixes.<locals>.<genexpr>r" )r� �stmt�prefixesr� rm rV rg rZ r s �z SQLCompiler._generate_prefixesc sb � j r(t� fdd�� jD �g �� j � _� �� j�d }|d�dd� � j�� D ��7 }|d7 }|S )Nc s g | ]}� j | �qS rV )r� )rX r r� rV rZ rw $ r\ z2SQLCompiler._render_cte_clause.<locals>.<listcomp>r� �, c S s g | ]}|�qS rV rV )rX �txtrV rV rZ rw ( r\ z )r� �sumr� r� �get_cte_preambler� r3 �values)r� Zcte_textrV r� rZ r� ! s �� z SQLCompiler._render_cte_clausec C s |rdS dS d S )NzWITH RECURSIVEZWITHrV )r� r� rV rV rZ rb , s z SQLCompiler.get_cte_preamblec K s |j r dp dS )zcCalled when building a ``SELECT`` statement, position is just before column list. rh r� )Z _distinct�r� rH r� rV rV rZ rL 2 s z!SQLCompiler.get_select_precolumnsc K s( |j j| fi |��}|r d| S dS dS )z5allow dialects to customize how GROUP BY is rendered.z GROUP BY r� N)rX r� )r� rH r� Zgroup_byrV rV rZ r� 9 s zSQLCompiler.group_by_clausec K s( |j j| fi |��}|r d| S dS dS )z5allow dialects to customize how ORDER BY is rendered.z ORDER BY r� N)rY r� )r� rH r� ry rV rV rZ r� B s zSQLCompiler.order_by_clausec K s dS )Nz FOR UPDATErV rd rV rV rZ rZ K s z SQLCompiler.for_update_clausec C s t �d��d S )Nz@RETURNING is not supported by this dialect's statement compiler.r& )r� r] �returning_colsrV rV rZ �returning_clauseN s �z SQLCompiler.returning_clausec K sf d}|j d ur*|d| j|j fi |�� 7 }|jd urb|j d u rF|d7 }|d| j|jfi |�� 7 }|S )Nr� z LIMIT z LIMIT -1z OFFSET )r� r� r� )r� rH r� rE rV rV rZ r� T s zSQLCompiler.limit_clausec K sv |s|rn| j �|�}|r<|r<| j �|�d | j �|j� } n| j �|j�} |rj||v rj| �| ||| |�} | S dS d S )Nr) r� )r� r. r/ r- r� r ) r� rL r r r r � use_schemar� r1 r rV rV rZ � visit_table^ s � �� �zSQLCompiler.visit_tablec K sh |j r d}n|jrd}nd}|jj| fddi|��| |jj| fddi|�� d |jj| fi |�� S )Nz FULL OUTER JOIN z LEFT OUTER JOIN z JOIN r Tz ON )r- Zisouterr5 r� rG r( )r� r3 r r� Z join_typerV rV rZ � visit_join{ s �����zSQLCompiler.visit_joinc sF t � fdd�|j�� D ��}|j|v r>� �||j||j d�}||fS )Nc s, g | ]$\\}}}|d � j jfv r||f�qS rC rE )rX rL r� rN r� rV rZ rw � s �z1SQLCompiler._setup_crud_hints.<locals>.<listcomp>T)r� rJ r' rL r )r� r] � table_text� dialect_hintsrV r� rZ �_setup_crud_hints� s �� �z SQLCompiler._setup_crud_hintsc s� | j }| j �t� t� |d�� tj| |tjfi |��}|s^| jjs^| jjs^t � d| jj ��|j r�| jj s~t � d| jj ��|d }n|}| j� | jj}d}|jr�|| j||jfi |��7 }|d7 }� �|j�} |jr�| �|| �\} } || 7 }|s�|�s|dd�� fd d �|D �� 7 }| j�s*|j�rV| �|| j�p<|j�} | j�rZ|d | 7 }nd } |jd u�r�| j| j fi |��} | j �r�|�r�| jj �r�|d | � � | f 7 }n |d | 7 }nh|�s�|�r�|d7 }nR|j �r�|dd�dd� |D �� 7 }n,d�dd � |D ��} |d| 7 }|�r | | _ |j!d u�rP| j|j!fi |��}|�rP|d | 7 }| �rj| j�sj|d | 7 }| j �r�|�r�| jj �s�| � � | }| j �"d� |�r�d| d S |S d S )N�r� r� r zWThe '%s' dialect with current database version settings does not support empty inserts.zcThe '%s' dialect with current database version settings does not support in-place multirow inserts.r zINSERT zINTO z (%s)rf c s g | ]}� � |d ��qS )r )r� rf �r� rV rZ rw � r\ z,SQLCompiler.visit_insert.<locals>.<listcomp>r� z %s%sz %sz DEFAULT VALUESz VALUES %sc s s& | ] }d d� dd� |D �� V qdS )rQ rf c s s | ]}|d V qdS )r NrV rf rV rV rZ r� � r\ z5SQLCompiler.visit_insert.<locals>.<genexpr>.<genexpr>Nr" )rX Zcrud_param_setrV rV rZ r� � s �z+SQLCompiler.visit_insert.<locals>.<genexpr>c S s g | ] }|d �qS )r rV rf rV rV rZ rw � r\ z VALUES (%s)r� r r )#r� r� rJ r �_setup_crud_paramsZISINSERTr� �supports_default_valuesZsupports_empty_insertr r r� Z_has_multi_parametersZsupports_multivalues_insertr� r r � format_tablerL rJ rl r3 r� r� rf �returning_precedes_valuesrH r� Z_insert_from_selectr� Zcte_follows_insertr� �insert_single_values_exprZ_post_values_clauser� )r� Z insert_stmtr r� rW � crud_paramsZcrud_params_singlerp rE rj r� rf Z select_textrs Zpost_values_clauserV rn rZ � visit_insert� s� ����������� �� �� �� �� zSQLCompiler.visit_insertc C s dS )z3Provide a hook for MySQL to add LIMIT to the UPDATENrV )r� � update_stmtrV rV rZ �update_limit_clause s z SQLCompiler.update_limit_clausec K s d|d< |j | fddi|��S )z|Provide a hook to override the initial table clause in an UPDATE statement. MySQL overrides this. Tr r r� )r� rv � from_table� extra_fromsr� rV rV rZ �update_tables_clause s z SQLCompiler.update_tables_clausec K s t d��dS )z~Provide a hook to override the generation of an UPDATE..FROM clause. MySQL and MSSQL override this. zCThis backend does not support multiple-table criteria within UPDATENr� �r� rv rx ry � from_hintsr� rV rV rZ �update_from_clause s �z SQLCompiler.update_from_clausec s< �j }|j}t|�}|rHtt�|j����fdd�|D �}��|�}n g }|jh}�j �|||d�� d} |j r�| �j ||j fi |��7 } �j ||j|fi |��} t j �|t jfi |��} |jrԈ�|| �\} } nd } | | 7 } | d7 } |o�j� | d�� �fdd�| D ��7 } �j�s |j�rF�j�rF| d ��|�j�p>|j� 7 } |�rx�j||j|| fi |��} | �rx| d | 7 } |jd u�r��j|jfi |��}|�r�| d | 7 } ��|�}|�r�| d | 7 } �j�s�|j�r��j�s�| d ��|�j�p�|j� 7 } �j�r|�r�� � | } �j � d � |�r4d | d S | S d S )Nc s g | ]}|� vr|�qS rV rV rT )� main_fromsrV rZ rw - s z,SQLCompiler.visit_update.<locals>.<listcomp>rm zUPDATE z SET rf c 3 s, | ]$}|d j �� d�d |d V qdS )r )r0 �=r Nr� rf )r0 r� rV rZ r� X s ���z+SQLCompiler.visit_update.<locals>.<genexpr>r� � WHERE r� r r ) r� � _extra_froms�boolrJ r rR rL rO r� r r rz r ro ZISUPDATErJ rl �'render_table_with_column_in_update_fromr3 r� r� rr rf r} rW r� rw r� r� r� )r� rv r r� rW ry Z is_multitableZrender_extra_fromsr� rE rj rt rk �extra_from_textr[ r� rV )r0 r~ r� rZ � visit_update$ s� � ��������� �� ��� ���� zSQLCompiler.visit_updatec C s t �| | j�S r� )r � _key_getters_for_crud_columnr� r� rV rV rZ r� � s z(SQLCompiler._key_getters_for_crud_columnc K s t d��dS )z�Provide a hook to override the generation of an DELETE..FROM clause. This can be used to implement DELETE..USING for example. MySQL and MSSQL override this. zCThis backend does not support multiple-table criteria within DELETENr� r{ rV rV rZ �delete_extra_from_clause� s �z$SQLCompiler.delete_extra_from_clausec C s |j | ddd�S )NT)r r r� )r� � delete_stmtrx ry rV rV rZ �delete_table_clause� s z SQLCompiler.delete_table_clausec K s� | j }tj| |tjfi |�� |j}|jh�|�}| j �|||d�� d}|jrl|| j ||jfi |��7 }|d7 }| � ||j|�}|j r�| � ||�\} }nd } ||7 }|j r�| jr�|d| �||j � 7 }|r�| j||j|| fi |��} | r�|d| 7 }|jd u�r*|jj| fi |��} | �r*|d| 7 }|j �rP| j�sP|d| �||j � 7 }| j�rj|�rj| �� | }| j �d� |�r�d| d S |S d S ) Nrm zDELETE �FROM r� r� r� r r )r� r ro ZISDELETEr� rL rO r� r r r� rJ rl r� rr rf r� rW r� r� r� r� ) r� r� r r� rW ry r� rE rj rk r� r[ rV rV rZ � visit_delete� sr ������ ��� � zSQLCompiler.visit_deletec C s d| j �|� S )Nz SAVEPOINT %s�r� �format_savepoint�r� Zsavepoint_stmtrV rV rZ �visit_savepoint� s zSQLCompiler.visit_savepointc C s d| j �|� S )NzROLLBACK TO SAVEPOINT %sr� r� rV rV rZ �visit_rollback_to_savepoint� s �z'SQLCompiler.visit_rollback_to_savepointc C s d| j �|� S )NzRELEASE SAVEPOINT %sr� r� rV rV rZ �visit_release_savepoint� s �z#SQLCompiler.visit_release_savepoint)NF)NNT)F)F)F)NFFN)NT)NFT)N)FTr )NF)F)FFF)NF)FFNN)FFFN)F)NTF)F)FTNr FNF)FFFNT)F)F)F)F)�r� r� r� r� � EXTRACT_MAPr �COMPOUND_KEYWORDSr� r� r� r� rK r� rr r� r� r� rS r� r� rs r� r� r� r� r� r� r Zmemoized_instancemethodr� � contextlib�contextmanagerr� r� �memoized_propertyr� r r� r� r� � dependenciesr r r r r r% r( r2 r5 r7 r9 r= rF r, rN rZ r] ra rc rk rn ro rp rt rz r{ r~ r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r� rG r� r r r r rT r r r r r! r# r- r7 r� � frozensetrR r< rG rK rH rM r r� rb rL r� r� rZ rf r� rh ri rl ru rw rz r} r� r� r� r� r� r� r� r� rV rV rV rZ r� � s� � I % 8 � #� � 1� (� "� 3 � � � = � � � ! � \]� � 6 � p f J r� c @ sX e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z dd� Z dd� Z dS )�StrSQLCompilera� A :class:`.SQLCompiler` subclass which allows a small selection of non-standard SQL features to render into a string value. The :class:`.StrSQLCompiler` is invoked whenever a Core expression element is directly stringified without calling upon the :meth:`_expression.ClauseElement.compile` method. It can render a limited set of non-standard SQL constructs to assist in basic stringification, however for more substantial custom or dialect-specific SQL constructs, it will be necessary to make use of :meth:`_expression.ClauseElement.compile` directly. .. seealso:: :ref:`faq_sql_expression_string` c C s dS )Nz<name unknown>rV r' rV rV rZ r( s z$StrSQLCompiler._fallback_column_namec K s, d| j |jfi |��| j |jfi |��f S )Nz%s[%s])r� r5 rG r� rV rV rZ �visit_getitem_binary s �z#StrSQLCompiler.visit_getitem_binaryc K s | j ||fi |��S r� �r� r� rV rV rZ � visit_json_getitem_op_binary s z+StrSQLCompiler.visit_json_getitem_op_binaryc K s | j ||fi |��S r� r� r� rV rV rZ �!visit_json_path_getitem_op_binary s z0StrSQLCompiler.visit_json_path_getitem_op_binaryc K s d| j �|� S )Nz<next sequence value: %s>)r� �format_sequence)r� �seqr� rV rV rZ r� s z StrSQLCompiler.visit_sequencec s& � fdd�t �|�D �}dd�|� S )Nc s g | ]}� � d |ddi ��qS )NTFr> rf r� rV rZ rw s �z3StrSQLCompiler.returning_clause.<locals>.<listcomp>z RETURNING rf )r Z_select_iterablesr3 )r� r] re �columnsrV r� rZ rf s �z StrSQLCompiler.returning_clausec s dd� � ��fdd�|D �� S )Nr� rf c 3 s& | ] }|j �fd � d����V qdS �TrS Nr� �rX r[ �r| r� r� rV rZ r� * s �z4StrSQLCompiler.update_from_clause.<locals>.<genexpr>r" r{ rV r� rZ r} ' s �z!StrSQLCompiler.update_from_clausec s dd� � ��fdd�|D �� S )Nrf c 3 s& | ] }|j �fd � d����V qdS r� r� r� r� rV rZ r� 2 s �z:StrSQLCompiler.delete_extra_from_clause.<locals>.<genexpr>r" r{ rV r� rZ r� / s �z'StrSQLCompiler.delete_extra_from_clausec C s d| S )Nz[%s]rV r rV rV rZ r 7 s z!StrSQLCompiler.get_from_hint_textN) r� r� r� r� r( r� r� r� r� rf r} r� r rV rV rV rZ r� � s r� c @ sJ e Zd Zejdd� �Zejdd� �ZdNdd�Zdd � Zd d � Z d d � Z dd� Z dOdd�Z dPdd�Z dd� Zdd� Zdd� ZdQd d �Zd d � ZdRd d!�Zd"d#� Zd$d%� Zd&d'� Zd(d)� Zd*d+� Zd,d-� Zd.d/� Zd0d1� Zd2d3� Z d4d5� Z d6d7� Z d8d9� Z d:d;� Z d<d=� Z!d>d?� Z"d@dA� Z#dBdC� Z$dDdE� Z%dFdG� Z&dHdI� Z'dJdK� Z(dLdM� Z)dS )S� DDLCompilerc C s | j j| j d | jd�S )N)r� )r� Zstatement_compilerr� r� rV rV rZ r� < s �zDDLCompiler.sql_compilerc C s | j jS r� )r� r; r� rV rV rZ r; B s zDDLCompiler.type_compilerNc C s d S r� rV r� rV rV rZ r� F s z DDLCompiler.construct_paramsc K s� |j }t|jtj�r�|�� }| j}|�|j�}t|�dkrJ|d d }}n|d |d }}|� d|� |� d|� |� d|� |j�� | j � |j | �S )Nr r r� r� rL r �fullname)�contextr �targetr �TablerI r� �format_table_seqr � setdefaultrq r� rF r� )r� Zddlr� r� r� �pathrL ZschrV rV rZ � visit_ddlI s zDDLCompiler.visit_ddlc C s | j �|j�}d| S )NzCREATE SCHEMA )r� � format_schemar� )r� r r rV rV rZ �visit_create_schema\ s z DDLCompiler.visit_create_schemac C s( | j �|j�}d| }|jr$|d7 }|S )Nz DROP SCHEMA � CASCADE)r� r� r� �cascade)r� �dropr rE rV rV rZ �visit_drop_schema` s z DDLCompiler.visit_drop_schemac C sT |j }| j}d}|jr*|d�|j�d 7 }|d|�|� d 7 }| �|�}|rZ||d 7 }|d7 }d}d}|jD ]�}|j } zD| j|| jo�| d�} | d ur�||7 }d}|d | 7 }| jr�d }W qp t j �y } z:t j t � t � d �|j| j| jd f �| d � W Y d } ~ qpd } ~ 0 0 qp| j||jd�} | �r>||d | 7 }|d| �|� 7 }|S )Nz CREATE r� zTABLE r � F��first_pkr_ � Tz (in table '%s', column '%s'): %sr )rQ )� _include_foreign_key_constraintsz )%s )r� r� r r3 rq �create_table_suffixr� r� � primary_keyr r r r� �u� descriptionr� �args�create_table_constraintsZ include_foreign_key_constraints�post_create_table) r� r rL r� rE r� � separatorr� Z create_columnr � processedZce�constrV rV rZ �visit_create_tableg sR � ��� �z DDLCompiler.visit_create_tableFc sL |j }|jrd S � j||d�}d�� fdd�|jD ��}|rH|d| 7 }|S )Nr� r� c 3 s | ]}� � |�V qd S r� )r� �rX r r� rV rZ r� � s z2DDLCompiler.visit_create_column.<locals>.<genexpr>)r� �system�get_column_specificationr3 � constraints)r� r r� r rE r� rV r� rZ �visit_create_column� s � z DDLCompiler.visit_create_columnc st g }�j r|��j � �j}|d ur0|�|�� nt� � |�� �fdd��jD �� d�dd� �fdd�|D �D ��S )Nc s" g | ]}|�j ur|� vr|�qS rV )r� rf )� omit_fkcsrL rV rZ rw � s �z8DDLCompiler.create_table_constraints.<locals>.<listcomp>z, c s s | ]}|d ur|V qd S r� rV )rX �prV rV rZ r� � s �z7DDLCompiler.create_table_constraints.<locals>.<genexpr>c 3 s@ | ]8}|j d u s|� � �r� jjr.t|dd�s� �|�V qd S )NZ use_alterF)Z _create_ruler� Zsupports_alterr� r� r� r� rV rZ r� � s �)r� r� Zforeign_key_constraintsr: rJ �extendZ_sorted_constraintsr3 )r� rL r� r� Zall_fkcsrV )r� r� rL rZ r� � s" �� ��z$DDLCompiler.create_table_constraintsc C s d| j �|j� S )Nz DROP TABLE �r� rq r� �r� r� rV rV rZ �visit_drop_table� s z DDLCompiler.visit_drop_tablec C s d| j �|j� S )Nz DROP VIEW r� r� rV rV rZ �visit_drop_view� s zDDLCompiler.visit_drop_viewc C s |j d u rt�d|j ��d S )Nz,Index '%s' is not associated with any table.)rL r r r� �r� r8 rV rV rZ �_verify_index_table� s �z DDLCompiler._verify_index_tableTc s~ |j }� �|� � j}d}|jr(|d7 }|jd u r<t�d��|d� j||d�|j|j |d�d� � fdd �|j D ��f 7 }|S ) NzCREATE zUNIQUE z0CREATE INDEX requires that the index have a namezINDEX %s ON %s (%s)��include_schema�rg rf c 3 s | ]}� j j|d dd�V qdS )FT�r0 r� N)r� r� )rX r\ r� rV rZ r� � s ��z1DDLCompiler.visit_create_index.<locals>.<genexpr>) r� r� r� rP r� r r �_prepared_index_namerq rL r3 Z expressions)r� r r� Zinclude_table_schemar8 r� rE rV r� rZ �visit_create_index� s( � ��� z DDLCompiler.visit_create_indexc C s, |j }|jd u rt�d��d| j|dd� S )Nz.DROP INDEX requires that the index have a namez DROP INDEX Tr� )r� r� r r r� )r� r� r8 rV rV rZ �visit_drop_index� s ��z DDLCompiler.visit_drop_indexc C sX |j d ur| j�|j �}nd }|r4|r4| j�|�}nd }| j�|�}|rT|d | }|S �Nr) )rL r� r. r/ � format_index)r� r8 r� r1 Z schema_nameZ index_namerV rV rZ r� s z DDLCompiler._prepared_index_namec C s d| j �|jj�| �|j�f S )NzALTER TABLE %s ADD %s)r� rq r� rL r� �r� r rV rV rZ �visit_add_constraint s �z DDLCompiler.visit_add_constraintc C s( d| j �|j�| j�|jjt�� �f S )NzCOMMENT ON TABLE %s IS %s)r� rq r� r� r� �commentr �Stringr� rV rV rZ �visit_set_table_comment s ��z#DDLCompiler.visit_set_table_commentc C s d| j �|j� S )NzCOMMENT ON TABLE %s IS NULLr� r� rV rV rZ �visit_drop_table_comment! s �z$DDLCompiler.visit_drop_table_commentc C s. d| j j|jddd�| j�|jjt�� �f S )NzCOMMENT ON COLUMN %s IS %sT)� use_tablerg )r� r� r� r� r� r� r r� r� rV rV rZ �visit_set_column_comment& s � ��z$DDLCompiler.visit_set_column_commentc C s d| j j|jdd� S )Nz COMMENT ON COLUMN %s IS NULLT)r� )r� r� r� r� rV rV rZ �visit_drop_column_comment0 s �z%DDLCompiler.visit_drop_column_commentc C s� d| j �|j� }|jjd ur.|d|jj 7 }|jjd urJ|d|jj 7 }|jjd urf|d|jj 7 }|jjd ur�|d|jj 7 }|jjd ur�|d7 }|jjd ur�|d7 }|jj d ur�|d|jj 7 }|jj d u r�|d 7 }|jj d ur�|d 7 }|S ) NzCREATE SEQUENCE %sz INCREMENT BY %dz START WITH %dz MINVALUE %dz MAXVALUE %dz NO MINVALUEz NO MAXVALUEz CACHE %dTz ORDERz CYCLE) r� r� r� � increment�startZminvalueZmaxvalueZ nominvalueZ nomaxvalue�cacherC �cycle)r� r rE rV rV rZ �visit_create_sequence5 s, � z!DDLCompiler.visit_create_sequencec C s d| j �|j� S )NzDROP SEQUENCE %s)r� r� r� r� rV rV rZ �visit_drop_sequenceM s z DDLCompiler.visit_drop_sequencec C s^ |j }|jd ur | j�|�}nd }|d u r:t�d|j ��d| j�|j j�||jrVdpXdf S )Nz<Can't emit DROP CONSTRAINT for constraint %r; it has no namez#ALTER TABLE %s DROP CONSTRAINT %s%sr� r� ) r� r� r� �format_constraintr r rq rL r� )r� r� r �formatted_namerV rV rZ �visit_drop_constraintP s �� �z!DDLCompiler.visit_drop_constraintc K sr | j �|�d | jjj|j|d� }| �|�}|d urB|d| 7 }|jd ur`|d| �|j� 7 }|jsn|d7 }|S )Nr� )r: z DEFAULT z NOT NULL) r� r� r� r; r� r� �get_column_default_stringZcomputedZnullable)r� r r� Zcolspecr" rV rV rZ r� b s ���� z$DDLCompiler.get_column_specificationc C s dS �Nr� rV �r� rL rV rV rZ r� u s z DDLCompiler.create_table_suffixc C s dS r� rV r� rV rV rZ r� x s z DDLCompiler.post_create_tablec C sP t |jtj�rHt |jjtj�r2| j�|jjt j �S | jj |jjdd�S nd S d S )NT)r� ) r Zserver_defaultr Z DefaultClause�argr � string_typesr� r� r r� r� r' rV rV rZ r� { s ��z%DDLCompiler.get_column_default_stringc C s\ d}|j d ur.| j�|�}|d ur.|d| 7 }|d| jj|jddd� 7 }|| �|�7 }|S �Nr� �CONSTRAINT %s z CHECK (%s)FTr� �r� r� r� r� r� r � define_constraint_deferrability�r� r rE r� rV rV rZ �visit_check_constraint� s � z"DDLCompiler.visit_check_constraintc C s\ d}|j d ur.| j�|�}|d ur.|d| 7 }|d| jj|jddd� 7 }|| �|�7 }|S r� r� r� rV rV rZ � visit_column_check_constraint� s � z)DDLCompiler.visit_column_check_constraintc s� t |�dkrdS d}|jd ur>� j�|�}|d ur>|d| 7 }|d7 }|dd�� fdd�|jrd|jn|jD �� 7 }|� �|�7 }|S ) Nr r� r� z PRIMARY KEY rQ rf c 3 s | ]}� j �|j�V qd S r� �r� r- r� rf r� rV rZ r� � s �z;DDLCompiler.visit_primary_key_constraint.<locals>.<genexpr>) r r� r� r� r3 Z_implicit_generatedZcolumns_autoinc_firstr� r� r� rV r� rZ � visit_primary_key_constraint� s �� z(DDLCompiler.visit_primary_key_constraintc s� | j � d}|jd ur4| j �|�}|d ur4|d| 7 }t|j�d jj}|dd�� fdd�|jD ��| �||� �d�� fdd�|jD ��f 7 }|| � |�7 }|| � |�7 }|| � |�7 }|S ) Nr� r� r z"FOREIGN KEY(%s) REFERENCES %s (%s)rf c 3 s | ]}� � |jj�V qd S r� )r- �parentr� rT rn rV rZ r� � s z;DDLCompiler.visit_foreign_key_constraint.<locals>.<genexpr>c 3 s | ]}� � |jj�V qd S r� )r- r r� rT rn rV rZ r� � s ) r� r� r� r� r r rL r3 � define_constraint_remote_table�define_constraint_match�define_constraint_cascadesr� )r� r rE r� Z remote_tablerV rn rZ � visit_foreign_key_constraint� s, ���� z(DDLCompiler.visit_foreign_key_constraintc C s |� |�S )z=Format the remote table clause of a CREATE CONSTRAINT clause.)rq )r� r rL r� rV rV rZ r� � s z*DDLCompiler.define_constraint_remote_tablec sp t |�dkrdS d}|jd ur>� j�|�}|d ur>|d| 7 }|dd�� fdd�|D �� 7 }|� �|�7 }|S )Nr r� r� z UNIQUE (%s)rf c 3 s | ]}� j �|j�V qd S r� r� rf r� rV rZ r� � r\ z6DDLCompiler.visit_unique_constraint.<locals>.<genexpr>)r r� r� r� r3 r� r� rV r� rZ �visit_unique_constraint� s �z#DDLCompiler.visit_unique_constraintc C sL d}|j d ur&|d| j�|j t� 7 }|jd urH|d| j�|jt� 7 }|S )Nr� z ON DELETE %sz ON UPDATE %s)Zondeleter� �validate_sql_phrase� FK_ON_DELETEZonupdate� FK_ON_UPDATE�r� r rE rV rV rZ r� � s � �z&DDLCompiler.define_constraint_cascadesc C sL d}|j d ur&|j r |d7 }n|d7 }|jd urH|d| j�|jt� 7 }|S )Nr� z DEFERRABLEz NOT DEFERRABLEz INITIALLY %s)r# r0 r� r � FK_INITIALLYr rV rV rZ r� � s �z+DDLCompiler.define_constraint_deferrabilityc C s d}|j d ur |d|j 7 }|S )Nr� z MATCH %s)�matchr rV rV rZ r� � s z#DDLCompiler.define_constraint_matchc C sB d| j j|jddd� }|jdu r,|d7 }n|jdu r>|d7 }|S )NzGENERATED ALWAYS AS (%s)FTr� z STOREDz VIRTUAL)r� r� r Z persisted)r� � generatedrE rV rV rZ �visit_computed_column� s � z!DDLCompiler.visit_computed_column)N)F)N)FT)F)*r� r� r� r r� r� r; r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r rV rV rV rZ r� ; sR 2 � ) � r� c @ s\ e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z dd� Z dd� Z dd� Z dd� Zdd� Zdd � Zd d � Zd d � Zd!d"� Zd#d$� Zd%d&� Zd'd(� Zd)d*� Zd+d,� Zd-d.� Zd/d0� Zd1d2� Zd3d4� Z d5d6� Z d7d8� Z d9d:� Z d;d<� Z d=d>� Z!d?d@� Z"dAdB� Z#dCdD� Z$dEdF� Z%dGdH� Z&dIdJ� Z'dKdL� Z(dMdN� Z)dOdP� Z*dQdR� Z+dSdT� Z,dUS )V�GenericTypeCompilerc K s dS )N�FLOATrV r� rV rV rZ � visit_FLOAT s z GenericTypeCompiler.visit_FLOATc K s dS )NZREALrV r� rV rV rZ � visit_REAL s z GenericTypeCompiler.visit_REALc K s< |j d u rdS |jd u r&dd|j i S d|j |jd� S d S )NZNUMERICzNUMERIC(%(precision)s)� precisionz!NUMERIC(%(precision)s, %(scale)s)�r �scaler r� rV rV rZ � visit_NUMERIC s �z!GenericTypeCompiler.visit_NUMERICc K s< |j d u rdS |jd u r&dd|j i S d|j |jd� S d S )NZDECIMALzDECIMAL(%(precision)s)r z!DECIMAL(%(precision)s, %(scale)s)r r r� rV rV rZ � visit_DECIMAL s �z!GenericTypeCompiler.visit_DECIMALc K s dS )NZINTEGERrV r� rV rV rZ � visit_INTEGER& s z!GenericTypeCompiler.visit_INTEGERc K s dS )NZSMALLINTrV r� rV rV rZ �visit_SMALLINT) s z"GenericTypeCompiler.visit_SMALLINTc K s dS )NZBIGINTrV r� rV rV rZ � visit_BIGINT, s z GenericTypeCompiler.visit_BIGINTc K s dS )N� TIMESTAMPrV r� rV rV rZ �visit_TIMESTAMP/ s z#GenericTypeCompiler.visit_TIMESTAMPc K s dS )NZDATETIMErV r� rV rV rZ �visit_DATETIME2 s z"GenericTypeCompiler.visit_DATETIMEc K s dS )NZDATErV r� rV rV rZ � visit_DATE5 s z GenericTypeCompiler.visit_DATEc K s dS )NZTIMErV r� rV rV rZ � visit_TIME8 s z GenericTypeCompiler.visit_TIMEc K s dS )NZCLOBrV r� rV rV rZ � visit_CLOB; s z GenericTypeCompiler.visit_CLOBc K s dS )NZNCLOBrV r� rV rV rZ � visit_NCLOB> s z GenericTypeCompiler.visit_NCLOBc C s0 |}|j r|d|j 7 }|jr,|d|j 7 }|S )N�(%d)z COLLATE "%s")�lengthr4 )r� r� r� rE rV rV rZ �_render_string_typeA s z'GenericTypeCompiler._render_string_typec K s | � |d�S )NZCHAR�r r� rV rV rZ � visit_CHARJ s z GenericTypeCompiler.visit_CHARc K s | � |d�S )NZNCHARr r� rV rV rZ � visit_NCHARM s z GenericTypeCompiler.visit_NCHARc K s | � |d�S )NZVARCHARr r� rV rV rZ � visit_VARCHARP s z!GenericTypeCompiler.visit_VARCHARc K s | � |d�S )NZNVARCHARr r� rV rV rZ �visit_NVARCHARS s z"GenericTypeCompiler.visit_NVARCHARc K s | � |d�S )NZTEXTr r� rV rV rZ � visit_TEXTV s z GenericTypeCompiler.visit_TEXTc K s dS )NZBLOBrV r� rV rV rZ � visit_BLOBY s z GenericTypeCompiler.visit_BLOBc K s d|j rd|j pd S )N�BINARYr r� �r r� rV rV rZ � visit_BINARY\ s z GenericTypeCompiler.visit_BINARYc K s d|j rd|j pd S )NZ VARBINARYr r� r& r� rV rV rZ �visit_VARBINARY_ s z#GenericTypeCompiler.visit_VARBINARYc K s dS )NZBOOLEANrV r� rV rV rZ � visit_BOOLEANb s z!GenericTypeCompiler.visit_BOOLEANc K s | j |fi |��S r� )r$ r� rV rV rZ �visit_large_binarye s z&GenericTypeCompiler.visit_large_binaryc K s | j |fi |��S r� )r) r� rV rV rZ � visit_booleanh s z!GenericTypeCompiler.visit_booleanc K s | j |fi |��S r� )r r� rV rV rZ � visit_timek s z GenericTypeCompiler.visit_timec K s | j |fi |��S r� )r r� rV rV rZ �visit_datetimen s z"GenericTypeCompiler.visit_datetimec K s | j |fi |��S r� )r r� rV rV rZ � visit_dateq s z GenericTypeCompiler.visit_datec K s | j |fi |��S r� )r r� rV rV rZ �visit_big_integert s z%GenericTypeCompiler.visit_big_integerc K s | j |fi |��S r� )r r� rV rV rZ �visit_small_integerw s z'GenericTypeCompiler.visit_small_integerc K s | j |fi |��S r� )r r� rV rV rZ � visit_integerz s z!GenericTypeCompiler.visit_integerc K s | j |fi |��S r� )r r� rV rV rZ � visit_real} s z GenericTypeCompiler.visit_realc K s | j |fi |��S r� )r r� rV rV rZ � visit_float� s z GenericTypeCompiler.visit_floatc K s | j |fi |��S r� )r r� rV rV rZ � visit_numeric� s z!GenericTypeCompiler.visit_numericc K s | j |fi |��S r� �r! r� rV rV rZ � visit_string� s z GenericTypeCompiler.visit_stringc K s | j |fi |��S r� r5 r� rV rV rZ � visit_unicode� s z!GenericTypeCompiler.visit_unicodec K s | j |fi |��S r� �r# r� rV rV rZ � visit_text� s z GenericTypeCompiler.visit_textc K s | j |fi |��S r� r8 r� rV rV rZ �visit_unicode_text� s z&GenericTypeCompiler.visit_unicode_textc K s | j |fi |��S r� r5 r� rV rV rZ � visit_enum� s z GenericTypeCompiler.visit_enumc K s t �d| ��d S )NzKCan't generate DDL for %r; did you forget to specify a type on this Column?r& r� rV rV rZ r] � s ��z GenericTypeCompiler.visit_nullc K s | j |�| j�fi |��S r� )r� Z type_enginer� r� rV rV rZ �visit_type_decorator� s z(GenericTypeCompiler.visit_type_decoratorc K s |j f i |��S r� )Z get_col_specr� rV rV rZ �visit_user_defined� s z&GenericTypeCompiler.visit_user_definedN)-r� r� r� r r r r r r r r r r r r r r r r r! r" r# r$ r' r( r) r* r+ r, r- r. r/ r0 r1 r2 r3 r4 r6 r7 r9 r: r; r] r< r= rV rV rV rZ r sT r c @ s e Zd Zdd� Zdd� ZdS )�StrSQLTypeCompilerc C s |� d�r| jS t|��d S )N�visit_)� startswith�_visit_unknown�AttributeError)r� r� rV rV rZ � __getattr__� s z StrSQLTypeCompiler.__getattr__c K s d|j j S )Nz%s)r� r� r� rV rV rZ rA � s z!StrSQLTypeCompiler._visit_unknownN)r� r� r� rC rA rV rV rV rZ r> � s r> c @ s e Zd ZdZeZeZeZ e � d�Z d5dd�Z dd � Zd d � Zd d � Zdd� Zdd� Zdd� Zdd� Zd6dd�Zd7dd�Zdd� Zd8d d �Zd9d d �Zd:d d!�Zd;d"d#�Ze � d$�d%d&� �Z d'd(� Z d<d)d*�Z d+d,� Z!d=d-d.�Z"d>d/d0�Z#e j$d1d2� �Z%d3d4� Z&dS )?�IdentifierPreparerz@Handle quoting and case-folding of identifiers based on options.N�"TFc C sN || _ || _|p| j| _|| _| jd | _|| _|| _i | _| j jdv | _ dS )as Construct a new ``IdentifierPreparer`` object. initial_quote Character that begins a delimited identifier. final_quote Character that ends a delimited identifier. Defaults to `initial_quote`. omit_schema Prevent prepending schema name. Useful for databases that do not support schemae. r )ra r` N) r� � initial_quote� final_quote� escape_quote�escape_to_quote� omit_schema� quote_case_sensitive_collations�_stringsr� rB )r� r� rF rG rH rK rJ rV rV rZ r� � s zIdentifierPreparer.__init__c C s, | j �| j �}|j�| j� t�|�|_|S r� )r� �__new__�__dict__r r �_schema_getterr. )r� r� �preprV rV rZ r� � s z)IdentifierPreparer._with_schema_translatec C s& |� | j| j�}| jr"|� dd�}|S )z�Escape an identifier. Subclasses should override this to provide database-dependent escaping behavior. r? r@ )rC rH rI rB �r� r� rV rV rZ �_escape_identifier� s z%IdentifierPreparer._escape_identifierc C s |� | j| j�S )z�Canonicalize an escaped identifier. Subclasses should override this to provide database-dependent unescaping behavior that reverses _escape_identifier. )rC rI rH rQ rV rV rZ �_unescape_identifier� s z'IdentifierPreparer._unescape_identifierc C s* |dur&|� |�s&t�d||jf ��|S )z�keyword sequence filter. a filter for elements that are intended to represent keyword sequences, such as "INITIALLY", "INITIALLY DEFERRED", etc. no special characters should be present. .. versionadded:: 1.3 Nz/Unexpected SQL phrase: %r (matching against %r))r r r �pattern)r� r� �regrV rV rZ r � s ��z&IdentifierPreparer.validate_sql_phrasec C s | j | �|� | j S )z~Quote an identifier. Subclasses should override this to provide database-dependent quoting behavior. )rF rR rG rQ rV rV rZ �quote_identifier s ���z#IdentifierPreparer.quote_identifierc C s< |� � }|| jv p:|d | jv p:| j�t�|�� p:||kS )z5Return True if the given identifier requires quoting.r )r� �reserved_words�illegal_initial_characters�legal_charactersr r � text_type)r� r� Zlc_valuerV rV rZ r s ���z#IdentifierPreparer._requires_quotesc C s | j �t�|�� S )zjReturn True if the given identifier requires quoting, but not taking case convention into account.)rY r r rZ rQ rV rV rZ r� " s z1IdentifierPreparer._requires_quotes_illegal_charsc C s |durt �d� | �|�S )a Conditionally quote a schema name. The name is quoted if it is a reserved word, contains quote-necessary characters, or is an instance of :class:`.quoted_name` which includes ``quote`` set to ``True``. Subclasses can override this to provide database-dependent quoting behavior for schema names. :param schema: string schema name :param force: unused .. deprecated:: 0.9 The :paramref:`.IdentifierPreparer.quote_schema.force` parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the :meth:`.IdentifierPreparer.quote` method; please refer to :class:`.quoted_name`. Nz�The IdentifierPreparer.quote_schema.force parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the IdentifierPreparer.quote method; please refer to quoted_name().)r �warn_deprecatedr- )r� r �forcerV rV rZ r/ ' s �z IdentifierPreparer.quote_schemac C s� |durt �d� t|dd�}|du rl|| jv r:| j| S | �|�rV| �|�| j|< n || j|< | j| S n|rz| �|�S |S dS )a Conditionally quote an identfier. The identifier is quoted if it is a reserved word, contains quote-necessary characters, or is an instance of :class:`.quoted_name` which includes ``quote`` set to ``True``. Subclasses can override this to provide database-dependent quoting behavior for identifier names. :param ident: string identifier :param force: unused .. deprecated:: 0.9 The :paramref:`.IdentifierPreparer.quote.force` parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the :meth:`.IdentifierPreparer.quote` method; please refer to :class:`.quoted_name`. Nz�The IdentifierPreparer.quote.force parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the IdentifierPreparer.quote method; please refer to quoted_name().r- )r r[ r� rL r rV )r� r� r\ rV rV rZ r- L s � zIdentifierPreparer.quotec C s | j r| �|�S |S d S r� )rK r- )r� Zcollation_namerV rV rZ r3 ~ s z#IdentifierPreparer.format_collationc C s> | � |j�}| �|�}| js:|r:|d ur:| �|�d | }|S r� )r- r� r. rJ r/ )r� r� rg r� r1 rV rV rZ r� � s ���z"IdentifierPreparer.format_sequencec C s | � |p |j�S r� �r- r� )r� r� r� rV rV rZ r# � s z IdentifierPreparer.format_labelc C s | � |p |j�S r� r] )r� r* r� rV rV rZ r� � s z IdentifierPreparer.format_aliasc C s" |p|j }| �|�r | �|�}|S r� )r� r rV )r� Z savepointr� r� rV rV rZ r� � s z#IdentifierPreparer.format_savepointzsqlalchemy.sql.namingc C s� |j tju r(|�||j�}|d u r.d S n|j }t|tj�r�|jdkrV| jj pR| jj }n| jj pd| jj }t |�|kr�|d|d � d t �|�dd � }n | j�|� | �|�S )Nr8 r � r� ���)r� r Z _NONE_NAMEZ_constraint_name_for_tablerL r r r� r� Zmax_index_name_lengthr� Zmax_constraint_name_lengthr r Zmd5_hexZvalidate_identifierr- )r� Znamingr r� Zmax_rV rV rZ r� � s& � �� ( z$IdentifierPreparer.format_constraintc C s | � |�S r� )r� r� rV rV rZ r� � s z IdentifierPreparer.format_indexc C sF |du r|j }| �|�}| �|�}| jsB|rB|rB| �|�d | }|S )z'Prepare a quoted table and schema name.Nr) )r� r- r. rJ r/ )r� rL rg r� r r1 rV rV rZ rq � s z IdentifierPreparer.format_tablec C s | � |�S )z Prepare a quoted schema name.)r- r� rV rV rZ r� � s z IdentifierPreparer.format_schemac C sp |du r|j }t|dd�sJ|r>| j|j||d�d | �|� S | �|�S n"|rh| j|j||d�d | S |S dS )z Prepare a quoted column name.Nr+ F)rg r� r) )r� r� rq rL r- )r� r r� r� Z table_namerg rV rV rZ r� � s. ���� ����z IdentifierPreparer.format_columnc C sD | � |�}| js0|r0|r0| �|�| j|dd�fS | j|dd�fS dS )z(Format table name and schema as a tuple.Fr� N)r. rJ r/ rq )r� rL rg r1 rV rV rZ r� � s �z#IdentifierPreparer.format_table_seqc C s@ dd� | j | j| �| j�fD �\}}}t�d|||d� �}|S )Nc S s g | ]}t �|��qS rV )r� r� rd rV rV rZ rw s �z5IdentifierPreparer._r_identifiers.<locals>.<listcomp>zM(?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+)�initial�final�escaped)rF rG rR r� r� )r� r` ra Z escaped_final�rrV rV rZ �_r_identifiers s �� ��z!IdentifierPreparer._r_identifiersc s( � j }� fdd�dd� |�|�D �D �S )z:Unpack 'schema.table.column'-like strings into components.c s g | ]}� � |��qS rV )rS )rX r� r� rV rZ rw # s �z;IdentifierPreparer.unformat_identifiers.<locals>.<listcomp>c S s g | ]\}}|p|�qS rV rV )rX �a�brV rV rZ rw % r\ )rd �findall)r� � identifiersrc rV r� rZ �unformat_identifiers s �z'IdentifierPreparer.unformat_identifiers)rE NrE TF)N)N)T)N)N)N)TN)FNNF)T)'r� r� r� r� �RESERVED_WORDSrW �LEGAL_CHARACTERSrY �ILLEGAL_INITIAL_CHARACTERSrX r rO r. r� r� rR rS r rV r r� r/ r- r3 r� r# r� r� r r� r� r� rq r� r� r� r� rd ri rV rV rV rZ rD � sN � $ % 2 � & rD )lr� r� r� r� r� r r r r r r r r r r rJ rj r� �Irk ZLEGAL_CHARACTERS_PLUS_SPACE�rangerO rl r r r �UNICODErM rL r� �and_�or_�add�mulr� �div�mod�truediv�neg�lt�le�ne�gt�ge�eqZis_distinct_fromZisnot_distinct_fromZ concat_opr� Z notmatch_opZin_opZnotin_opZcomma_oprQ r" �is_Zisnotr �existsZ distinct_op�invZany_opZall_opZdesc_opZasc_opZ nullsfirst_opZ nullslast_opr! ri r r r r! r8 r9 rj rk rI rQ ZcubeZrollupZ grouping_setsr� r� r� r| Z UNION_ALLr} Z EXCEPT_ALLr~ Z INTERSECT_ALLr� �objectr �with_metaclassZEnsureKWArgTyper� Z Visitabler� r� r� r� r� r� r r> rD rV rV rV rZ �<module> s �c ��� �,��� LB Q
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка