Dashboard
PHP:
8.2.30
OS:
Linux
User:
dh_nv8b2m
/
/
usr
/
local
/
lib
/
python3.10
/
dist-packages
/
sqlalchemy
/
sql
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: compiler.cpython-310.pyc
o [�hl� � @ s� 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 i 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/�i ej0d0�ej1d1�ej2d2�ej3d3�ej4d4�ej5d5�ej6d6�ej7d7�ej8d8�ej9d9�ej: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)^�all�analyse�analyze�and�any�array�as�asc� asymmetric� authorization�between�binary�both�case�cast�check�collate�column� constraint�create�cross� current_date� current_role� current_time�current_timestamp� current_user�default� deferrable�desc�distinct�do�else�end�except�false�for�foreign�freeze�from�full�grant�group�having�ilike�in� initially�inner� intersect�into�is�isnull�join�leading�left�like�limit� localtime�localtimestamp�natural�new�not�notnull�null�off�offset�old�on�only�or�order�outer�overlaps�placing�primary� references�right�select� session_user�set�similar�some� symmetric�table�then�to�trailing�true�union�unique�user�using�verbose�when�wherez ^[A-Z0-9_$]+$z^[A-Z0-9_ $]+$c C s h | ]}t |��qS � )�str)�.0�xrl rl �B/usr/local/lib/python3.10/dist-packages/sqlalchemy/sql/compiler.py� <setcomp>� � rq � �$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)�pyformat�qmark�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�coalesce� CURRENT_DATE� CURRENT_TIME�CURRENT_TIMESTAMP� CURRENT_USER� LOCALTIME�LOCALTIMESTAMP�random�sysdate� SESSION_USER�USER�CUBE�ROLLUPz GROUPING SETS�month�day�year�second�hour�doy�minute�quarter�dow�week�epoch� milliseconds� microseconds� timezone_hour�timezone_minute)r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� �UNIONz UNION ALL�EXCEPTz EXCEPT ALL� INTERSECTz INTERSECT ALLc @ s� e Zd ZdZdZe�� Z dde�� fdd�Ze� dd�dd� �Z d d � Z e d d � �Z d 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 sj || _ || _| j j| _|r| j�|�| _|dur3|| _|j| _| jr&|j| _ | j | jfi |��| _ dS dS )aq Construct a new :class:`.Compiled` object. :param dialect: :class:`.Dialect` to compile against. :param statement: :class:`.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�bind�identifier_preparer�preparer�_with_schema_translate� statement�supports_execution� can_execute�_execution_options�execution_options�process�string)�selfr� r� r� �schema_translate_map�compile_kwargsrl rl rp �__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 � dS )zDProduce the internal string representation of this element. Nrl �r� rl rl rp �compileA s zCompiled.compilec C s | j r |�| ||�S t�| j���N)r� �_execute_compiledr �ObjectNotExecutableErrorr� )r� � connection� multiparams�paramsrl rl rp �_execute_on_connectionM s z Compiled._execute_on_connectionc C � t � �)z�Return a Compiled that is capable of processing SQL expressions. If this compiler is one, it would likely just return 'self'. ��NotImplementedErrorr� rl rl rp � sql_compilerS � zCompiled.sql_compilerc K � |j | fi |��S r� ��_compiler_dispatch)r� �obj�kwargsrl rl rp r� ] � zCompiled.processc C s | j pdS )z3Return the string text of the generated SQL or DDL.� )r� r� rl rl rp �__str__` � zCompiled.__str__c C r� )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. r� �r� r� rl rl rp �construct_paramse r� zCompiled.construct_paramsc C s | � � S )z0Return the bind params for this compiled object.�r� r� rl rl rp r� o s zCompiled.paramsc O s* | j }|du rtjddd��|�| ||�S )z Execute this compiled object.Nz>This Compiled object is not bound to any Engine or Connection.�2afi��code)r� r �UnboundExecutionErrorr� )r� r� r� �erl rl rp �executet s �zCompiled.executec O s | j |i |���� S )zJExecute this compiled object and return the result's scalar value.)r� �scalar)r� r� r� rl rl rp r� � s zCompiled.scalarr� )�__name__� __module__� __qualname__�__doc__�_cached_metadatar � immutabledictr� r� � deprecatedr� r� �propertyr� r� r� r� r� r� r� rl rl rl rp r� � s0 �/� 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� rl rl rp r� � � zTypeCompiler.__init__c K r� r� r� �r� �type_�kwrl rl rp r� � r� zTypeCompiler.processN)r� r� r� r� � ensure_kwargr� r� rl rl rl rp 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�namerl c C s || _ || _|f| | _d S r� )r� r� � _alt_names)r� �colr� � alt_namesrl rl rp r� � s z_CompileLabel.__init__c C � | j jS r� )r� � proxy_setr� rl rl rp r� � � z_CompileLabel.proxy_setc C r� r� )r� �typer� rl rl rp r� � r� z_CompileLabel.typec K � | S r� rl )r� r� rl rl rp � self_group� � z_CompileLabel.self_groupN)rl ) r� r� r� r� �__visit_name__� __slots__r� r� r� r� r� rl rl rl rp 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�getrm )r� �key�ident�derived�anonymous_counter�valuerl rl rp � __missing__� s zprefix_anon_map.__missing__N)r� r� r� r� r� rl rl rl rp r� � s r� c @ sL e Zd ZdZeZeZd Z Z Z dZ dZ dZ dZ dZ dZ dZ dZ dZ dZ d ZZ �ddd�Zedd � �Zejd d � �Z e j d d � �Z dd� Z ej!dd� �Z"dd� Z#edd� �Z$�ddd�Z%edd� �Z&e�'d�dd � �Z(d d � Z)�dd d �Z* �dd!d"�Z+ �dd#d$�Z, �dd%d&�Z-d'd(� Z. �dd)d*�Z/d+d,� Z0d-d.� Z1d/d0� Z2d1d2� Z3d3d4� Z4d5d6� Z5d7d8� Z6 �dd9d:�Z7d;d<� Z8d=d>� Z9d?d@� Z:dAdB� Z;dCdD� Z<dEdF� Z=dGdH� Z>dIdJ� Z?dKdL� Z@dMdN� ZAdOdP� ZBdQdR� ZC�ddSdT�ZDdUdV� ZEdWdX� ZFdYdZ� ZG [�d d\d]�ZHd^d_� ZId`da� ZJdbdc� ZKddde� ZLdfdg� ZMdhdi� ZNdjdk� ZOdldm� ZPdndo� ZQ �ddpdq�ZRdrds� ZSdtdu� ZTdvdw� ZUdxdy� ZVdzd{� ZW �dd|d}�ZXd~d� ZYd�d�� ZZej!d�d�� �Z[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�� Zg �d d�d��Zhd�d�� Zid�d�� Zjd�d�� Zkd�d�� Zld�d�� Zm �dd�d��Zn �d d�d��Zo �d d�d��Zpd�d�� Zq�dd�d��Zrd�d�� Zsd�d�� Zt �d d�d��Zud�d�� Zvd�d�� Zwd�d�� Zxd�d�� Zyd�d�� Zzd�dÄ Z{d�dń 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��dd�d��Z�d�d�� Z�d�d�� Z��d �d� Z�dS ( � SQLCompilerzsDefault implementation of :class:`.Compiled`. Compiles :class:`.ClauseElement` objects into SQL strings. FNTrl c K s� || _ |p t|dd�| _i | _t�� | _g | _g | _|j | _ | j r*g | _ |j dk| _ t |j | _d| _|jp8|j| _t� | _i | _tj| ||fi |�� | jsU| jsU| jr\|jr\|j| _| j rh| j rj| � � dS dS dS )a Construct a new :class:`.SQLCompiler` object. :param dialect: :class:`.Dialect` to be used :param statement: :class:`.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. �inlineFry N) � column_keys�getattrr� �bindsr � 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� rl rl rp r� s: ����� �zSQLCompiler.__init__c C s t | j| j �S r� )�list�insert_prefetch�update_prefetchr� rl rl rp �prefetchW � zSQLCompiler.prefetchc C s* t �� | _i | _d| _| jri | _dS 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� rl rl rp �_init_cte_state[ s �zSQLCompiler._init_cte_statec c s� � | j | j}}g d| _ | _z'| jr | jd }d|d< nd}| j | jfV W |r.|�d� ||| _ | _dS |r>|�d� ||| _ | _w )z;special API to support the use case of 'nested result sets'F���T�need_result_map_for_nestedN)r �_ordered_columnsr �pop)r� �result_columns�ordered_columns�entryrl rl rp �_nested_resulti s* �� �� �zSQLCompiler._nested_resultc s( t �d�� t�d� fdd�| j�| _d S )Nr z \[_POSITION\]c s t t�� ��S r� )rm r �next��m��poscountrl rp �<lambda>� s z4SQLCompiler._apply_numbered_params.<locals>.<lambda>)� itertools�count�re�subr� r� rl r* rp r � s �z"SQLCompiler._apply_numbered_paramsc s" t dd� � fdd�� jD �D ��S )Nc s s$ � | ] \}}|d ur||fV qd S r� rl )rn r� r� rl rl rp � <genexpr>� s � ��z/SQLCompiler._bind_processors.<locals>.<genexpr>c 3 s( � | ]}� j | |j�� j�fV qd S r� )r r� �_cached_bind_processorr� )rn � bindparamr� rl rp r1 � s � � � �)�dictr r� rl r� rp �_bind_processors� s ��z SQLCompiler._bind_processorsc C s t | j�dkS �Nr )�lenr r� rl rl rp � is_subquery� � zSQLCompiler.is_subqueryc C r� r� rl r� rl rl rp r� � � zSQLCompiler.sql_compilerc C s |rTi }| j D ]J}| j | }|j|v r||j ||< q||v r&|| ||< q|rC|jrC|r9tjd|j|f dd��tjd|j dd��|jrL|j||< q|j||< q|S i }| j D ]3}|rx|jrx|rntjd|j|f dd��tjd|j dd��|jr�|j|| j | < qY|j|| j | < qY|S )z5return a dictionary of bind parameter keys and valuesz@A value is required for bind parameter %r, in parameter group %d�cd3xr� z)A value is required for bind parameter %r)r r� �requiredr �InvalidRequestError�callable�effective_valuer� )r� r� � _group_number�_check�pdr3 r� rl rl rp 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)rA r� r� rl rl rp r� � s zSQLCompiler.paramszsqlalchemy.engine.resultc C s |j �| j�S )z(utility method used for unit tests only.)�ResultMetaData�_create_result_mapr )r� �resultrl rl rp rD � s z SQLCompiler._create_result_mapc C r� )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� rl r� rl rl rp � default_from� s zSQLCompiler.default_fromc K s d|j j| fi |�� d S )N�(�)�r� r� )r� �grouping�asfromr� rl rl rp �visit_grouping� s zSQLCompiler.visit_groupingc K s� | j r6| jjr6| j d d }|j\}}}|r|}n|}|jj} | d ur6| j|v r6| �|| j �r6|jj|d< | j|jfd|i|��S )Nr r �render_label_as_label�within_columns_clause) r r� � supports_simple_order_by_label�_label_resolve_dictr� �_order_by_label_elementr� �shares_lineager� ) r� r� rN r� r � with_cols� only_froms� only_cols� resolve_dict� order_by_elemrl rl rp �visit_label_reference� s0 �������z!SQLCompiler.visit_label_referencec K s� | j s | �|j�S | j d d }|j\}}}z|r ||j }n||j }W n ty8 t�|jtj d� Y d S w ||d< | j|fd|i|��S )Nr r zECan't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.rM rN ) r r� � _text_clauserP r� �KeyErrorr �_no_text_coercionr � CompileError) r� r� rN r� r rS rT rU r� rl rl rp � visit_textual_label_reference s0 � �����z)SQLCompiler.visit_textual_label_referencec K s� |o| }||u }|s |r t |jtj�r | �d|j�} n|j} |rL|d ur3|| |j|| f|j |j� |jj| fddd�|��t t j | j � || � S |rU| j � || �S |jj| fddi|��S )N�colidentT)rN �within_label_clauserN F)� isinstancer� r �_truncated_label�_truncated_identifierr� r� r� r� � OPERATORSr �as_r� � format_label) r� r� �add_to_result_mapr_ rN rM r� �render_label_with_as�render_label_only� labelnamerl rl rp � visit_label( sJ � ����� �� ���zSQLCompiler.visit_labelc C � t �d��)Nz:Cannot compile Column object until its 'name' is assigned.�r r\ �r� r rl rl rp �_fallback_column_nameY � �z!SQLCompiler._fallback_column_namec K s� |j }}|d u r| �|�}|j}|s t|tj�r | �d|�}|d ur/||||||jf|j� |r7| � |�}n| j � |�}|j }|d u sI|rI|j sK|S | j �|�} | r\| j �| �d } nd} |j } t| tj�rm| �d| �} | | j � | � d | S )Nr^ �.r� �alias)r� rn � is_literalr` r ra rb r� r� �escape_literal_columnr� �quoter` �named_with_column�schema_for_object� quote_schema) r� r rf � include_tabler� r� � orig_namerr r` �effective_schema� schema_prefix� tablenamerl rl rp � visit_column^ s2 � � zSQLCompiler.visit_columnc K s | j �|j�S r� )r� �format_collation� collation)r� r� r� rl rl rp �visit_collation� r9 zSQLCompiler.visit_collationc K � |j S r� �r� )r� � fromclauser� rl rl rp �visit_fromclause� � z SQLCompiler.visit_fromclausec K r� r� r� )r� �indexr� rl rl rp � visit_index� r� zSQLCompiler.visit_indexc K s ||d< | j jj|jfi |��S )N�type_expression)r� � type_compilerr� r� )r� � typeclauser� rl rl rp �visit_typeclause� s z SQLCompiler.visit_typeclausec C � | j jr |�dd�}|S �N�%�%%�r� �_double_percents�replace�r� �textrl rl rp �post_process_text� � z SQLCompiler.post_process_textc C r� r� r� r� rl rl rp rs � r� z!SQLCompiler.escape_literal_columnc s< � ��fdd�}�j sd�_t�dd� t�|���j���S )Nc s> | � d�}|�jv r�j�j| fi � ��S �j|fi � ��S r6 )r7 � _bindparamsr� �bindparam_string)r) r� �r� r� � textclauserl rp � do_bindparam� s z2SQLCompiler.visit_textclause.<locals>.do_bindparamTc S s | � d�S r6 )r7 r( rl rl rp r, � s z.SQLCompiler.visit_textclause.<locals>.<lambda>)r � isplaintext�BIND_PARAMS_ESCr0 � BIND_PARAMSr� r� )r� r� r� r� rl r� rp �visit_textclause� s ��z SQLCompiler.visit_textclausec K s� | j }|r | jn| j d }|p |dko|�dd�p |�dd�}|r8|j | _| _|jD ] } | j| d| jd� q,| j|j fi |��} |rJ|rJd| } | S ) Nr r � need_result_map_for_compoundFr T�rN rf �(%s)) r �_default_stack_entryr� r r! �_textual_ordered_columns� column_argsr� �_add_to_result_mapr� ) r� �taf�compound_indexrK �parensr� �toplevelr% �populate_result_map�cr� rl rl rp �visit_text_as_from� s, � � � �z SQLCompiler.visit_text_as_fromc K r� )N�NULLrl �r� �exprr� rl rl rp � visit_null� r� zSQLCompiler.visit_nullc K � | j jrdS dS )Nrd �1�r� �supports_native_booleanr� rl rl rp � visit_true� � zSQLCompiler.visit_truec K r� )Nr0 �0r� r� rl rl rp � visit_false� r� zSQLCompiler.visit_falsec s^ |j }|d u r d}nt|j }|�dd� � �fdd�|jD �D ��}|jr-�jjr-d| }|S )Nr� c s s � | ]}|r|V qd S r� rl �rn �srl rl rp r1 � s � � �z/SQLCompiler.visit_clauselist.<locals>.<genexpr>c 3 s" � | ] }|j �fi � ��V qd S r� r� �rn r� �r� r� rl rp r1 � s � �zVALUES )�operatorrc rA �clauses� _tuple_valuesr� �tuple_in_values)r� � clauselistr� �sepr� rl r� rp �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 }q|jd urL|d|jj| fi |�� d 7 }|d7 }|S )NzCASE r� zWHEN z THEN zELSE �END)r� r� �whens�else_)r� �clauser� ro �condrE rl rl rp � visit_case� s* ����� �zSQLCompiler.visit_casec K � |j j| fi |��S r� )�typed_expressionr� )r� � type_coercer� rl rl rp �visit_type_coerce � z SQLCompiler.visit_type_coercec K �, d|j j| fi |��|jj| fi |��f S )NzCAST(%s AS %s))r� r� r� )r� r r� rl rl rp � visit_cast � �zSQLCompiler.visit_castc K s d|d t ju r dn2|d t ju rdn)|d dk r,d| jt �t|d ��fi |��f nd| jt �|d �fi |��f |d t ju rGdf S |d t ju rRdf S |d dk rmd| jt �t|d ��fi |��f f S d| jt �|d �fi |��f f S ) Nz %s AND %sr zUNBOUNDED PRECEDINGz CURRENT ROWz %s PRECEDINGz %s FOLLOWINGr zUNBOUNDED FOLLOWING)r �RANGE_UNBOUNDED� RANGE_CURRENTr� �literal�abs)r� �range_r� rl rl rp �_format_frame_clause s6 �� � � ��� �� � �� ��z SQLCompiler._format_frame_clausec s� |j rd�j|j fi � �� }n|jr d�j|jfi � �� }nd }d|jj�fi � ��d�� �fdd�d|jfd|jffD �|rD|gng �f S ) NzRANGE BETWEEN %szROWS BETWEEN %sz %s OVER (%s)r� c s: g | ]\}}|d urt |�rd||j�fi � ��f �qS )Nz%s BY %s)r7 r� )rn �wordr� �r� r� rl rp � <listcomp>3 s ��z*SQLCompiler.visit_over.<locals>.<listcomp>� PARTITION�ORDER)r� r� �rowsr� r� rA � partition_by�order_by)r� �overr� r� rl r� rp � visit_over$ s2 � �� � �� ���zSQLCompiler.visit_overc K r� )Nz %s WITHIN GROUP (ORDER BY %s))r� r� r� )r� � withingroupr� rl rl rp �visit_withingroup@ r� z SQLCompiler.visit_withingroupc K r� )Nz%s FILTER (WHERE %s))�funcr� � criterion)r� � funcfilterr� rl rl rp �visit_funcfilterF r� 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� rl rl rp � visit_extractL s �zSQLCompiler.visit_extractc s� |d ur||j |j d|j� t�d|j �� d �}|r#||fi |��S t�|jd �� � r4|jr3� d7 � n|j � �j� � �sCt � t j �rI�j� � �n� � � d � d�� �fdd�|jD �� g �d�j|fi |��i S )Nrl z visit_%s_funcz%(expr)srp c s4 g | ]}�j �|�st� tj�r�j �|�n|�qS rl )r� � _requires_quotes_illegal_charsr` r � quoted_namert )rn �tok�r� r� rl rp r� i s �� ��z.SQLCompiler.visit_function.<locals>.<listcomp>r� )r� r� r� �lower� FUNCTIONSr� � __class__� _has_argsr� r� r` r r� rt rA � packagenames�function_argspec)r� r� rf r� �disprl r� rp �visit_functionS s6 � � �� � �� �zSQLCompiler.visit_functionc K s | � |j�S r� )�visit_sequence�sequence)r� � next_valuer� rl rl rp �visit_next_value_funcu � z!SQLCompiler.visit_next_value_funcc K � t d| jj ��)Nz2Dialect '%s' does not support sequence increments.�r� r� r� )r� r� r� rl rl rp r� x � ��zSQLCompiler.visit_sequencec K r� r� )� clause_exprr� )r� r� r� rl rl rp r� ~ r� z SQLCompiler.function_argspecr c s, �j }|r �jn�j d }|p|dko|�dd�}�j �|d |d ||d�� �j�|j�} d| d �� ��fd d �t|j�D ��} | �j |fi t dd � i�����7 } | �j |fi ���7 } | |j d usm|j d urv�j|fi ���pwd 7 } �jr�|r���� | } �j �d� � r�|r�d | d S | S )Nr r r� F�correlate_froms� asfrom_froms)r r r r� r� c 3 s. � | ]\}}|j �f� d |d����V qdS )F)rK r� r� Nr� )rn �ir� �rK r� r� rl rp r1 � s � ���� �z4SQLCompiler.visit_compound_select.<locals>.<genexpr>rK r� rG rH rl )r r� r� �append�compound_keywords�keywordrA � enumerate�selects�group_by_clauser4 �order_by_clause� _limit_clause�_offset_clause� limit_clauser �_render_cte_clauser" ) r� �csrK r� r� r� r� r% �need_result_mapr r� rl r rp �visit_compound_select� sB ��� ��$ �� z!SQLCompiler.visit_compound_selectc C s( d|j ||r d| ndf }t| |d �S )Nz visit_%s_%s%sr� r� )r� r� )r� � operator_� qualifier1� qualifier2�attrnamerl rl rp �_get_operator_dispatch� s � z"SQLCompiler._get_operator_dispatchc K s� |j r,|jr t�d��| �|j dd�}|r |||j fi |��S | j|t|j fi |��S |jrP| �|jdd�}|rC|||jfi |��S | j|t|j fi |��S t�d��)NzFUnary expression does not support operator and modifier simultaneously�unaryr� �modifierz,Unary expression has no operator or modifier)r� r r r\ r � _generate_generic_unary_operatorrc � _generate_generic_unary_modifier)r� r r� r� rl rl rp � visit_unary� s: �� ��� ���zSQLCompiler.visit_unaryc K s: |j s| jjr| j|jfi |��S d| j|jfi |�� S )Nz%s = 1��_is_implicitly_booleanr� r� r� r� �r� r� r� r� rl rl rp �visit_istrue_unary_operator� s ��z'SQLCompiler.visit_istrue_unary_operatorc K s> |j s| jjrd| j|jfi |�� S d| j|jfi |�� S )N�NOT %sz%s = 0r r rl rl rp � 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 r� r� rl rl rp �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� rl rl rp �_emit_empty_in_warning� s �z"SQLCompiler._emit_empty_in_warningc K s. | j jrdS | j jr| �� | �|j|jk�S )Nz1 != 1�r� �_use_static_in�_warn_on_empty_inr* r� rC r' rl rl rp �visit_empty_in_op_binary� � z$SQLCompiler.visit_empty_in_op_binaryc K s. | j jrdS | j jr| �� | �|j|jk�S )Nz1 = 1r+ r' rl rl rp �visit_empty_notin_op_binary r/ z'SQLCompiler.visit_empty_notin_op_binaryc C r� )Nz3Dialect '%s' does not support empty set expression.r� )r� � element_typesrl rl rp �visit_empty_set_expr r z SQLCompiler.visit_empty_set_exprc K s� | j rt|jtj�rt|jtj�rd|d< |p|j}| �|dd �}|r,|||fi |��S zt| }W n t y? t � | |��w | j ||fi |��S )NT� literal_bindsr ) �ansi_bind_rulesr` rC r � BindParameterrY r� r rc rZ r �UnsupportedCompilationError�_generate_generic_binary)r� r r$ �eager_groupingr� r r� �opstringrl rl rp r% s" � � � �zSQLCompiler.visit_binaryc K s | j |jfi |��S r� )r� � sql_functionr rl rl rp �&visit_function_as_comparison_op_binary) r� z2SQLCompiler.visit_function_as_comparison_op_binaryc K s` | j jr| j|jfi |��d | j|jfi |�� S | j|jfi |��d | j|jfi |�� S )Nz %% r{ )r� r� r� rC rY r' rl rl rp �visit_mod_binary, s ������z SQLCompiler.visit_mod_binaryc K s( |j |d< | j|d|j d fi |��S )Nr8 r� )r8 r7 r9 r rl rl rp �visit_custom_op_binary: s ��z"SQLCompiler.visit_custom_op_binaryc K s | j ||jd fi |��S �Nr� )r r9 r rl rl rp � visit_custom_op_unary_operator@ � ��z*SQLCompiler.visit_custom_op_unary_operatorc K s | j |d|j fi |��S r> )r r9 r rl rl rp � visit_custom_op_unary_modifierE r@ z*SQLCompiler.visit_custom_op_unary_modifierc K s\ |� dd�}d|d< |jj| fd|i|��| |jj| fd|i|�� }|r,|r,d| }|S )N� _in_binaryFTr8 r� )r� rC r� rY )r� r r9 r8 r� rB r� rl rl rp r7 J s. ��������� z$SQLCompiler._generate_generic_binaryc K s ||j j| fi |�� S r� rI �r� r r9 r� rl rl rp r _ � z,SQLCompiler._generate_generic_unary_operatorc K s |j j| fi |��| S r� rI rC rl rl rp r b rD z,SQLCompiler._generate_generic_unary_modifierc C s t jdtjd�S )Nz'%')r� )r �literal_columnr � STRINGTYPEr� rl rl rp �_like_percent_literale r z!SQLCompiler._like_percent_literalc K �6 |� � }| j}|�|j��|�|_| j||fi |��S r� ��_clonerG �__add__rY �visit_like_op_binary�r� r r� r� �percentrl rl rp �visit_contains_op_binaryi � z$SQLCompiler.visit_contains_op_binaryc K rH r� �rJ rG rK rY �visit_notlike_op_binaryrM rl rl rp �visit_notcontains_op_binaryo rP z'SQLCompiler.visit_notcontains_op_binaryc K �0 |� � }| j}|�|j�|_| j||fi |��S r� )rJ rG �__radd__rY rL rM rl rl rp �visit_startswith_op_binaryu � z&SQLCompiler.visit_startswith_op_binaryc K rT r� )rJ rG rU rY rR rM rl rl rp � visit_notstartswith_op_binary{ rW z)SQLCompiler.visit_notstartswith_op_binaryc K rT r� rI rM rl rl rp �visit_endswith_op_binary� rW z$SQLCompiler.visit_endswith_op_binaryc K rT r� rQ rM rl rl rp �visit_notendswith_op_binary� rW z'SQLCompiler.visit_notendswith_op_binaryc K �V |j �dd �}d|jj| fi |��|jj| fi |��f |r(d| �|tj� S d S )N�escapez %s LIKE %s� ESCAPE r� �� modifiersr� rC r� rY �render_literal_valuer rF �r� r r� r� r\ rl rl rp rL � s ����z SQLCompiler.visit_like_op_binaryc K r[ )Nr\ z%s NOT LIKE %sr] r� r^ ra rl rl rp rR � � ����z#SQLCompiler.visit_notlike_op_binaryc K r[ )Nr\ zlower(%s) LIKE lower(%s)r] r� r^ ra rl rl rp �visit_ilike_op_binary� rb z!SQLCompiler.visit_ilike_op_binaryc K r[ )Nr\ z lower(%s) NOT LIKE lower(%s)r] r� r^ ra rl rl rp �visit_notilike_op_binary� rb z$SQLCompiler.visit_notilike_op_binaryc K �* |j �dd�}| j||rdndfi |��S )Nr_ Fz BETWEEN SYMMETRIC z BETWEEN �r_ r� r7 �r� r r� r� r_ rl rl rp �visit_between_op_binary� s ��z#SQLCompiler.visit_between_op_binaryc K re )Nr_ Fz NOT BETWEEN SYMMETRIC z NOT BETWEEN rf rg rl rl rp �visit_notbetween_op_binary� s ��z&SQLCompiler.visit_notbetween_op_binaryc K s$ |s |j �| j�}|jr |�|�}| j|fd||d�|��S |s%|rB| jrB|jd u r7|jd u r7t � d|j ��| j |fddi|��S | � |�}|| jv r{| j| } | |ur{| js[|jrj| j�|j�sjt � d|j ��| jsp|jr{t � d|j |j f ��| | j|j < | j|< | j|fd|ji|��S )NT)�skip_bind_expressionrN r3 z@Bind parameter '%s' without a renderable value not allowed here.rN 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� �_has_bind_expression�bind_expressionr� r4 r� r> r r\ r� �render_literal_bindparam�_truncate_bindparamr� rf r� � intersection�_is_crudr� rk ) r� r3 rN r3 rj r� �implrn r� �existingrl rl rp �visit_bindparam� sp �������� �� ��� �� ���zSQLCompiler.visit_bindparamc K s |j }| �||j�S r� )r? r` r� )r� r3 r� r� rl rl rp ro s z$SQLCompiler.render_literal_bindparamc C s$ |� | j�}|r ||�S td| ��)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 %r)�_cached_literal_processorr� r� )r� r� r� � processorrl rl rp r` s �z SQLCompiler.render_literal_valuec C s@ || j v r | j | S |j}t|tj�r| �d|�}|| j |< |S )Nr3 )r r� r` r ra rb )r� r3 � bind_namerl rl rp rp s z SQLCompiler._truncate_bindparamc C s� ||f| j v r| j ||f S |�| j�}t|�| jd krB| j �|d�}|dt| jd d�� d t|�dd � }|d | j |< n|}|| j ||f< |S )N� r r r� r )r � apply_mapr r7 r r� �max�hex)r� � ident_classr� �anonname�counter� truncnamerl rl rp rb * s ���z!SQLCompiler._truncated_identifierc C s || j S r� )r �r� r� rl rl rp � _anonymize= r� zSQLCompiler._anonymizec K sF | j r|d ur |�|� n| j�|� |r d| _d| S | jd|i S )NTz([EXPANDING_%s])r� )r r r � contains_expanding_parametersr )r� r� �positional_namesrk r� rl rl rp r� @ s z SQLCompiler.bindparam_stringc s� � � � ||d< t|jtj�r� �d|j�}n|j}d}d} |� jv rI� j| } || u } || jv s5|| u r8d}n| |jv rB� j| = nt � d| ��|sM|rj|j d urf|j } |j j} t| tj�re� �d| �} n|} d } |�r&|� j|< d|j j v r�d� jvr�� j�d|j j d i�� _| � jvr�� j| fi |�� | �s&|� jv�r&|jr�d� _� j�||�} |jr�t|jtj�r�|j}nt|jtj�r�|jjd }nJ �dd � t�|j �D �}| d d � � fd d �|D �� 7 } � j r�g |d< � j |< | d� j ||j!fi |��|jj"� fddi|��f 7 } |j#�r!| d� j ||j#fi |�� 7 } | � j|< |�r]|�s6| �r6� j�||�S | �rV� j�|| �} � j�$|��rM� j�%|�}| � �&|�7 } | S � j�||�S d S )N� visiting_cterq TFz5Multiple, unrelated CTEs found with the same name: %r� autocommitr c S � g | ]}|d ur|�qS r� rl r� rl rl rp r� � s �z)SQLCompiler.visit_cte.<locals>.<listcomp>r� r} c 3 s � | ] }� j �|�V qd S r� )r� � format_column)rn r� r� rl rp r1 � s � � �z(SQLCompiler.visit_cte.<locals>.<genexpr>r� z AS %s %srK r� )'r r` r� r ra rb r � _restatesr r r\ � _cte_aliasr� r� r� re � visit_cte� recursiver r� � format_alias�originalr �Select�CompoundSelectr r � unique_list� inner_columnsrA r r �_generate_prefixes� _prefixesr� � _suffixes�_requires_quotesrt �get_render_as_alias_suffix)r� �cterK �ashint� fromhintsr� r� �cte_name� is_new_cte� embedded_in_current_named_cte� existing_cte� pre_alias_cte�cte_pre_alias_namer� � col_source� recur_colsrl r� rp r� N s� �� �� ��� �������� � �zSQLCompiler.visit_ctec K s� |s|rt |jtj�r| �d|j�}n|j}|r | j�||�S |rI|jj| fddi|��| � | j�||�� }|rG||v rG| � |||| |�}|S |jj| fi |��S )Nrq rK T) r` r� r ra rb r� r� r� r� r� �format_from_hint_text) r� rq rK r� �iscrudr� r� � alias_name�retrl rl rp � visit_alias� s0 ��� �� �zSQLCompiler.visit_aliasc K s d|d< d| j |fi |�� S )NT�lateralz LATERAL %s)r� )r� r� r� rl rl rp � visit_lateral� s zSQLCompiler.visit_lateralc K sZ d| j |fddi|��|�� j| fi |��f }|jd ur+|d|jj| fi |�� 7 }|S )Nz%s TABLESAMPLE %srK Tz REPEATABLE (%s))r� � _get_methodr� �seed)r� � tablesamplerK r� r� rl rl rp �visit_tablesample� s � �z SQLCompiler.visit_tablesamplec C s d| S )Nr~ rl )r� �alias_name_textrl rl rp r� � s z&SQLCompiler.get_render_as_alias_suffixc C s | j �||||f� d S r� )r r )r� �keynamer� �objectsr� rl rl rp r� � rD z SQLCompiler._add_to_result_mapc s� � j ��j�} | jr |s|r | �� �} |r � �fdd�} n d} n � } |r(�j} nd} |s/| } n�t� tj�rG| � urDt | � j � j fd�} nm| } nj|durW|rWt | |� j fd�} nZ|r|t� tj �r|� js|� jdur|t� jtj�s|t | t�� j �� jfd�} n5t� tj�s�t� tj�r�� jr�t� d�r�t� tj�r�t | � j�} n| � ur�t | t�� j �� jfd�} n| } |j|| d� | j �fi |��S )z.produce labeled columns present in a select().c s �� | |� f| |� d S r� )r� )r� r� r� r� �r r� rl rp rf s �z;SQLCompiler._label_select_column.<locals>.add_to_result_mapN)r� r� r� ) r� rl r� �_has_column_expression�column_expressionr� r` r �Labelr� r� r� � _key_label� ColumnClauserr r` r r� � _as_truncatedr� � TextClause�UnaryExpression�wraps_column_expression�hasattrr �Function� anon_label�updater� ) r� rZ r r� rK �column_clause_argsr� rN �need_column_expressionsrs �col_exprrf � result_exprrl r� rp �_label_select_column s~ �� � �� �� � � � ��� � ��z SQLCompiler._label_select_columnc C s | � ||�}|r|d| 7 }|S r> )�get_from_hint_text)r� �sqltextr` �hintr� �hinttextrl rl rp r� ^ s z!SQLCompiler.format_from_hint_textc C � d S r� rl )r� �byfromsrl rl rp �get_select_hint_textd r� z SQLCompiler.get_select_hint_textc C r� r� rl �r� r` r� rl rl rp r� g r� z SQLCompiler.get_from_hint_textc C r� r� rl r� rl rl rp �get_crud_hint_textj r� z SQLCompiler.get_crud_hint_textc C s d� |�S r> �rA )r� � hint_textsrl rl rp �get_statement_hint_textm r� 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 | � � }� | < |jr�|jr�t|jtj�r�|�� �|jfi |��|_�|jfi |��}tj |j gdd�� � }|j D ] }|j |_|j|_qNtt|jj j |j ��}|||j j< |||j j< |||jj j< |||jj j< t�d �� �D ]\}}||v r�|| �d |< q��d �|� ||_�|jfi |��|_|S |jr�d|d< |jdd�i|�� |S |jr�|jr�|�dd �dk} | rՈ�i � d|d< |jdd�i|�� | r�d= |S |jdd�i|�� |S ) Nr T)� use_labels�select_container�transform_clue�clone� inside_selectrl ) rJ � is_selectable�_is_joinr` rY r � FromGrouping�_reset_exportedrC r� r� rq r� r� r� r� �_labelr4 �zipr �itemsr� �onclause�_is_from_container�_copy_internals� _is_selectr� r ) r� r� �newelemrY � selectable_r� �translate_dict�k�v�barrier_select��cloned�column_translate�visitrl rp r� z sj �� ��� � �� �� �z=SQLCompiler._transform_select_for_nested_joins.<locals>.visitrl )r� rZ rl r� rp �"_transform_select_for_nested_joinsp 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� r� rl rl rp r1 � � � �zESQLCompiler._transform_result_map_for_nested_joins.<locals>.<genexpr>c 3 s � | ] }� |j |fV qd S r� r� r� )� inner_colrl rp r1 � � � c �2 g | ]\}}}}||t � fd d�|D ��|f�qS )c s g | ]}� � ||��qS rl �r� )rn r� ��drl rp r� � � zQSQLCompiler._transform_result_map_for_nested_joins.<locals>.<listcomp>.<listcomp>��tuple)rn r� r� �objs�typr� rl rp r� � � ��zFSQLCompiler._transform_result_map_for_nested_joins.<locals>.<listcomp>)r4 r� r )r� rZ �transformed_selectrl )r� r� rp �&_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 }|r&|s&|j|�|�dd�}|S |j||d�}|S )Nr r r rl ��explicit_correlate_froms�implicit_correlate_froms)r r� �_get_display_froms� difference) r� rZ rK r� r� r% r r �fromsrl rl rp �_display_froms_for_select� s" �� ��z%SQLCompiler._display_froms_for_selectc sj �j o| o�j o�jj } | r%����} �j| f� |||dd�| ��} �j } | r.�jn�jd }| p@|�dd�p@|�dd� ��|dkrId��sRd| v rR| d= | r^�r\���| � | S �� �|� |�}| � � ��� ddd �� d } �j r��� ��\}}|r�| |d 7 } nd }�jr�| �j��jfi | ��7 } | �j�fi | ��7 } d d � � �����fdd ��jD �D �}�r�|d ur�ttdd � �jD �dd � |jD �����fdd ��jD ��_��| �|||| �} �jr��fdd ��jD �}|r�| d ��|� 7 } �j�r | �r ��� | } �j�r | d �j��jfi | �� 7 } �j�d� � �s*|�r3|�r3d| d S | S )NT)rK r� r� r� �nested_join_translationr r� Fr r rf )r_ rN zSELECT r� c S r� r� rl r� rl rl rp r� H s � z,SQLCompiler.visit_select.<locals>.<listcomp>c s( g | ]\}}�j �|�� �|�d ��qS ))r� r� �r� )rn r� r )rK r� r� r� rZ r� rl rp r� J s ���c S � g | ]\}}|�qS rl rl �rn r� r� rl rl rp r� _ rr c S r rl rl r rl rl rp r� ` s ��c r� )c 3 s � | ] }� � ||�V qd S r� r� )rn �o�� translaterl rp r1 h s � z6SQLCompiler.visit_select.<locals>.<listcomp>.<genexpr>r� )rn r� r� r� r� r rl rp r� g r� c s$ g | ]\}}|d � j jfv r|�qS ��*�r� r� )rn � dialect_name�htr� rl rp r� q s �rG rH ) r� r r� �supports_right_nested_joinsr� � visit_selectr� r� r� �_setup_select_stack�copyr� �_hints�_setup_select_hintsr� r� �get_select_precolumns�_columns_plus_namesr4 r� r �_compose_select_body�_statement_hintsr� r r r� r" )r� rZ rK r� r� r� r �select_wraps_forr� r� �needs_nested_translationr� r� r� r% r � hint_text�byfromr� � per_dialectrl )rK r� r� r� rZ r� r rp r � s� ������� � � �� � �� ��� � � � � � zSQLCompiler.visit_selectc s. t � fdd�|j�� D ��}� �|�}||fS )Nc s> g | ]\\}}}|d � j jfv r||d|j� dd�i f�qS )r r� T)r� �r� r� r� )rn �from_r� r� r� rl rp r� � s ���z3SQLCompiler._setup_select_hints.<locals>.<listcomp>)r4 r r� r� )r� rZ r r rl r� rp r � s �� z SQLCompiler._setup_select_hintsc C sp |d }|d }|r|s|j |�|�dd�}n|j ||d�}ttj|� �}|�|�} || |d�} | j�| � |S )Nr r rl r� )r r r )r� r� r\ r � _from_objectsre r r ) r� rZ r% rK r� r r r �new_correlate_froms�all_correlate_froms� new_entryrl rl rp r � s* ��� � z SQLCompiler._setup_select_stackc sT |d� |�7 }|r1|d7 }|jr!|d� � ��fdd�|D ��7 }n|d� ��fdd�|D ��7 }n|��� 7 }|jd urN|jj�fi ���}|rN|d| 7 }|jjr]|�j|fi ���7 }|jd urt|jj�fi ���}|rt|d| 7 }|j jr�|�j |fi ���7 }|j d us�|j d ur�|�j |fi ���7 }|jd ur�|�j|fi ���7 }|S )Nr} z FROM c s$ g | ]}|j �fd � d�����qS )T�rK r� r� �rn �f�r r� r� rl rp r� � s �����z4SQLCompiler._compose_select_body.<locals>.<listcomp>c s" g | ] }|j �fd di� ���qS )rK Tr� r$ r� rl rp r� � s ��z WHERE z HAVING )rA r rF � _whereclauser� �_group_by_clauser� r �_having�_order_by_clauser r r r �_for_update_arg�for_update_clause)r� r� rZ r� r r r� �trl r& rp r � sB �� �� z SQLCompiler._compose_select_bodyc s* d� � �fdd�|D ��}|r|d7 }|S )Nr� c 3 s: � | ]\}}|d u s|�j jkr|j�fi � ��V qd S r� r )rn �prefixr r� rl rp r1 � s � ��z1SQLCompiler._generate_prefixes.<locals>.<genexpr>r� )r� �stmt�prefixesr� r� rl r� rp r� � s �z SQLCompiler._generate_prefixesc sb � j rt� fdd�� jD �g �� j � _� �� j�d }|d�dd� � j�� D ��7 }|d7 }|S )Nc s g | ]}� j | �qS rl )r )rn r� r� rl rp r� � s z2SQLCompiler._render_cte_clause.<locals>.<listcomp>r� �, c S s g | ]}|�qS rl rl )rn �txtrl rl rp r� � s z )r �sumr r �get_cte_preambler rA �values)r� �cte_textrl r� rp r � s �� z SQLCompiler._render_cte_clausec C s |rdS dS )NzWITH RECURSIVE�WITHrl )r� r� rl rl rp r4 � s z SQLCompiler.get_cte_preamblec K s |j rdpdS )zcCalled when building a ``SELECT`` statement, position is just before column list. r r� )� _distinct�r� rZ r� rl rl rp r s z!SQLCompiler.get_select_precolumnsc K �$ |j j| fi |��}|rd| S dS )z5allow dialects to customize how GROUP BY is rendered.z GROUP BY r� )r( r� )r� rZ r� �group_byrl rl rp r � zSQLCompiler.group_by_clausec K r: )z5allow dialects to customize how ORDER BY is rendered.z ORDER BY r� )r* r� )r� rZ r� r� rl rl rp r r< zSQLCompiler.order_by_clausec K r� )Nz FOR UPDATErl r9 rl rl rp r, r� z SQLCompiler.for_update_clausec C rk )Nz@RETURNING is not supported by this dialect's statement compiler.rl )r� r/ �returning_colsrl rl rp �returning_clause! ro z SQLCompiler.returning_clausec K sf d}|j d ur|d| j|j fi |�� 7 }|jd ur1|j d u r#|d7 }|d| j|jfi |�� 7 }|S )Nr� z LIMIT z LIMIT -1z OFFSET )r r� r )r� rZ r� r� rl rl rp r ' s zSQLCompiler.limit_clausec K sr |s|r7| j �|�}|r |r | j �|�d | j �|j� } n| j �|j�} |r5||v r5| �| ||| |�} | S dS )Nrp r� )r� rv rw rt r� r� ) r� r` rK r� r� r� � use_schemar� rz r� rl rl rp � visit_table1 s � �� �zSQLCompiler.visit_tablec K sh |j rd}n|jr d}nd}|jj| fddi|��| |jj| fddi|�� d |jj| fi |�� S )Nz FULL OUTER JOIN z LEFT OUTER JOIN z JOIN rK Tz ON )r5 �isouterrC r� rY r� )r� rA rK r� � join_typerl rl rp � visit_joinN 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 r r )rn r` r� r r� rl rp r� _ s �z1SQLCompiler._setup_crud_hints.<locals>.<listcomp>T)r4 r r� r` r� )r� r/ � table_text� dialect_hintsrl r� rp �_setup_crud_hints] s �� �z SQLCompiler._setup_crud_hintsc s� | j }| j �t� t� |d�� tj| |tjfi |��}|s/| jjs/| jjs/t � d| jj ��|j rD| jj s?t � d| jj ��|d }n|}| j� | jj}d}|jr_|| j||jfi |��7 }|d7 }� �|j�} |jrt| �|| �\} } || 7 }|s||s�|dd�� fd d �|D �� 7 }| js�|jr�| �|| jp�|j�} | jr�|d | 7 }nd } |jd ur�| j| j fi |��} | j r�|r�| jj r�|d | � � | f 7 }n8|d | 7 }n1|s�|r�|d7 }n(|j r�|dd�dd� |D �� 7 }nd�dd � |D ��} |d| 7 }|�r| | _ |j!d u�r | j|j!fi |��}|�r |d | 7 }| �r)| j�s)|d | 7 }| j �r;|�r;| jj �s;| � � | }| j �"d� |�rJd| d S |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)r} c s g | ] }� � |d ��qS )r )r� r� �r� rl rp r� � s z,SQLCompiler.visit_insert.<locals>.<listcomp>r� z %s%sz %sz DEFAULT VALUESz VALUES %sc s s( � | ]}d d� dd� |D �� V qdS )r� r} c s s � | ]}|d V qdS )r Nrl r� rl rl rp r1 � s � z5SQLCompiler.visit_insert.<locals>.<genexpr>.<genexpr>Nr� )rn �crud_param_setrl rl rp r1 � � � � �z+SQLCompiler.visit_insert.<locals>.<genexpr>c S s g | ]}|d �qS )r rl r� rl rl rp r� � rr z VALUES (%s)r rG rH )#r r r\ r �_setup_crud_params�ISINSERTr� �supports_default_values�supports_empty_insertr r\ r� �_has_multi_parameters�supports_multivalues_insertr� r� r� � format_tabler` r rF rA r r r> �returning_precedes_valuesrZ r� �_insert_from_selectr �cte_follows_insertr �insert_single_values_expr�_post_values_clauser" )r� � insert_stmtrK r� r� � crud_params�crud_params_singlerM r� rD r� r> � select_textrU �post_values_clauserl rH rp � visit_insertk s� ����������� �� � � � �� �� zSQLCompiler.visit_insertc C r� )z3Provide a hook for MySQL to add LIMIT to the UPDATENrl )r� � update_stmtrl rl rp �update_limit_clause� r: 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. TrK r� r� )r� r] � from_table� extra_fromsr� rl rl rp �update_tables_clause� s z SQLCompiler.update_tables_clausec K � t d��)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 UPDATEr� �r� r] r_ r` � from_hintsr� rl rl rp �update_from_clause� s �z SQLCompiler.update_from_clausec s �j }|j}t|�}|r$tt�|j����fdd�|D �}��|�}ng }|jh}�j �|||d�� d} |j rF| �j ||j fi |��7 } �j ||j|fi |��} t j �|t jfi |��} |jrj��|| �\} } nd } | | 7 } | d7 } |ox�j� | d�� �fdd�| D ��7 } �js�|jr��jr�| d ��|�jp�|j� 7 } |r��j||j|| fi |��} | r�| d | 7 } |jd ur͈j|jfi |��}|r�| d | 7 } ��|�}|r�| d | 7 } �js�|jr�js�| d ��|�jp�|j� 7 } �jr�|r��� � | } �j � d � |�r d | d S | S )Nc s g | ]}|� vr|�qS rl rl r$ )� main_fromsrl rp r� s z,SQLCompiler.visit_update.<locals>.<listcomp>rG zUPDATE z SET r} c 3 s. � | ]}|d j �� d�d |d V qdS )r )rx �=r Nr� r� )rx r� rl rp r1 + s � ��� �z+SQLCompiler.visit_update.<locals>.<genexpr>r� � WHERE r rG rH ) r � _extra_froms�boolr\ r r r` re r r� r� ra r rK �ISUPDATEr rF �'render_table_with_column_in_update_fromrA r r rR r> re r' r� r^ r r r" )r� r] rK r� r� r` � is_multitable�render_extra_fromsr r� rD rX rE �extra_from_textr- r rl )rx rf r� rp � visit_update� s� � �������� �� � ��� ��� � zSQLCompiler.visit_updatec C s t �| | j�S r� )r � _key_getters_for_crud_columnr� r� rl rl rp rq ] s z(SQLCompiler._key_getters_for_crud_columnc K rb )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 DELETEr� rc rl rl rp �delete_extra_from_clausea s �z$SQLCompiler.delete_extra_from_clausec C s |j | ddd�S )NT)rK r� r� )r� � delete_stmtr_ r` rl rl rp �delete_table_clauseq � z SQLCompiler.delete_table_clausec K s~ | j }tj| |tjfi |�� |j}|jh�|�}| j �|||d�� d}|jr6|| j ||jfi |��7 }|d7 }| � ||j|�}|j rN| � ||�\} }nd } ||7 }|j re| jre|d| �||j � 7 }|r|| j||j|| fi |��} | r||d| 7 }|jd ur�|jj| fi |��} | r�|d| 7 }|j r�| js�|d| �||j � 7 }| jr�|r�| �� | }| j �d� |r�d| d S |S ) NrG zDELETE �FROM r� rh r rG rH )r r rK �ISDELETEri r` re r r� r� rt r rF r rR r> rr r' r� r r r" ) r� rs rK r� r� r` r r� rD rE ro r- rl rl rp � visit_deletet sr ����� ���� � zSQLCompiler.visit_deletec C � d| j �|� S )Nz SAVEPOINT %s�r� �format_savepoint�r� �savepoint_stmtrl rl rp �visit_savepoint� ru zSQLCompiler.visit_savepointc C ry )NzROLLBACK TO SAVEPOINT %srz r| rl rl rp �visit_rollback_to_savepoint� � �z'SQLCompiler.visit_rollback_to_savepointc C ry )NzRELEASE SAVEPOINT %srz r| rl rl rp �visit_release_savepoint� r� z#SQLCompiler.visit_release_savepoint)NF)NNT�F)NFFN)NT)NFTr� )FTr )FFF)FFNN)FFFN�NTF)FTNr FNF)FFFNT)�r� r� r� r� � EXTRACT_MAPr� �COMPOUND_KEYWORDSr r r r r� r rR rl r� r4 r� r! r rU r r r� r� r r �memoized_instancemethodr � contextlib�contextmanagerr& r �memoized_propertyr5 r8 r� r� r� � dependenciesrD rF rL rX r] rj rn r} r� r� r� r� r� rs 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 r2 r% r; r< r= r? rA r7 r r rG rO rS rV rX rY rZ rL rR rc rd rh ri ru ro r` rp rb r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� � frozensetr� r r r r r r� r r4 r r r r, r> r r@ rC rF r\ r^ ra re rp rq rr rt rx r~ r r� rl rl rl rp r� � s� �H 8 �# � �1 �( � " �3 � � �= � � �! �\]� � 6 � p f Jr� c @ sP e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z dd� Z dS )�StrSQLCompileraw 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:`.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:`.ClauseElement.compile` directly. .. seealso:: :ref:`faq_sql_expression_string` c C r� )Nz<name unknown>rl rm rl rl rp rn � r� z$StrSQLCompiler._fallback_column_namec K s, d| j |jfi |��| j |jfi |��f S )Nz%s[%s])r� rC rY r' rl rl rp �visit_getitem_binary� r� z#StrSQLCompiler.visit_getitem_binaryc K � | j ||fi |��S r� �r� r' rl rl rp � visit_json_getitem_op_binary� r� z+StrSQLCompiler.visit_json_getitem_op_binaryc K r� r� r� r' rl rl rp �!visit_json_path_getitem_op_binary� r� z0StrSQLCompiler.visit_json_path_getitem_op_binaryc K ry )Nz<next sequence value: %s>)r� �format_sequence)r� �seqr� rl rl rp r� � ru z StrSQLCompiler.visit_sequencec s& � fdd�t �|�D �}dd�|� S )Nc s g | ] }� � d |ddi ��qS r� r r� r� rl rp r� � s ��z3StrSQLCompiler.returning_clause.<locals>.<listcomp>z RETURNING r} )r �_select_iterablesrA )r� r/ r= �columnsrl r� rp r> � s �z StrSQLCompiler.returning_clausec s dd� � ��fdd�|D �� S )Nrv r} c 3 �( � | ]}|j �fd � d����V qdS �Tr# Nr� �rn r- �rd r� r� rl rp r1 � rJ z4StrSQLCompiler.update_from_clause.<locals>.<genexpr>r� rc rl r� rp re � � �z!StrSQLCompiler.update_from_clausec s dd� � ��fdd�|D �� S )Nr} c 3 r� r� r� r� r� rl rp r1 rJ z:StrSQLCompiler.delete_extra_from_clause.<locals>.<genexpr>r� rc rl r� rp rr r� z'StrSQLCompiler.delete_extra_from_clauseN) r� r� r� r� rn r� r� r� r� r> re rr rl rl rl rp r� � s r� c @ sN e Zd Zejdd� �Zejdd� �ZdNdd�Zdd � Zd d � Z d d � Z dd� Z dOdd�Z dNdd�Z dd� Zdd� Zdd� Z dPd d �Zd d � ZdOd 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 )Q� DDLCompilerc C s | j �| j d �S r� )r� �statement_compilerr� rl rl rp r� r zDDLCompiler.sql_compilerc C r� r� )r� r� r� rl rl rp r� r� zDDLCompiler.type_compilerNc C r� r� rl r� rl rl rp r� r� z DDLCompiler.construct_paramsc K s� |j }t|jtj�rD|�� }| j}|�|j�}t|�dkr%|d d}}n |d |d }}|� d|� |� d|� |� d|� |j�� | j � |j | �S )Nr r r� r r` r �fullname)�contextr` �targetr �Tabler r� �format_table_seqr7 � setdefaultrQ r� r� r� )r� �ddlr� r� r� �pathr` �schrl rl rp � visit_ddl s zDDLCompiler.visit_ddlc C s | j �|j�}d| S )NzCREATE SCHEMA )r� � format_schemar� )r� r! r rl rl rp �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 r� rl rl rp �visit_drop_schema, s z DDLCompiler.visit_drop_schemac C sJ |j }| j}d}|jr|d�|j�d 7 }|d|�|� d 7 }| �|�}|r-||d 7 }|d7 }d}d}|jD ]O}|j } z"| j|| joF| d�} | d urY||7 }d}|d | 7 }| jr^d }W q8 t j y� } zt � t � t � d �|j| j| jd f �� W Y d } ~ q8d } ~ ww | j||jd �} | r�||d | 7 }|d| �|� 7 }|S )Nz CREATE r� zTABLE rG � F��first_pkr1 � Tz (in table '%s', column '%s'): %sr )� _include_foreign_key_constraintsz )%s )r� r� r� rA rQ �create_table_suffixr� r� � primary_keyr r\ r �raise_from_cause�u� descriptionr� �args�create_table_constraints� include_foreign_key_constraints�post_create_table) r� r! r` r� r� r� � separatorr� � create_columnr � processed�ce�constrl rl rp �visit_create_table3 sV � �������z DDLCompiler.visit_create_tableFc sL |j }|jrd S � j||d�}d�� fdd�|jD ��}|r$|d| 7 }|S )Nr� r� c 3 s � | ]}� � |�V qd S r� )r� �rn r r� rl rp r1 k r� z2DDLCompiler.visit_create_column.<locals>.<genexpr>)r� �system�get_column_specificationrA � constraints)r� r! r� r r� r� rl r� rp �visit_create_columnd s � z DDLCompiler.visit_create_columnc st g }�j r |��j � �j}|d ur|�|�� nt� � |�� �fdd��jD �� d�dd� �fdd�|D �D ��S )Nc s" g | ] }|�j ur|� vr|�qS rl )r� r� )� omit_fkcsr` rl rp r� � s �z8DDLCompiler.create_table_constraints.<locals>.<listcomp>z, c s s � | ] }|d ur|V qd S r� rl )rn �prl rl rp r1 � s � � �z7DDLCompiler.create_table_constraints.<locals>.<genexpr>c 3 sB � | ] }|j d u s|� � �r� jjrt|dd�s� �|�V qd S )N� use_alterF)� _create_ruler� �supports_alterr� r� r� r� rl rp r1 � s � �� ���)r� r �foreign_key_constraintsr� r\ �extend�_sorted_constraintsrA )r� r` r� r� �all_fkcsrl )r� r� r` rp r� s s" �� ��z$DDLCompiler.create_table_constraintsc C � d| j �|j� S )Nz DROP TABLE �r� rQ r� �r� r� rl rl rp �visit_drop_table� r� z DDLCompiler.visit_drop_tablec C r� )Nz DROP VIEW r� r� rl rl rp �visit_drop_view� r� zDDLCompiler.visit_drop_viewc C s |j d u r t�d|j ��d S )Nz,Index '%s' is not associated with any table.)r` r r\ r� �r� r� rl rl rp �_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�r? r} c 3 s" � | ] }� j j|d dd�V qdS )FT�rx r3 N)r� r� )rn r� r� rl rp r1 � s � �� �z1DDLCompiler.visit_create_index.<locals>.<genexpr>) r� r� r� rf r� r r\ �_prepared_index_namerQ r` rA � expressions)r� r! r� �include_table_schemar� r� r� rl r� rp �visit_create_index� s( � ��� z DDLCompiler.visit_create_indexc C s, |j }|jd u r t�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� r� rl rl rp �visit_drop_index� s ��z DDLCompiler.visit_drop_indexc C sX |j d ur | j�|j �}nd }|r|r| j�|�}nd }| j�|�}|r*|d | }|S �Nrp )r` r� rv rw � format_index)r� r� r� rz � schema_name� index_namerl rl rp r� � s z DDLCompiler._prepared_index_namec C s d| j �|jj�| �|j�f S )NzALTER TABLE %s ADD %s)r� rQ r� r` r� �r� r! rl rl rp �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� rl rl rp �visit_set_table_comment� s ��z#DDLCompiler.visit_set_table_commentc C � d| j �|j� S )NzCOMMENT ON TABLE %s IS NULLr� r� rl rl rp �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_tabler? )r� r� r� r� r` r� r r� r� rl rl rp �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� rl rl rp �visit_drop_column_comment� s �z%DDLCompiler.visit_drop_column_commentc C s� d| j �|j� }|jjd ur|d|jj 7 }|jjd ur%|d|jj 7 }|jjd ur3|d|jj 7 }|jjd urA|d|jj 7 }|jjd urK|d7 }|jjd urU|d7 }|jj d urc|d|jj 7 }|jj d u rm|d 7 }|jj d urw|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�start�minvalue�maxvalue� nominvalue� nomaxvalue�cacherS �cycle)r� r! r� rl rl rp �visit_create_sequence s, � z!DDLCompiler.visit_create_sequencec C r� )NzDROP SEQUENCE %s)r� r� r� r� rl rl rp �visit_drop_sequence r� z DDLCompiler.visit_drop_sequencec C s^ |j }|jd ur| j�|�}nd }|d u r t�d|j ��d| j�|j j�||jr+dp,df 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 r` r� )r� r� r �formatted_namerl rl rp �visit_drop_constraint s �� �z!DDLCompiler.visit_drop_constraintc K sr | j �|�d | jjj|j|d� }| �|�}|d ur!|d| 7 }|jd ur0|d| �|j� 7 }|js7|d7 }|S )Nr� )r� z DEFAULT z NOT NULL) r� r� r� r� r� r� �get_column_default_string�computed�nullable)r� r r� �colspecr( rl rl rp r� - s ���� z$DDLCompiler.get_column_specificationc C r� �Nr� rl �r� r` rl rl rp r� @ r� z DDLCompiler.create_table_suffixc C r� r� rl r� rl rl rp r� C r� z DDLCompiler.post_create_tablec C sJ t |jtj�r#t |jjtj�r| j�|jjt j �S | jj |jjdd�S d S )NT)r3 ) r` �server_defaultr � DefaultClause�argr � string_typesr� r` r rF r� rm rl rl rp r� F s ��z%DDLCompiler.get_column_default_stringc C �\ 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 r� r� rl rl rp �visit_check_constraintS � �z"DDLCompiler.visit_check_constraintc C r r r r rl rl rp � visit_column_check_constraint_ r z)DDLCompiler.visit_column_check_constraintc s� t |�dkrdS d}|jd ur � j�|�}|d ur |d| 7 }|d7 }|dd�� fdd�|jr2|jn|jD �� 7 }|� �|�7 }|S ) Nr r� r z PRIMARY KEY r� r} c 3 � � | ] }� j �|j�V qd S r� �r� rt r� r� r� rl rp r1 t s � � �z;DDLCompiler.visit_primary_key_constraint.<locals>.<genexpr>) r7 r� r� r� rA �_implicit_generated�columns_autoinc_firstr� r r rl r� rp � visit_primary_key_constraintk s � �z(DDLCompiler.visit_primary_key_constraintc s� | j � d}|jd ur| j �|�}|d ur|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)r} c 3 � � | ] }� � |jj�V qd S r� )rt �parentr� r$ rH rl rp r1 � � � �z;DDLCompiler.visit_foreign_key_constraint.<locals>.<genexpr>c 3 r r� )rt r r� r$ rH rl rp r1 � r ) r� r� r� r r r r` rA � define_constraint_remote_table�define_constraint_match�define_constraint_cascadesr )r� r r� r� � remote_tablerl rH rp � 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 r` r� rl rl rp r � r� 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)r} c 3 r r� r r� r� rl rp r1 � r� z6DDLCompiler.visit_unique_constraint.<locals>.<genexpr>)r7 r� r� r� rA r r rl r� rp �visit_unique_constraint� s �z#DDLCompiler.visit_unique_constraintc C sL d}|j d ur|d| j�|j t� 7 }|jd ur$|d| j�|jt� 7 }|S )Nr� z ON DELETE %sz ON UPDATE %s)�ondeleter� �validate_sql_phrase� FK_ON_DELETE�onupdate� FK_ON_UPDATE�r� r r� rl rl rp r � s � �z&DDLCompiler.define_constraint_cascadesc C sL d}|j d ur|j r|d7 }n|d7 }|jd ur$|d| j�|jt� 7 }|S )Nr� z DEFERRABLEz NOT DEFERRABLEz INITIALLY %s)r) r; r� r � FK_INITIALLYr rl rl rp r � s �z+DDLCompiler.define_constraint_deferrabilityc C s d}|j d ur|d|j 7 }|S )Nr� z MATCH %s)�matchr rl rl rp r � s z#DDLCompiler.define_constraint_matchc C sD d| j j|jddd� }|jdu r|d7 }|S |jdu r |d7 }|S )NzGENERATED ALWAYS AS (%s)FTr� z STOREDz VIRTUAL)r� r� r� � persisted)r� � generatedr� rl rl rp �visit_computed_column� s � �z!DDLCompiler.visit_computed_columnr� r� )FT)*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% rl rl rl rp r� sT 1 �) � 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 r� )N�FLOATrl r� rl rl rp � visit_FLOAT� r� z GenericTypeCompiler.visit_FLOATc K r� )N�REALrl r� rl rl rp � visit_REAL� r� z GenericTypeCompiler.visit_REALc K �8 |j d u rdS |jd u rdd|j i S d|j |jd� S )N�NUMERICzNUMERIC(%(precision)s)� precisionz!NUMERIC(%(precision)s, %(scale)s)�r- �scaler. r� rl rl rp � visit_NUMERIC� � �z!GenericTypeCompiler.visit_NUMERICc K r+ )N�DECIMALzDECIMAL(%(precision)s)r- z!DECIMAL(%(precision)s, %(scale)s)r. r. r� rl rl rp � visit_DECIMAL� r1 z!GenericTypeCompiler.visit_DECIMALc K r� )N�INTEGERrl r� rl rl rp � visit_INTEGER� r� z!GenericTypeCompiler.visit_INTEGERc K r� )N�SMALLINTrl r� rl rl rp �visit_SMALLINT� r� z"GenericTypeCompiler.visit_SMALLINTc K r� )N�BIGINTrl r� rl rl rp � visit_BIGINT� r� z GenericTypeCompiler.visit_BIGINTc K r� )N� TIMESTAMPrl r� rl rl rp �visit_TIMESTAMP� r� z#GenericTypeCompiler.visit_TIMESTAMPc K r� )N�DATETIMErl r� rl rl rp �visit_DATETIME� r� z"GenericTypeCompiler.visit_DATETIMEc K r� )N�DATErl r� rl rl rp � visit_DATE r� z GenericTypeCompiler.visit_DATEc K r� )N�TIMErl r� rl rl rp � visit_TIME r� z GenericTypeCompiler.visit_TIMEc K r� )N�CLOBrl r� rl rl rp � visit_CLOB r� z GenericTypeCompiler.visit_CLOBc K r� )N�NCLOBrl r� rl rl rp � visit_NCLOB r� z GenericTypeCompiler.visit_NCLOBc C s0 |}|j r |d|j 7 }|jr|d|j 7 }|S )N�(%d)z COLLATE "%s")�lengthr )r� r� r� r� rl rl rp �_render_string_type s z'GenericTypeCompiler._render_string_typec K � | � |d�S )N�CHAR�rH r� rl rl rp � visit_CHAR r� z GenericTypeCompiler.visit_CHARc K rI )N�NCHARrK r� rl rl rp � visit_NCHAR r� z GenericTypeCompiler.visit_NCHARc K rI )N�VARCHARrK r� rl rl rp � visit_VARCHAR r� z!GenericTypeCompiler.visit_VARCHARc K rI )N�NVARCHARrK r� rl rl rp �visit_NVARCHAR r� z"GenericTypeCompiler.visit_NVARCHARc K rI )N�TEXTrK r� rl rl rp � visit_TEXT! r� z GenericTypeCompiler.visit_TEXTc K r� )N�BLOBrl r� rl rl rp � visit_BLOB$ r� z GenericTypeCompiler.visit_BLOBc K � d|j r d|j p d S )N�BINARYrF r� �rG r� rl rl rp � visit_BINARY' rD z GenericTypeCompiler.visit_BINARYc K rW )N� VARBINARYrF r� rY r� rl rl rp �visit_VARBINARY* rD z#GenericTypeCompiler.visit_VARBINARYc K r� )N�BOOLEANrl r� rl rl rp � visit_BOOLEAN- r� z!GenericTypeCompiler.visit_BOOLEANc K � | j |fi |��S r� )rV r� rl rl rp �visit_large_binary0 r� z&GenericTypeCompiler.visit_large_binaryc K r_ r� )r^ r� rl rl rp � visit_boolean3 r� z!GenericTypeCompiler.visit_booleanc K r_ r� )rA r� rl rl rp � visit_time6 r� z GenericTypeCompiler.visit_timec K r_ r� )r= r� rl rl rp �visit_datetime9 r� z"GenericTypeCompiler.visit_datetimec K r_ r� )r? r� rl rl rp � visit_date< r� z GenericTypeCompiler.visit_datec K r_ r� )r9 r� rl rl rp �visit_big_integer? r� z%GenericTypeCompiler.visit_big_integerc K r_ r� )r7 r� rl rl rp �visit_small_integerB r� z'GenericTypeCompiler.visit_small_integerc K r_ r� )r5 r� rl rl rp � visit_integerE r� z!GenericTypeCompiler.visit_integerc K r_ r� )r* r� rl rl rp � visit_realH r� z GenericTypeCompiler.visit_realc K r_ r� )r( r� rl rl rp � visit_floatK r� z GenericTypeCompiler.visit_floatc K r_ r� )r0 r� rl rl rp � visit_numericN r� z!GenericTypeCompiler.visit_numericc K r_ r� �rP r� rl rl rp � visit_stringQ r� z GenericTypeCompiler.visit_stringc K r_ r� rk r� rl rl rp � visit_unicodeT r� z!GenericTypeCompiler.visit_unicodec K r_ r� �rT r� rl rl rp � visit_textW r� z GenericTypeCompiler.visit_textc K r_ r� rn r� rl rl rp �visit_unicode_textZ r� z&GenericTypeCompiler.visit_unicode_textc K r_ r� rk r� rl rl rp � visit_enum] r� z GenericTypeCompiler.visit_enumc K s t �d| ��)NzKCan't generate DDL for %r; did you forget to specify a type on this Column?rl r� rl rl rp r� ` s ��z GenericTypeCompiler.visit_nullc K s | j |�| j�fi |��S r� )r� � type_enginer� r� rl rl rp �visit_type_decoratorg s z(GenericTypeCompiler.visit_type_decoratorc K s |j di |��S )Nrl )� get_col_specr� rl rl rp �visit_user_definedj ru z&GenericTypeCompiler.visit_user_definedN)-r� r� r� r( r* r0 r3 r5 r7 r9 r; r= r? rA rC rE rH rL rN rP rR rT rV rZ r\ r^ r` ra rb rc rd re rf rg rh ri rj rl rm ro rp rq r� rs ru rl rl rl rp r& � sV r& c @ s e Zd Zdd� Zdd� ZdS )�StrSQLTypeCompilerc C s |� d�r| jS t|��)N�visit_)� startswith�_visit_unknown�AttributeError)r� r� rl rl rp � __getattr__o s z StrSQLTypeCompiler.__getattr__c K s d|j j S )Nz%s)r� r� r� rl rl rp ry u r� z!StrSQLTypeCompiler._visit_unknownN)r� r� r� r{ ry rl rl rl rp rv n s rv c @ s e Zd ZdZeZeZeZ e � d�Z d5dd�Z dd � Zd d � Zd d � Zdd� Zdd� Zdd� Zdd� Zd6dd�Zd6dd�Zdd� Zd7d d �Zd6d d �Zd6d d!�Zd6d"d#�Ze � d$�d%d&� �Z d'd(� Z d8d)d*�Z d+d,� Z! d9d-d.�Z"d7d/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 )rx rv N) r� � initial_quote� final_quote� escape_quote�escape_to_quote� omit_schema� quote_case_sensitive_collations�_stringsr r� )r� r� r~ r r� r� r� rl rl rp r� � s zIdentifierPreparer.__init__c C s, | j �| j �}|j�| j� t�|�|_|S r� )r� �__new__�__dict__r� r �_schema_getterrv )r� r� �preprl rl rp 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� )r� r� r� r� �r� r� rl rl rp �_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. )r� r� r� r� rl rl rp �_unescape_identifier� s z'IdentifierPreparer._unescape_identifierc C s* |dur|� |�st�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� �regrl rl rp 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. )r~ r� r r� rl rl rp �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� �lc_valuerl rl rp 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.)r� r" r r� r� rl rl rp r� � s z1IdentifierPreparer._requires_quotes_illegal_charsc C s |dur t �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_deprecatedrt )r� r �forcerl rl rp rw � s � z IdentifierPreparer.quote_schemac C s| |dur t �d� t|dd�}|du r5|| jv r | j| S | �|�r+| �|�| j|< n|| j|< | j| S |r<| �|�S |S )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().rt )r r� r� r� r� r� )r� r� r� rl rl rp rt s � zIdentifierPreparer.quotec C s | j r| �|�S |S r� )r� rt )r� �collation_namerl rl rp r~ I s z#IdentifierPreparer.format_collationc C s> | � |j�}| �|�}| js |r |d ur | �|�d | }|S r� )rt r� rv r� rw )r� r� r? r� rz rl rl rp r� O s ��z"IdentifierPreparer.format_sequencec C � | � |p|j�S r� �rt r� )r� r� r� rl rl rp re \ ru z IdentifierPreparer.format_labelc C r� r� r� )r� rq r� rl rl rp r� _ ru z IdentifierPreparer.format_aliasc C s" |p|j }| �|�r| �|�}|S r� )r� r� r� )r� � savepointr� r� rl rl rp r{ b s z#IdentifierPreparer.format_savepointzsqlalchemy.sql.namingc C s� t |jtj�r |�||j�}|d u r t |jtj�rd S |j}n|j}t |tj�rT|jdkr6| j j p4| j j }n| j j }t |�|krS|d|d � d t �|�dd � }n| j �|� | �|�S )Nr� r � r� ���)r` r� r � _defer_name�_constraint_name_for_tabler` �_defer_none_namera r� r� �max_index_name_lengthr r7 r �md5_hex�validate_identifierrt )r� �namingr r� �max_rl rl rp r� k s* �� � &� z$IdentifierPreparer.format_constraintc C � | � |�S r� )r� r� rl rl rp r� � r� z IdentifierPreparer.format_indexc C sF |du r|j }| �|�}| �|�}| js!|r!|r!| �|�d | }|S )z'Prepare a quoted table and schema name.Nrp )r� rt rv r� rw )r� r` r? r� rE rz rl rl rp rQ � s z IdentifierPreparer.format_tablec C r� )z Prepare a quoted schema name.)rt r� rl rl rp r� � r� z IdentifierPreparer.format_schemac C sj |du r|j }t|dd�s$|r | j|j||d�d | �|� S | �|�S |r3| j|j||d�d | S |S )z Prepare a quoted column name.Nrr F)r? r� rp )r� r� rQ r` rt )r� r r� r� � table_namer? rl rl rp r� � s. ���� ����z IdentifierPreparer.format_columnc C s@ | � |�}| js|r|r| �|�| j|dd�fS | j|dd�fS )z(Format table name and schema as a tuple.Fr� )rv r� rw rQ )r� r` r? rz rl rl rp r� � s �z#IdentifierPreparer.format_table_seqc C s@ dd� | j | j| �| j�fD �\}}}t�d|||d� �}|S )Nc S s g | ]}t �|��qS rl )r/ r\ r� rl rl rp r� � � ��z5IdentifierPreparer._r_identifiers.<locals>.<listcomp>zM(?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+)�initial�final�escaped)r~ r r� r/ r� )r� r� r� � escaped_final�rrl rl rp �_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 rl )r� )rn r r� rl rp r� � r� z;IdentifierPreparer.unformat_identifiers.<locals>.<listcomp>c S s g | ]\}}|p |�qS rl rl )rn �a�brl rl rp r� � r� )r� �findall)r� � identifiersr� rl r� rp �unformat_identifiers� s �z'IdentifierPreparer.unformat_identifiers)r} Nr} TFr� )T)TN)FNNF)'r� r� r� r� �RESERVED_WORDSr� �LEGAL_CHARACTERSr� �ILLEGAL_INITIAL_CHARACTERSr� r r� rv r� r� r� r� r r� r� r� rw rt r~ r� re r� r{ r r� r� r� rQ r� r� r� r� r� r� rl rl rl rp r| y sP �$ %2 � & r| )lr� r� r- r/ r� r r r r r r r r r r r\ r� r� �Ir� �LEGAL_CHARACTERS_PLUS_SPACE�rangere r� r r r! �UNICODEr� r� r �and_�or_�add�mulr0 �div�mod�truediv�neg�lt�le�ne�gt�ge�eq�is_distinct_from�isnot_distinct_from� concat_opr& � notmatch_op�in_op�notin_op�comma_opr rd �is_�isnotr �exists� distinct_op�inv�any_op�all_op�desc_op�asc_op� nullsfirst_op� nullslast_oprc r� r# r% r& r' rF rG r� r� r[ rg �cube�rollup� grouping_setsr� r� r� r� � UNION_ALLr� � EXCEPT_ALLr� � INTERSECT_ALLr� �objectr� �with_metaclass�EnsureKWArgTyper� � Visitabler� r4 r� r� r� r� r& rv r| rl rl rl rp �<module> sf �c ��� ������� � � � � ��������������� � � � �!�"�#�%�&�,��� != N
Save
Cancel