ó H`¾Tc@sãddlmZmZddlmZddlmZddlmZddlmZddlm Z m Z m Z m Z ddl mZmZd ejfd „ƒYZd ejfd „ƒYZd ejfd„ƒYZdZdS(i(tfixturestconfig(t requirements(t exclusions(teq_(tenginesiÿÿÿÿ(tIntegertStringtselecttutil(tTabletColumnt LastrowidTestcBsceZdZeZd Zied6Zed„ƒZ d„Z d„Z d„Z e jd„ƒZRS( teachtimplements_get_lastrowidtautoincrement_inserttimplicit_returningc Csrtd|tdtdtdtƒtdtdƒƒƒtd|tdtdtdtƒtdtdƒƒƒdS( Nt autoinc_pktidt primary_keyttest_needs_autoincrementtdatai2t manual_pkt autoincrement(R R RtTrueRtFalse(tclstmetadata((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt define_tabless  cCs;|j|jƒƒjƒ}t|tjjjdfƒdS(Ns some data(texecuteRtfirstRRtdbtdialecttdefault_sequence_base(tselfttabletconntrow((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt_assert_round_trip"scCs?tjj|jjjƒddƒ|j|jjtjƒdS(NRs some data(RRRttablesRtinsertR&(R"((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_autoincrement_on_insert)s cCsbtjj|jjjƒddƒ}tjjt|jjjj gƒƒ}t |j |gƒdS(NRs some data( RRRR'RR(tscalarRtcRRtinserted_primary_key(R"trtpk((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_last_inserted_id1s  'cCsetjj|jjjƒddƒ}|j}tjjt|jjj j gƒƒ}t ||ƒdS(NRs some data( RRRR'RR(t lastrowidR*RR+RR(R"R-R0R.((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_native_lastrowid_autoincAs   '(RR(t__name__t __module__t run_deletesRt __backend__t __requires__Rt__engine_options__t classmethodRR&R)R/Rtdbapi_lastrowidR1(((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR s    tInsertBehaviorTestcBsbeZdZeZed„ƒZd„Zej d„ƒZ ej d„ƒZ ej d„ƒZRS(R c Csrtd|tdtdtdtƒtdtdƒƒƒtd|tdtdtdtƒtdtdƒƒƒdS( NRRRRRi2RR(R R RRRR(RR((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyRRs  cCs„tjjr(tjditd6ƒ}n tj}|j|j j j ƒddƒ}|j sat ‚|jspt ‚|j s€t ‚dS(NtoptionsRRs some data(Rt returningtenabledRttesting_engineRRRRR'RR(tclosedtAssertionErrort is_insertt returns_rows(R"tengineR-((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_autoclose_on_insert^s    cCsVtjj|jjjƒddƒ}|js3t‚|jsBt‚|j sRt‚dS(NRs some data( RRRR'RR(R?R@RARB(R"R-((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt+test_autoclose_on_insert_implicit_returningms   cCs‚tjj|jjjƒƒ}|js-t‚tjj|jjjƒj |jjj j dkƒƒ}t |jƒƒs~t‚dS(N(RRRR'RR(R?R@RtwhereR+RtNonetlentfetchall(R"R-((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_empty_insertws  c Cs |jj}tjj|jƒtddddƒtddddƒtddddƒgƒtjj|jd tƒjd t |j j d |j j gƒj |j j jddgƒƒƒƒttjjt |j j gƒj|j j ƒƒjƒd d dddgƒdS(NRiRtdata1itdata2itdata3tinlinei(RR(RK(RL(RL(RM(RM(R'RRRRR(tdictRt from_selectRR+RRRFtin_Rtorder_byRI(R"R#((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyttest_insert_from_select…s     "" * (R2R3R4RR5R8RRDRR<REt empty_insertsRJtinsert_from_selectRS(((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR:Ns  t ReturningTestcBsleZdZd ZeZied6Zd„Zed„ƒZ e j d„ƒZ d„Z d„Zd „ZRS( R R<RRcCs;|j|jƒƒjƒ}t|tjjjdfƒdS(Ns some data(RRRRRRR R!(R"R#R$R%((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR&©sc Cs;td|tdtdtdtƒtdtdƒƒƒdS(NRRRRRi2(R R RRR(RR((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyR°s cCstj}|jj}|j|jƒj|jjƒddƒ}|j ƒd}tjj t |jjgƒƒ}t ||ƒdS(NRs some datai( RRR'RRR(R<R+RRR*RR(R"RCR#R-R.t fetched_pk((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt%test_explicit_returning_pk_autocommit¸s    !cCs–tj}|jj}|jƒA}|j|jƒj|jj ƒddƒ}|j ƒd}WdQXtjj t |jj gƒƒ}t ||ƒdS(NRs some datai(RRR'RtbeginRR(R<R+RRR*RR(R"RCR#R$R-R.RW((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt(test_explicit_returning_pk_no_autocommitÅs    !cCs?tjj|jjjƒddƒ|j|jjtjƒdS(NRs some data(RRRR'RR(R&(R"((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt.test_autoincrement_on_insert_implcit_returningÒs cCsbtjj|jjjƒddƒ}tjjt|jjjj gƒƒ}t |j |gƒdS(NRs some data( RRRR'RR(R*RR+RRR,(R"R-R.((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyt(test_last_inserted_id_implicit_returningÚs  '(s returningsautoincrement_insert(R2R3trun_create_tablesR6RR5R7R&R8RRtfetch_rows_post_commitRXRZR[R\(((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyRV¢s   N(R R:RV(tRRRRt assertionsRRt sqlalchemyRRRR tschemaR R t TablesTestR R:RVt__all__(((sj/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_insert.pyts"BTE