ó H`¾Tc@s´ddlmZmZddlmZddlmZddlmZddlmZmZm Z m Z ddl m Z m Z dej fd „ƒYZd ejfd „ƒYZd S( i(tfixturestconfig(t requirements(teq_i(ttesting(tIntegertStringtSequencetschema(tTabletColumnt SequenceTestcBs_eZdZeZdZed„ƒZd„Zd„Z d„Z e j d„ƒZ d„ZRS( t sequencesteachc Cs~td|tdttdƒdtƒtdtdƒƒƒtd|tdttddtƒdtƒtdtdƒƒƒdS( Ntseq_pktidt tab_id_seqt primary_keytdatai2t seq_opt_pktoptional(R R RRtTrueR(tclstmetadata((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt define_tabless  cCs?tjj|jjjƒddƒ|j|jjtjƒdS(NRs some data(RtdbtexecutettablesRtinsertt_assert_round_trip(tself((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_insert_roundtrips cCs;tjj|jjjƒddƒ}t|jdgƒdS(NRs some datai(RRRRRRRtinserted_primary_key(Rtr((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_insert_lastrowid%s   cCs2tjj|jjjjjƒ}t|dƒdS(Ni( RRRRRtcRtdefaultR(RR!((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_nextval_direct/s cCs;tjj|jjjƒddƒ}t|jdgƒdS(NRs some datai(RRRRRRRR (RR!((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_optional_seq7s   cCs,|j|jƒƒjƒ}t|dƒdS(Nis some data(is some data(RtselecttfirstR(Rttabletconntrow((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyRBs(R (t__name__t __module__t __requires__Rt __backend__trun_create_tablest classmethodRRR"R%Rtsequences_optionalR&R(((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR s   tHasSequenceTestcBszeZdZeZd„Zejjd„ƒZ d„Z ejjd„ƒZ ejjd„ƒZ ejjd„ƒZ RS(R cCsltdƒ}tjjtj|ƒƒz&ttjjjtjdƒt ƒWdtjjtj |ƒƒXdS(Nt user_id_seq( RRRRRtCreateSequenceRtdialectt has_sequenceRt DropSequence(Rts1((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequenceNs  cCsxtdddƒ}tjjtj|ƒƒz,ttjjjtjdddƒt ƒWdtjjtj |ƒƒXdS(NR4Rt test_schema( RRRRRR5RR6R7RR8(RR9((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_schemaWs cCs&ttjjjtjdƒtƒdS(NR4(RRRR6R7tFalse(R((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_negascCs,ttjjjtjdddƒtƒdS(NR4RR;(RRRR6R7R=(R((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_schemas_negescCsrtdƒ}tjjtj|ƒƒz,ttjjjtjdddƒt ƒWdtjjtj |ƒƒXdS(NR4RR;( RRRRRR5RR6R7R=R8(RR9((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt'test_has_sequence_default_not_in_remoteks  cCsrtdddƒ}tjjtj|ƒƒz&ttjjjtjdƒt ƒWdtjjtj |ƒƒXdS(NR4RR;( RRRRRR5RR6R7R=R8(RR9((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt'test_has_sequence_remote_not_in_defaultvs  (s sequences(R,R-R.RR/R:RtrequirestschemasR<R>R?R@RA(((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR3Js   N(tRRRt assertionsRRRRRRR R t TablesTestR tTestBaseR3(((sl/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyts"?