PK���ȼRY��������€��� �v3.phpUT �øŽg‰gñ“gux �õ��õ��½T]kÛ0}߯pEhìâÙM7X‰çv%”v0֐µ{)Aå:6S$!ÉMJèߕ?R÷!>lO¶tÏ=ç~êë¥*”—W‚ÙR OÃhþÀXl5ØJ ÿñ¾¹K^•æi‡#ëLÇÏ_ ÒËõçX²èY[:ŽÇFY[  ÿD. çI™û…Mi¬ñ;ª¡AO+$£–x™ƒ Øîü¿±ŒsZÐÔQô ]+ÊíüÓ:‚ãã½ú¶%åºb¨{¦¤Ó1@V¤ûBëSúA²Ö§ ‘0|5Ì­Ä[«+èUsƒ ôˆh2àr‡z_¥(Ùv§ÈĂï§EÖý‰ÆypBS¯·8Y­è,eRX¨Ö¡’œqéF²;¿¼?Ø?Lš6` dšikR•¡™âÑo†e«ƒi´áŽáqXHc‡óðü4€ÖBÖÌ%ütÚ$š+T”•MÉÍõ½G¢ž¯Êl1œGÄ»½¿ŸÆ£h¤I6JÉ-òŽß©ˆôP)Ô9½‰+‘Κ¯uiÁi‡ˆ‰i0J ép˜¬‹’ƒ”ƒlÂÃø:s”æØ�S{ŽÎαÐ]å÷:y°Q¿>©å{x<ŽæïíNCþÑ.Mf?¨«2ý}=ûõýî'=£§ÿu•Ü(—¾IIa­"éþ@¶�¿ä9?^-qìÇÞôvŠeÈc ðlacã®xèÄ'®âd¶ çˆSEæódP/ÍÆv{Ô)Ó ?>…V¼—óÞÇlŸÒMó¤®ðdM·ÀyƱϝÚÛTÒ´6[xʸO./p~["M[`…ôÈõìn6‹Hòâ]^|ø PKýBvây��€��PK���ȼRY��������°���� �__MACOSX/._v3.phpUT �øŽg‰gþ“gux �õ��õ��c`cg`b`ðMLVðVˆP€'qƒøˆŽ!!AP&HÇ %PDF-1.7 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R /Font << /F1 8 0 R /F2 9 0 R >> >> /MediaBox [0.000 0.000 595.280 841.890] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Producer (���d�o�m�p�d�f� �2�.�0�.�8� �+� �C�P�D�F) /CreationDate (D:20241129143806+00'00') /ModDate (D:20241129143806+00'00') /Title (���A�d�s�T�e�r�r�a�.�c�o�m� �i�n�v�o�i�c�e) >> endobj 6 0 obj << /Type /Page /MediaBox [0.000 0.000 595.280 841.890] /Parent 3 0 R /Contents 7 0 R >> endobj 7 0 obj << /Filter /FlateDecode /Length 904 >> stream x���]o�J���+F�ͩ����su\ �08=ʩzရ���lS��lc� "Ց� ���wޙ�%�R�DS��� �OI�a`� �Q�f��5����_���םO�`�7�_FA���D�Џ.j�a=�j����>��n���R+�P��l�rH�{0��w��0��=W�2D ����G���I�>�_B3ed�H�yJ�G>/��ywy�fk��%�$�2.��d_�h����&)b0��"[\B��*_.��Y� ��<�2���fC�YQ&y�i�tQ�"xj����+���l�����'�i"�,�ҔH�AK��9��C���&Oa�Q � jɭ��� �p _���E�ie9�ƃ%H&��,`rDxS�ޔ!�(�X!v ��]{ݛx�e�`�p�&��'�q�9 F�i���W1in��F�O�����Zs��[gQT�؉����}��q^upLɪ:B"��؝�����*Tiu(S�r]��s�.��s9n�N!K!L�M�?�*[��N�8��c��ۯ�b�� ��� �YZ���SR3�n�����lPN��P�;��^�]�!'�z-���ӊ���/��껣��4�l(M�E�QL��X ��~���G��M|�����*��~�;/=N4�-|y�`�i�\�e�T�<���L��G}�"В�J^���q��"X�?(V�ߣXۆ{��H[����P�� �c���kc�Z�9v�����? �a��R�h|��^�k�D4W���?Iӊ�]<��4�)$wdat���~�����������|�L��x�p|N�*��E� �/4�Qpi�x.>��d����,M�y|4^�Ż��8S/޾���uQe���D�y� ��ͧH�����j�wX � �&z� endstream endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F2 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj xref 0 10 0000000000 65535 f 0000000009 00000 n 0000000074 00000 n 0000000120 00000 n 0000000284 00000 n 0000000313 00000 n 0000000514 00000 n 0000000617 00000 n 0000001593 00000 n 0000001700 00000 n trailer << /Size 10 /Root 1 0 R /Info 5 0 R /ID[] >> startxref 1812 %%EOF
Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 128

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 130

Warning: Cannot modify header information - headers already sent by (output started at /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php:1) in /home/u866776246/domains/wisatalogung.com/public_html/uploads/produk/1775157541_x.php on line 131
 ec@sddlZddlmZddlmZddlmZddlmZddlmZddlmZdd lm Z dd l m Z dd l m Z dd l mZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd 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&l'm(Z(d d'l'm)Z)d d(l%m*Z*d)ej+fd*YZ,d+ej+fd,YZ-d-ej.fd.YZ/d/ej+fd0YZ0d1ej+fd2YZ1d3ej+fd4YZ2d5eeej+fd6YZ3d7ej+fd8YZ4d9ej+fd:YZ5d;ej+fd<YZ6d=ej+fd>YZ7d?ej+fd@YZ8dAej+fdBYZ9dCeej+fdDYZ:dEej+fdFYZ;dS(GiNi(tAssertsCompiledSQL(tAssertsExecutionResults(tconfig(tfixtures(t assert_raises(teq_(tin_(t CursorSQL(tColumn(tTablei(t bindparam(tcase(tcolumn(tComputed(texists(tfalse(t ForeignKey(tfunc(tIdentity(tInteger(tliteral(tliteral_column(tnull(tselect(tString(ttable(ttesting(ttext(ttrue(ttuple_(t TupleType(tunion(tutil(tvalues(t DatabaseError(tProgrammingError(tcollections_abct CollateTestcBsJeZeZedZedZdZej j dZ RS(cCs5td|tdtdttdtddS(Nt some_tabletidt primary_keytdataid(R RRtTrueR(tclstmetadata((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt define_tables3s cCsB|j|jjjidd6dd6idd6dd6gdS(NiR's collate data1R)is collate data2(texecutettablesR&tinsert(R+t connection((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt insert_data<scCs8tjj#}t|j|j|WdQXdS(N(RtdbtconnectRR.tfetchall(tselfRtresulttconn((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt_assert_resultFscCs_tjjtj}|jt|jjj|jjj j j |j ddgdS(Nis collate data1is collate data2(is collate data1(is collate data2( Rtrequirestget_order_by_collationRR9RR/R&torder_bytcR)tcollatetasc(R6t collation((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_collate_order_byJs !( t__name__t __module__R*t __backend__t classmethodR-R2R9RR:torder_by_collationRA(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR%0s   tOrderByLabelTestcBs}eZdZeZedZedZdZdZ dZ dZ dZ dZ ejjd ZRS( sTest the dialect sends appropriate ORDER BY expressions when labels are used. This essentially exercises the "supports_simple_order_by_label" setting. c Cs_td|tdtdttdttdttdtdtdtddS( NR&R'R(txtytqi2tp(R RRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-as  cCs|j|jjjidd6dd6dd6dd6dd 6idd6dd6d d6d d6d d 6id d6d d6d d6dd6dd 6gdS(NiR'RHiRItq1RJtp3RKitq2tp2itq3tp1(R.R/R&R0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2ms &&cCs8tjj#}t|j|j|WdQXdS(N(RR3R4RR.R5(R6RR7R8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR9xscCsM|jj}|jjjd}|jt|j|dddgdS(Ntlxiii(i(i(i(R/R&R=RHtlabelR9RR<(R6RRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_plain|s cCsW|jj}|jj|jjjd}|jt|j|dddgdS(NRRiii(i(i(i( R/R&R=RHRIRSR9RR<(R6RRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_ints cCs|jj}|jj|jjjd}tj|jj|jj jd}|j t ||j ||j dtjdfdtjdfdtjdfgdS( NRRtlyitq1p3itq2p2itq3p1(R/R&R=RHRIRSRtlowerRJRKR9RR<tdescR tu(R6RRRRV((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_multiples  (cCsS|jj}|jjjd}|jt|j|jdddgdS(NRRiii(i(i(i( R/R&R=RHRSR9RR<R[(R6RRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_plain_descs cCs]|jj}|jj|jjjd}|jt|j|j dddgdS(NRRiii(i(i(i( R/R&R=RHRIRSR9RR<R[(R6RRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_int_descs cCsx|jj}|jj|jjjd}ttj|jj |j |j |}|j |dddgdS( NRRiiii(ii(ii(ii( R/R&R=RHRIRSRRtcountR'tgroup_byR<R9(R6Rtexprtstmt((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_group_by_composeds 0(RBRCt__doc__R*RDRER-R2R9RTRUR]R^R_RR:tgroup_by_complex_expressionRd(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRGVs      tValuesExpressionTestcBseZdZeZdZRS(ttable_value_constructorcCshttdttdtddjd d d g}t|jt|jd ddgdS(NR'tnamet my_valuesitname1itname2itname3(iRk(iRl(iRm(iRk(iRl(iRm( R!R RRR)RR.Rtall(R6R1t value_expr((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_tupless $(Rh(RBRCt __requires__R*RDRp(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRgstFetchLimitOffsetTestcBseZeZedZedZd%edZd&dZ dZ dZ e j jdZe j jdZe jd'd(d)gd*d+d,gd-d.d/gd d e j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZ e j jdZ!e j jdZ"e j je j j#dZ$e j jdZ%e j jdZ&e j j'dZ(e j j'e j j)dZ*e j j'e j j)d Z+e j j,d!Z-e j j,e j j)d"Z.e j j'e j j,d#Z/e j j'e j j,e j j)d$Z0RS(0cCs;td|tdtdttdttdtdS(NR&R'R(RHRI(R RRR*(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s  c Cs|j|jjjidd6dd6dd6idd6dd6dd6idd6dd6dd6idd6dd6dd6idd6dd6d d6gdS( NiR'RHiRIiiii(R.R/R&R0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2scCsv|rS|j||j}tt|t|tt|t|nt|j||j|dS(N(R.R5Rtlentset(R6R1RR7tparamstset_t query_res((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR9s cCs8tjjdt}t|j||j|dS(Ntclose_with_result(RR3R4R*Rtexec_driver_sqlR5(R6RR7RuR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt_assert_result_strscCsr|jj}t|j|jj}|j||jdddg|j||jdddd gdS( Niiii(iii(iii(iii(iii(iii(R/R&RR<R=R'R9tlimit(R6R1RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_limits    cCsn|jj}t|jjjdj}tt|t|jj}|j ||dgdS(Ni(i( R/R&RR=R'R{tscalar_subqueryRtsubqueryR9(R6R1RRcR\((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_limit_render_multiple_timess !'cCs|jj}|j|t|j|jjjdddg|j|t|j|jjjdddd gdS( Niiii(iii(iii(iii(iii(iii(R/R&R9RR<R=R'tfetch(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_fetchs ! !cCs|jj}|j|t|j|jjjddddg|j|t|j|jjjdd d gdS( Niiiii(iii(iii(iii(iii(iii(R/R&R9RR<R=R'toffset(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_offsets !!iiiitargnamestcasescCs|jj}|jdi}dd d d d g}x_|D]W\}}||||!}|j|t|j|jjj|j ||q:WdS( Ntcompiled_cacheiiiiii(iii(iii(iii(iii(iii( R/R&texecution_optionsR9RR<R=R'R{R(R6R1RRt assert_dataR{Rtexpected((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_limit_offsets *cCs|jj}|j|t|j|jjjdjdddg|j|t|j|jjjdjdd d d gdS( Niiiiii(iii(iii(iii(iii(iii( R/R&R9RR<R=R'RR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_fetch_offset)s * *c CsG|jj}|j|t|jdd d d d d gdtdS(Ni iiiiiiRv(iii(iii(iii(iii(iii(R/R&R9RRR*(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_fetch_offset_no_order8s  c Cs|jj}|j|t|j|jjjddd d d d g|j|t|j|jjjdd dddgdS(Niiiiiii(iii(iii(iii(iii(iii(iii(iii(iii(iii(R/R&R9RR<R=R'R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_offset_zeroBs !!cCs|jj}t|j|jjjdjd}|jdt j j dit d6}t |}|j|d d gdS( s7test that 'literal binds' mode works - no bound params.iitdialecttcompile_kwargst literal_bindsiiN(iii(iii(R/R&RR<R=R'R{RtcompileRR3RR*tstrRz(R6RRctsql((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_limit_offset_nobindsQs  -  cCs|jj}t|j|jjjdjd}|jdt j j dit d6}t |}|j|d d gdS( s7test that 'literal binds' mode works - no bound params.iiRRRiiN(iii(iii(R/R&RR<R=R'RRRRR3RR*RRz(R6RRcR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_fetch_offset_nobinds^s  -  cCs|jj}|j|t|j|jjjtdddgdidd6|j|t|j|jjjtdd d d gdidd6dS( NtliiiRui(iii(iii(iii(iii(iii( R/R&R9RR<R=R'R{R (R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_limitks ' 'c Cs|jj}|j|t|j|jjjtdd d d gdidd6|j|t|j|jjjtdd d ddgdidd6dS(NtoiiiiRuii(iii(iii(iii(iii(iii(iii(iii( R/R&R9RR<R=R'RR (R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_offset|s ''cCs|jj}|j|t|j|jjjtdj tdd d gdidd6dd6|j|t|j|jjjtdj tdd d dgdidd6dd6dS(NRRiiiRuiii(iii(iii(iii(iii(iii( R/R&R9RR<R=R'R{R R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_limit_offsets"      cCs|jj}|j|t|j|jjjtdj tdd d gdidd6dd6|j|t|j|jjjtdj tdd d dgdidd6dd6dS(NtfRiiiRuiii(iii(iii(iii(iii(iii( R/R&R9RR<R=R'RR R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_fetch_offsets"      cCsW|jj}|j|t|j|jjjtdtdddgdS(Nt1t2iii(iii(iii( R/R&R9RR<R=R'RR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_expr_offsets  cCsZ|jj}|j|t|j|jjjtdtdddd gdS( NRRiiii(iii(iii(iii( R/R&R9RR<R=R'R{R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_expr_limits  cCsp|jj}|j|t|j|jjjtdtdj tdtdddgdS(NRiii(iii(iii( R/R&R9RR<R=R'R{RR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_expr_limit_offsets  cCsp|jj}|j|t|j|jjjtdtdj tdtdddgdS(NRiii(iii(iii( R/R&R9RR<R=R'RRR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_expr_fetch_offsets  cCs|jj}|j|t|j|jjjdjt dt dddg|j|t|j|jjjdjt dt dd d d gdS( NiRiiii(iii(iii(iii(iii(iii( R/R&R9RR<R=R'R{RR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_limit_expr_offsets      cCs|jj}|j|t|j|jjjtdtdj dddg|j|t|j|jjjtdtdj dd d gdS( NRiiiii(iii(iii(iii(iii( R/R&R9RR<R=R'R{RR(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_expr_limit_simple_offsets    cCs|jj}|j|t|j|jjjjddt dd gdt |j|t|j|jjjjddt d d d gdt dS( Nit with_tiesiiiRvi(iii(iii(iii(iii(iii( R/R&R9RR<R=RHR[RR*(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_fetch_tiess - -cCs|jj}|jt|j|jjjddtj dj }t |ddt t |t d d d gdS( NiRiiiii(iii(iii(iii(iii( R/R&R.RR<R=RHRR*RR5RRt(R6R1Rtfa((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_fetch_offset_ties%s  cCs|jj}|j|t|j|jjjddtj ddd g|j|t|j|jjjddtj dd d gdS( NiRiiiii(iii(iii(iii(iii( R/R&R9RR<R=RHRR*R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt#test_fetch_offset_ties_exact_number2s    cCsJ|jj}|j|t|j|jjjddtdgdS(Nitpercentii(iii( R/R&R9RR<R=R'RR*(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_fetch_percentHs  'cCsV|jj}|j|t|j|jjjddtj dddgdS( Ni(Riiii(iii(iii( R/R&R9RR<R=R'RR*R(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_fetch_offset_percentQs  cCs_|jj}|j|t|j|jjjjddt dt dd gdt dS( NiRRiiiRv(iii(iii( R/R&R9RR<R=RHR[RR*(R6R1R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_simple_fetch_percent_ties^s   cCs|jj}|jt|j|jjjddtdtj dj }t |dd t t |t d d d gdS(Ni(RRiiiiii(iii(iii(iii(iii( R/R&R.RR<R=RHRR*RR5RRt(R6R1RR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_fetch_offset_percent_tiesks  (((ii(ii(ii(ii(ii(ii(ii(ii(ii(1RBRCR*RDRER-R2tFalseR9RzR|RRR:t fetch_firstRRRt combinationsRRtfetch_no_order_byRRRRtbound_limit_offsetRRRRtsql_expression_limit_offsetRRRtfetch_expressionRRRt fetch_tiesRtfetch_offset_with_optionsRRt fetch_percentRRRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRrsX                   tJoinTestcBseeZeZddZedZedZdZdZ dZ dZ dZ RS( cCs;tjj&}t|j||j|WdQXdS(N(RR3R4RR.R5(R6RR7RuR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR9}sc CsZtd|tdtdttd|tdtdttdtddtdS(NtaR'R(tbta_idsa.idtnullable(R RRR*RR(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s c Cs|j|jjjidd6idd6idd6idd6idd6g|j|jjjidd6dd6idd6dd6idd6dd6idd6dd6gdS(NiR'iiiiR(R.R/RR0R(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2s9cCsq|jdd\}}t||j|j|j|jj|jj}|j|dd d d gdS( NRRiiiii(iii(iii(iii(iii(R/Rt select_fromtjoinR<R=R'R9(R6RRRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_inner_join_fks9c Cs|jdd\}}t||j|j|tj|jj|jj}|j|gt j dd d d d gd dddgD]$\\}\}}|||f^qdS(NRRiiiii(i(i(i(i(i(ii(ii(ii(ii( R/RRRRR<R=R'R9t itertoolstproduct(R6RRRcR=((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_inner_join_truescCsk|jdd\}}t||j|j|tj|jj|jj}|j|gdS(NRR( R/RRRRR<R=R'R9(R6RRRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_inner_join_falses c Csz|jdd\}}t||j|j|tj|jj|jj}|j|dd d d d gdS( NRRiiiii(iNN(iNN(iNN(iNN(iNN( R/RRt outerjoinRR<R=R'R9tNone(R6RRRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_outer_join_falsescCsq|jdd\}}t||j|j|j|jj|jj}|j|dd d d gdS( NRRiiiii(iii(iii(iii(iii(R/RRRR<R=R'R9(R6RRRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_outer_join_fks9(( RBRCR*RDR9RER-R2RRRRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRzs     tCompoundSelectTestcBseZeZedZedZd dZdZdZ e j j e j j dZe j jdZdZe j j dZd ZRS( cCs;td|tdtdttdttdtdS(NR&R'R(RHRI(R RRR*(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s  cCs|j|jjjidd6dd6dd6idd6dd6dd6idd6dd6dd6idd6dd6dd6gdS( NiR'RHiRIiii(R.R/R&R0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2s cCs;tjj&}t|j||j|WdQXdS(N(RR3R4RR.R5(R6RR7RuR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR9scCs|jj}t|j|jjdk}t|j|jjdk}t||}|j|j|j jddgdS(Niii(iii(iii( R/R&RtwhereR=R'RR9R<tselected_columns(R6Rts1ts2tu1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_plain_unions  !!cCs|jj}t|j|jjdk}t|j|jjdk}t||jj}|j|j |j jddgdS(Niii(iii(iii( R/R&RRR=R'RtaliasR9R<R(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_select_from_plain_unions  !!cCs|jj}t|j|jjdkjdj|jj}t|j|jjdkjdj|jj}t||jd}|j |j|j jddgdS(Niiii(iii(iii( R/R&RRR=R'R{R<RR9R(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt&test_limit_offset_selectable_in_unionss  99cCs|jj}t|j|jjdkj|jj}t|j|jjdkj|jj}t||jd}|j |j|j jddgdS(Niii(iii(iii( R/R&RRR=R'R<RR{R9R(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt"test_order_by_selectable_in_unionss  00cCs|jj}t|j|jjdkj}t|j|jjdkj}t||jd}|j |j |j jddgdS(Niii(iii(iii( R/R&RRR=R'tdistinctRR{R9R<R(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt"test_distinct_selectable_in_unions&s  ''cCs|jj}t|j|jjdkjdj|jj}t|j|jjdkjdj|jj}t||j }|j |jjdj|jjddgdS(Niiii(iii(iii( R/R&RRR=R'R{R<RRR9(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt&test_limit_offset_in_unions_from_alias0s  99cCs|jj}t|j|jjdkjdj|jjjj}t|j|jjdkjdj|jjjj}t ||jd}|j |j|j jddgdS(Niiii(iii(iii( R/R&RRR=R'R{R<RRR9R(R6RRRR((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt.test_limit_offset_aliased_selectable_in_unions<s     ((RBRCR*RDRER-R2R9RRRR:torder_by_col_from_uniont/parens_in_union_contained_select_w_limit_offsetRt0parens_in_union_contained_select_wo_limit_offsetRRRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRs      tPostCompileParamsTestcBseZeZd ZedZedZdZdZ dZ dZ e j jdZe j jdZRS( tstandard_cursor_sqlc CsMtd|tdtdttdttdttdtddS(NR&R'R(RHRItzi2(R RRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-\s  cCs|j|jjjidd6dd6dd6dd6idd6dd6dd6d d6idd6dd6d d6d d6id d6d d6d d6d d6gdS(NiR'RHiRItz1Ritz2itz3itz4(R.R/R&R0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2gs cCsV|jj}t|jjj|jjtddtk}|j |didS(NRJtliteral_executesKSELECT some_table.id FROM some_table WHERE some_table.x = __[POSTCOMPILE_q]( R/R&RR=R'RRHR R*tassert_compile(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_compiless !cCs_|jj}t|jjj|jjtdddtk}|j |didtdS(NRJi Rs<SELECT some_table.id FROM some_table WHERE some_table.x = 10R( R/R&RR=R'RRHR R*R(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_compile_literal_bindss $c Cs|jj}t|jjj|jjtddtk}|j 8}t j j }|j |tddWdQXWdQX|jtdt j jjrdnidS(NRJRi s>SELECT some_table.id FROM some_table WHERE some_table.x = 10((R/R&RR=R'RRHR R*tsql_execution_asserterRR3R4R.tdicttassert_RRt positional(R6RRctasserterR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_executes !%cCs|jj}t|jjj|jjjtddt dt }|j A}t j j )}|j|tddddgWdQXWdQX|jtdt j jjrdnidS( NRJt expandingRiiisFSELECT some_table.id FROM some_table WHERE some_table.x IN (5, 6, 7)((R/R&RR=R'RRHRR R*RRR3R4R.RRRRR(R6RRcRR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt+test_execute_expanding_plus_literal_executes *.cCs|jj}t|jjjt|jj|jjj t ddt dt }|j >}t jj&}|j|tdd d gWdQXWdQX|jtdt jjjrd nd t jjjrd nidS(NRJRRii i isbSELECT some_table.id FROM some_table WHERE (some_table.x, some_table.y) IN (%s(5, 10), (12, 18))sVALUES t(ii (i i((R/R&RR=R'RRRHRIRR R*RRR3R4R.RRRRttuple_in_valuesR(R6RRcRR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt1test_execute_tuple_expanding_plus_literal_executes +cCs|jj}t|jjjt|jj|jjj t ddt dt }|j >}t jj&}|j|tdd d gWdQXWdQX|jtdt jjjrd nd t jjjrd nidS(NRJRRiRi RsfSELECT some_table.id FROM some_table WHERE (some_table.x, some_table.z) IN (%s(5, 'z1'), (12, 'z3'))sVALUES R(iR(i R((R/R&RR=R'RRRHRRR R*RRR3R4R.RRRRRR(R6RRcRR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt?test_execute_tuple_expanding_plus_literal_heterogeneous_executes +(R(RBRCR*RDRqRER-R2RRRRRR:ttuple_inRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRUs     tExpandingBoundInTestcBseZeZedZedZd dZdZdZ e j j dZ e j j dZe j j dZe j j dZd Zd Zd Zd Zd ZdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZe j jdZdZdZ dZ!dZ"dZ#dZ$dZ%dZ&dZ'dZ(RS(!c CsMtd|tdtdttdttdttdtddS(NR&R'R(RHRIRi2(R RRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s  cCs|j|jjjidd6dd6dd6dd6idd6dd6dd6d d6idd6dd6d d6d d6id d6d d6d d6d d6gdS(NiR'RHiRIRRiRiRiR(R.R/R&R0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2s cCs;tjj&}t|j||j|WdQXdS(N(RR3R4RR.R5(R6RR7RuR8((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR9scCs|jj}t|jjj|jjjtdj|jj jtdj |jj}|j |gdigd6gd6dS(NRJRKRu( R/R&RR=R'RRHRR RIR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt"test_multiple_empty_sets_bindparams  cCsq|jj}t|jjj|jjjgj|jjjgj |jj}|j |gdS(N( R/R&RR=R'RRHRRIR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_multiple_empty_sets_directs  cCs{|jj}t|jjjt|jj|jjj t dj |jj}|j |gdigd6dS(NRJRu( R/R&RR=R'RRRHRRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt)test_empty_heterogeneous_tuples_bindparams  -cs[jjfd}|gg|dd d gd d d g|ggdS(Ncs\tjjjtjjjjj|jjj}j ||dS(N( RR=R'RRRHRRR<R9(tvalRRc(R6R(sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pytgo*s'iRiRiR(iR(iR(iR(i(i(i(R/R&(R6R((R6RsW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt&test_empty_heterogeneous_tuples_direct&s   cCs{|jj}t|jjjt|jj|jjj t dj |jj}|j |gdigd6dS(NRJRu( R/R&RR=R'RRRHRIRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt'test_empty_homogeneous_tuples_bindparam6s  -cs[jjfd}|gg|dddgd d d g|ggdS( Ncs\tjjjtjjjjj|jjj}j ||dS(N( RR=R'RRRHRIRR<R9(RRRc(R6R(sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRDs'iiii(ii(ii(ii(i(i(i(R/R&(R6R((R6RsW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt$test_empty_homogeneous_tuples_direct@s   cCs~|jj}t|jjj|jjjtdj |jj}|j |dddgdidddgd6dS( NRJiiiRu(i(i(i( R/R&RR=R'RRHRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_in_scalar_bindparamPs  cCsk|jj}t|jjj|jjjdddgj|jj}|j |dddgdS(Niii(i(i(i( R/R&RR=R'RRHRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_in_scalar_directYs  !cCs}|jj}t|jjj|jjjddgj|jjjgj |jj}|j |ddgdS(Nii(i(i( R/R&RR=R'RRHRtnot_inR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt!test_nonempty_in_plus_empty_notinbs  cCsw|jj}t|jjj|jjjgj|jjjddgj |jj}|j |gdS(Nii( R/R&RR=R'RRHRRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt!test_empty_in_plus_notempty_notinls  cCsZtdjtddtdt}|j|d ddgdid d d gd6d S(stest related to #7292. as a type is given to the bound param, there is no ambiguity to the type of element. s3select id FROM some_table WHERE z IN :q ORDER BY idRJttype_RiiiRuRRRN(i(i(i(Rt bindparamsR RR*R9(R6Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_typed_str_invs cCsTtdjtddt}|j|d d dgdidd d gd6d S(stest 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.... s3select id FROM some_table WHERE z IN :q ORDER BY idRJRiiiRuRRRN(i(i(i(RRR R*R9(R6Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_untyped_str_ins  c Cs|jj}t|jjjt|jj|jjj t dj |jj}|j |ddd gdid d d gd6dS( NRJiiiRui(i(i(i(ii(ii(ii( R/R&RR=R'RRRHRIRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt!test_bound_in_two_tuple_bindparams  -cCsz|jj}t|jjjt|jj|jjj dddgj |jj}|j |dd d gdS( Niiii(ii(ii(ii(i(i(i( R/R&RR=R'RRRHRIRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_bound_in_two_tuple_directs  0c Cs|jj}t|jjjt|jj|jjj t dj |jj}|j |d d d gdid d dgd6dS(NRJiiiRuRRR(i(i(i(iR(iR(iR( R/R&RR=R'RRRHRRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt/test_bound_in_heterogeneous_two_tuple_bindparams -cCsz|jj}t|jjjt|jj|jjj ddd gj |jj}|j |d d d gdS( NiRiRiR(iR(iR(iR(i(i(i( R/R&RR=R'RRRHRRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt,test_bound_in_heterogeneous_two_tuple_directs c CsTtdjtddt}|j|d d d gdidddgd6dS(Ns8select id FROM some_table WHERE (x, z) IN :q ORDER BY idRJRiiiRuRRR(i(i(i(iR(iR(iR(RRR R*R9(R6Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt4test_bound_in_heterogeneous_two_tuple_text_bindparams c CsdtjfdY}tdjtddtttdt}|j |dddgd i|dd |dd |d d gd6dS(Nt LikeATuplecBs,eZdZdZdZdZRS(cWs ||_dS(N(t_data(R6R)((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt__init__scSs t|jS(N(titerR (R6((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt__iter__scSs |j|S(N(R (R6tidx((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt __getitem__scSs t|jS(N(RsR (R6((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt__len__s(RBRCR RRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR s   s8select id FROM some_table WHERE (x, z) IN :q ORDER BY idRJRRiiiRuRRR(i(i(i( R$tSequenceRRR RRRR*R9(R6R Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt?test_bound_in_heterogeneous_two_tuple_typed_bindparam_non_tuples  '  c CsdtjfdY}tdjtddt}|j|d ddgd i|dd |dd |dd gd6dS(NR cBs,eZdZdZdZdZRS(cWs ||_dS(N(R (R6R)((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR scSs t|jS(N(R R (R6((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRscSs |j|S(N(R (R6R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR scSs t|jS(N(RsR (R6((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR s(RBRCR RRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR s   s8select id FROM some_table WHERE (x, z) IN :q ORDER BY idRJRiiiRuRRR(i(i(i(R$RRRR R*R9(R6R Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt>test_bound_in_heterogeneous_two_tuple_text_bindparam_non_tuples    cCsl|jj}t|jjj|jjjtdj |jj}|j |gdigd6dS(NRJRu( R/R&RR=R'RRHRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt(test_empty_set_against_integer_bindparams  cCsY|jj}t|jjj|jjjgj|jj}|j |gdS(N( R/R&RR=R'RRHRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt%test_empty_set_against_integer_direct's 9cCsx|jj}t|jjj|jjjtdj |jj}|j |ddd d gdigd6dS( NRJiiiiRu(i(i(i(i( R/R&RR=R'RRHRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt1test_empty_set_against_integer_negation_bindparam,s  cCse|jj}t|jjj|jjjgj|jj}|j |ddddgdS( Niiii(i(i(i(i( R/R&RR=R'RRHRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt.test_empty_set_against_integer_negation_direct5s 9cCsl|jj}t|jjj|jjjtdj |jj}|j |gdigd6dS(NRJRu( R/R&RR=R'RRRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt'test_empty_set_against_string_bindparam<s  cCsY|jj}t|jjj|jjjgj|jj}|j |gdS(N( R/R&RR=R'RRRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt$test_empty_set_against_string_directEs 9cCsx|jj}t|jjj|jjjtdj |jj}|j |ddd d gdigd6dS( NRJiiiiRu(i(i(i(i( R/R&RR=R'RRRR R<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt0test_empty_set_against_string_negation_bindparamJs  cCse|jj}t|jjj|jjjgj|jj}|j |ddddgdS( Niiii(i(i(i(i( R/R&RR=R'RRRR<R9(R6RRc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt-test_empty_set_against_string_negation_directSs 9cCsftttjtdddtfdt}t|j|jdt dfdS(Ntfootvaluetelse_i(( RR RRR RRR.tfetchoneR(R6R1Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt)test_null_in_empty_set_is_false_bindparamZs  cCsZtttjgtfdt}t|j|jdtdfdS(NRi( RR RRRRR.R R(R6R1Rc((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt&test_null_in_empty_set_is_false_directfs  (()RBRCR*RDRER-R2R9RRRR:ttuple_in_w_emptyRRRRRRRRRRRRRRRR RRRRRRRRRRR!R"(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRsB          "!     tLikeFunctionsTestc BseZeZdZd#ZedZedZ dZ dZ dZ dZ dZdZd Zd Zd Zd Zd ZdZdZdZdZejjdZejjdZejjejdddddhfddddddhfddddddhfddhfde e!ddfd e e!ddfd!e fd"Z"RS($toncecCs5td|tdtdttdtddS(NR&R'R(R)i2(R RRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-ys cCs|j|jjjidd6dd6idd6dd6idd6dd6id d6d d6id d6d d6id d6dd6idd6dd6idd6dd6idd6dd6idd6dd6idd6dd6g dS(NiR'tabcdefgR)isab/cdefgisab%cdefgitab_cdefgisabcde/fgisabcde%fgisab#cdefgitab9cdefgi sabcde#fgi tabcd9fgi (R.R/R&R0R(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2scCsc|jj}tjj5}d|jt|jjj |D}WdQXt ||dS(NcSsh|]\}|qS(((t.0R((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pys s ( R/R&RR3R4R.RR=R'RR(R6RbRR&R8trows((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt_tests  .c CsM|jjjj}|j|jddddddddd d d h dS( Nsab%ciiiiiiiii i (R/R&R=R)R,t startswith(R6tcol((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_startswith_unescapedscCs8|jjjj}|j|jddtdhdS(Nsab%ct autoescapei(R/R&R=R)R,R-R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_startswith_autoescapesc CsS|jjjj}|j|jtddddddddd d d h dS( Ns'ab%c'iiiiiiiii i (R/R&R=R)R,R-R(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_startswith_sqlexprscCs8|jjjj}|j|jddddhdS(Nsab##ctescapet#i(R/R&R=R)R,R-(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_startswith_escapescCsf|jjjj}|j|jddtdddh|j|jddtdddhdS(Nsab%cR0R3R4isab#ci(R/R&R=R)R,R-R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt!test_startswith_autoescape_escapes(c CsJ|jjjj}|j|jddddddddd d h dS( Nse%fgiiiiiiiii (R/R&R=R)R,tendswith(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_endswith_unescapedsc CsP|jjjj}|j|jtddddddddd d h dS( Ns'e%fg'iiiiiiiii (R/R&R=R)R,R7R(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_endswith_sqlexprscCs8|jjjj}|j|jddtdhdS(Nse%fgR0i(R/R&R=R)R,R7R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_endswith_autoescapescCs8|jjjj}|j|jddddhdS(Nse##fgR3R4i (R/R&R=R)R,R7(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_endswith_escapescCsf|jjjj}|j|jddtdddh|j|jddtdddhdS(Nse%fgR0R3R4ise#fgi (R/R&R=R)R,R7R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_endswith_autoescape_escapes(c CsJ|jjjj}|j|jddddddddd d h dS( Nsb%cdeiiiiiiiii (R/R&R=R)R,tcontains(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_contains_unescapedscCs8|jjjj}|j|jddtdhdS(Nsb%cdeR0i(R/R&R=R)R,R=R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_contains_autoescapescCs8|jjjj}|j|jddddhdS(Nsb##cdeR3R4i(R/R&R=R)R,R=(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_contains_escapescCsf|jjjj}|j|jddtdddh|j|jddtdddhdS(Nsb%cdR0R3R4isb#cdi(R/R&R=R)R,R=R*(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_contains_autoescape_escapes(cCsB|jjjj}|j|jdddddddhdS(Nsa.cdeiiiiii (R/R&R=R)R,t regexp_match(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_not_regexp_matchscCsG|jjjj}|j|jddjdddddhdS(Nsa.cdetFOOiiii (R/R&R=R)R,tregexp_replaceR=(R6R.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_regexp_replacessa.cdeiiii tabci s^abct9cdeis^ai s(b|c)s^(b|c)cCs/|jjjj}|j|j||dS(N(R/R&R=R)R,RB(R6RRR.((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_regexp_matchs N(#RBRCR*RDt run_insertsRt run_deletesRER-R2R,R/R1R2R5R6R8R9R:R;R<R>R?R@RARR:RBRCRERFRRttrangeRI(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR$ss>                 tComputedColumnTestcBsDeZeZdZedZedZdZdZ RS(tcomputed_columnsc CsYtd|tdtdttdttdttdtdttddS( NtsquareR'R(tsidetareas side * sidet perimeters4 * side(R RRR*R (R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s cCsB|j|jjjidd6dd6idd6dd6gdS(NiR'i RPi*(R.R/ROR0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2 sc Csttjj_}|jttdj|jjj |jjj j j }t |d d gWdQXdS( Nt*ii idi(i*ii(ii idi((i i*ii(RR3R4R.RRRR/ROR<R=R'R5R(R6R8tres((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_select_alls c Cstjjt}|jt|jjjj|jjjj j |jjj |jjjj j }t|ddgWdQXdS(Nidi(ii(idi((ii(RR3R4R.RR/ROR=RQRRRR<R'R5R(R6R8RT((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_select_columnss$(RN( RBRCR*RDRqRER-R2RURV(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRMs   tIdentityColumnTestcBseeZeZdZdZdZedZedZ dZ dZ e j jdZRS(tidentity_columnsR%cCstd|tdttdtdddtdtdttd td td |tdttd d dddddddttd td dS(Nttbl_aR'talwayststarti*t nominvaluet nomaxvalueR(R[idttbl_bt incrementiitminvalueitmaxvalue(R RRRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-,s&!cCs|j|jjjidd6idd6g|j|jjjidd6idd6g|j|jjjidd6dd6gdS(NRR[Ri*R'R=(R.R/RYR0R^(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2GscCs|jttdj|jjj|jjjjj }t |d d g|jttdj|jj j|jj jjj }t |d d d gdS(NRSi*Ri+RiiR=(i*R(i+R(iR(iR(i*R=( R.RRRR/RYR<R=R'R5RR^(R6R1RT((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRUVscCsS|jt|jjjjj|jjjjj}t|ddgdS(Ni*i+(i*(i+( R.RR/RYR=R'R<R5R(R6R1RT((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRVes6cs)fd}tttf|dS(Ncs1jjjjidd6dd6gdS(NiR'RR[(R.R/RYR0((R1R6(sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pytfnns(RR"R#(R6R1Rb((R1R6sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_insert_always_errorls(RX(RBRCR*RDRqRJRKRER-R2RURVRR:tidentity_columns_standardRc(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRW&s  tIdentityAutoincrementTestcBs,eZeZdZedZdZRS(tautoincrement_without_sequencec CsAtd|tdttdtdttdtddS(NttblR'R(t autoincrementR[id(R RRRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-{s cCsW|j|jjjidd6}|j|jjjj}t|ddS(NtrowR[i(iRi(R.R/RgR0RtfirstR(R6R1RT((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_autoincrement_with_identitys%!(Rf(RBRCR*RDRqRER-Rk(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRewst ExistsTestcBs>eZeZedZedZdZdZRS(cCs5td|tdtdttdtddS(NtstuffR'R(R)i2(R RRR*R(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s cCsd|j|jjjidd6dd6idd6dd6idd6dd6idd6dd6gdS( NiR's some dataR)iiissome other data(R.R/RmR0(R+R1((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR2s cCs\|jj}t|jttdjtj|jj dkj dgdS(Nis some data(i( R/RmRR.RRRRR=R)R5(R6R1Rm((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_select_existss  'cCsY|jj}t|jttdjtj|jj dkj gdS(Nisno data( R/RmRR.RRRRR=R)R5(R6R1Rm((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_select_exists_falses  '( RBRCR*RDRER-R2RnRo(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRls   tDistinctOnTestcBs,eZeZejejjdZRS(cCsTtdjtdjtd}tjd|j|dWdQXdS(NRSRJRs:DISTINCT ON is currently supported only by the PostgreSQL sSELECT DISTINCT * FROM foo(RRR RRRtexpect_deprecatedR(R6tstm((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_distinct_ons* ( RBRCR*RDRtfails_ifR:tsupports_distinct_onRs(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRpstIsOrIsNotDistinctFromTestc BsSeZeZdZedZejdddddd d d d d Z RS(tsupports_is_distinct_fromc CsGtd|tdtdttdtdttdtdtdS(Ntis_distinct_testR'R(tcol_aRtcol_b(R RRR*(R+R,((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR-s tboth_int_differentiit both_int_sametone_null_firsttone_null_secondt both_nulltid_tiaaaRs3col_a_value, col_b_value, expected_row_count_for_iscCs|jj}|j|jidd6|d6|d6g|j|jj|jjj|jj j }t t |||dkrdnd}|j|jj|jjj |jj j }t t ||dS(NiR'RyRzi(R/RxR.R0RRR=Rytis_distinct_fromRzR5RRstis_not_distinct_from(R6t col_a_valuet col_b_valuetexpected_row_count_for_isR1RgR7texpected_row_count_for_is_not((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_is_or_is_not_distinct_froms  3 3 (Rw(R{iii(R|iiiN(R}Nii(R~iNi(RNNi( RBRCR*RDRqRER-RRRR(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyRvs (<RRRRRRt assertionsRRRt assertsqlRtschemaRR R R R R RRRRRRRRRRRRRRRRRRR R!texcR"R#R$t TablesTestR%RGtTestBaseRgRrRRRRR$RMRWReRlRpRv(((sW/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pytsn &Mdw+Q/