ó H`¾Tc@s‹ddlmZmZddlmZddlmZddlmZmZm Z m Z ddl m Z m Z dejfd„ƒYZd S( i(tfixturestconfig(teq_iÿÿÿÿ(tutil(tIntegertStringtselecttfunc(tTabletColumntOrderByLabelTestcBsheZdZeZed„ƒZed„ƒZd„Zd„Z d„Z d„Z d„Z d„Z RS( s©Test the dialect sends appropriate ORDER BY expressions when labels are used. This essentially exercises the "supports_simple_order_by_label" setting. c Cs_td|tdtdtƒtdtƒtdtƒtdtdƒƒtdtdƒƒƒdS( Nt some_tabletidt primary_keytxtytqi2tp(RR RtTrueR(tclstmetadata((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt define_tabless    cCs•tjj|jjjƒidd6dd6dd6dd6dd 6idd6dd6d d6d d6d d 6id d6d d6d d6dd6dd 6gƒdS(NiR RiRtq1Rtp3Ritq2tp2itq3tp1(RtdbtexecutettablesR tinsert(R((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt insert_datas  &&cCs#ttjj|ƒjƒ|ƒdS(N(RRRRtfetchall(tselfRtresult((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt_assert_result*scCsP|jj}|jjjdƒ}|jt|gƒj|ƒdddgƒdS(Ntlxiii(i(i(i(RR tcRtlabelR$Rtorder_by(R"ttableR%((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyt test_plain0s  cCsZ|jj}|jj|jjjdƒ}|jt|gƒj|ƒdddgƒdS(NR%iii(i(i(i( RR R&RRR'R$RR((R"R)R%((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_int8s  cCs»|jj}|jj|jjjdƒ}tj|jjƒ|jj jdƒ}|j t ||gƒj ||j ƒƒdtjdƒfdtjdƒfdtjdƒfgƒdS( NR%tlyitq1p3itq2p2itq3p1(RR R&RRR'RtlowerRRR$RR(tdescRtu(R"R)R%R,((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_multiple@s  (!cCsV|jj}|jjjdƒ}|jt|gƒj|jƒƒdddgƒdS(NR%iii(i(i(i( RR R&RR'R$RR(R1(R"R)R%((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_plain_descIs  cCs`|jj}|jj|jjjdƒ}|jt|gƒj|j ƒƒdddgƒdS(NR%iii(i(i(i( RR R&RRR'R$RR(R1(R"R)R%((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyttest_composed_int_descQs  (t__name__t __module__t__doc__Rt __backend__t classmethodRR R$R*R+R3R4R5(((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyR s     N(tRRt assertionsRt sqlalchemyRRRRRtschemaRR t TablesTestR (((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_select.pyts "