a
    •˜ëj’B  ã                   @   sö   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 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ƒZG dd„ dejejƒZdS )é    Né   )Úengines)Úfixtures)Úeq_)Úrequirements)ÚColumn)ÚTableé   )ÚDateTime)Úfunc)ÚInteger)Úselect)Úsql)ÚString)Útesting©Útextc                   @   s^   e Zd ZdZedd„ ƒZedd„ ƒZdd„ Zdd	„ Zd
d„ Z	dd„ Z
ejdd„ ƒZdd„ ZdS )ÚRowFetchTestTc                 C   sD   t d|tdtdd�tdtdƒƒƒ t d|tdtdd�tdtƒƒ d S )	NÚplain_pkÚidT)Úprimary_keyÚdataé2   Ú	has_datesÚtoday)r   r   r   r   r
   ©ÚclsÚmetadata© r   úd/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_results.pyÚdefine_tables   s    üüzRowFetchTest.define_tablesc                 C   s\   |  | jj ¡ dddœdddœdddœg¡ |  | jj ¡ dt dd	d
d
dd¡dœg¡ d S )Né   Úd1)r   r   r   Zd2r	   Zd3éÖ  é   é   r   )r   r   )ÚexecuteÚtablesr   Úinsertr   Údatetime)r   Ú
connectionr   r   r   Úinsert_data.   s    
ýþ	
þzRowFetchTest.insert_datac                 C   s@   |  | jj ¡  | jjjj¡¡ ¡ }t|jdƒ t|j	dƒ d S ©Nr!   r"   )
r&   r'   r   r   Úorder_byÚcr   Úfirstr   r   ©Úselfr*   Úrowr   r   r   Útest_via_attr>   s
    ÿzRowFetchTest.test_via_attrc                 C   sH   |  | jj ¡  | jjjj¡¡ ¡ }t|j	d dƒ t|j	d dƒ d S )Nr   r!   r   r"   )
r&   r'   r   r   r-   r.   r   r/   r   Ú_mappingr0   r   r   r   Útest_via_stringF   s
    ÿzRowFetchTest.test_via_stringc                 C   sD   |  | jj ¡  | jjjj¡¡ ¡ }t|d dƒ t|d dƒ d S )Nr   r!   r"   )	r&   r'   r   r   r-   r.   r   r/   r   r0   r   r   r   Útest_via_intN   s
    ÿzRowFetchTest.test_via_intc                 C   sX   |  | jj ¡  | jjjj¡¡ ¡ }t|j	| jjjj dƒ t|j	| jjjj
 dƒ d S r,   )r&   r'   r   r   r-   r.   r   r/   r   r4   r   r0   r   r   r   Útest_via_col_objectV   s
    ÿz RowFetchTest.test_via_col_objectc                 C   s\   |  t| jjjj| jjjj d¡ƒ | jjjj¡¡}| 	¡ }t
| ¡ ddgƒ t
|dƒ d S )Nr   )r"   r"   )r&   r   r'   r   r.   r   Úlabelr-   r   r/   r   Úkeys)r1   r*   Úresultr2   r   r   r   Útest_row_with_dupe_names^   s    
þ
ýÿz%RowFetchTest.test_row_with_dupe_namesc              
   C   s`   | j j}t| d¡jjƒ ¡ }t|jj| d¡ƒ}| 	|¡ 
¡ }t|jt dddddd¡ƒ dS )zýtest that a scalar select as a column is returned as such
        and that type conversion works OK.

        (this is half a SQLAlchemy Core test and half to catch database
        backends that may have unusual behavior with scalar selects.)

        ÚxÚ	somelabelr#   r$   r%   r   N)r'   r   r   Úaliasr.   r   Zscalar_subqueryr   r8   r&   r/   r   r=   r)   )r1   r*   Z	datetableÚsÚs2r2   r   r   r   Útest_row_w_scalar_selectj   s
    z%RowFetchTest.test_row_w_scalar_selectN)Ú__name__Ú
__module__Ú__qualname__Ú__backend__Úclassmethodr    r+   r3   r5   r6   r7   r   Z%duplicate_names_in_cursor_descriptionr;   rA   r   r   r   r   r      s   


r   c                   @   sJ   e Zd ZdZdZdZedd„ ƒZdd„ Zdd	„ Z	e
jd
d„ ƒZdd„ ZdS )ÚPercentSchemaNamesTestz¡tests using percent signs, spaces in table and column names.

    This didn't work for PostgreSQL / MySQL drivers for a long time
    but is now supported.

    )Zpercent_schema_namesTc                 C   s@   t d|tdtƒtdtƒƒ| j_t dt d¡t d¡¡| j_d S )Nzpercent%tableúpercent%úspaces % more spaces)	r   r   r   r'   Úpercent_tabler   ÚtableÚcolumnÚlightweight_percent_tabler   r   r   r   r    †   s    üýz$PercentSchemaNamesTest.define_tablesc                 C   sP   | j j}dddœdddœdddœdddœfD ]}| | ¡ |¡ q,|  |¡ d S ©Nr$   r%   ©rH   rI   é   é   é	   é
   ©r'   rJ   r&   r(   Ú_assert_table)r1   r*   rJ   Úparamsr   r   r   Útest_single_roundtrip”   s    üz,PercentSchemaNamesTest.test_single_roundtripc                 C   sT   | j j}| | ¡ dddœ¡ | | ¡ dddœdddœdddœg¡ |  |¡ d S rN   rT   )r1   r*   rJ   r   r   r   Útest_executemany_roundtripŸ   s    ÿýþz1PercentSchemaNamesTest.test_executemany_roundtripc                 C   sz   | j j}| | ¡ dddœ¡ | | ¡  |jd |jd ¡dddœdd	dœdddœg¡}t| ¡ g d
¢ƒ |  |¡ d S )Nr$   r%   rO   rH   rI   rP   rQ   rR   rS   )©rP   rQ   ©rR   rS   ©rQ   rR   )	r'   rJ   r&   r(   Z	returningr.   r   ÚallrU   )r1   r*   rJ   r:   r   r   r   Ú$test_executemany_returning_roundtrip®   s     ÿþýûz;PercentSchemaNamesTest.test_executemany_returning_roundtripc                 C   sD  | j j}| j j}|| ¡ || ¡ fD ]Ô}tt| | ¡  |j	d ¡¡ƒg d¢ƒ tt| | ¡  
|j	d  ddg¡¡ |j	d ¡¡ƒddgƒ | | ¡  |j	d ¡¡ ¡ }t|jd dƒ t|jd d	ƒ t|j|j	d  dƒ t|j|j	d  d	ƒ q$| | ¡  |j	d d
i¡¡ tt| | ¡  |j	d ¡¡ƒg d¢ƒ d S )NrH   ))r$   r%   rY   rZ   r[   rI   rR   rS   rZ   r[   r$   r%   é   ))r$   r^   )rP   r^   )rR   r^   )rQ   r^   )r'   rJ   rM   r>   r   Úlistr&   r   r-   r.   ÚwhereZin_r/   r4   ÚupdateÚvalues)r1   ÚconnrJ   rM   rK   r2   r   r   r   rU   Â   s^    üÿüÿþÿÿøÿÿÿÿÿÿøz$PercentSchemaNamesTest._assert_tableN)rB   rC   rD   Ú__doc__Ú__requires__rE   rF   r    rW   rX   r   Zinsert_executemany_returningr]   rU   r   r   r   r   rG   z   s   

rG   c                   @   s  e Zd ZdZdZdd„ Zdd„ Zdd„ Zej	d	dd
d„ dfdddd„ dfdde
dƒdfdddd„ dfdde
dƒjdd�dfdde
dƒjdd�dfdde
dƒ ¡ dfdddd„ de ddg¡fdddd„ dfdddd„ dfdd d!�d"d#„ ƒZd$d%„ Zd&d'„ Zd(d)„ Zd*d+„ Zd,d-„ Zd.S )/ÚServerSideCursorsTest)Úserver_side_cursorsTc                 C   s  | j jjdkrt|jƒS | j jjdkr<tdƒjj}t||ƒS | j jjdv rP|j	S | j jjdkrttdƒjj}t||ƒS | j jjdkrŠ|j
 S | j jjdkrªd	t|ƒj ¡ vS | j jjd
v r¾|j	S | j jjdkrØt|ddƒS | j jjdk� røtt|ddƒƒS | j jjdk�rt|ddƒS dS d S )NZpsycopg2Zpymysqlzpymysql.cursors)ZaiomysqlZasyncmyZaioodbcZmysqldbzMySQLdb.cursorsZmariadbconnectorZmysqlconnectorÚbuffered)ZasyncpgZ	aiosqliteZpg8000Úserver_sideFZpsycopgÚnameZoracledb)ÚengineÚdialectZdriverÚboolrj   Ú
__import__ZcursorsZSSCursorÚ
isinstanceri   rh   ÚtyperB   ÚlowerÚgetattr)r1   ÚcursorZsscursorr   r   r   Ú_is_server_side   s.    


z%ServerSideCursorsTest._is_server_sidec                 C   sZ   |rBt  d¡�" tjd|id�| _W d   ƒ qT1 s60    Y  ntjd|id�| _| jS )Nz­The create_engine.server_side_cursors parameter is deprecated and will be removed in a future release.  Please use the Connection.execution_options.stream_results parameter.rg   )Úoptions)r   Zexpect_deprecatedr   Ztesting_enginerk   )r1   rg   r   r   r   Ú_fixture  s    ÿÿ(ÿzServerSideCursorsTest._fixturec                 C   s   t  dt j¡ dd„ |¡S )NzSELECT (\d+)c                 S   s   t tt|  d¡ƒƒ tj¡ƒS )Nr!   )Ústrr   ÚintÚgroupÚcompiler   Údb)Úmr   r   r   Ú<lambda>/  ó    z1ServerSideCursorsTest.stringify.<locals>.<lambda>)Úrerz   ÚIÚsub)r1   Zstr_r   r   r   Ú	stringify-  s    ÿzServerSideCursorsTest.stringifyZglobal_stringc                 C   s   | dƒS ©Núselect 1r   ©r‚   r   r   r   r}   3  r~   zServerSideCursorsTest.<lambda>Zglobal_textc                 C   s   t | dƒƒS rƒ   r   r…   r   r   r   r}   7  r~   Zglobal_exprr!   Zglobal_off_explicitFc                 C   s   t | dƒƒS rƒ   r   r…   r   r   r   r}   >  r~   Zstmt_option©Zstream_resultsZstmt_option_disabledZfor_update_exprZfor_update_stringc                 C   s   | dƒS )NzSELECT 1 FOR UPDATEr   r…   r   r   r   r}   R  r~   ZsqliteZmssqlZ
text_no_ssc                 C   s   t | dƒƒS )Nú	select 42r   r…   r   r   r   r}   Y  r~   Ztext_ss_optionc                 C   s   t | dƒƒjdd�S )Nr‡   Tr†   )r   Úexecution_optionsr…   r   r   r   r}   _  s   ÿZiaaaz*engine_ss_arg, statement, cursor_ss_status)Zid_Úargnamesc                 C   sˆ   |   |¡}| ¡ �b}t|ƒr,tj|| jd�}t|tƒrB| |¡}n
| 	|¡}t
|  |j¡|ƒ | ¡  W d   ƒ n1 sz0    Y  d S )Nr…   )rv   ÚbeginÚcallabler   Zresolve_lambdar‚   ro   rw   Úexec_driver_sqlr&   r   rt   rs   Úclose)r1   Zengine_ss_argZ	statementZcursor_ss_statusrk   rc   r:   r   r   r   Útest_ss_cursor_status2  s    8

ÿ

z+ServerSideCursorsTest.test_ss_cursor_statusc                 C   sf   |   d¡}| ¡ �@}|jdd� |  d¡¡}|  |j¡s<J ‚| ¡  W d   ƒ n1 sX0    Y  d S )NFTr†   r„   )rv   Úconnectrˆ   rŒ   r‚   rt   rs   r�   )r1   rk   rc   r:   r   r   r   Útest_conn_optionx  s    

ÿþz&ServerSideCursorsTest.test_conn_optionc                 C   sh   |   d¡}tdƒjdd�}| ¡ �2}|jdd� |¡}|  |j¡rFJ ‚W d   ƒ n1 sZ0    Y  d S )NFr!   Tr†   )rv   r   rˆ   r�   r&   rt   rs   )r1   rk   r?   rc   r:   r   r   r   Ú&test_stmt_enabled_conn_option_disabled�  s
    

z<ServerSideCursorsTest.test_stmt_enabled_conn_option_disabledc                 C   sÔ   |   d¡}tt d¡ d¡ƒjdd� ¡ }| ¡ �6}| | ¡ ¡}|  	|j
¡rRJ ‚| ¡  W d   ƒ n1 sn0    Y  tdƒ |¡}| ¡ �2}| |¡}|  	|j
¡rªJ ‚| ¡  W d   ƒ n1 sÆ0    Y  d S )NFÚ1r<   Tr†   r!   )rv   r   r   Zliteral_columnr8   rˆ   ZsubqueryrŠ   r&   rt   rs   r�   Úselect_from)r1   rk   Ús1rc   r:   r@   r   r   r   Útest_aliases_and_ssš  s    
ÿÿ
&

z)ServerSideCursorsTest.test_aliases_and_ssc              	   C   sB  | j }|  d¡}td|tdtddd�tdtdƒƒƒ}| ¡ �ð}|j|dd� | | 	¡ t
dd	�¡ | | 	¡ t
d
d	�¡ t| | ¡  |jj¡¡ ¡ ddgƒ | | ¡  |jjdk¡j|jjd d	�¡ t| | ¡  |jj¡¡ ¡ ddgƒ | | ¡ ¡ t| tt d¡ƒ |¡¡dƒ W d   ƒ n1 �s40    Y  d S )NTÚ
test_tabler   ©r   Ztest_needs_autoincrementr   r   ©Z
checkfirstÚdata1©r   Údata2)r!   r™   )r   r›   r   z updated)r   zdata2 updatedÚ*r   )r   rv   r   r   r   r   rŠ   Úcreater&   r(   Údictr   r   r-   r.   r   Úfetchallra   r`   rb   r   ÚdeleteZscalarr   Úcountr“   )r1   r   Úmdrk   r–   r*   r   r   r   Útest_roundtrip_fetchall®  sP    
ÿú	
ÿü
ÿ
þÿÿüÿüz-ServerSideCursorsTest.test_roundtrip_fetchallc              	   C   s  | j }|  d¡}td|tdtddd�tdtdƒƒƒ}| ¡ �´}|j|dd� | | 	¡ dd	„ t
d
dƒD ƒ¡ | | ¡  |jj¡¡}t| d¡dd	„ t
d
dƒD ƒƒ t| d¡dd	„ t
ddƒD ƒƒ t| ¡ dd	„ t
ddƒD ƒƒ W d   ƒ n1 sö0    Y  d S )NTr–   r   r—   r   r   r˜   c                 S   s   g | ]}t d | d�‘qS )údata%drš   )rž   ©Ú.0Úir   r   r   Ú
<listcomp>é  r~   zBServerSideCursorsTest.test_roundtrip_fetchmany.<locals>.<listcomp>r!   é   r$   c                 S   s   g | ]}|d | f‘qS ©r¤   r   r¥   r   r   r   r¨   ò  r~   é   rS   c                 S   s   g | ]}|d | f‘qS rª   r   r¥   r   r   r   r¨   ö  r~   é   c                 S   s   g | ]}|d | f‘qS rª   r   r¥   r   r   r   r¨   ø  r~   )r   rv   r   r   r   r   rŠ   r�   r&   r(   Úranger   r-   r.   r   r   Z	fetchmanyrŸ   )r1   r   r¢   rk   r–   r*   r:   r   r   r   Útest_roundtrip_fetchmanyØ  s8    
ÿú	
þÿþþz.ServerSideCursorsTest.test_roundtrip_fetchmanyN)rB   rC   rD   re   rE   rt   rv   r‚   r   Úcombinationsr   rˆ   Zwith_for_updateZskip_ifrŽ   r�   r‘   r•   r£   r®   r   r   r   r   rf   ù   sl   üüüüûüúÍ5

*rf   )r)   r   Ú r   r   Z
assertionsr   Úconfigr   Zschemar   r   r
   r   r   r   r   r   r   r   Z
TablesTestr   rG   ZTestBaseZAssertsExecutionResultsrf   r   r   r   r   Ú<module>	   s(   ^
ÿ