w collations r) test_collate_order_byz!CollateTest.test_collate_order_by4 s $;;GNKK DK*+ , , 5 5 &(-55i@@DDFF
"#7 8
r+ N) __name__
__module__ __qualname__ __backend__ classmethodr* r7 r@ r rC order_by_collationrJ r+ r) r r s~ K
[
[
: : :
(
)(
r+ r c e Zd ZdZdZed Zed Zd Zd Z d Z
d Z d Z d
Z
ej j d Zd S )
OrderByLabelTestzTest the dialect sends appropriate ORDER BY expressions when
labels are used.
This essentially exercises the "supports_simple_order_by_label"
setting.
Tc t d|t dt d t dt t dt t dt d t d t d d S )
Nr r Tr! xyq2 pr% r& s r) r* z OrderByLabelTest.define_tablesK sv
4d 3 3 3 3 3 3r
# # 3r
# #
r+ c | | j j ddddddddddddddd d
d dg d S ) Nr- r q1p3)r rU rV rW rY r q2p2 q3p1r1 r5 s r) r7 z OrderByLabelTest.insert_dataW sp J ! ( ( * *qqt$??qqt$??qqt$??
r+ c t t j | | d S r9 r: r= s r) r@ z OrderByLabelTest._assert_resultb rA r+ c | j j }|j j d }| t
|g | g d d S )Nlx)r- r r )r3 r rF rU labelr@ r rE r> tablerd s r)
test_plainzOrderByLabelTest.test_plaine sZ &
WY__T
"
" FB4LL 1 1" 5 57I7I7IJJJJJr+ c | j j }|j j |j j z d }| t |g | g d d S )Nrd )rg ) r3 r rF rU rV rh r@ r rE ri s r) test_composed_intz"OrderByLabelTest.test_composed_intj se &gi%')#
*
*4
0
0 FB4LL 1 1" 5 57I7I7IJJJJJr+ c | j j }|j j |j j z d }t
j |j j |j j z d }|
t ||g ||
dt j d fdt j d fdt j d fg d S ) Nrd lyr q1p3rn q2p2rp q3p1)r3 r rF rU rV rh r lowerrW rY r@ r rE descr u)r> rj rd rs s r) test_composed_multiplez'OrderByLabelTest.test_composed_multipleo s &gi%')#
*
*4
0
0j##egi/
6
6t
<
< B8 % %b"'')) 4 4
1dfVnn"546&>>7J K
r+ c | j j }|j j d }| t
|g | g d d S )Nrd )rg rf re ) r3 r rF rU rh r@ r rE rx ri s r) test_plain_descz OrderByLabelTest.test_plain_descx sm &
WY__T
"
" B4LL ! !"'')) , ,.@.@.@
r+ c | j j }|j j |j j z d }| t |g | g d d S )Nrd )ro rm rg )
r3 r rF rU rV rh r@ r rE rx ri s r) test_composed_int_descz'OrderByLabelTest.test_composed_int_desc sx &gi%')#
*
*4
0
0 B4LL ! !"'')) , ,.@.@.@
r+ c L | j j }|j j |j j z d }t
t j |j j |g
| | }| |g d d S )Nrd ))r- r )r- rn )r- rp )
r3 r rF rU rV rh r r countr group_byrE r@ )r> rj exprstmts r) test_group_by_composedz'OrderByLabelTest.test_group_by_composed s & EGI%,,T22 DJuwz**D1 2 2
Xd^^
Xd^^
D":":":;;;;;r+ N)rK rL rM __doc__rN rO r* r7 r@ rk rq rz r| r~ r rC group_by_complex_expressionr rQ r+ r) rS rS @ s K
[
[
: : :K K K
K K K
1< < 21< < r r? paramss r) r@ z LimitOffsetTest._assert_result 6 FI ff - - 6 6 8 8&AAAAAr+ c | j j }| t |g |j j d ddg d S )Nr r- r- r r r r )r3 r r@ r rE rF r limitr> rj s r) test_simple_limitz!LimitOffsetTest.test_simple_limit sa & E7OO $ $UWZ 0 0 6 6q 9 9
"
r+ c | j j }| t |g |j j d ddg d S )Nr r r r_ r_ r_ rn )r3 r r@ r rE rF r offsetr s r) test_simple_offsetz"LimitOffsetTest.test_simple_offset sa & E7OO $ $UWZ 0 0 7 7 : :
"
r+ c | j j }| t |g |j j d d ddg d S )Nr r- r r ) r3 r r@ r rE rF r r r r s r) test_simple_limit_offsetz(LimitOffsetTest.test_simple_limit_offset so & E7OO $ $UWZ 0 0 6 6q 9 9 @ @ C C
"
r+ c b | j j }t |g |j j d d }| t j
j ddi }t | }|
|ddg dS ) z7test that 'literal binds' mode works - no bound params.r r-
literal_bindsT)dialectcompile_kwargsr r N)r3 r r rE rF r r r compiler r; r strr@ )r> rj r sqls r) test_limit_offset_nobindsz)LimitOffsetTest.test_limit_offset_nobinds s &ug''
3399!<<CCAFFllI%6M
#hh C)Y!788888r+ c | j j }| t |g |j j t d ddgddi d S )Nlr r r r ) r3 r r@ r rE rF r r r
r s r) test_bound_limitz LimitOffsetTest.test_bound_limit ss & E7OO $ $UWZ 0 0 6 6y~~ F F
"8
r+ c | j j }| t |g |j j t d ddgddi d S )Nor r r r ) r3 r r@ r rE rF r r r
r s r) test_bound_offsetz!LimitOffsetTest.test_bound_offset ss & E7OO $ $UWZ 0 0 7 7 # G G
"8
r+ c . | j j }| t |g |j j t d t d ddgddd d S ) Nr r r r r r- )r r r )
r3 r r@ r rE rF r r r
r r s r) test_bound_limit_offsetz'LimitOffsetTest.test_bound_limit_offset s & E7OO
Xegj
!
!
U9S>>
"
"
VIcNN
#
#
"##
r+ NrQ )rK rL rM rN rO r* r7 r@ r r rC r r r r bound_limit_offsetr r r rQ r+ r) r r s@ K
[
[
B B B B
9
9
9
(
)(
(
)(
(
)(
r+ r c e Zd ZdZed Zed ZddZd Zd Z e
j j e
j j
d Ze
j j d Zd
Ze
j j
d Zd Zd
S )CompoundSelectTestTc
t d|t dt d t dt t dt d S r r r& s r) r* z CompoundSelectTest.define_tables r r+ c
| | j j ddddddddddddddddg d S r r1 r5 s r) r7 z CompoundSelectTest.insert_data r r+ rQ c t t j || | d S r9 r: r s r) r@ z!CompoundSelectTest._assert_result
r r+ c l | j j }t |g |j j dk }t |g |j j dk }t
|| }| | |j j ddg d S Nr r r r ) r3 r r whererF r r r@ rE r> rj s1s2u1s r) test_plain_unionz#CompoundSelectTest.test_plain_union
s &
UG__
"
"57:?
3
3
UG__
"
"57:?
3
3
2r]] BKK 0 09i2HIIIIIr+ c | j j }t |g |j j dk }t |g |j j dk }t
|| }| | |j j ddg d S r )
r3 r r r rF r r aliasr@ rE r s r) test_select_from_plain_unionz/CompoundSelectTest.test_select_from_plain_union s &
UG__
"
"57:?
3
3
UG__
"
"57:?
3
3
2r]]
"
"
)
)
+
+ BKK 0 09i2HIIIIIr+ c R | j j }t |g |j j dk d |j j }t |g |j j dk d |j j }t || d }| | |j j ddg d S Nr r- r r r )
r3 r r r rF r r rE r r@ r s r) &test_limit_offset_selectable_in_unionsz9CompoundSelectTest.test_limit_offset_selectable_in_unions s & E7OO
U57:?
#
#
U1XX
Xegj
!
!
E7OO
U57:?
#
#
U1XX
Xegj
!
! 2r]]
#
# BKK 0 09i2HIIIIIr+ c | j j }t |g |j j dk |j j }t |g |j j dk |j j }t || d }| | |j j ddg d S r )
r3 r r r rF r rE r r r@ r s r) "test_order_by_selectable_in_unionsz5CompoundSelectTest.test_order_by_selectable_in_unions1 s &
UG__
"
"57:?
3
3
<
>
UG__
"
"57:?
3
3
<
<
>
>
2r]]
#
# BKK 0 09i2HIIIIIr+ c | j j }t |g |j j dk d |j j }t |g |j j dk d |j j }t || }|
| d |j j ddg d S r ) r3 r r r rF r r rE r r r@ r s r) &test_limit_offset_in_unions_from_aliasz9CompoundSelectTest.test_limit_offset_in_unions_from_aliasB s & E7OO
U57:?
#
#
U1XX
Xegj
!
!
E7OO
U57:?
#
#
U1XX
Xegj
!
! 2r]]
"
" IIKK a ) )"$' 2 2Y 4J
r+ c | j j }t |g |j j dk d |j j }t |g |j j dk d |j j }t || d }|
| |j j ddg d S r ) r3 r r r rF r r rE r r r@ r s r) .test_limit_offset_aliased_selectable_in_unionszACompoundSelectTest.test_limit_offset_aliased_selectable_in_unionsX s & E7OO
U57:?
#
#
U1XX
Xegj
!
!
UWW
VXX
E7OO
U57:?
#
#
U1XX
Xegj
!
!
UWW
VXX
2r]]
#
# BKK 0 09i2HIIIIIr+ Nr )rK rL rM rN rO r* r7 r@ r r r rC order_by_col_from_union/parens_in_union_contained_select_w_limit_offsetr 0parens_in_union_contained_select_wo_limit_offsetr r r r rQ r+ r) r r s/ K
[
[
B B B BJ J JJ J J
- EJ J FE .-J$
FJ J GFJJ J J
E
FE
*J J J J Jr+ r c e Zd ZdZed Zed ZddZd Ze j
j d Z e j
j d Z
d Ze j
j d
Ze j
j d Zd Zd
Zd Zd Zd ZdS )ExpandingBoundInTestTc
t d|t dt d t dt t dt t dt d d S ) Nr r Tr! rU rV zrX r% r& s r) r* z"ExpandingBoundInTest.define_tablesr sc
4d 3 3 3 3 3 3r
# #
r+ c | | j j dddddddddddddddddd d
dg d S ) Nr- r z1)r rU rV r r z2r_ z3rn z4r1 r5 s r) r7 z ExpandingBoundInTest.insert_data} sy J ! ( ( * *qqt44qqt44qqt44qqt44
r+ rQ c t t j || | d S r9 r: r s r) r@ z#ExpandingBoundInTest._assert_result r r+ c | j j }t |j j g |j j t dd |j j t dd
|j j }| |g g g d d S )NrW T expandingrY )rW rY r ) r3 r r rF r r rU r r
rV rE r@ r> rj r s r) test_multiple_empty_setsz-ExpandingBoundInTest.test_multiple_empty_sets s &
EGJ<
U579==3$!?!?!?@@
A
A
U579==3$!?!?!?@@
A
A
Xegj
!
!
D"2B-?-?@@@@@r+ c n | j j }t |j j g t
|j j |j j t dd |j j }| |g dg i d S NrW Tr r
r3 r r rF r r r rU r r r
rE r@ r s r) test_empty_heterogeneous_tuplesz4ExpandingBoundInTest.test_empty_heterogeneous_tuples &
EGJ<
Uuwy%'),,00 cT222
Xegj
!
!
D"c2Y77777r+ c n | j j }t |j j g t
|j j |j j t dd |j j }| |g dg i d S r
r3 r r rF r r r rU rV r r
rE r@ r s r) test_empty_homogeneous_tuplesz2ExpandingBoundInTest.test_empty_homogeneous_tuples r r+ c F | j j }t |j j g |j j t dd |j j }|
|g ddg di d S )NrW Tr rf rg r_ )r r r_ r r3 r r rF r r rU r r
rE r@ r s r) test_bound_in_scalarz)ExpandingBoundInTest.test_bound_in_scalar s &
EGJ<
U579==3$!?!?!?@@
A
A
Xegj
!
!
D"4"4"4c999=MNNNNNr+ c v | j j }t |j j g t
|j j |j j t dd |j j }| |g ddg di d S )NrW Tr r ))r r )r r_ )r_ rn r r r s r) test_bound_in_two_tuplez,ExpandingBoundInTest.test_bound_in_two_tuple s &
EGJ<
Uuwy%'),,00 cT222
Xegj
!
!
$$$c3K3K3K-L
r+ c v | j j }t |j j g t
|j j |j j t dd |j j }| |g ddg di d S )NrW Tr r ))r r )r r )r_ r r r r s r) %test_bound_in_heterogeneous_two_tuplez:ExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple s &
EGJ<
Uuwy%'),,00 cT222
Xegj
!
!
:::;
r+ c > | j j }t |j j g |j j t dd |j j }|
|g dg i d S r r r s r) test_empty_set_against_integerz3ExpandingBoundInTest.test_empty_set_against_integer &
EGJ<
U579==3$!?!?!?@@
A
A
Xegj
!
!
D"c2Y77777r+ c B | j j }t |j j g |j j t dd |j j }|
|g ddg i d S NrW Tr )re rf rg r r ) r3 r r rF r r rU notin_r
rE r@ r s r) 'test_empty_set_against_integer_negationz | j j }t |j j g |j j t dd |j j }|
|g dg i d S r ) r3 r r rF r r r r r
rE r@ r s r) test_empty_set_against_stringz2ExpandingBoundInTest.test_empty_set_against_string r r+ c B | j j }t |j j g |j j t dd |j j }|
|g ddg i d S r ) r3 r r rF r r r r r
rE r@ r s r) &test_empty_set_against_string_negationz;ExpandingBoundInTest.test_empty_set_against_string_negation r r+ c b t t t t ddd t fgt
g }t t j |
d d d S )NfoorQ T)valuer )else_ )Fr ) r r r r r
r r r r; r2 fetchone)r> r s r) test_null_in_empty_set_is_falsez4ExpandingBoundInTest.test_null_in_empty_set_is_false s !FFJJ )%rT J J J !FF ''
FI d # # , , . .q 1:>>>>>r+ Nr )rK rL rM rN rO r* r7 r@ r r rC tuple_in_w_emptyr r r tuple_inr r r r r r r rQ r+ r) r r o sb K
[
[
B B B B A A A
&
8
8 '&
8
&
8
8 '&
8 O O O
"
& 8 8 8 N N N 8 8 8 N N N? ? ? ? ?r+ r c e Zd ZdZdZdZed Zed Zd Z d Z
d Z d Z d
Z
d Zd Zd
Zd Zd Zd Zd Zd Zd Zd ZdS )LikeFunctionsTestTonceNc t d|t dt d t dt d d S )Nr r Tr! r# rX r% r& s r) r* z LikeFunctionsTest.define_tables0 sI
4d 3 3 3 66":: & &
r+ c | | j j ddddddddddd dd
d dd d
dddddddddddddg
d S )Nr- abcdefgr/ r zab/cdefgr zab%cdefgr_ ab_cdefgrn zabcde/fg zabcde%fgrp zab#cdefg ab9cdefg zabcde#fg
abcd9fgr1 r5 s r) r7 z LikeFunctionsTest.insert_data9 s J ! ( ( * *),,*--*--*--*--*--*--*--*--9--
r+ c > | j j }t j 5 }d | t
|j j g | D }d d d n # 1 swxY w Y t || d S )Nc h | ]\ }|S rQ rQ ).0r s r) z*LikeFunctionsTest._test..O s* E r+ ) r3 r r r; connectr2 r rF r r r )r> r expectedr connrowss r) _testzLikeFunctionsTest._testK s [+
Y
D "llJLO,--33D99 D D(s A BB Bc | j j j j }| | d h d d S )Nab%c
r- r r r_ rn r rp r r r r3 r rF r# r
startswithr> cols r) test_startswith_unescapedz+LikeFunctionsTest.test_startswith_unescapedX s? k$&+
3>>&))+J+J+JKKKKKr+ c | j j j j }| | dd dh d S )Nr T
autoescaper r! r# s r) test_startswith_autoescapez,LikeFunctionsTest.test_startswith_autoescape\ s> k$&+
3>>&T>::QC@@@@@r+ c | j j j j }| | t
d h d d S )Nz'ab%c'r )r3 r rF r# r r" r r# s r) test_startswith_sqlexprz)LikeFunctionsTest.test_startswith_sqlexpr` sR k$&+
NN>(33 4 4 + + +
r+ c | j j j j }| | dd dh d S )Nzab##c#escaperp r! r# s r) test_startswith_escapez(LikeFunctionsTest.test_startswith_escapeg s> k$&+
3>>'#>66<<<<>&T#>FFLLL
3>>&T#>FFLLLLLr+ c | j j j j }| | d h d d S )Ne%fg r- r r r_ rn r rp r r r3 r rF r# r endswithr# s r) test_endswith_unescapedz)LikeFunctionsTest.test_endswith_unescapedp s? k$&+
3<<'')D)D)DEEEEEr+ c | j j j j }| | t
d h d d S )Nz'e%fg'r6 )r3 r rF r# r r8 r r# s r) test_endswith_sqlexprz'LikeFunctionsTest.test_endswith_sqlexprt sR k$&+
LL 11 2 24O4O4O
r+ c | j j j j }| | dd dh d S )Nr5 Tr' r r7 r# s r) test_endswith_autoescapez*LikeFunctionsTest.test_endswith_autoescapez s> k$&+
3<<4<881#>>>>>r+ c | j j j j }| | dd dh d S )Nze##fgr- r. r r7 r# s r) test_endswith_escapez&LikeFunctionsTest.test_endswith_escape~ s> k$&+
3<<<44qc:::::r+ c | j j j j }| | ddd dh | | ddd dh d S )Nr5 Tr- r2 r ze#fgr r7 r# s r) test_endswith_autoescape_escapez1LikeFunctionsTest.test_endswith_autoescape_escape h k$&+
3<<4<DDqcJJJ
3<<4<DDqcJJJJJr+ c | j j j j }| | d h d d S )Nb%cder6 r3 r rF r# r containsr# s r) test_contains_unescapedz)LikeFunctionsTest.test_contains_unescaped s? k$&+
3<<((*E*E*EFFFFFr+ c | j j j j }| | dd dh d S )NrD Tr' r rE r# s r) test_contains_autoescapez*LikeFunctionsTest.test_contains_autoescape s> k$&+
3<<D<99A3?????r+ c | j j j j }| | dd dh d S )Nzb##cder- r. rp rE r# s r) test_contains_escapez&LikeFunctionsTest.test_contains_escape s> k$&+
3<<<55s;;;;;r+ c | j j j j }| | ddd dh | | ddd dh d S )Nzb%cdTr- r2 r zb#cdrp rE r# s r) test_contains_autoescape_escapez1LikeFunctionsTest.test_contains_autoescape_escape rB r+ )rK rL rM rN run_inserts run_deletesrO r* r7 r r% r) r+ r0 r3 r9 r; r= r? rA rG rI rK rM rQ r+ r) r r * sR KKK
[
[
" L L LA A A
= = =M M M
F F F
? ? ?; ; ;K K K
G G G@ @ @< < <K K K K Kr+ r c N e Zd ZdZdZed Zed Zd Zd Z dS )ComputedColumnTestT)computed_columnsc t d|t dt d t dt t dt t d t dt t d d S )
Nsquarer Tr! sideareaz side * side perimeterz4 * side)r r r r r& s r) r* z ComputedColumnTest.define_tables sq
4d 3 3 3 67 # # 67H]$;$; < < ;*)=)= > >
r+ c z | | j j ddddddg d S )Nr- r )r rU * )r2 r3 rT r4 r5 s r) r7 z ComputedColumnTest.insert_data sP J $ $ & &r
"
"2r$:$: ;
r+ c t j 5 }| t t d g | j j | j j j
j }t |ddg d d d d S # 1 swxY w Y d S )N*)r- r r$ ( )r rY )r r; r r2 r r select_fromr3 rT rE rF r r< r r> r ress r) test_select_allz"ComputedColumnTest.test_select_all s
Y
>D,,S {## T[ /00$+,.122 hjj
&(;< = = =
> > > > > > > > > > > > > > > > > >s BCC C c t j 5 }| t | j j j j | j j j j g
| j j | j j j j
}t |ddg d d d d S # 1 swxY w Y d S )N)r$ r\ )r] r^ )r r; r r2 r r3 rT rF rV rW r_ rE r r< r r` s r) test_select_columnsz&ComputedColumnTest.test_select_columns s
Y
/D,,['). 0B0D0NO T[ /00$+,.122 hjj
i- . . . / / / / / / / / / / / / / / / / / /s B5C!!C%(C%N)
rK rL rM rN __requires__rO r* r7 rb rd rQ r+ r) rQ rQ sp K(L
[
[
> > > / / / / /r+ rQ c J e Zd ZdZed Zed Zd Zd ZdS )
ExistsTestTc t d|t dt d t dt d d S )Nstuffr Tr! r# rX r% r& s r) r* zExistsTest.define_tables sI
4d 3 3 3 66":: & &
r+ c | | j j ddddddddddddg d S )Nr- some datar/ r r r_ zsome other data)r2 r3 ri r4 r5 s r) r7 zExistsTest.insert_data sj J # # % %+..+..+.."344
r+ c
@ | j j }t | t t d g t |j j dk
dg d S )Nr- rk re r3 ri r r2 r r r r
rF r# r< r> r6 ri s r) test_select_existsz ExistsTest.test_select_exists s !
|$$**HHNN57<;#>??
hjj
F
r+ c
> | j j }t | t t d g t |j j dk
g d S )Nr- zno datarm rn s r) test_select_exists_falsez#ExistsTest.test_select_exists_false s !
|$$**HHNN57<9#<==
hjj
r+ N) rK rL rM rN rO r* r7 ro rq rQ r+ r) rg rg sk K
[
[
r+ rg c l e Zd ZdZdZed Z ej dddddd d
d Z d
S )IsOrIsNotDistinctFromTestT)supports_is_distinct_fromc t d|t dt d t dt d t dt d d S )Nis_distinct_testr Tr! col_a)nullablecol_br r& s r) r* z'IsOrIsNotDistinctFromTest.define_tables sZ
4d 3 3 3 7Gd 3 3 3 7Gd 3 3 3
r+ )both_int_differentr r- r- )
both_int_samer- r- r )one_null_firstNr- r- )one_null_secondr Nr- ) both_nullNNr iaaaz3col_a_value, col_b_value, expected_row_count_for_is)id_argnamesc | j j }| | d||dg | | |j j |j j }t t | | |dk rdnd}| | |j j |j j }t t | | d S )Nr- )r rw ry r )
r3 rv r2 r4 r rF rw is_distinct_fromry r< r lenisnot_distinct_from)r> col_a_value col_b_valueexpected_row_count_for_isr6 tblr? expected_row_count_for_isnots r) test_is_or_isnot_distinct_fromz8IsOrIsNotDistinctFromTest.test_is_or_isnot_distinct_from s3 k* JJLL k
B
B C
## JJsu{33CEK@@ A A
(** KK %
+a//AAQ % ## JJsu{66su{CC D D
(** KK (
r+ N)
rK rL rM rN re rO r* r combinationsr rQ r+ r) rs rs s~ K1L
[
W'"&'$ F
r+ rs N)% r r
assertionsr r schemar r r
r r r
r r r r r r r r r r r r r r
TablesTestr rS r r r r rQ rg rs rQ r+ r) r s "
"
"
"
"
(% "
"
"
JO< O< O< O< O