a
    •˜ëjB  ã                   @  sT  d dl mZ d dlZd dlZd dlZd dlZddlmZ ddlm	Z	 ddl
mZ ddlmZ G dd	„ d	ƒZG d
d„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ dƒZG d d!„ d!e d!g d"¢¡ƒZG d#d$„ d$ƒZejd%d&„ ƒZdS )'é    )ÚannotationsNé   )Úevent)Úurl)ÚDefaultDialect)ÚBaseDDLElementc                   @  s(   e Zd ZdZdZdZdd„ Zdd„ ZdS )Ú
AssertRuleFNTc                 C  s   d S ©N© ©ÚselfÚexecute_observedr
   r
   ú[/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/assertsql.pyÚprocess_statement   s    zAssertRule.process_statementc                 C  s   dsJ dƒ‚d S )NFz?All statements are complete, but pending assertion rules remainr
   ©r   r
   r
   r   Úno_more_statements   s    ÿzAssertRule.no_more_statements)Ú__name__Ú
__module__Ú__qualname__Úis_consumedÚerrormessageÚconsume_statementr   r   r
   r
   r
   r   r      s
   r   c                   @  s   e Zd ZdS )ÚSQLMatchRuleN©r   r   r   r
   r
   r
   r   r   &   s   r   c                   @  s   e Zd Zddd„Zdd„ ZdS )Ú	CursorSQLNTc                 C  s   || _ || _|| _d S r	   )Ú	statementÚparamsr   )r   r   r   r   r
   r
   r   Ú__init__+   s    zCursorSQL.__init__c                 C  sp   |j d }| j|jks,| jd urN| j|jkrNd| _d| j| j|j|jf | _n|j  d¡ d| _|j sld| _d S )Nr   Tz5Testing for exact SQL %s parameters %s received %s %s)Ú
statementsr   r   Ú
parametersr   r   Úpopr   )r   r   Ústmtr
   r
   r   r   0   s&    
ÿ
ÿüÿÿ
zCursorSQL.process_statement)NT©r   r   r   r   r   r
   r
   r
   r   r   *   s   
r   c                   @  sF   e Zd Zddd„Zdd„ Zdd	„ Zd
d„ Zdd„ Zdd„ Zdd„ Z	dS )ÚCompiledSQLNÚdefaultTc                 C  s   || _ || _|| _|| _d S r	   )r   r   ÚdialectÚenable_returning)r   r   r   r%   r&   r
   r
   r   r   G   s    zCompiledSQL.__init__c                 C  s   t  dd| j¡}||kS ©Nú[\n\t]Ú )ÚreÚsubr   ©r   r   Úreceived_statementr!   r
   r
   r   Ú_compare_sqlO   s    zCompiledSQL._compare_sqlc                 C  sl   | j dkrTtƒ }d|_| jrPd |_ |_|_d|_d|_d|_	d|_
|jsPJ ‚|S tj | j ¡ ¡ ƒ S d S )Nr$   T)r%   r   Zsupports_default_metavaluer&   Zinsert_returningZupdate_returningZdelete_returningZuse_insertmanyvaluesZsupports_multivalues_insertZupdate_returning_multifromZdelete_returning_multifromZinsert_executemany_returningr   ÚURLÚcreateÚget_dialect)r   r   r%   r
   r
   r   Ú_compile_dialectS   s    
þ
zCompiledSQL._compile_dialectc           	        s¶   |j }|  |¡}d}d‰d|jv r.|jd }nd}t|jtƒrP|jj||d�‰ n|jj|||jj|jj	|d�‰ t
 ddtˆ ƒ¡}|j}|sšˆ jˆd�g}n‡ ‡fdd	„|D ƒ}||fS )
zxreconstruct the statement and params in terms
        of a target dialect, which for CompiledSQL is just DefaultDialect.NÚschema_translate_map)r%   r3   )Ú	cache_keyr%   Úcolumn_keysÚfor_executemanyr3   r(   r)   ©Úextracted_parametersc                   s   g | ]}ˆ j |ˆd �‘qS )r7   )Úconstruct_params)Ú.0Úm©Úcompiledr8   r
   r   Ú
<listcomp>™   s   ýÿz3CompiledSQL._received_statement.<locals>.<listcomp>)Úcontextr2   Úexecution_optionsÚ
isinstanceÚclauseelementr   Úcompiler=   r5   r6   r*   r+   Ústrr   r9   )	r   r   r?   Zcompare_dialectr4   Zmap_Ú_received_statementr   Ú_received_parametersr
   r<   r   rE   m   s>    
ÿ
þûÿÿüzCompiledSQL._received_statementc                 C  sä   |j }|  |¡\}}|  |¡}|  ||¡}|r¶|d ur¶t|ƒ}t|ƒ}|rª|rªt| d¡ƒ}	tt|ƒƒD ]8\}
}|	D ] }||vs�|| |	| krt qhqt||
=  qFqhd}qªqF|s²|r¶d}|rÈd| _d | _	n|  
||¡||dœ | _	d S )Nr   FT)r-   Zreceived_parameters)r?   rE   Ú_all_paramsr.   ÚlistÚdictr    Ú	enumerater   r   Ú_failure_message)r   r   r?   rE   rF   r   Z
equivalentÚ
all_paramsZall_receivedÚparamÚidxZreceivedZ	param_keyr
   r
   r   r   ¢   sF    ÿ
ÿþÿþþzCompiledSQL.process_statementc                 C  s>   | j r6t| j ƒr|   |¡}n| j }t|tƒs2|g}|S d S d S r	   )r   ÚcallablerA   rH   )r   r?   r   r
   r
   r   rG   Õ   s    

zCompiledSQL._all_paramsc                 C  s"   d| j  dd¡t|ƒ dd¡f S ©NzzTesting for compiled statement
%r partial params %s, received
%%(received_statement)r with params %%(received_parameters)rú%ú%%)r   ÚreplaceÚrepr©r   r   Zexpected_paramsr
   r
   r   rK   á   s    þýÿzCompiledSQL._failure_message)Nr$   T)
r   r   r   r   r.   r2   rE   r   rG   rK   r
   r
   r
   r   r#   F   s    ÿ
53r#   c                   @  s&   e Zd Zd
dd„Zdd„ Zdd	„ ZdS )ÚRegexSQLNr$   Fc                 C  s2   t  | ¡ t |¡| _|| _|| _|| _|| _d S r	   )	r   r   r*   rC   ÚregexÚ
orig_regexr   r%   r&   )r   rW   r   r%   r&   r
   r
   r   r   î   s    
zRegexSQL.__init__c                 C  s"   d| j  dd¡t|ƒ dd¡f S )Nz{Testing for compiled statement ~%r partial params %s, received %%(received_statement)r with params %%(received_parameters)rrQ   rR   )rX   rS   rT   rU   r
   r
   r   rK   ø   s    þýÿzRegexSQL._failure_messagec                 C  s   t | j |¡ƒS r	   )ÚboolrW   Úmatch)r   r   r-   r
   r
   r   r.     s    zRegexSQL._compare_sql)Nr$   F)r   r   r   r   rK   r.   r
   r
   r
   r   rV   í   s    ÿ

rV   c                      sD   e Zd Zdd„ Zdd„ Z‡ fdd„Zdd„ Zd	d
„ Zdd„ Z‡  Z	S )Ú
DialectSQLc                 C  s   |j jS r	   )r?   r%   r   r
   r
   r   r2     s    zDialectSQL._compile_dialectc                 C  s   t  dd|¡}||kS r'   )r*   r+   )r   Ú	real_stmtÚreceived_stmtr!   r
   r
   r   Ú_compare_no_space  s    zDialectSQL._compare_no_spacec                   sH   t ƒ  |¡\}}|jD ]}|  |jj|¡r q<qtd| ƒ‚||jjfS )NzICan't locate compiled statement %r in list of statements actually invoked)ÚsuperrE   r   r^   r?   r   ÚAssertionErrorZcompiled_parameters)r   r   r]   Zreceived_paramsr\   ©Ú	__class__r
   r   rE     s    ÿ
ÿÿÿzDialectSQL._received_statementc                   sª   |j }t dd| j¡}| dd¡}|dkr:t dd|¡}n`d }|dkrLd	}n@|d
krZd}n2| d¡rŒt d¡‰ |dkrzdnd‰‡ ‡fdd„}t d||¡}| dd¡}|S )Nr(   r)   z::z!!Zpyformatz	:([\w_]+)z%(\1)sZqmarkú?Úformatz%sÚnumericé   Znumeric_dollarú$ú:c                   s   ˆ› t ˆ ƒ› �S r	   )Únext)r;   ©ÚcounterZnum_identifierr
   r   Úrepl7  s    z4DialectSQL._dialect_adjusted_statement.<locals>.repl)Ú
paramstyler*   r+   r   rS   Ú
startswithÚ	itertoolsÚcount)r   r%   rm   r!   rl   r
   rj   r   Ú_dialect_adjusted_statement"  s"    

z&DialectSQL._dialect_adjusted_statementc                 C  s   |   |jj¡}||kS r	   )rq   r?   r%   r,   r
   r
   r   r.   A  s    ÿzDialectSQL._compare_sqlc                 C  s*   d|   |jj¡ dd¡t|ƒ dd¡f S rP   )rq   r?   r%   rS   rT   rU   r
   r
   r   rK   G  s    ÿþüýÿzDialectSQL._failure_message)
r   r   r   r2   r^   rE   rq   r.   rK   Ú__classcell__r
   r
   ra   r   r[     s   r[   c                   @  s$   e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚCountStatementsc                 C  s   || _ d| _d S ©Nr   ©rp   Ú_statement_count)r   rp   r
   r
   r   r   V  s    zCountStatements.__init__c                 C  s   |  j d7  _ d S )Nrf   )rv   r   r
   r
   r   r   Z  s    z!CountStatements.process_statementc                 C  s(   | j | jkr$ds$J d| j | jf ƒ‚d S )NFz,desired statement count %d does not match %dru   r   r
   r
   r   r   ]  s
    þz"CountStatements.no_more_statementsN)r   r   r   r   r   r   r
   r
   r
   r   rs   U  s   rs   c                   @  s   e Zd Zdd„ Zdd„ ZdS )ÚAllOfc                 G  s   t |ƒ| _d S r	   )ÚsetÚrules©r   ry   r
   r
   r   r   f  s    zAllOf.__init__c                 C  sj   t | jƒD ]H}d |_| |¡ |jrB| j |¡ | js<d| _ qfq
|js
d | _ qfq
t | jƒd j| _d S ©NTr   )rH   ry   r   r   r   Údiscard©r   r   Úruler
   r
   r   r   i  s    
zAllOf.process_statementNr"   r
   r
   r
   r   rw   e  s   rw   c                      s,   e Zd Zdd„ Zdd„ Z‡ fdd„Z‡  ZS )ÚEachOfc                 G  s   t |ƒ| _d S r	   )rH   ry   rz   r
   r
   r   r   {  s    zEachOf.__init__c                 C  sh   | j sd| _d| _| j rX| j d }| |¡ |jr@| j  d¡ n|jrN|j| _|jrqXq| j sdd| _d S )NTFr   )ry   r   r   r   r    r   r}   r
   r
   r   r   ~  s    

zEachOf.process_statementc                   s6   | j r"| j d js"| j d  ¡  n| j r2tƒ  ¡  d S rt   )ry   r   r   r_   r   ra   r
   r   r   �  s    zEachOf.no_more_statements)r   r   r   r   r   r   rr   r
   r
   ra   r   r   z  s   r   c                      s   e Zd Z‡ fdd„Z‡  ZS )ÚConditionalc                   s"   |rt ƒ j|Ž  nt ƒ j|Ž  d S r	   )r_   r   )r   Ú	conditionry   Z
else_rulesra   r
   r   r   ˜  s    zConditional.__init__)r   r   r   r   rr   r
   r
   ra   r   r€   —  s   r€   c                   @  s   e Zd Zdd„ ZdS )ÚOrc                 C  s<   | j D ]}| |¡ |jrd| _ q8qt| j ƒd j| _d S r{   )ry   r   r   rH   r   r}   r
   r
   r   r      s    

zOr.process_statementN)r   r   r   r   r
   r
   r
   r   r‚   Ÿ  s   r‚   c                   @  s   e Zd Zdd„ Zdd„ ZdS )ÚSQLExecuteObservedc                 C  s6   || _ || _|r|| _n|r&|g| _ng | _g | _d S r	   )r?   rB   r   r   )r   r?   rB   Úmultiparamsr   r
   r
   r   r   «  s    
zSQLExecuteObserved.__init__c                 C  s
   t | jƒS r	   )rD   r   r   r
   r
   r   Ú__repr__·  s    zSQLExecuteObserved.__repr__N)r   r   r   r   r…   r
   r
   r
   r   rƒ   ª  s   rƒ   c                   @  s   e Zd ZdS )ÚSQLCursorExecuteObservedNr   r
   r
   r
   r   r†   »  s   r†   )r   r   r?   Úexecutemanyc                   @  s$   e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚSQLAsserterc                 C  s
   g | _ d S r	   )Úaccumulatedr   r
   r
   r   r   Å  s    zSQLAsserter.__init__c                 C  s   | j | _| ` d S r	   )r‰   Ú_finalr   r
   r
   r   Ú_closeÈ  s    zSQLAsserter._closec                 G  sr   t |Ž }t| jƒ}|rJ| d¡}| |¡ |jr4qJq|jrdsJ |jƒ‚q|r`dsnJ d| ƒ‚n|jsn| ¡  d S )Nr   Fz$Additional SQL statements remain:
%s)r   rH   rŠ   r    r   r   r   r   )r   ry   r~   Zobservedr   r
   r
   r   Úassert_Ì  s    


zSQLAsserter.assert_N)r   r   r   r   r‹   rŒ   r
   r
   r
   r   rˆ   Ä  s   rˆ   c                 #  s–   t ƒ ‰ g ‰t | d¡‡fdd„ƒ}t | d¡‡ ‡fdd„ƒ}z.ˆ V  W t | d|¡ t | d|¡ ˆ  ¡  n&t | d|¡ t | d|¡ ˆ  ¡  0 d S )NZbefore_executec                   s   d| _ |||fˆ d d …< d S )NT)Z_WORKAROUND_ISSUE_13018)ÚconnrB   r„   r   r@   )Úorigr
   r   Úconnection_executeã  s    z)assert_engine.<locals>.connection_executeZafter_cursor_executec                   sj   |sd S ˆ j r*ˆ j d j|u r*ˆ j d }n&t|ˆd ˆd ˆd ƒ}ˆ j  |¡ |j t||||ƒ¡ d S )Néÿÿÿÿr   rf   r   )r‰   r?   rƒ   Úappendr   r†   )r�   Úcursorr   r   r?   r‡   Zobs©ZasserterrŽ   r
   r   Úcursor_executeì  s    ÿþÿÿz%assert_engine.<locals>.cursor_execute)rˆ   r   Zlistens_forÚremover‹   )Úenginer�   r”   r
   r“   r   Úassert_engineÝ  s    


þr—   )Ú
__future__r   ÚcollectionsÚ
contextlibro   r*   r)   r   r–   r   Zengine.defaultr   Zschemar   r   r   r   r#   rV   r[   rs   rw   r   r€   r‚   rƒ   Ú
namedtupler†   rˆ   Úcontextmanagerr—   r
   r
   r
   r   Ú<module>
   s<    (N
þÿ	