a
    •˜ëjû&  ã                   @   sø   d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dl	m
Z
 d dl	mZ d	d
l mZ d	dl m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ejƒZG dd„ dejejƒZG dd„ dejƒZG dd„ dejƒZdS )é   )Úconfig)Úfixtures)Úeq_)Úis_true)Úrequirements)Únormalize_sequence)ÚColumn)ÚTableé   )Úinspect)ÚInteger)ÚMetaData)ÚSequence)ÚString)Útestingc                   @   sŠ   e Zd ZdZdZdZedd„ ƒZdd„ Zdd	„ Z	d
d„ Z
ejdd„ ƒZdd„ Zdd„ Zejdddd�ejjdd„ ƒƒZejjdd„ ƒZdS )ÚSequenceTest©Ú	sequencesTZeachc                 C   sÞ   t d|tdttttdƒƒdd�tdtdƒƒƒ t d|tdttttdtdd	�ƒdd�tdtdƒƒƒ t d
|tdttttdƒƒdd�tdtdƒƒdd� tjj	j
rÚt d|tdttttdtjd�ƒdd�tdtdƒƒdtjd� d S )NÚseq_pkÚidZ
tab_id_seqT©Zprimary_keyÚdataé2   Ú
seq_opt_pk)Z	data_typeÚoptionalÚseq_no_returningZnoret_id_seqF)Úimplicit_returningÚseq_no_returning_schÚnoret_sch_id_seq©Úschema©r   r    )r	   r   r   r   r   r   r   r   ÚrequiresÚschemasÚenabledÚtest_schema©ÚclsÚmetadata© r)   úe/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_sequence.pyÚdefine_tables   sp    ü÷þù	ôüö
ÿþ÷ðzSequenceTest.define_tablesc                 C   s.   |  | jj ¡ tdd�¡ |  | jj|¡ d S ©Nú	some data©r   )ÚexecuteÚtablesr   ÚinsertÚdictÚ_assert_round_trip©ÚselfÚ
connectionr)   r)   r*   Útest_insert_roundtrip]   s    z"SequenceTest.test_insert_roundtripc                 C   s2   |  | jj ¡ tdd�¡}t|jtjj	j
fƒ d S r,   )r/   r0   r   r1   r2   r   Úinserted_primary_keyr   ÚdbÚdialectÚdefault_sequence_base©r5   r6   Úrr)   r)   r*   Útest_insert_lastrowida   s    ÿÿz"SequenceTest.test_insert_lastrowidc                 C   s(   |  | jjjjj¡}t|tjj	j
ƒ d S ©N)Úscalarr0   r   Úcr   Údefaultr   r   r9   r:   r;   r<   r)   r)   r*   Útest_nextval_directi   s    z SequenceTest.test_nextval_directc                 C   s*   |  | jj ¡ tdd�¡}t|jdƒ d S )Nr-   r.   )é   )r/   r0   r   r1   r2   r   r8   r<   r)   r)   r*   Útest_optional_seqm   s    ÿzSequenceTest.test_optional_seqc                 C   s*   |  | ¡ ¡ ¡ }t|tjjjdfƒ d S )Nr-   )r/   ÚselectÚfirstr   r   r9   r:   r;   )r5   ÚtableÚconnÚrowr)   r)   r*   r3   t   s    zSequenceTest._assert_round_tripc                 C   s.   |  | jj ¡ tdd�¡ |  | jj|¡ d S r,   )r/   r0   r   r1   r2   r3   r4   r)   r)   r*   Ú+test_insert_roundtrip_no_implicit_returningx   s    ÿz8SequenceTest.test_insert_roundtrip_no_implicit_returning)T)Fr   )Úargnamesc                 C   sr   t dtƒ tdttttddd�ƒdd�tdtd	ƒƒ|dd
�}|jdtj	id�}| 
| ¡ tdd�¡ |  ||¡ d S )Nr   r   r   Ú
alt_schemar   Tr   r   r   r!   ©Zschema_translate_mapr-   r.   )r	   r   r   r   r   r   r   r   Úexecution_optionsr%   r/   r1   r2   r3   )r5   r6   r   r   r)   r)   r*   Útest_insert_roundtrip_translate~   s(    ÿúóÿz,SequenceTest.test_insert_roundtrip_translatec                 C   sB   t ttddd�ƒ}|jdtjid�}| |¡}t|tjj	j
ƒ d S )Nr   rM   r   rN   )r   r   r   rO   r%   r@   r   r   r9   r:   r;   )r5   r6   Úseqr=   r)   r)   r*   Ú$test_nextval_direct_schema_translate—   s    ÿÿ
z1SequenceTest.test_nextval_direct_schema_translateN)Ú__name__Ú
__module__Ú__qualname__Ú__requires__Ú__sparse_driver_backend__Zrun_create_tablesÚclassmethodr+   r7   r>   rC   r   Zsequences_optionalrE   r3   rK   r   Úcombinationsr"   r#   rP   rR   r)   r)   r)   r*   r      s"   
=
r   c                   @   s   e Zd ZdZdZdd„ ZdS )ÚSequenceCompilerTestr   Tc              
   C   sx   t dtƒ tdttttdƒƒƒtdtƒƒ}| ¡ jdd�}|j	j
d |j	d� tttdƒƒ¡}| j|d|f d	|j	d
� d S )NÚxÚyZy_seqÚqé   )r]   )Z	statementr:   z#INSERT INTO x (y, q) VALUES (%s, 5)T)Zliteral_bindsr:   )r	   r   r   r   r   r   r   r1   Úvaluesr:   Zstatement_compilerZvisit_sequenceZassert_compile)r5   r6   rH   ÚstmtZseq_nextvalr)   r)   r*   Ú!test_literal_binds_inline_compile¨   s(    ÿú	ÿþüz6SequenceCompilerTest.test_literal_binds_inline_compileN)rS   rT   rU   rV   rW   ra   r)   r)   r)   r*   rZ   ¤   s   rZ   c                   @   s¬   e Zd ZdZdZdZedd„ ƒZdd„ Zdd	„ Z	d
d„ Z
ejjdd„ ƒZdd„ Zejjdd„ ƒZejjdd„ ƒZejjdd„ ƒZdd„ Zejjdd„ ƒZejjdd„ ƒZdS )ÚHasSequenceTestNr   Tc                 C   sx   t ttd|d�ƒ t ttd|ddd�ƒ tjjjr^t ttdtj|d�ƒ t ttdtj|d�ƒ td|t	d	t
dd
�ƒ d S )NÚuser_id_seq©r(   Ú	other_seqT)r(   Z
nomaxvalueZ
nominvalue)r    r(   Ú
schema_seqÚuser_id_tabler   r   )r   r   r   r   r"   r#   r$   r%   r	   r   r   r&   r)   r)   r*   r+   Å   s8    üþ	
ÿþÿþýzHasSequenceTest.define_tablesc                 C   s   t t|ƒ d¡dƒ d S )Nrc   T©r   r   Úhas_sequencer4   r)   r)   r*   Útest_has_sequenceä   s    z!HasSequenceTest.test_has_sequencec              	   C   sŒ   t |ƒ}t| d¡dƒ tttd|d�ƒ}t| d¡dƒ | |¡ z6t| d¡dƒ | ¡  t| d¡dƒ W | |¡ n| |¡ 0 d S )Nrc   TZnew_seqrd   F)	r   r   ri   r   r   r   ÚcreateÚclear_cacheZdrop)r5   r6   r(   ZinspÚssr)   r)   r*   Útest_has_sequence_cacheç   s    
z'HasSequenceTest.test_has_sequence_cachec                 C   s   t t|ƒ d¡dƒ d S )Nrg   Frh   r4   r)   r)   r*   Útest_has_sequence_other_objectô   s    z.HasSequenceTest.test_has_sequence_other_objectc                 C   s   t t|ƒjdtjd�dƒ d S )Nrc   r   T©r   r   ri   r   r%   r4   r)   r)   r*   Útest_has_sequence_schema÷   s    ÿüz(HasSequenceTest.test_has_sequence_schemac                 C   s   t t|ƒ d¡dƒ d S )NÚsome_sequenceFrh   r4   r)   r)   r*   Útest_has_sequence_neg   s    z%HasSequenceTest.test_has_sequence_negc                 C   s   t t|ƒjdtjd�dƒ d S )Nrr   r   Frp   r4   r)   r)   r*   Útest_has_sequence_schemas_neg  s    ÿüz-HasSequenceTest.test_has_sequence_schemas_negc                 C   s   t t|ƒjdtjd�dƒ d S )NZother_sequencer   Frp   r4   r)   r)   r*   Ú'test_has_sequence_default_not_in_remote  s    ÿüz7HasSequenceTest.test_has_sequence_default_not_in_remotec                 C   s   t t|ƒ d¡dƒ d S )Nrf   Frh   r4   r)   r)   r*   Ú'test_has_sequence_remote_not_in_default  s    z7HasSequenceTest.test_has_sequence_remote_not_in_defaultc                 C   s:   ddh}t t|ƒ ¡ ƒ}t| |¡|kƒ td|vƒ d S )Nre   rc   rf   )Úsetr   Úget_sequence_namesr   Úintersection)r5   r6   ÚexpÚresr)   r)   r*   Útest_get_sequence_names  s    z'HasSequenceTest.test_get_sequence_namesc                 C   s   t t|ƒjtjd�g ƒ d S )Nr   )r   r   rx   r   Ztest_schema_2r4   r)   r)   r*   Ú*test_get_sequence_names_no_sequence_schema   s    ÿüz:HasSequenceTest.test_get_sequence_names_no_sequence_schemac                 C   s$   t tt|ƒjtjd�ƒddgƒ d S )Nr   rf   rc   )r   Úsortedr   rx   r   r%   r4   r)   r)   r*   Ú(test_get_sequence_names_sequences_schema)  s    ÿÿúz8HasSequenceTest.test_get_sequence_names_sequences_schema)rS   rT   rU   Zrun_deletesrV   rW   rX   r+   rj   rn   ro   r   r"   r#   rq   rs   rt   ru   rv   r|   r}   r   r)   r)   r)   r*   rb   ¿   s,   





rb   c                   @   s   e Zd ZdZdZdd„ ZdS )ÚHasSequenceTestEmptyr   Tc                 C   s   t t|ƒ ¡ g ƒ d S r?   )r   r   rx   r4   r)   r)   r*   Ú#test_get_sequence_names_no_sequence9  s    
þz8HasSequenceTestEmpty.test_get_sequence_names_no_sequenceN)rS   rT   rU   rV   rW   r�   r)   r)   r)   r*   r€   5  s   r€   N)Ú r   r   Z
assertionsr   r   r   Z	provisionr   r    r   r	   r   r   r   r   r   r   Z
TablesTestr   ZAssertsCompiledSQLZTestBaserZ   rb   r€   r)   r)   r)   r*   Ú<module>	   s$    v