U
|
¸ý°dm ã @ sv d dl mZ d dlmZ d dlmZ d dlmZ ddl mZ ddl mZ ddl m Z dd l m
|
Z
|
G d
|
d d ej Z d S ) é )Úfixtures)Úeq_)ÚColumn)ÚTableé )ÚInteger)Úselect)Útesting)Úunionc @ sz e Zd ZdZedd Zedd ZdddZd d
|
Zd d Z e
|
j j e
|
j j d d Ze
|
j jdd Zdd Zdd ZdS )Ú DeprecatedCompoundSelectTestTc C s* t d|tdtddtdttdt d S )NÚ
|
some_tableÚidT)Z primary_keyÚxÚy)r r r )ÚclsÚmetadata© r úad:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/testing/suite/test_deprecations.pyÚ define_tables s ûz*DeprecatedCompoundSelectTest.define_tablesc
|
C s@ | | jj ¡ ddddddddddddddddg¡ d S )Né r )r r r r é é )ÚexecuteÚtablesr Úinsert)r Ú
|
connectionr r r Ú insert_data s
|
|
|
|
|
üþz(DeprecatedCompoundSelectTest.insert_datar c C s t | ||¡ ¡ | d S )N)r r Zfetchall)ÚselfÚconnr ÚresultÚparamsr r r Ú_assert_result& s z+DeprecatedCompoundSelectTest._assert_resultc C st | j j}t| |jjdk¡}t| |jjdk¡}t||}t d¡" | ||
|
|jj¡ddg¡ W 5 Q R X d S ©Nr r úAThe SelectBase.c and SelectBase.columns attributes are deprecated©r r r ©r r r ) r r r ÚwhereÚcr r
|
r Úexpect_deprecatedr! Úorder_by©r r ÚtableÚs1Ús2Úu1r r r Útest_plain_union) s
|
ÿ ÿz-DeprecatedCompoundSelectTest.test_plain_unionc C s| | j j}t| |jjdk¡}t| |jjdk¡}t|| ¡ ¡ }t d¡" |
|
|| |jj¡ddg¡ W 5 Q R X d S r" ) r r r r& r' r r
|
Úaliasr r( r! r) r* r r r Ú"_dont_test_select_from_plain_union> s ÿ ÿz?DeprecatedCompoundSelectTest._dont_test_select_from_plain_unionc C s | j j}t| |jjdk¡ d¡ |jj¡}t| |jjdk¡ d¡ |jj¡}t|| d¡}t
|
d¡" | || |jj¡ddg¡ W 5 Q R X d S ©Nr r r r# r$ r% ) r r r r& r' r Úlimitr) r
|
r r( r! r* r r r Ú&test_limit_offset_selectable_in_unionsL s &&ÿ ÿzCDeprecatedCompoundSelectTest.test_limit_offset_selectable_in_unionsc C s | j j}t| |jjdk¡ |jj¡}t| |jjdk¡ |jj¡}t|| d¡}t
|
d¡" | || |jj¡ddg¡ W 5 Q R X d S r" ) r r r r& r' r r) r
|
r3 r r( r! r* r r r Ú"test_order_by_selectable_in_unions\ s ÿ ÿz?DeprecatedCompoundSelectTest.test_order_by_selectable_in_unionsc C s | j j}t| |jjdk¡ ¡ }t| |jjdk¡ ¡ }t|| d¡}t
|
d¡" | || |jj¡ddg¡ W 5 Q R X d S r" ) r r r r& r' r Zdistinctr
|
r3 r r( r! r) r* r r r Ú"test_distinct_selectable_in_unionsk s ÿ ÿz?DeprecatedCompoundSelectTest.test_distinct_selectable_in_unionsc C sª | j j}t| |jjdk¡ d¡ |jj¡ ¡ ¡ }t| |jjdk¡ d¡ |jj¡ ¡ ¡ }t || d¡}t
|
d¡" | || |jj¡ddg¡ W 5 Q R X d S r2 ) r r r r& r' r r3 r) r0 r
|
r r( r! r* r r r Ú.test_limit_offset_aliased_selectable_in_unionsy s4
|
ÿþý
|
ÿ
|
ÿþý
|
ÿ ÿ ÿzKDeprecatedCompoundSelectTest.test_limit_offset_aliased_selectable_in_unionsN)r )Ú__name__Ú
|
__module__Ú __qualname__Z __backend__Ú classmethodr r r! r/ r1 r ÚrequiresZorder_by_col_from_unionZ/parens_in_union_contained_select_w_limit_offsetr4 Z0parens_in_union_contained_select_wo_limit_offsetr5 r6 r7 r r r r r s
|
|
|
|
r N) Ú r Z
|
assertionsr Zschemar r r r r r
|
Z
|
TablesTestr r r r r Ú<module> s
|
