ÿØÿàJFIFÿþ ÿÛC       ÿÛC ÿÀÿÄÿÄ"#QrÿÄÿÄ&1!A"2qQaáÿÚ ?Øy,æ/3JæݹÈ߲؋5êXw²±ÉyˆR”¾I0ó2—PI¾IÌÚiMö¯–þrìN&"KgX:Šíµ•nTJnLK„…@!‰-ý ùúmë;ºgµŒ&ó±hw’¯Õ@”Ü— 9ñ-ë.²1<yà‚¹ïQÐU„ہ?.’¦èûbß±©Ö«Âw*VŒ) `$‰bØԟ’ëXÖ-ËTÜíGÚ3ð«g Ÿ§¯—Jx„–’U/ÂÅv_s(Hÿ@TñJÑãõçn­‚!ÈgfbÓc­:él[ðQe 9ÀPLbÃãCµm[5¿ç'ªjglå‡Ûí_§Úõl-;"PkÞÞÁQâ¼_Ñ^¢SŸx?"¸¦ùY騐ÒOÈ q’`~~ÚtËU¹CڒêV  I1Áß_ÿÙ 4]c@sddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lmZdd lm Z dd lm Z dd lm Z dejfdYZde jejfdYZdejfdYZdS(i(tconfig(tfixtures(teq_(t requirements(tColumn(tTablei(tInteger(tMetaData(tschema(tSequence(tString(ttestingt SequenceTestcBs_eZdZeZdZedZdZdZ dZ e j dZ dZRS( t sequencesteachc Cs~td|tdttddttdtdtd|tdttddtdttdtddS( Ntseq_pktidt tab_id_seqt primary_keytdatai2t seq_opt_pktoptional(RRRR tTrueR (tclstmetadata((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt define_tablesscCs?tjj|jjjdd|j|jjtjdS(NRs some data(RtdbtexecutettablesRtinsertt_assert_round_trip(tself((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_insert_roundtrip*s"cCs;tjj|jjjdd}t|jdgdS(NRs some datai(RRRRRRRtinserted_primary_key(Rtr((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_insert_lastrowid.s$cCs2tjj|jjjjj}t|ddS(Ni( RRRRRtcRtdefaultR(RR"((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_nextval_direct2s!cCs;tjj|jjjdd}t|jdgdS(NRs some datai(RRRRRRRR!(RR"((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_optional_seq6s cCs,|j|jj}t|ddS(Nis some data(is some data(RtselecttfirstR(Rttabletconntrow((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR=s(R (t__name__t __module__t __requires__Rt __backend__trun_create_tablest classmethodRR R#R&Rtsequences_optionalR'R(((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR s   tSequenceCompilerTestcBseZdZeZdZRS(R cCstdttdttdtdt}|jjdd}tjj j dddtjj j td}|j |d|fd tdtjj dS( Ntxtyty_seqtqit statementtdialects#INSERT INTO x (y, q) VALUES (%s, 5)t literal_binds(RRRRR RtvaluesR RR:tstatement_compilertNonetvisit_sequencetassert_compileR(RR*tstmtt seq_nextval((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt!test_literal_binds_inline_compileFs (R (R-R.R/RR0RC(((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR4BstHasSequenceTestcBszeZdZeZdZejjdZ dZ ejjdZ ejjdZ ejjdZ RS(R cCsltd}tjjtj|z&ttjjjtjdt Wdtjjtj |XdS(Nt user_id_seq( R R RRRtCreateSequenceRR:t has_sequenceRt DropSequence(Rts1((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_s  cCs~tddtj}tjjtj|z/ttjj j tjddtjt Wdtjjtj |XdS(NRER( R Rt test_schemaR RRRRFRR:RGRRH(RRI((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_schemajs  cCs&ttjjjtjdtdS(NRE(RR RR:RGtFalse(R((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_negxscCs/ttjjjtjddtjtdS(NRER(RR RR:RGRRKRM(R((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyttest_has_sequence_schemas_neg{s cCsutd}tjjtj|z/ttjjjtjddt j t Wdtjjtj |XdS(NRER( R R RRRRFRR:RGRRKRMRH(RRI((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt'test_has_sequence_default_not_in_remotes   cCsutddtj}tjjtj|z&ttjj j tjdt Wdtjjtj |XdS(NRER( R RRKR RRRRFRR:RGRMRH(RRI((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt'test_has_sequence_remote_not_in_defaults (R (R-R.R/RR0RJR trequirestschemasRLRNRORPRQ(((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyRD[s   N(tRRt assertionsRRRRRRRR R R t TablesTestR tAssertsCompiledSQLtTestBaseR4RD(((sY/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyts3