관리-도구
편집 파일: crud.cpython-38.pyc
U -?�f�� � @ s\ d Z ddlmZ ddlZddlZddlmZ ddlmZ ddlmZ ddlm Z ddlm Z dd lm Z dd lm Z dd lm Z dd lmZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z ddl m Z dd l m!Z! dd l"m#Z# dd l"m$Z$ d d lm%Z% d d!lm&Z& d d"l'm(Z( e�r�dd#l)m*Z* dd$l)m+Z+ dd%lm,Z, dd&lm-Z- dd'lm.Z. dd(lm/Z/ dd)lm0Z0 dd*l m1Z1 dd+l m2Z2 e&�3d,d-�Z4d.d/d0�d1d2�Z5ed.e6eee6d3f e e6 f Z7ed4e6e6e e6 f Z8ed/e6d3e e6 f Z9e e7 Z:G d5d6� d6e �Z;d7d8d9d:d;d6d<�d=d>�Z<ed�d7d.d;dAd:dBd;dCdD�dEdF��Z=ed7d.d;d;dCdG�dHdF��Z=d�d7d.d;d:d:dBd;dJdD�dKdF�Z=dLdM� Z>d7d8d9dNdO�dPdQ�Z?dRdS� Z@dTdU� ZAdVdW� ZBdXdY� ZCdZd[� ZDd\d]� ZEd^d_� ZFd7d8d/d`dadbdc�ddde�ZGdfdg� ZHed�d7d.dAd;dCdh�didj��ZIed7d.dkd;dldh�dmdj��ZId�d7d.d:dBd;dndo�dpdj�ZIed�d7d.dAd;dCdh�dqdr��ZJed7d.dkd;dldh�dsdr��ZJd�d7d.d:dBd;dndo�dtdr�ZJG dudv� dvej/e �ZKd7d8d4dwdadCdx�dydz�ZLd{d|� ZMd7d8d9d}d~dadd��d�d��ZNd�d�� ZOd�d�� ZPd�d�� ZQdS )�ziFunctions used by compiler.py to determine the parameters rendered within INSERT and UPDATE statements. � )� annotationsN)�Any)�Callable)�cast)�Dict)�Iterable)�List)�MutableMapping)� NamedTuple)�Optional)�overload)�Sequence)�Set)�Tuple)� TYPE_CHECKING)�Union� )� coercions)�dml)�elements)�roles)�_DefaultDescriptionTuple)�isinsert)� ColumnClause)�default_is_clause_element)�default_is_sequence)�Select)� TableClause� )�exc)�util)�Literal)�_BindNameForColProtocol)� SQLCompiler)�_DMLColumnElement)�DMLState)� ValuesBase)� ColumnElement)�KeyedColumnElement)�_SQLExprDefault)�Column�REQUIREDa8 Placeholder for the value within a :class:`.BindParameter` which is required to be present when the statement is passed to :meth:`_engine.Connection.execute`. This symbol is typically used when a :func:`_expression.insert` or :func:`_expression.update` statement is compiled without parameter values present. zColumnElement[Any]�ColumnClause[Any])�c�returnc C s t | t�st�d| ����| S )Nz5Can't create DML statement against column expression )� isinstancer r � CompileError)r- � r1 �C/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/sql/crud.py�_as_dml_columnJ s �r3 r) zKeyedColumnElement[Any]c @ sB e Zd ZU ded< ded< dZded< dZded< d Zd ed < d S ) � _CrudParams�_CrudParamSequenceZ single_params�$List[Sequence[_CrudParamElementStr]]Zall_multi_paramsF�bool�is_default_metavalue_only�use_insertmanyvaluesNz Optional[Sequence[Column[Any]]]�use_sentinel_columns)�__name__� __module__� __qualname__�__annotations__r8 r9 r: r1 r1 r1 r2 r4 j s r4 r# r& r% r7 r )�compiler�stmt� compile_state�toplevel�kwr. c s� g �_ g �_g �_g �_|�dd�}|dk r8|�dd� d|ksHtd��t�||�\� }}|�_|j rv|j rvt � d��|j r�t�||d|� |dd||� tg g �S �jdkr�|jr�t�fdd�|jjD �g �S t|��r|j�r|j}|dk s�t�|d } t| �� �} � fd d �| D ��np|j�rP|j} |j} | dk �s<t�� fd d �| D ��n:|j�r~|j} t| �� �} � fd d �| D ��n d } } ��jdk�r�i } n@| �rȈdk �s�t�� �fdd��jD �} n� fdd��jD �} g } | dk �r�t�|| | � | |� i } t � |��r.|j �r.t �||| | ||| |� t|��rr|j �rr|j�rLt�t!�||| |� || | ||� d}d}n t"�||| |� || | ||� \}}| �r�| �r�t#| ��$� fdd�| D ���%| �}|�r�t � dd�&dd� |D �� ��d}t|��r.|j�r.|j �rt�t'�||t(d| �t(d� �|�}t| |�S | �sx�j)�rx�j*j+�rxt,|jjd ��j-�.|jjd ��j*j/dfg} d}t| g |||d�S )aQ create a set of tuples representing column/string pairs for use in an INSERT or UPDATE statement. Also generates the Compiled object's postfetch, prefetch, and returning column collections, used for default handling and ultimately populating the CursorResult's prefetch_cols() and postfetch_cols() collections. � visiting_cteN�accumulate_bind_namesz;Don't know how to handle insert within insert without a CTEzVCan't compile statement that includes returning() and return_defaults() simultaneouslyr1 c s6 g | ].}|j s|� j�|�t� |d dd�|jff�qS )NT)�required)Z_omit_from_statements�preparer� format_column�_create_bind_param�key��.0r- )r? r1 r2 � <listcomp>� s � �z$_get_crud_params.<locals>.<listcomp>r c s h | ] }� |��qS r1 r1 �rL rJ ��_column_as_keyr1 r2 � <setcomp>� s z#_get_crud_params.<locals>.<setcomp>c s h | ] }� |��qS r1 r1 rN rO r1 r2 rQ � s c s h | ] }� |��qS r1 r1 rN rO r1 r2 rQ � s c s i | ]}|�kr� |�t �qS r1 �r+ rN )rP � spd_str_keyr1 r2 � <dictcomp>� s � z$_get_crud_params.<locals>.<dictcomp>c s i | ]}� |�t �qS r1 rR rN rO r1 r2 rT s Fc 3 s | ]\}}� |�V qd S �Nr1 )rL �k�vrO r1 r2 � <genexpr>K s z#_get_crud_params.<locals>.<genexpr>zUnconsumed column names: %s�, c s s | ]}d |f V qdS )z%sNr1 rK r1 r1 r2 rX Q s � Sequence[_CrudParamElementStr]�Callable[..., str]T)r8 r9 r: )0� postfetch�insert_prefetch�update_prefetch�implicit_returning�get�pop�AssertionError� _key_getters_for_crud_columnZ_get_bind_name_for_col� _returning�_return_defaultsr r0 �isdelete� _setup_delete_return_defaultsr4 Z column_keysZ_no_parameters�table�columns�_compile_state_isinsert�_has_multi_parameters�_multi_parameters�list�itemsZ_ordered_valuesZ_dict_parameters�!_get_stmt_parameter_tuples_paramsr �isupdateZ is_multitable� _get_update_multitable_params� _select_names� _scan_insert_from_select_cols� _scan_cols�set� intersection� difference�join� _extend_values_for_multiparamsr �for_executemany�dialectZsupports_default_metavaluer3 rG rH Zdefault_metavalue_token)r? r@ rA rB rC rD �_getattr_col_key�_col_bind_name�mpZspd�stmt_parameter_tuples� parameters�values� check_columnsr9 r: �checkr8 Zmulti_extended_valuesr1 )rP r? rS r2 �_get_crud_paramsr sb ( �� � �� � ��� � � � � � � ������� �� ��� ���r� .Fz Literal[True]z Optional[str]�str)r? �col�value�processrF �namerC r. c K s d S rU r1 )r? r� r� r� rF r� rC r1 r1 r2 rI � s rI )r? r� r� rC r. c K s d S rU r1 )r? r� r� rC r1 r1 r2 rI � s Tz'Union[str, elements.BindParameter[Any]]c K sB |d kr|j }tj|||j|d�}d|_|r:|j| f|�S |S d S )N)�type_rF T)rJ r � BindParameter�typeZ_is_crud�_compiler_dispatch)r? r� r� r� rF r� rC � bindparamr1 r1 r2 rI � s �c K sR d|k}|s0|j r0t|jtj�r0|| jd|jf< |jjrD|�|j�}|j | f|�S )NrD r� ) �uniquer/ rJ r Z_truncated_labelZtruncated_namesr� �_isnull�_with_binary_element_typer� )r? r� r� r� rC Zis_cter1 r1 r2 � _handle_values_anonymous_param� s �� � r� z�Tuple[Callable[[Union[str, ColumnClause[Any]]], Union[str, Tuple[str, str]]], Callable[[ColumnClause[Any]], Union[str, Tuple[str, str]]], _BindNameForColProtocol])r? r@ rA r. c s� t �|�rj|jrjt|j�� t�tjtj ��ddd�� �fdd� }ddd�� fdd � }dd d�� fd d � }n t�tjtj �}t � d � }}|||fS )Nz Union[ColumnClause[Any], str]zUnion[str, Tuple[str, str]])rJ r. c s0 �| �}t | d�r(| j� kr(| jj|fS |S d S )Nrh )�hasattrrh r� )rJ Zstr_key��_etZ c_key_roler1 r2 rP � s z4_key_getters_for_crud_column.<locals>._column_as_keyr, )r� r. c s" | j � kr| j j| jfS | jS d S rU )rh r� rJ �r� �r� r1 r2 r| � s z6_key_getters_for_crud_column.<locals>._getattr_col_keyr� c s: | j � kr0tr t| j t�s t�d| j j| jf S | jS d S )Nz%s_%s)rh r r/ r rb r� rJ r� r� r1 r2 r} � s z4_key_getters_for_crud_column.<locals>._col_bind_namerJ ) r rp � _extra_fromsru � functools�partialr Z expect_as_keyr � DMLColumnRole�operator� attrgetter)r? r@ rA rP r| r} r1 r� r2 rc � s � �rc c sT � �fdd��j D �} | jd d �ks,t��j| jd d< g } �jr|t| �} �jjD ]$}|| krV|jrV|jj sV| � |� qV| D ]R}||�}||kr�||kr�|� |� |� || j � |�d df� q�t| �|| | � q�| �rP|�| � | jd d }t|t��s t�dd�d d � | D ��� d ���|�� }t|j�d d� | D � |_|| jd d< d S ) Nc s g | ]}�j j� |� �qS r1 )rh r- )rL r� �rP r@ r1 r2 rM s z1_scan_insert_from_select_cols.<locals>.<listcomp>���� selectableZinsert_from_selectr1 z_Can't extend statement for INSERT..FROM SELECT to include additional default-holding column(s) rY c s s | ]\}}}}t |�V qd S rU )�repr)rL �_rJ r1 r1 r2 rX @ s z0_scan_insert_from_select_cols.<locals>.<genexpr>z~. Convert the selectable to a subquery() first, or pass include_defaults=False to Insert.from_select() to skip these columns.c S s g | ]\}}}}|�qS r1 r1 )rL r� �exprr1 r1 r2 rM I s )rr �stackrb �selectZ#include_insert_from_select_defaultsru rh ri �default� is_sentinel�appendra rG rH �&_append_param_insert_select_hasdefault�extendr/ r r r0 rx Z _generaterm Z _raw_columns)r? r@ rA r� r| rP r} r� r� rB rC �colsZadd_select_colsZcol_setr� r- �col_keyZins_from_selectr1 r� r2 rs sP ��� � �� � rs c sr t | �|| �\} } } }}}|js*|js*t�|jrv� fdd�|jD �}t|���fdd�|D ��fdd��jjD � }n�jj}t |�}|r�|j s��jj }| j j }nd }}�jr�t�j�}nt� }| j}|D �]p}||�}||k�r||k�rt| �|||||| | ||||| � �n|�r|j�rR| �rR| �r@t| �||| � nt| �||| � n�|jd k �r�|jj�rr|d k �rt| �|| || � n�|jd k �r�| �r�|| k�r�|�|� n|j�s| j�|� nB| �r�|| k�r�|�|� n&|j�r$|�jj k �r$|j�s$t|� n |j�r$t | |�|| || � ||kr�||kr�|�|� q�|�rj|� |��|� �fdd��jD �� ||fS )Nc s g | ] }� |��qS r1 r1 rN rO r1 r2 rM h s z _scan_cols.<locals>.<listcomp>c s. g | ]&}t |t�r|� jjkr� jj| �qS r1 )r/ r� rh r- rN )r@ r1 r2 rM l s �c s g | ]}|j � kr|�qS r1 )rJ rK )� ordered_keysr1 r2 rM p s c 3 s | ]}|� kr|V qd S rU r1 rK )�remaining_supplementalr1 r2 rX � s �z _scan_cols.<locals>.<genexpr>) �_get_returning_modifiersrp r rb Z_parameter_orderingru rh r- ri rj rk �_autoincrement_columnr{ �#insert_null_pk_still_autoincrements�_supplemental_returningr_ �_append_param_parameter� primary_key�!_append_param_insert_pk_returning�$_append_param_insert_pk_no_returningr� r� � _append_param_insert_hasdefault�server_defaultr� r\ �nullable�"_warn_pk_with_no_anticipated_value�_append_param_updaterw r� )r? r@ rA r� r| rP r} r� r� rB rC �need_pksr_ �implicit_return_defaults�postfetch_lastrowidr9 r: Zparameter_orderingr� r �autoincrement_colr� Zsupplemental_returningZcompiler_implicit_returningr- r� r1 )rP r� r� r@ r2 rt O s� � � �� � � � � � � � �� ��� ��rt c s` t | ||| �^} } } } | s d S |jr0| j�| � |jr\t| j�� | j�� fdd�|jD �� d S )Nc 3 s | ]}|� kr|V qd S rU r1 rK �Zir_setr1 r2 rX , s z0_setup_delete_return_defaults.<locals>.<genexpr>)r� �_return_defaults_columnsr_ r� r� ru ) r? r@ rA r� r| rP r} r� r� rB rC r� r� r1 r� r2 rg s � �rg c C s� |� |�}| jj||jd�}t� }t�|�r�| rZ|jrZ|| krZ| rJd| _n|rZ| j � |� t | ||f|t kt |�rx|js�||�n d||� |d�| ��}�n&|j�r | r�|jd kr�|jr�|| kr�|r�| j � |� n| jjr�d| _t| ||ft |�r�|j�s||�n d||� |d�| ��}n�| j|�� fd|i| ��}|j�rj|�r\||k�r\| j � |� n | j� |� nX|j�r�|�r�| j � |� n| jj�r�d| _n*|�r�||k�r�| j � |� n | j� |� | � ||||f� d S )N�Z use_tableTz%s_m0)rF r� rE )r� rE rE )ra rG rH � include_table_with_column_exprsru r � _is_literalr� r� r_ r� rI r+ rj rk �_is_bind_parameterr� r{ r� r� � self_grouprp r\ )r? r@ rA r- r� r� r} r_ r� r� r� r� r� rC r� � col_value�accumulated_bind_namesr1 r1 r2 r� 1 s� � ��� ��� � � ������� � ���� r� c C s |j dk r�|j jrl| jjr^|j jr*| jjs^t� }|�|| j� |�| j |j fd|i|��|f� | j �|� nx|j j r�t� }|�|| j� |�| j |j j �� fd|i|��|f� | j �|� n(|�|| j� |�t| |f|�|jff� n6||jjks�|jdk �r | j �|� n|j�s t|� dS )z�Create a primary key expression in the INSERT statement where we want to populate result.inserted_primary_key and RETURNING is available. NrE )r� � is_sequencer{ �supports_sequences�optional�sequences_optionalru r� rG rH r� r_ �is_clause_element�argr� �"_create_insert_prefetch_bind_paramrJ rh r� r� r� r� )r? r@ r- r� rC r� r1 r1 r2 r� � sb �� ����� ����� ��r� c C s� |j dk r*|j jrj| jjr*|j jrj| jjrj||jjkr�| jjs�|j dk rX|j jrX| jjsj|j dkr�| jj r�|� || j � |�t | |f|�|jff� n>|j dkr�|jdkr�|js�||jjk r�t|� n| jjr�d| _dS )ao Create a primary key expression in the INSERT statement where we want to populate result.inserted_primary_key and we cannot use RETURNING. Depending on the kind of default here we may create a bound parameter in the INSERT statement and pre-execute a default generation function, or we may use cursor.lastrowid if supported by the dialect. NT)r� r� r{ r� r� r� rh r� r� Z"preexecute_autoincrement_sequencesr� rG rH r� rJ r� r� r� �r? r@ r- r� rC r1 r1 r2 r� � sT ��� � � �����!�"�( �� ��� � r� c C s |j jr�| jjr�|j jr | jjs�t� }|�|| j� |�| j |j fd|i|��|f� |rn||krn| j �|� n|j s�| j �|� n�|j jr�t� }|�|| j� |�| j |j j�� fd|i|��|f� |r�||kr�| j �|� n|j s�| j �|� n(|�|| j� |�t| |f|�|jff� d S )NrE )r� r� r{ r� r� r� ru r� rG rH r� r_ r� r\ r� r� r� r� rJ )r? r@ r- r� r� rC r� r1 r1 r2 r� . sd �� ����� ����� ��r� z List[_CrudParamElementSQLExpr]zDict[str, Any]�None)r? r@ r- r� rC r. c C s� t |j�rD| jjr�|jjr"| jjs�|�|| j�|�|j� � df� n^t |j�rr|�|| j�|�|jj � � df� n0|�|| j�|�t | |fddi|��|jff� d S )Nr1 r� F)r r� r{ r� r� r� r� rG rH Z next_valuer r� r� r� rJ r� r1 r1 r2 r� e sF �� �� �� �����r� c C s |j }|jd k r�|jjs�|jjrx|�|| jj||d�| j|jj� � f|�df� |rj||krj| j �|� q�| j �|� q�|�|| jj||d�t | |f|�|j ff� nV|jd k r�|r�||kr�| j �|� q�| j �|� n$|r�|js�|js�||kr�| j �|� d S )Nr� r1 )r� �onupdater� r� r� rG rH r� r� r� r_ r\ �"_create_update_prefetch_bind_paramrJ �server_onupdater� re )r? rA r@ r- r� r� rC � include_tabler1 r1 r2 r� � sN ��� � �� ����r� )r? r- r� rC r. c K s d S rU r1 �r? r- r� rC r1 r1 r2 r� � s r� zLiteral[False]zelements.BindParameter[Any]c K s d S rU r1 r� r1 r1 r2 r� � s z'Union[elements.BindParameter[Any], str])r? r- r� r� rC r. c K s* t | |d f||d�|��}| j�|� |S �N)r� r� )rI r] r� �r? r- r� r� rC �paramr1 r1 r2 r� � s � �� c K s d S rU r1 r� r1 r1 r2 r� � s r� c K s d S rU r1 r� r1 r1 r2 r� � s c K s* t | |d f||d�|��}| j�|� |S r� )rI r^ r� r� r1 r1 r2 r� � s � �� c @ sX e Zd ZdZdd� Zdd� Zdd� Zdd � Zej d d �d d ��Z ej d d �dd��Z dS )�_multiparam_columnTc C s4 || _ d|j|d f | _|| _|j| _|j| _d S )N�%s_m%dr )�indexrJ �originalr� r� )�selfr� r� r1 r1 r2 �__init__� s z_multiparam_column.__init__c K s t � �d S rU ��NotImplementedError)r� �otherrC r1 r1 r2 �compare s z_multiparam_column.comparec K s t � �d S rU r� )r� rC r1 r1 r2 �_copy_internals s z"_multiparam_column._copy_internalsc C s" t |t�o |j| jko |j| jkS rU )r/ r� rJ r� )r� r� r1 r1 r2 �__eq__ s � �z_multiparam_column.__eq__r )r. c C s t �| j�S �z1used by default.py -> _process_execute_defaults())r �_from_column_defaultr� �r� r1 r1 r2 �_default_description_tuple s z-_multiparam_column._default_description_tuplec C s t �| j�S r� )r r� r� r� r1 r1 r2 �_onupdate_description_tuple s z._multiparam_column._onupdate_description_tupleN) r; r< r= Z_is_multiparam_columnr� r� r� r� r Zmemoized_propertyr� r� r1 r1 r1 r2 r� � s r� �int)r? r@ r- r� rC r. c C s� |j st�d| ��nht|j �r6| j|j j�� f|�S |j jrN| j|j f|�S t||�}t |t j �sht �t | |fddi|��S d S )Nz�INSERT value for column %s is explicitly rendered as a boundparameter in the VALUES clause; a Python-side value or SQL expression is requiredr� T)r� r r0 r r� r� r� r� r� r/ r ZInsertrb r� )r? r@ r- r� rC r� r1 r1 r2 � _process_multiparam_default_bind s( �� ���r� c C s� dd� |p dD �} |j } t� } |jD ]�} | jD ]�} | | kr.| �| � | ||| �< | | }| j| | d�}t�|�r�t| | |f|t k|| �d�|��}| j f}nP|j r�|| �}t | | |fd|i|��}|f}n"| j �| � | j|�� f|�}d}|�| |||f� q.q$| D ]�} | jD ]�} | | k�r$�qn�| jd k �r�| jj�s�| jj�r�|�| | j| | d�| j| jj�� f|�df� | j �| � n6|�| | j| | d�t| | fd|| �i|��| j ff� n| jd k �r| j �| � �q�qd S )Nc S s i | ]\}}t �tj|�|�qS r1 )r �expectr r� )rL r- r� r1 r1 r2 rT L s � z1_get_update_multitable_params.<locals>.<dictcomp>r1 �r� )rF r� r� )r� ru r� r- �addr� r r� rI r+ rJ r� r� r\ r� r� r� r� r� r� r� r� )r? r@ rA r r� r} r| r� rC Znormalized_paramsr� Zaffected_tables�tr- r� r� r� Zcbnr1 r1 r2 rq A s� � ��� ��� ���� ����� rq rZ r[ r6 )r? r@ rA �initial_valuesrP rC r. c s� |}|g}|j }|d k s t�t|dd � �D ]�\} } g } � fdd�| �� D �} |D ]�\} } }}| j| kr�| j}t�| | �r�t| | | | fdd| j| d f i|��}q�| j| | � � f|�}nt | || | |�}| � | | ||f� qR|� | � q,|S )Nr c s i | ]\}}� |�|�qS r1 r1 )rL rJ rW rO r1 r2 rT � s z2_extend_values_for_multiparams.<locals>.<dictcomp>r� r� ) rl rb � enumeratern rJ r r� rI r� r� r� r� )r? r@ rA r� rP rC Zvalues_0r� r~ �i�row� extensionr� �col_exprr� Zaccumulated_namesrJ � new_paramr1 rO r2 ry � s> ��� � ry c C s� |D ]�\}}||�} | d k r*|� | |� q| j||jd�} t�|�rb| jtjd ||jd�f|�}n,|jr||jj r||� |j�}| j|� � f|�}|� || |df� qd S )Nr� )r� r1 ) � setdefaultr� r� r r� r r� r� r� r� r� r� r� ) r? rA r� r rP r� rC rV rW Zcolkeyr� r1 r1 r2 ro � s$ � �� ro c C s� | j }|o<t|�o<|j o<| j s.|jo<|jo<|j o<|j }|oR|joR|j j dk }|o�|j o�|j j o�|jo�| p�|jp�|jp�|j}|r�d}t|�r�|o�|j}|p�|jp�|j} |o�| jo�|jo�| p�|j} d} | r�| r�|jr�| �|j �} np|j�r|j�o|j j �o|j�o|j}d} d} n>|j�rL|j�o@|j j �o@|j�o@|j}d} d} n d}d} d} |�r�|j�stt|j j�} n t|j�} nd} ||�p�|| || | fS )z�determines RETURNING strategy, if any, for the statement. This is where it's determined what we need to fetch from the INSERT or UPDATE statement after it's invoked. NF) r{ rj Z_inlinerz Z insert_executemany_returningre rd rk r� rh r� Zinsert_returningZ_primary_tabler_ Z _supports_implicit_returningZ favor_returning_over_lastrowidr� r9 Z!use_insertmanyvalues_wo_returningZ_sort_by_parameter_orderZ _get_sentinel_column_for_tablerp Zupdate_returningrf Zdelete_returningr� ru r- ) r? r@ rA rB r{ r� r� r_ Z should_implicit_return_defaultsZexplicit_returningr9 r: r� r1 r1 r2 r� � s� �� �� �� � �� � �������� ���������� �r� c C s> d| j j| j| j jf }t| j j�dkr0|d7 }t�|� d S )Na Column '%s.%s' is marked as a member of the primary key for table '%s', but has no Python-side or server-side default generator indicated, nor does it indicate 'autoincrement=True' or 'nullable=True', and no explicit value is passed. Primary key columns typically may not store NULL.r a0 Note that as of SQLAlchemy 1.1, 'autoincrement=True' must be indicated explicitly for composite (e.g. multicolumn) primary keys if AUTO_INCREMENT/SERIAL/IDENTITY behavior is expected for one of the columns in the primary key. CREATE TABLE statements are impacted by this change as well on most backends.)rh �fullnamer� �lenr� r �warn)r- �msgr1 r1 r2 r� r s �� �r� ).FN)TFN).)TN).)TN)R�__doc__� __future__r r� r� �typingr r r r r r r r r r r r r r r � r r r r �baser r rj r Zschemar r r� r r r r Z util.typingr! r? r" r# r$ r% r& r' r( r) r* �symbolr+ r3 r� Z_CrudParamElementZ_CrudParamElementStrZ_CrudParamElementSQLExprr5 r4 r� rI r� rc rs rt rg r� r� r� r� r� r� r� r� r� r� rq ry ro r� r� r1 r1 r1 r2 �<module> s� � ������� � � &6E E s=M7). � � � �$!R,*