ó H`¾Tc@sÜddlmZmZddlmZddlmZddlmZddlmZddlm Z m Z m Z m Z m Z mZddlZdd lmZmZd ejfd „ƒYZd ejfd „ƒYZdS(i(tfixturestconfig(t requirements(t exclusions(teq_(tenginesiÿÿÿÿ(tIntegertStringtselecttutiltsqltDateTimeN(tTabletColumnt RowFetchTestcBsbeZeZed„ƒZed„ƒZd„Zd„Zd„Z e j d„ƒZ d„Z RS(cCs`td|tdtdtƒtdtdƒƒƒtd|tdtdtƒtdtƒƒdS(Ntplain_pktidt primary_keytdatai2t has_datesttoday(R R RtTrueRR (tclstmetadata((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyt define_tabless   c Csžtjj|jjjƒidd6dd6idd6dd6idd6dd6gƒtjj|jjjƒidd6tjd d d d d d ƒd 6gƒdS(NiRtd1Ritd2itd3iÖii iR(RtdbtexecutettablesRtinsertRtdatetime(R((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyt insert_datas  cCs_tjj|jjjƒj|jjjjƒƒj ƒ}t |ddƒt |ddƒdS(NRiRR( RRRRRRtorder_bytcRtfirstR(tselftrow((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_via_string,s cCs_tjj|jjjƒj|jjjjƒƒj ƒ}t |ddƒt |ddƒdS(NiiR( RRRRRRR"R#RR$R(R%R&((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyt test_via_int9s cCswtjj|jjjƒj|jjjjƒƒj ƒ}t ||jjjjdƒt ||jjjj dƒdS(NiR( RRRRRRR"R#RR$RR(R%R&((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_via_col_objectFs cCsŠtjjt|jjjj|jjjjjdƒgƒj |jjjj ƒƒ}|j ƒ}t |j ƒddgƒt |dƒdS(NRR(sd1sd1(RRRRRRR#RtlabelR"RR$Rtkeys(R%tresultR&((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_row_with_dupe_namesSs ! c Cs–|jj}t|jdƒjjgƒjƒ}t|jj|jdƒgƒ}t j j |ƒj ƒ}t |dtjddddddƒƒdS(sýtest that a scalar select as a column is returned as such and that type conversion works OK. (this is half a SQLAlchemy Core test and half to catch database backends that may have unusual behavior with scalar selects.) txt somelabeliÖii iN(RRRtaliasR#Rt as_scalarRR*RRRR$RR (R%t datetabletsts2R&((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_row_w_scalar_select^s  $!(t__name__t __module__Rt __backend__t classmethodRR!R'R(R)Rt%duplicate_names_in_cursor_descriptionR-R5(((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyR s   tPercentSchemaNamesTestcBsDeZdZdZeZed„ƒZd„Zd„Z d„Z RS(sÜtests using percent signs, spaces in table and column names. This is a very fringe use case, doesn't work for MySQL or Postgresql. the requirement, "percent_schema_names", is marked "skip" by default. tpercent_schema_namescCs^td|tdtƒtdtƒƒ|j_tjdtjdƒtjdƒƒ|j_dS(Ns percent%tablespercent%sspaces % more spaces( R R RRt percent_tableR ttabletcolumntlightweight_percent_table(RR((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyR{s  cCsˆ|jj}xkidd6dd6idd6dd6idd6dd6idd6dd6gD]}tjj|jƒ|ƒqWW|jƒdS( Nispercent%i sspaces % more spacesii i i (RR=RRRRt _assert_table(R%R=tparams((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_single_roundtrip‡s cCs|jj}tjj|jƒidd6dd6ƒtjj|jƒidd6dd6idd6dd6idd6dd6gƒ|jƒdS( Nispercent%i sspaces % more spacesii i i (RR=RRRRRA(R%R=((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyttest_executemany_roundtrip’s     cCsÎ|jj}|jj}xA||jƒ||jƒfD]!}tttjj|j ƒj |j dƒƒƒd d d d gƒtttjj|j ƒj |j dj ddgƒƒj |j dƒƒƒddgƒtjj|j ƒj |j dƒƒjƒ}t|ddƒt|ddƒt||j ddƒt||j ddƒq7Wtjj|jƒjid |j d6ƒƒtttjj|j ƒj |j dƒƒƒddddgƒdS(Nspercent%ii ii i i sspaces % more spacesi(ii (ii (i i (i i (i i (i i (ii(ii(i i(i i(RR=R@R0RtlistRRRRR"R#twheretin_R$tupdatetvalues(R%R=R@R>R&((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyRA sL            (R<( R6R7t__doc__t __requires__RR8R9RRCRDRA(((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyR;ns (tRRRRt assertionsRRt sqlalchemyRRRR R R R tschemaR R t TablesTestRR;(((sk/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_results.pyts. b