U
|
¸ý°d1ë ã @ sâ d dl mZ d dlZddlmZ ddlmZ ddlmZ ddlmZ ddl m
|
Z
|
ddl m Z dd l m Z dd
|
l mZ dd lmZ dd lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dlm Z d dlm Z d dlm Z d d lm Z d d lm!Z! d d lm"Z" d d lm#Z# d d lm$Z$ d d!lm%Z% d d"lm&Z& d d#lm'Z' d d$lm(Z( d d%l)m*Z* d d&l)m+Z+ G d'd( d(ej,Z-G d)d* d*ej,Z.G d+d, d,ej/Z0G d-d. d.ej,Z1G d/d0 d0ej,Z2G d1d2 d2ej,Z3G d3d4 d4ej,Z4G d5d6 d6eeej,Z5G d7d8 d8ej,Z6G d9d: d:ej,Z7G d;d< d<ej,Z8G d=d> d>ej,Z9G d?d@ d@ej,Z:G dAdB dBej,Z;G dCdD dDeej,Z<G dEdF dFej,Z=dS )Gé Né )ÚAssertsCompiledSQL)ÚAssertsExecutionResults)Úconfig)Úfixtures)Ú assert_raises)Úeq_)Úin_)Ú CursorSQL)ÚColumn)ÚTableé )Ú bindparam)Úcase)Úcolumn)ÚComputed)Úexists)Úfalse)Ú
|
ForeignKey)Úfunc)ÚIdentity)ÚInteger)Úliteral)Úliteral_column)Únull)Úselect)ÚString)Útable)Útesting)Útext)Útrue)Útuple_)Ú TupleType)Úunion)Úvalues)Ú DatabaseError)ÚProgrammingErrorc @ s@ e Zd ZdZedd Zedd Zdd Zej j
|
dd Z d
|
S ) Ú CollateTestTc C s& t d|tdtddtdtd d S )NÚ
|
some_tableÚidT©Ú primary_keyÚdataéd ©r r r r ©ÚclsÚmetadata© r2 ú[d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/testing/suite/test_select.pyÚ define_tables. s üzCollateTest.define_tablesc C s( | | jj ¡ ddddddg¡ d S )Né ú collate data1©r) r, r ú collate data2©ÚexecuteÚtablesr( Úinsert©r0 Ú
|
connectionr2 r2 r3 Ú insert_data7 s
|
þþzCollateTest.insert_datac C s. t j ¡ }t| |¡ ¡ | W 5 Q R X d S ©N©r ÚdbÚconnectr r: Úfetchall©Úselfr ÚresultÚconnr2 r2 r3 Ú_assert_resultA s zCollateTest._assert_resultc C sB t j t j¡}| t| jj | jjj j
|
|¡ ¡ ¡ddg¡ d S )N)r5 r6 )r r8 ) r ÚrequiresZget_order_by_collationr rI r r; r( Úorder_byÚcr, ZcollateZasc)rF Z collationr2 r2 r3 Útest_collate_order_byE s ÿüz!CollateTest.test_collate_order_byN) Ú__name__Ú
|
__module__Ú __qualname__Ú __backend__Ú classmethodr4 r? rI r rJ Zorder_by_collationrM r2 r2 r2 r3 r' + s
|
|
r' c @ sl e Zd ZdZdZedd Zedd Zdd Zd d
|
Z d d Z
|
d d Z dd Z dd Z ejjdd ZdS )ÚOrderByLabelTestz©Test the dialect sends appropriate ORDER BY expressions when
|
labels are used.
|
|
This essentially exercises the "supports_simple_order_by_label"
|
setting.
|
|
Tc C sB t d|tdtddtdttdttdtdtd td d S )
|
Nr( r) Tr* ÚxÚyÚqé2 Úpr. r/ r2 r2 r3 r4 \ s ùz OrderByLabelTest.define_tablesc C sB | | jj ¡ ddddddddddddddd d
|
d dg¡ d S ) Nr5 r Zq1Zp3)r) rT rU rV rX r Zq2Úp2é Zq3Úp1r9 r= r2 r2 r3 r? h s
|
ýþz OrderByLabelTest.insert_datac C s. t j ¡ }t| |¡ ¡ | W 5 Q R X d S r@ rA rE r2 r2 r3 rI s s z OrderByLabelTest._assert_resultc C s6 | j j}|jj d¡}| t| |¡dddg¡ d S )NÚlx©r5 ©r ©r )r; r( rL rT ÚlabelrI r rK ©rF r r\ r2 r2 r3 Ú
|
test_plainw s zOrderByLabelTest.test_plainc C s> | j j}|jj|jj d¡}| t| |¡dddg¡ d S )Nr\ r_ ©é ©é ) r; r( rL rT rU r` rI r rK ra r2 r2 r3 Útest_composed_int| s z"OrderByLabelTest.test_composed_intc C sb | j j}|jj|jj d¡}t |jj¡|jj d¡}|
|
t || || ¡ ¡dddg¡ d S )Nr\ Úly)r Zq1p3)rd Zq2p2)rf Zq3p1)r; r( rL rT rU r` r ÚlowerrV rX rI r rK Údesc)rF r r\ rh r2 r2 r3 Útest_composed_multiple s þz'OrderByLabelTest.test_composed_multiplec C s: | j j}|jj d¡}| t| | ¡ ¡dddg¡ d S )Nr\ r_ r^ r] ) r; r( rL rT r` rI r rK rj ra r2 r2 r3 Útest_plain_desc s z OrderByLabelTest.test_plain_descc C sB | j j}|jj|jj d¡}| t| | ¡ ¡dddg¡ d S )Nr\ re rc r_ )
|
r; r( rL rT rU r` rI r rK rj ra r2 r2 r3 Útest_composed_int_desc s z'OrderByLabelTest.test_composed_int_descc C sT | j j}|jj|jj d¡}tt |jj ¡|
|
|¡ |¡}| |dddg¡ d S )Nr\ )r5 r )r5 rd )r5 rf ) r; r( rL rT rU r` r r Úcountr) Zgroup_byrK rI )rF r ÚexprÚstmtr2 r2 r3 Útest_group_by_composed s
|
ÿz'OrderByLabelTest.test_group_by_composedN)rN rO rP Ú__doc__rQ rR r4 r? rI rb rg rk rl rm r rJ Zgroup_by_complex_expressionrq r2 r2 r2 r3 rS Q s
|
|
|
rS c @ s e Zd ZdZdZdd ZdS )ÚValuesExpressionTest)Ztable_value_constructorTc C sH t tdttdtdd dddg¡}t| t|¡ ¡ dddg d S )Nr) ÚnameZ my_values)rt )r5 Zname1)r Zname2)r Zname3) r$ r r r r, r r: r Úall)rF r> Z
|
value_exprr2 r2 r3 Ú test_tuples£ s ÿþþz ValuesExpressionTest.test_tuplesN)rN rO rP Ú __requires__rQ rv r2 r2 r2 r3 rs s rs c @ s8 e Zd ZdZedd Zedd ZdIdd ZdJd
|
d Zd d Z dd Z
|
e j j dd Ze j jdd Ze jdddgdddgdddgdde j jdd Ze j j d d Ze j jd d Ze j jd d! Ze j jd"d# Ze j j d$d% Ze j jd&d' Ze j jd(d) Ze j jd*d+ Z e j j d,d- Z e j j d.d/ Z e j j d0d1 Z e j j d2d3 Z!e j j e j j"d4d5 Z#e j j d6d7 Z$e j j d8d9 Z%e j j&d:d; Z'e j j&e j j(d<d= Z)e j j&e j j(d>d? Z*e j j+d@dA Z,e j j+e j j(dBdC Z-e j j&e j j+dDdE Z.e j j&e j j+e j j(dFdG Z/dHS )KÚFetchLimitOffsetTestTc C s* t d|tdtddtdttdt d S ©Nr( r) Tr* rT rU ©r r r r/ r2 r2 r3 r4 ± s ûz"FetchLimitOffsetTest.define_tablesc C sJ | | jj ¡ ddddddddddddddddddddg¡ d S )Nr5 r ©r) rT rU r rZ rd é r9 r= r2 r2 r3 r? » s
|
|
|
|
|
|
ûþz FetchLimitOffsetTest.insert_datar2 Fc C sT |r:| ||¡ ¡ }tt|t| tt|t| nt| ||¡ ¡ | d S r@ )r: rD r ÚlenÚset)rF r> r rG ÚparamsÚset_Z query_resr2 r2 r3 rI È s
|
z#FetchLimitOffsetTest._assert_resultc C s0 t j ¡ }t| ||¡ ¡ | W 5 Q R X d S r@ )r rB rC r Zexec_driver_sqlrD ©rF r rG r rH r2 r2 r3 Ú_assert_result_strÓ s z'FetchLimitOffsetTest._assert_result_strc C sP | j j}t| |jj¡}| || d¡ddg¡ | || d¡dddg¡ d S ©Nr ©r5 r5 r ©r r r r ©r r rZ )r; r( r rK rL r) rI Úlimit)rF r> r rp r2 r2 r3 Útest_simple_limit× s ýýz&FetchLimitOffsetTest.test_simple_limitc C sL | j j}t|jj d¡ ¡ }tt|t| ¡ ¡ }| ||dg¡ d S )Nr5 r] )
|
r; r( r rL r) r Zscalar_subqueryr# ÚsubqueryrI )rF r> r rp Úur2 r2 r3 Ú test_limit_render_multiple_timeså s ÿýz5FetchLimitOffsetTest.test_limit_render_multiple_timesc C sZ | j j}| |t| |jj¡ d¡ddg¡ | |t| |jj¡ d¡dddg¡ d S r ©r; r( rI r rK rL r) Úfetch©rF r> r r2 r2 r3 Útest_simple_fetchó s ýýz&FetchLimitOffsetTest.test_simple_fetchc C sZ | j j}| |t| |jj¡ d¡dddg¡ | |t| |jj¡ d¡ddg¡ d S )Nr r ©rZ rZ rd ©rd rZ r| r ©r; r( rI r rK rL r) Úoffsetr r2 r2 r3 Útest_simple_offset s ýýz'FetchLimitOffsetTest.test_simple_offset)r r ©r r5 )r r )r r5 Úcases)Úargnamesc C sl | j j}|ji d}dddddg}|D ]@\}}||||
}| |t| |jj¡ |¡ |¡|¡ q&d S )N)Zcompiled_cacher r
r r r )
|
r; r( Zexecution_optionsrI r rK rL r) r r )rF r> r r Z assert_datar r Úexpectedr2 r2 r3 Útest_simple_limit_offset s ýz-FetchLimitOffsetTest.test_simple_limit_offsetc C sf | j j}| |t| |jj¡ d¡ d¡ddg¡ | |t| |jj¡ d¡ d¡dddg¡ d S )Nr r5 r
r r r r © r; r( rI r rK rL r) r r r r2 r2 r3 Útest_simple_fetch_offset$ s ý ýz-FetchLimitOffsetTest.test_simple_fetch_offsetc C s2 | j j}| j|t| d¡dddddgdd d S ) Né
|
r r
r r r T©r )r; r( rI r r r r2 r2 r3 Útest_fetch_offset_no_order3 s üz/FetchLimitOffsetTest.test_fetch_offset_no_orderc C sb | j j}| |t| |jj¡ d¡dddddg¡ | |t| |jj¡ d¡ddddg¡ d S )Nr r r
r r r r5 r r r2 r2 r3 Útest_simple_offset_zero= s ý
|
ýz,FetchLimitOffsetTest.test_simple_offset_zeroc C sX | j j}t| |jj¡ d¡ d¡}|jt j
|
j ddid}t |}| |ddg¡ dS © z7test that 'literal binds' mode works - no bound params.r r5 Ú literal_bindsT)ÚdialectÚcompile_kwargsr
r N)r; r( r rK rL r) r r Úcompiler rB r¢ Ústrr ©rF r rp Zsqlr2 r2 r3 Útest_limit_offset_nobindsL s ÿz.FetchLimitOffsetTest.test_limit_offset_nobindsc C sX | j j}t| |jj¡ d¡ d¡}|jt j
|
j ddid}t |}| |ddg¡ dS r )r; r( r rK rL r) r r r¤ r rB r¢ r¥ r r¦ r2 r2 r3 Útest_fetch_offset_nobindsY s ÿz.FetchLimitOffsetTest.test_fetch_offset_nobindsc C sr | j j}| j|t| |jj¡ td¡ddgddid | j|t| |jj¡ td¡dddgddid d S )NÚlr r
r ©r r r ) r; r( rI r rK rL r) r r r r2 r2 r3 Útest_bound_limitf s üüz%FetchLimitOffsetTest.test_bound_limitc C sv | j j}| j|t| |jj¡ td¡dddgddid | j|t| |jj¡ td¡ddddgddid d S ) NÚor r r r rª r
r5 ) r; r( rI r rK rL r) r r r r2 r2 r3 Útest_bound_offsetw s ü
|
üz&FetchLimitOffsetTest.test_bound_offsetc C s | j j}| j|t| |jj¡ td¡ td¡ddgdddd | j|t| |jj¡ td¡ td¡dd d
|
gd ddd d S ) Nr© r¬ r
r r r5 )r© r¬ rª r r r )
|
r; r( rI r rK rL r) r r r r r2 r2 r3 Útest_bound_limit_offset s2 ÿþýù
|
ÿþýùz,FetchLimitOffsetTest.test_bound_limit_offsetc C s | j j}| j|t| |jj¡ td¡ td¡ddgdddd | j|t| |jj¡ td¡ td¡dd d
|
gd ddd d S ) NÚfr¬ r
r r r5 )r¯ r¬ rª r r r )
|
r; r( rI r rK rL r) r r r r r2 r2 r3 Útest_bound_fetch_offset s2 ÿþýù
|
ÿþýùz,FetchLimitOffsetTest.test_bound_fetch_offsetc C s> | j j}| |t| |jj¡ tdtd ¡ddg¡ d S )NÚ1Ú2r r ) r; r( rI r rK rL r) r r r r2 r2 r3 Útest_expr_offset¶ s ÿþûz%FetchLimitOffsetTest.test_expr_offsetc C s@ | j j}| |t| |jj¡ tdtd ¡dddg¡ d S )Nr± r² r r
r ) r; r( rI r rK rL r) r r r r2 r2 r3 Útest_expr_limitÁ s ÿþûz$FetchLimitOffsetTest.test_expr_limitc C sP | j j}| |t| |jj¡ tdtd ¡ tdtd ¡ddg¡ d S ©Nr± r r ©
|
r; r( rI r rK rL r) r r r r r2 r2 r3 Útest_expr_limit_offsetÌ s ÿþýúz+FetchLimitOffsetTest.test_expr_limit_offsetc C sP | j j}| |t| |jj¡ tdtd ¡ tdtd ¡ddg¡ d S rµ )
|
r; r( rI r rK rL r) r r r r r2 r2 r3 Útest_expr_fetch_offsetØ s ÿþýúz+FetchLimitOffsetTest.test_expr_fetch_offsetc C s~ | j j}| |t| |jj¡ d¡ t dt d ¡ddg¡ | |t| |jj¡ d¡ t dt d ¡dddg¡ d S )Nr r± r r r r )
|
r; r( rI r rK rL r) r r r r r2 r2 r3 Ú test_simple_limit_expr_offsetå s. ÿþýú ÿþýúz2FetchLimitOffsetTest.test_simple_limit_expr_offsetc C s| | j j}| |t| |jj¡ tdtd ¡ d¡ddg¡ | |t| |jj¡ tdtd ¡ d¡ddg¡ d S )Nr± r r r r5 r
r¶ r r2 r2 r3 Ú test_expr_limit_simple_offsetú s. ÿþýú ÿþýúz2FetchLimitOffsetTest.test_expr_limit_simple_offsetc C sr | j j}| j|t| |jj ¡ ¡jdddddgdd | j|t| |jj ¡ ¡jddddddgdd d S ) Nr5 T©Ú with_tiesr r r r r © r; r( rI r rK rL rT rj r r r2 r2 r3 Útest_simple_fetch_ties s ü üz+FetchLimitOffsetTest.test_simple_fetch_tiesc C sZ | j j}| t| |jj¡jddd d¡¡ ¡ }t
|
|d d t
|
t |dddh d S )Nr Tr» r r r r © r; r( r: r rK rL rT r r rD r r~ ©rF r> r Úfar2 r2 r3 Útest_fetch_offset_ties s ÿ þýÿz+FetchLimitOffsetTest.test_fetch_offset_tiesc C sl | j j}| |t| |jj¡jddd d¡ddg¡ | |t| |jj¡jddd d¡dd g¡ d S )
|
Nr Tr» r5 r
r r r r ) r; r( rI r rK rL rT r r r r2 r2 r3 Ú#test_fetch_offset_ties_exact_number- s2 ÿ þýú ÿ þýúz8FetchLimitOffsetTest.test_fetch_offset_ties_exact_numberc C s4 | j j}| |t| |jj¡jddddg¡ d S )Né T©Úpercentr r r r2 r2 r3 Útest_simple_fetch_percentC s ýz.FetchLimitOffsetTest.test_simple_fetch_percentc C s< | j j}| |t| |jj¡jddd d¡ddg¡ d S )Né( TrÅ r5 r
r r r r2 r2 r3 Útest_fetch_offset_percentL s ÿ þýúz.FetchLimitOffsetTest.test_fetch_offset_percentc C s@ | j j}| j|t| |jj ¡ ¡jddddddgdd d S )NrÄ T©rÆ r¼ r r r r½ r r2 r2 r3 Ú test_simple_fetch_percent_tiesY s
|
ÿ þúz3FetchLimitOffsetTest.test_simple_fetch_percent_tiesc C s\ | j j}| t| |jj¡jdddd d¡¡ ¡ }t
|
|d d t
|
t |dddh d S ) NrÈ TrÊ r r r r r r¿ rÀ r2 r2 r3 Ú test_fetch_offset_percent_tiesf s ÿ þýÿz3FetchLimitOffsetTest.test_fetch_offset_percent_tiesN)r2 F)r2 )0rN rO rP rQ rR r4 r? rI r r r r rJ Z fetch_firstr r r Ú combinationsr r Zfetch_no_order_byr r r§ r¨ Zbound_limit_offsetr« r r® r° Zsql_expression_limit_offsetr³ r´ r· Zfetch_expressionr¸ r¹ rº Z
|
fetch_tiesr¾ Zfetch_offset_with_optionsr rà Z fetch_percentrÇ rÉ rË rÌ r2 r2 r2 r3 rx ® s
|
|
ÿ
|
|
|
|
ü
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
rx c @ sH e Zd ZdZdZdZedd Zedd Zdd Z d
|
d Z
|
d d Z dS )ÚSameNamedSchemaTableTestztests for #7471T)Zschemasc C sB t d|tdtddtjd t d|tdtddtdtdd d S ) Nr( r) Tr* )ÚschemaÚ some_table_idF©Znullable)r r r r Ú test_schemar/ r2 r2 r3 r4 | s ü üüz&SameNamedSchemaTableTest.define_tablesc C sD | ddtj ¡\}}| | ¡ ddi¡ | | ¡ ddd¡ d S )Nr( ú %s.some_tabler) r5 )r) rÐ )r; r rÒ r: r< )r0 r> r( Úsome_table_schemar2 r2 r3 r? s ÿz$SameNamedSchemaTableTest.insert_datac C sJ | ddtj ¡\}}t| t|| |||jj|jj k¡¡
|
¡ d d S )Nr( rÓ ©r5 r5 r5 ) r; r rÒ r r: r Ú join_fromrL rÐ r) Úfirst©rF r> r( rÔ r2 r2 r3 Ú test_simple_join_both_tables s ÿ
|
ýÿøz5SameNamedSchemaTableTest.test_simple_join_both_tablesc C sV | ddtj ¡\}}t| t| |||jj|jj k¡
|
|jj dk¡¡ ¡ d d S )Nr( rÓ r5 ©r5 r5 ) r; r rÒ r r: r rÖ rL rÐ r) Úwherer× rØ r2 r2 r3 Ú!test_simple_join_whereclause_only¨ s ÿü
|
úÿ öz:SameNamedSchemaTableTest.test_simple_join_whereclause_onlyc C s | ddtj ¡\}}t| |||jj|jjk¡ |jjdk¡ ¡ }t
|
| t||jj |||jj|jjk¡ |jjdk¡¡ ¡ d d S )Nr( rÓ r5 rÕ ) r; r rÒ r rÖ rL rÐ r) rÛ r r r: r× )rF r> r( rÔ Zsubqr2 r2 r3 Ú test_subqueryº s0 ÿü
|
úÿ ü
|
úÿ öz&SameNamedSchemaTableTest.test_subqueryN) rN rO rP rr rQ rw rR r4 r? rÙ rÜ rÝ r2 r2 r2 r3 rÎ u s
|
|
rÎ c @ sZ e Zd ZdZdddZedd Zedd Zd d
|
Zd d Z d d Z
|
dd Z dd Z dS )ÚJoinTestTr2 c C s0 t j ¡ }t| ||¡ ¡ | W 5 Q R X d S r@ rA r r2 r2 r3 rI Û s zJoinTest._assert_resultc C s@ t d|tdtdd t d|tdtddtdtddd d S )
|
NÚar) Tr* ÚbÚa_idza.idFrÑ )r r r r r/ r2 r2 r3 r4 ß s üzJoinTest.define_tablesc C sj | | jj ¡ ddiddiddiddiddig¡ | | jj ¡ ddddddddddddg¡ d S )Nr) r5 r r rZ rd )r) rá )r: r; rß r< rà r= r2 r2 r3 r? é s
|
þ
|
üþzJoinTest.insert_datac C sN | dd¡\}}t|| | |¡¡ |jj|jj¡}| |ddddg¡ d S ©Nrß rà rÕ )r5 r r5 )r rZ r )r rd r ©r; r Ú select_fromÚjoinrK rL r) rI ©rF rß rà rp r2 r2 r3 Útest_inner_join_fkú s &zJoinTest.test_inner_join_fkc C sn | dd¡\}}t|| | |t ¡¡ |jj|jj¡}| |dd t
|
ddddd gd
|
d d d g¡D ¡ d S )Nrß rà c S s g | ]\\}\}}|||fqS r2 r2 )Ú.0rß rà rL r2 r2 r3 Ú
|
<listcomp> s ÿz1JoinTest.test_inner_join_true.<locals>.<listcomp>r] r^ r_ ©rZ rc rÚ r )rZ r )rd r ) r; r rä rå r rK rL r) rI Ú itertoolsÚproductræ r2 r2 r3 Útest_inner_join_true s"
|
ÿ þÿ
|
þþþz JoinTest.test_inner_join_truec C sJ | dd¡\}}t|| | |t ¡¡ |jj|jj¡}| |g ¡ d S )Nrß rà ) r; r rä rå r rK rL r) rI ræ r2 r2 r3 Útest_inner_join_false s
|
ÿ þÿz JoinTest.test_inner_join_falsec C sT | dd¡\}}t|| | |t ¡¡ |jj|jj¡}| |dddddg¡ d S )Nrß rà )r5 NN)r NN)r NN)rZ NN)rd NN) r; r rä Z outerjoinr rK rL r) rI ræ r2 r2 r3 Útest_outer_join_false s"
|
ÿ þÿûþz JoinTest.test_outer_join_falsec C sN | dd¡\}}t|| | |¡¡ |jj|jj¡}| |ddddg¡ d S râ rã ræ r2 r2 r3 Útest_outer_join_fk4 s &zJoinTest.test_outer_join_fkN)r2 ) rN rO rP rQ rI rR r4 r? rç rí rî rï rð r2 r2 r2 r3 rÞ Ø s
|
|
|
rÞ c @ s e Zd ZdZedd Zedd ZdddZd d
|
Zd d Z e
|
j j e
|
j j d d Ze
|
j jdd Zdd Ze
|
j j dd Zdd ZdS )ÚCompoundSelectTestTc C s* t d|tdtddtdttdt d S ry rz r/ r2 r2 r3 r4 ? s ûz CompoundSelectTest.define_tablesc
|
C s@ | | jj ¡ ddddddddddddddddg¡ d S )Nr5 r r{ r rZ rd r9 r= r2 r2 r3 r? I s
|
|
|
|
|
üþz CompoundSelectTest.insert_datar2 c C s0 t j ¡ }t| ||¡ ¡ | W 5 Q R X d S r@ rA r r2 r2 r3 rI U s z!CompoundSelectTest._assert_resultc C s\ | j j}t| |jjdk¡}t| |jjdk¡}t||}| | |j j¡ddg¡ d S ©Nr r r
r )
|
r; r( r rÛ rL r) r# rI rK Úselected_columns©rF r Ús1Ús2Úu1r2 r2 r3 Útest_plain_unionY s
|
ÿz#CompoundSelectTest.test_plain_unionc C sd | j j}t| |jjdk¡}t| |jjdk¡}t|| ¡ ¡ }| | |j
|
j¡ddg¡ d S rò ) r; r( r rÛ rL r) r# ÚaliasrI rK ró rô r2 r2 r3 Ú test_select_from_plain_unionc s ÿz/CompoundSelectTest.test_select_from_plain_unionc C s | j j}t| |jjdk¡ d¡ |jj¡}t| |jjdk¡ d¡ |jj¡}t|| d¡}| | |j
|
j¡ddg¡ d S ©Nr r5 r r
r ) r; r( r rÛ rL r) r rK r# rI ró rô r2 r2 r3 Ú&test_limit_offset_selectable_in_unionsm s && ÿz9CompoundSelectTest.test_limit_offset_selectable_in_unionsc C sv | j j}t| |jjdk¡ |jj¡}t| |jjdk¡ |jj¡}t|| d¡}| | |j
|
j¡ddg¡ d S rò ) r; r( r rÛ rL r) rK r# r rI ró rô r2 r2 r3 Ú"test_order_by_selectable_in_unionsy s ÿz5CompoundSelectTest.test_order_by_selectable_in_unionsc C sj | j j}t| |jjdk¡ ¡ }t| |jjdk¡ ¡ }t|| d¡}| |
|
|j j¡ddg¡ d S rò ) r; r( r rÛ rL r) Údistinctr# r rI rK ró rô r2 r2 r3 Ú"test_distinct_selectable_in_unions s ÿz5CompoundSelectTest.test_distinct_selectable_in_unionsc C s | j j}t| |jjdk¡ d¡ |jj¡}t| |jjdk¡ d¡ |jj¡}t|| ¡ }|
|
| ¡ d¡ |jj¡ddg¡ d S rû ) r; r( r rÛ rL r) r rK r# rù rI rô r2 r2 r3 Ú&test_limit_offset_in_unions_from_alias s && ÿz9CompoundSelectTest.test_limit_offset_in_unions_from_aliasc C s | j j}t| |jjdk¡ d¡ |jj¡ ¡ ¡ }t| |jjdk¡ d¡ |jj¡ ¡ ¡ }t || d¡}|
|
| |j j¡ddg¡ d S rû ) r; r( r rÛ rL r) r rK rù r# rI ró rô r2 r2 r3 Ú.test_limit_offset_aliased_selectable_in_unions s,
|
ÿþý
|
ÿ
|
ÿþý
|
ÿ ÿzACompoundSelectTest.test_limit_offset_aliased_selectable_in_unionsN)r2 )rN rO rP rQ rR r4 r? rI rø rú r rJ Zorder_by_col_from_unionZ/parens_in_union_contained_select_w_limit_offsetrü Z0parens_in_union_contained_select_wo_limit_offsetrý rÿ r r r2 r2 r2 r3 rñ < s"
|
|
|
|
|
|
|
|
|
|
rñ c @ sl e Zd ZdZdZedd Zedd Zdd Zd d
|
Z d d Z
|
d d Z e j jdd Ze j jdd ZdS )ÚPostCompileParamsTestT)Zstandard_cursor_sqlc
|
C s6 t d|tdtddtdttdttdtd d S © Nr( r) Tr* rT rU ÚzrW r. r/ r2 r2 r3 r4 º s úz#PostCompileParamsTest.define_tablesc C sH | | jj ¡ dddddddddddddddddd d
|
dg¡ d S © Nr5 r Úz1)r) rT rU r r Úz2rZ Úz3rd Úz4r9 r= r2 r2 r3 r? Å s
|
üþz!PostCompileParamsTest.insert_datac C s< | j j}t|jj |jjtdddk¡}| |di ¡ d S )NrV T©Úliteral_executezKSELECT some_table.id FROM some_table WHERE some_table.x = __[POSTCOMPILE_q]© r; r( r rL r) rÛ rT r Úassert_compile©rF r rp r2 r2 r3 Ú test_compileÑ s ÿüz"PostCompileParamsTest.test_compilec C sB | j j}t|jj |jjtddddk¡}| j|di dd d S )NrV r Tr
|
z<SELECT some_table.id FROM some_table WHERE some_table.x = 10)r¡ r r r2 r2 r3 Útest_compile_literal_bindsß s ÿüz0PostCompileParamsTest.test_compile_literal_bindsc
|
C s | j j}t|jj |jjtdddk¡}| ¡ .}t j
|
¡ }| |t dd¡ W 5 Q R X W 5 Q R X | tdt j
|
jjr|dni ¡ d S )NrV Tr
|
r ©rV z>SELECT some_table.id
|
FROM some_table
|
WHERE some_table.x = 10r2 )r; r( r rL r) rÛ rT r Úsql_execution_asserterr rB rC r: ÚdictÚassert_r
|
r¢ Ú
|
positional©rF r rp ZasserterrH r2 r2 r3 Ú test_executeí s ÿ
|
&ýÿz"PostCompileParamsTest.test_executec
|
C s | j j}t|jj |jj tdddd¡¡}| ¡ 4}t
|
j ¡ }| |tdddgd¡ W 5 Q R X W 5 Q R X | tdt
|
j jjrd ni ¡ d S )
|
NrV T©Ú expandingr rd r| rf r zFSELECT some_table.id
|
FROM some_table
|
WHERE some_table.x IN (5, 6, 7)r2 )r; r( r rL r) rÛ rT r r r r rB rC r: r r r
|
r¢ r r r2 r2 r3 Ú+test_execute_expanding_plus_literal_execute s ÿ
|
,ýÿzAPostCompileParamsTest.test_execute_expanding_plus_literal_executec
|
C s¬ | j j}t|jj t|jj|jj t
|
dddd¡¡}| ¡ 2}t j ¡ }| |tddgd¡ W 5 Q R X W 5 Q R X | tdt j jjrdnd t j jjr d
|
ni ¡ d S ) NrV Tr )rd r )é é r zbSELECT some_table.id
|
FROM some_table
|
WHERE (some_table.x, some_table.y) IN (%s(5, 10), (12, 18))úVALUES Ú r2 )r; r( r rL r) rÛ r! rT rU r r r r rB rC r: r r r
|
r¢ Útuple_in_valuesr r r2 r2 r3 Ú1test_execute_tuple_expanding_plus_literal_execute s" ÿÿ
|
*ýûÿzGPostCompileParamsTest.test_execute_tuple_expanding_plus_literal_executec
|
C s¬ | j j}t|jj t|jj|jj t
|
dddd¡¡}| ¡ 2}t j ¡ }| |tddgd¡ W 5 Q R X W 5 Q R X | tdt j jjrdnd t j jjr d
|
ni ¡ d S ) NrV Tr )rd r )r r r zfSELECT some_table.id
|
FROM some_table
|
WHERE (some_table.x, some_table.z) IN (%s(5, 'z1'), (12, 'z3'))r r r2 )r; r( r rL r) rÛ r! rT r r r r r rB rC r: r r r
|
r¢ r r r r2 r2 r3 Ú?test_execute_tuple_expanding_plus_literal_heterogeneous_execute+ s" ÿÿ
|
*ýûÿzUPostCompileParamsTest.test_execute_tuple_expanding_plus_literal_heterogeneous_executeN)rN rO rP rQ rw rR r4 r? r r r r r rJ Útuple_inr r! r2 r2 r2 r3 r ³ s
|
|
|
|
r c @ sr e Zd ZdZedd Zedd ZdDddZd d
|
Zd d Z e
|
j j d d Z e
|
j j dd Ze
|
j j dd Ze
|
j j dd Zdd Zdd Zdd Zdd Zd d Zd d Ze
|
j jd!d" Ze
|
j jd#d$ Ze
|
j jd%d& Ze
|
j jd'd( Ze
|
j jd)d* Z e
|
j jd+d, Z e
|
j jd-d. Z d/d0 Z d1d2 Z d3d4 Z!d5d6 Z"d7d8 Z#d9d: Z$d;d< Z%d=d> Z&d?d@ Z'dAdB Z(dCS )EÚExpandingBoundInTestTc
|
C s6 t d|tdtddtdttdttdtd d S r r. r/ r2 r2 r3 r4 G s úz"ExpandingBoundInTest.define_tablesc C sH | | jj ¡ dddddddddddddddddd d
|
dg¡ d S r r9 r= r2 r2 r3 r? R s
|
üþz ExpandingBoundInTest.insert_datar2 c C s0 t j ¡ }t| ||¡ ¡ | W 5 Q R X d S r@ rA r r2 r2 r3 rI ^ s z#ExpandingBoundInTest._assert_resultc C s` | j j}t|jj |jj td¡¡ |jj td¡¡
|
|jj¡}| j |g g g dd d S )NrV rX )rV rX rª ) r; r( r rL r) rÛ rT r r rU rK rI r r2 r2 r3 Ú"test_multiple_empty_sets_bindparamb s ÿþýÿz7ExpandingBoundInTest.test_multiple_empty_sets_bindparamc C sN | j j}t|jj |jj g ¡¡ |jj g ¡¡ |jj¡}|
|
|g ¡ d S r@ ) r; r( r rL r) rÛ rT r rU rK rI r r2 r2 r3 Ú test_multiple_empty_sets_directn s ÿ þýÿz4ExpandingBoundInTest.test_multiple_empty_sets_directc C sT | j j}t|jj t|jj|jj t
|
d¡¡ |jj¡}| j |g dg id d S ©NrV rª © r; r( r rL r) rÛ r! rT r r r rK rI r r2 r2 r3 Ú)test_empty_heterogeneous_tuples_bindparamz s ÿþÿz>ExpandingBoundInTest.test_empty_heterogeneous_tuples_bindparamc sD j j fdd}|g g |dddgdddg |g g d S ) Nc s@ t jj tjjjj | ¡¡ jj¡} ||¡ d S r@ )
|
r rL r) rÛ r! rT r r rK rI ©Úvalr rp ©rF r r2 r3 Úgo s ÿþÿzGExpandingBoundInTest.test_empty_heterogeneous_tuples_direct.<locals>.go©r r ©r r ©rZ r r^ r_ rê ©r; r( ©rF r, r2 r+ r3 Ú&test_empty_heterogeneous_tuples_direct s
|
|
z;ExpandingBoundInTest.test_empty_heterogeneous_tuples_directc C sT | j j}t|jj t|jj|jj t
|
d¡¡ |jj¡}| j |g dg id d S r& © r; r( r rL r) rÛ r! rT rU r r rK rI r r2 r2 r3 Ú'test_empty_homogeneous_tuples_bindparam s ÿþÿz<ExpandingBoundInTest.test_empty_homogeneous_tuples_bindparamc sD j j fdd}|g g |dddgdddg |g g d S ) Nc s@ t jj tjjjj | ¡¡ jj¡} ||¡ d S r@ )
|
r rL r) rÛ r! rT rU r rK rI r) r+ r2 r3 r, ¢ s ÿþÿzEExpandingBoundInTest.test_empty_homogeneous_tuples_direct.<locals>.go)r5 r ©r r ©r rZ r] r^ r_ r0 r1 r2 r+ r3 Ú$test_empty_homogeneous_tuples_direct s
|
|
z9ExpandingBoundInTest.test_empty_homogeneous_tuples_directc C sV | j j}t|jj |jj td¡¡ |jj¡}| j
|
|dddgddddgid d S ) NrV r^ r_ rê r r rZ rª © r; r( r rL r) rÛ rT r r rK rI r r2 r2 r3 Ú test_bound_in_scalar_bindparam® s ÿþÿz3ExpandingBoundInTest.test_bound_in_scalar_bindparamc C sJ | j j}t|jj |jj dddg¡¡ |jj¡}| |dddg¡ d S )Nr r rZ r^ r_ rê ©
|
r; r( r rL r) rÛ rT r rK rI r r2 r2 r3 Útest_bound_in_scalar_direct· s ÿþÿz0ExpandingBoundInTest.test_bound_in_scalar_directc C sV | j j}t|jj |jj ddg¡¡ |jj g ¡¡ |jj¡}|
|
|ddg¡ d S )Nr r r^ r_ © r; r( r rL r) rÛ rT r Únot_inrK rI r r2 r2 r3 Ú!test_nonempty_in_plus_empty_notinÀ s ÿ þýÿz6ExpandingBoundInTest.test_nonempty_in_plus_empty_notinc C sR | j j}t|jj |jj g ¡¡ |jj ddg¡¡ |jj¡}|
|
|g ¡ d S )Nr r r< r r2 r2 r3 Ú!test_empty_in_plus_notempty_notinÊ s ÿþýÿz6ExpandingBoundInTest.test_empty_in_plus_notempty_notinc C s< t d tdtdd¡}| j|dddgddd d
|
gid d S ) ztest related to #7292.
|
|
as a type is given to the bound param, there is no ambiguity
|
to the type of element.
|
|
ú3select id FROM some_table WHERE z IN :q ORDER BY idrV T©Útype_r r^ r_ rê r r r rª N)r Ú
|
bindparamsr r rI ©rF rp r2 r2 r3 Útest_typed_str_inÔ s ÿ þ ýz&ExpandingBoundInTest.test_typed_str_inc C s: t d tddd¡}| j|dddgddd d
|
gid d S ) zÂtest related to #7292.
|
|
for untyped expression, we look at the types of elements.
|
Test for Sequence to detect tuple in. but not strings or bytes!
|
as always....
|
|
r@ rV T©r r^ r_ rê r r r rª N©r rC r rI rD r2 r2 r3 Útest_untyped_str_inå s ÿ
|
þ ýz(ExpandingBoundInTest.test_untyped_str_inc C s` | j j}t|jj t|jj|jj t
|
d¡¡ |jj¡}| j |dddgddddgid d S ) NrV r^ r_ rê r5 r6 ©rZ rd rª r3 r r2 r2 r3 Ú!test_bound_in_two_tuple_bindparam÷ s ÿþÿ ÿz6ExpandingBoundInTest.test_bound_in_two_tuple_bindparamc C sT | j j}t|jj t|jj|jj dddg¡¡
|
|jj¡}| |dddg¡ d S )Nr5 r6 rI r^ r_ rê ) r; r( r rL r) rÛ r! rT rU r rK rI r r2 r2 r3 Ú test_bound_in_two_tuple_direct s ÿþÿz3ExpandingBoundInTest.test_bound_in_two_tuple_directc C s` | j j}t|jj t|jj|jj t
|
d¡¡ |jj¡}| j |dddgddddgid d S ) NrV r^ r_ rê r- r. r/ rª r' r r2 r2 r3 Ú/test_bound_in_heterogeneous_two_tuple_bindparam s ÿþÿ ýzDExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_bindparamc C sT | j j}t|jj t|jj|jj dddg¡¡
|
|jj¡}| |dddg¡ d S )Nr- r. r/ r^ r_ rê ) r; r( r rL r) rÛ r! rT r r rK rI r r2 r2 r3 Ú,test_bound_in_heterogeneous_two_tuple_direct s ÿþúÿ þzAExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_directc C s: t d tddd¡}| j|dddgddd d
|
gid d S ) Nú8select id FROM some_table WHERE (x, z) IN :q ORDER BY idrV TrF r^ r_ rê r- r. r/ rª rG rD r2 r2 r3 Ú4test_bound_in_heterogeneous_two_tuple_text_bindparam, s ÿ
|
þ ýzIExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparamc C sj G dd dt j}td tdtt t dd¡}| j|ddd gd|d
|
d |d d |ddgid d S )Nc @ s, e Zd Zdd Zdd Zdd Zdd Zd S )
|
zhExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple.<locals>.LikeATuplec W s
|
|| _ d S r@ ©Ú_data©rF r, r2 r2 r3 Ú__init__< s zqExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple.<locals>.LikeATuple.__init__c S s
|
t | jS r@ ©ÚiterrQ ©rF r2 r2 r3 Ú__iter__? s zqExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple.<locals>.LikeATuple.__iter__c S s
|
| j | S r@ rP ©rF Úidxr2 r2 r3 Ú __getitem__B s ztExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple.<locals>.LikeATuple.__getitem__c S s
|
t | jS r@ ©r} rQ rV r2 r2 r3 Ú__len__E s zpExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple.<locals>.LikeATuple.__len__N©rN rO rP rS rW rZ r\ r2 r2 r2 r3 Ú
|
LikeATuple; s r^ rN rV TrA r^ r_ rê r r r r rZ r rª ) Úcollections_abcÚSequencer rC r r" r r rI ©rF r^ rp r2 r2 r3 Ú?test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuple9 s( ÿ ÿýýÿýzTExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuplec C s^ G dd dt j}td tddd¡}| j|ddd gd|d
|
d |d d |ddgid d S )Nc @ s, e Zd Zdd Zdd Zdd Zdd Zd S )
|
zgExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple.<locals>.LikeATuplec W s
|
|| _ d S r@ rP rR r2 r2 r3 rS a s zpExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple.<locals>.LikeATuple.__init__c S s
|
t | jS r@ rT rV r2 r2 r3 rW d s zpExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple.<locals>.LikeATuple.__iter__c S s
|
| j | S r@ rP rX r2 r2 r3 rZ g s zsExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple.<locals>.LikeATuple.__getitem__c S s
|
t | jS r@ r[ rV r2 r2 r3 r\ j s zoExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple.<locals>.LikeATuple.__len__Nr] r2 r2 r2 r3 r^ ` s r^ rN rV TrF r^ r_ rê r r r r rZ r rª )r_ r` r rC r rI ra r2 r2 r3 Ú>test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuple[ s ÿ
|
þýÿýzSExpandingBoundInTest.test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuplec C sJ | j j}t|jj |jj td¡¡ |jj¡}| j
|
|g dg id d S r& r8 r r2 r2 r3 Ú(test_empty_set_against_integer_bindparam| s ÿþÿz=ExpandingBoundInTest.test_empty_set_against_integer_bindparamc C s> | j j}t|jj |jj g ¡¡ |jj¡}| |g ¡ d S r@ r: r r2 r2 r3 Ú%test_empty_set_against_integer_direct
s &z:ExpandingBoundInTest.test_empty_set_against_integer_directc C sR | j j}t|jj |jj td¡¡ |jj¡}| j
|
|ddddgdg id d S ©NrV r] r^ r_ rê rª ) r; r( r rL r) rÛ rT r= r rK rI r r2 r2 r3 Ú1test_empty_set_against_integer_negation_bindparam s ÿþÿzFExpandingBoundInTest.test_empty_set_against_integer_negation_bindparamc C sF | j j}t|jj |jj g ¡¡ |jj¡}| |ddddg¡ d S ©Nr] r^ r_ rê )
|
r; r( r rL r) rÛ rT r= rK rI r r2 r2 r3 Ú.test_empty_set_against_integer_negation_direct s $ÿzCExpandingBoundInTest.test_empty_set_against_integer_negation_directc C sJ | j j}t|jj |jj td¡¡ |jj¡}| j
|
|g dg id d S r& ) r; r( r rL r) rÛ r r r rK rI r r2 r2 r3 Ú'test_empty_set_against_string_bindparam s ÿþÿz<ExpandingBoundInTest.test_empty_set_against_string_bindparamc C s> | j j}t|jj |jj g ¡¡ |jj¡}| |g ¡ d S r@ )
|
r; r( r rL r) rÛ r r rK rI r r2 r2 r3 Ú$test_empty_set_against_string_direct£ s &z9ExpandingBoundInTest.test_empty_set_against_string_directc C sR | j j}t|jj |jj td¡¡ |jj¡}| j
|
|ddddgdg id d S rf ) r; r( r rL r) rÛ r r= r rK rI r r2 r2 r3 Ú0test_empty_set_against_string_negation_bindparam¨ s ÿþÿzEExpandingBoundInTest.test_empty_set_against_string_negation_bindparamc C sF | j j}t|jj |jj g ¡¡ |jj¡}| |ddddg¡ d S rh )
|
r; r( r rL r) rÛ r r= rK rI r r2 r2 r3 Ú-test_empty_set_against_string_negation_direct± s $ÿzBExpandingBoundInTest.test_empty_set_against_string_negation_directc C sD t tt tddd¡t ft d}t| |¡ ¡ d d d S )NÚfoor2 )Úvalue©Zelse_r ©Fr ) r r r r r r r r: Úfetchone©rF r> rp r2 r2 r3 Ú)test_null_in_empty_set_is_false_bindparam¸ s þûÿ z>ExpandingBoundInTest.test_null_in_empty_set_is_false_bindparamc C s< t tt g ¡t ft d}t| |¡ ¡ d d d S )Nrp r rq )r r r r r r r: rr rs r2 r2 r3 Ú&test_null_in_empty_set_is_false_directÄ s
|
þûÿ z;ExpandingBoundInTest.test_null_in_empty_set_is_false_directN)r2 ))rN rO rP rQ rR r4 r? rI r$ r% r rJ Ztuple_in_w_emptyr( r2 r4 r7 r9 r; r> r? rE rH r" rJ rK rL rM rO rb rc rd re rg ri rj rk rl rm rt ru r2 r2 r2 r3 r# D s\
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
!
|
r# c @ s> e Zd ZdZdZdZedd Zedd Zdd Z d
|
d Z
|
d d Z dd Z dd Z dd Zdd Zdd Zdd Zdd Zd d Zd d Zd d! Zd"d# Zd$d% Zejjd&d' Zejj d(d) Z ejje d*d+d,d-d.hfd/d+d,d-d.d0hfd1d+d,d-d.d0hfd2d3hfd4e e d+d5fd6e e d+d5fd7e f¡d8d9 Z!dS ):ÚLikeFunctionsTestTÚonceNc C s& t d|tdtddtdtd d S )Nr( r) Tr* r, rW r. r/ r2 r2 r3 r4 × s üz LikeFunctionsTest.define_tablesc C sp | | jj ¡ ddddddddddd dd
|
d dd d ddddddddddddddd dg ¡ d S )Nr5 Zabcdefgr7 r zab/cdefgr zab%cdefgrZ Zab_cdefgrd zabcde/fgr| zabcde%fgrf zab#cdefgé Zab9cdefgé zabcde#fgr Zabcd9fgé r9 r= r2 r2 r3 r? à s
|
õþz LikeFunctionsTest.insert_datac C sN | j j}tj ¡ (}dd | t|jj |¡¡D }W 5 Q R X t
|
|| d S )Nc S s h | ]
|
\}|qS r2 r2 )rè ro r2 r2 r3 Ú <setcomp>÷ s ÿz*LikeFunctionsTest._test.<locals>.<setcomp>) r; r( r rB rC r: r rL r) rÛ r )rF ro r r( rH Úrowsr2 r2 r3 Ú_testó s þzLikeFunctionsTest._testc C s6 | j jjj}| | d¡dddddddd d
|
d h
|
¡ d S ) Núab%cr5 r r rZ rd r| rf rx ry r ©r; r( rL r, r} Ú
|
startswith©rF Úcolr2 r2 r3 Útest_startswith_unescapedþ s z+LikeFunctionsTest.test_startswith_unescapedc C s( | j jjj}| |jddddh¡ d S )Nr~ T©Ú
|
autoescaper r r r2 r2 r3 Útest_startswith_autoescape s z,LikeFunctionsTest.test_startswith_autoescapec C s: | j jjj}| | td¡dddddddd d
|
d h
|
¡ d S ) Nz'ab%c'r5 r r rZ rd r| rf rx ry r )r; r( rL r, r} r r r r2 r2 r3 Útest_startswith_sqlexpr s
|
þz)LikeFunctionsTest.test_startswith_sqlexprc C s( | j jjj}| |jddddh¡ d S )Nzab##cú#©Úescaperf r r r2 r2 r3 Útest_startswith_escape s z(LikeFunctionsTest.test_startswith_escapec C sD | j jjj}| |jdddddh¡ | |jdddddh¡ d S )Nr~ Tr ©r
r r zab#crf r r r2 r2 r3 Ú!test_startswith_autoescape_escape s z3LikeFunctionsTest.test_startswith_autoescape_escapec C s4 | j jjj}| | d¡dddddddd d
|
h ¡ d S ) Núe%fgr5 r r rZ rd r| rf rx ry ©r; r( rL r, r} Úendswithr r2 r2 r3 Útest_endswith_unescaped s z)LikeFunctionsTest.test_endswith_unescapedc C s8 | j jjj}| | td¡dddddddd d
|
h ¡ d S ) Nz'e%fg'r5 r r rZ rd r| rf rx ry )r; r( rL r, r} r r r r2 r2 r3 Útest_endswith_sqlexpr s
|
ÿz'LikeFunctionsTest.test_endswith_sqlexprc C s( | j jjj}| |jddddh¡ d S )Nr Tr r| r r r2 r2 r3 Útest_endswith_autoescape s z*LikeFunctionsTest.test_endswith_autoescapec C s( | j jjj}| |jddddh¡ d S )Nze##fgr r ry r r r2 r2 r3 Útest_endswith_escape$ s z&LikeFunctionsTest.test_endswith_escapec C sD | j jjj}| |jdddddh¡ | |jdddddh¡ d S )Nr Tr r r| ze#fgry r r r2 r2 r3 Ú test_endswith_autoescape_escape( s z1LikeFunctionsTest.test_endswith_autoescape_escapec C s4 | j jjj}| | d¡dddddddd d
|
h ¡ d S ) Núb%cder5 r r rZ rd r| rf rx ry ©r; r( rL r, r} Úcontainsr r2 r2 r3 Útest_contains_unescaped- s z)LikeFunctionsTest.test_contains_unescapedc C s( | j jjj}| |jddddh¡ d S )Nr Tr r r r r2 r2 r3 Útest_contains_autoescape1 s z*LikeFunctionsTest.test_contains_autoescapec C s( | j jjj}| |jddddh¡ d S )Nzb##cder r rf r r r2 r2 r3 Útest_contains_escape5 s z&LikeFunctionsTest.test_contains_escapec C sD | j jjj}| |jdddddh¡ | |jdddddh¡ d S )Nzb%cdTr r r zb#cdrf r r r2 r2 r3 Ú test_contains_autoescape_escape9 s z1LikeFunctionsTest.test_contains_autoescape_escapec C s0 | j jjj}| | d¡ ddddddh¡ d S )Núa.cder r rZ rf rx r ©r; r( rL r, r} Ú regexp_matchr r2 r2 r3 Útest_not_regexp_match> s z'LikeFunctionsTest.test_not_regexp_matchc C s2 | j jjj}| | dd¡ d¡ddddh¡ d S )Nr ZFOOr5 rd r| ry )r; r( rL r, r} Úregexp_replacer r r2 r2 r3 Útest_regexp_replaceC s
|
|
ÿz%LikeFunctionsTest.test_regexp_replacer r5 rd r| ry Úabcr z^abcZ9cderx z^arz z(b|c)z^(b|c)c C s" | j jjj}| | |¡|¡ d S r@ r )rF r r r r2 r2 r3 Útest_regexp_matchJ s z#LikeFunctionsTest.test_regexp_match)"rN rO rP rQ Ú run_insertsÚ run_deletesrR r4 r? r} r r r r r r r r r r r r r r r rJ r r r¡ r¢ rÍ r~ Úranger¤ r2 r2 r2 r3 rv Ñ sJ
|
|
|
|
ù rv c @ s< e Zd ZdZdZedd Zedd Zdd Zd d
|
Z d S ) ÚComputedColumnTestT)Zcomputed_columnsc C s> t d|tdtddtdttdttdtdttd d S )
|
NÚsquarer) Tr* ÚsideÚareaz side * sideÚ perimeterz4 * side)r r r r r/ r2 r2 r3 r4 ] s úz ComputedColumnTest.define_tablesc C s( | | jj ¡ ddddddg¡ d S )Nr5 r )r) rª é* )r: r; r© r< r= r2 r2 r3 r? h s
|
þz ComputedColumnTest.insert_datac C sV t j ¡ B}| ttd | jj¡ | jjj
|
j ¡¡ ¡ }t |ddg W 5 Q R X d S )NÚ*)r5 r r- rÈ )r r éä é¨ )r rB rC r: r r rä r; r© rK rL r) rD r ©rF rH Úresr2 r2 r3 Útest_select_allo s ÿ
|
þÿz"ComputedColumnTest.test_select_allc C sd t j ¡ P}| t| jjjj| jjjj
|
| jj¡ | jjjj ¡¡ ¡ }t|ddg W 5 Q R X d S )N)r- rÈ )r¯ r° )r rB rC r: r r; r© rL r« r¬ rä rK r) rD r r± r2 r2 r3 Útest_select_columnsx s
|
|
ÿý
|
üÿz&ComputedColumnTest.test_select_columnsN)
|
rN rO rP rQ rw rR r4 r? r³ r´ r2 r2 r2 r3 r¨ Y s
|
|
|
r¨ c @ sT e Zd ZdZdZdZdZedd Zedd Z dd Z
|
d
|
d Z e j jd d ZdS )ÚIdentityColumnTestT)Zidentity_columnsrw c C sd t d|tdttdddddddtdtd t d |tdttd
|
d d d d ddtdtd d S )NÚtbl_ar) Tr )ÚalwaysÚstartZ
|
nominvalueZ
|
nomaxvaluer* rj r- Útbl_béûÿÿÿr iüÿÿ)Ú incrementr¸ ZminvalueZmaxvalue©r r r r r r/ r2 r2 r3 r4 s6 ÿú õ ü ÷z IdentityColumnTest.define_tablesc C s` | | jj ¡ ddiddig¡ | | jj ¡ ddiddig¡ | | jj ¡ dddg¡ d S )Nrj rß rà r rL ©r) rj )r: r; r¶ r< r¹ r= r2 r2 r3 r? ¥ s
|
þ
|
þ
|
|
þz IdentityColumnTest.insert_datac C s~ | ttd | jj¡ | jjjj¡¡ ¡ }t
|
|ddg | ttd | jj ¡ | jj jj¡¡ ¡ }t
|
|dddg d S )Nr® )r rß )é+ rà )rº rà )r rß )r rL ) r: r r rä r; r¶ rK rL r) rD r r¹ ©rF r> r² r2 r2 r3 r³ ´ s ÿ
|
þÿ ÿ
|
þÿz"IdentityColumnTest.test_select_allc C s: | t| jjjj | jjjj¡¡ ¡ }t|ddg d S )N)r )r¾ ) r: r r; r¶ rL r) rK rD r r¿ r2 r2 r3 r´ à s ÿz&IdentityColumnTest.test_select_columnsc s fdd}t ttf| d S )Nc s jj ¡ dddg¡ d S )NéÈ rß r½ )r: r; r¶ r< r2 ©r> rF r2 r3 ÚfnÌ s
|
|
þz7IdentityColumnTest.test_insert_always_error.<locals>.fn)r r% r& )rF r> r r2 rÁ r3 Útest_insert_always_errorÊ s z+IdentityColumnTest.test_insert_always_errorN)rN rO rP rQ rw r¥ r¦ rR r4 r? r³ r´ r rJ Zidentity_columns_standardrà r2 r2 r2 r3 rµ s
|
|
rµ c @ s( e Zd ZdZdZedd Zdd ZdS )ÚIdentityAutoincrementTestT)Z autoincrement_without_sequencec
|
C s, t d|tdtt dddtdtd d S )NÚtblr) T)r+ Z autoincrementrj r- r¼ r/ r2 r2 r3 r4 Ù s û öz'IdentityAutoincrementTest.define_tablesc C s< | | jj ¡ ddi¡}| | jj ¡ ¡ ¡ }t|d d S )Nrj Úrow)r5 rÆ )r: r; rÅ r< r r× r r¿ r2 r2 r3 Ú test_autoincrement_with_identityè s z:IdentityAutoincrementTest.test_autoincrement_with_identityN)rN rO rP rQ rw rR r4 rÇ r2 r2 r2 r3 rÄ Õ s
|
|
rÄ c @ s8 e Zd ZdZedd Zedd Zdd Zdd Zd
|
S ) Ú
|
ExistsTestTc C s& t d|tdtddtdtd d S )NÚstuffr) Tr* r, rW r. r/ r2 r2 r3 r4 ñ s üzExistsTest.define_tablesc C s8 | | jj ¡ ddddddddddddg¡ d S )Nr5 ú some datar7 r r rZ zsome other data)r: r; rÉ r< r= r2 r2 r3 r? ú s
|
üþzExistsTest.insert_datac C s@ | j j}t| ttd t |jj dk¡¡¡
|
¡ dg d S )Nr5 rÊ r] © r; rÉ r r: r r rÛ r rL r, rD ©rF r> rÉ r2 r2 r3 Útest_select_exists s ÿÿúz ExistsTest.test_select_existsc C s> | j j}t| ttd t |jj dk¡¡¡
|
¡ g d S )Nr5 zno datarË rÌ r2 r2 r3 Útest_select_exists_false s ÿÿúz#ExistsTest.test_select_exists_falseN) rN rO rP rQ rR r4 r? rÍ rÎ r2 r2 r2 r3 rÈ î s
|
|
rÈ c @ s& e Zd ZdZe ejj¡dd ZdS )ÚDistinctOnTestTc C sB t d td¡ td¡}t d¡ | |d¡ W 5 Q R X d S )Nr® rV rn z:DISTINCT ON is currently supported only by the PostgreSQL zSELECT DISTINCT * FROM foo)r rþ r rä r r Zexpect_deprecatedr )rF Zstmr2 r2 r3 Útest_distinct_on s
|
ÿz DistinctOnTest.test_distinct_onN) rN rO rP rQ r Zfails_ifrJ Zsupports_distinct_onrÐ r2 r2 r2 r3 rÏ s rÏ c @ s@ e Zd ZdZdZedd Zejddddd d
|
d d d d Z dS )ÚIsOrIsNotDistinctFromTestT)Zsupports_is_distinct_fromc
|
C s2 t d|tdtddtdtddtdtdd d S )NÚis_distinct_testr) Tr* Úcol_arÑ Úcol_brz r/ r2 r2 r3 r4 - s ûz'IsOrIsNotDistinctFromTest.define_tables)Zboth_int_differentr r5 r5 )Z both_int_samer5 r5 r )Zone_null_firstNr5 r5 )Zone_null_secondr Nr5 )Z both_nullNNr Ziaaaz3col_a_value, col_b_value, expected_row_count_for_is)Zid_r c C s | j j}| | ¡ d||dg¡ | | ¡ |jj |jj ¡¡¡
|
¡ }t t || |dkrbdnd}| | ¡ |jj |jj ¡¡¡
|
¡ }t t || d S )Nr5 )r) rÓ rÔ r )r; rÒ r: r< r rÛ rL rÓ Zis_distinct_fromrÔ rD r r} Zis_not_distinct_from)rF Z col_a_valueZ col_b_valueZexpected_row_count_for_isr> rÅ rG Z expected_row_count_for_is_notr2 r2 r3 Ú test_is_or_is_not_distinct_from7 s* þÿþÿÿþz9IsOrIsNotDistinctFromTest.test_is_or_is_not_distinct_fromN)
|
rN rO rP rQ rw rR r4 r rÍ rÕ r2 r2 r2 r3 rÑ ) s
|
ù rÑ )>Úcollections.abcr£ r_ rë r r r r r Z
|
assertionsr r r Z assertsqlr
|
rÏ r r r r r r r r r r r r r r r r r r r r r r! r" r# r$ Úexcr% r& Z
|
TablesTestr' rS ZTestBasers rx rÎ rÞ rñ r r# rv r¨ rµ rÄ rÈ rÏ rÑ r2 r2 r2 r3 Ú<module> s &M Jcdw
|
ÿ +Q/
|
