JezK
Edit File: test_sequence.pyc
� 1��fc @ s> d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d e j f d � � YZ d e j e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d S( i ( t config( t fixtures( t eq_( t is_true( t requirements( t Column( t Tablei ( t inspect( t Integer( t MetaData( t Sequence( t String( t testingt SequenceTestc B s� e Z d Z e Z d Z e d � � Z d � Z d � Z d � Z e j d � � Z d � Z d � Z e j e f e f d d �e j j d � � � Z e j j d � � Z RS( t sequencest eachc C s( t d | t d t t d � d t �t d t d � � � t d | t d t t d d t d t �d t �t d t d � � � t d | t d t t d � d t �t d t d � � d t �t j j j r$t d | t d t t d d t j �d t �t d t d � � d t d t j �n d S( Nt seq_pkt idt tab_id_seqt primary_keyt datai2 t seq_opt_pkt data_typet optionalt seq_no_returningt noret_id_seqt implicit_returningt seq_no_returning_scht noret_sch_id_seqt schema( R R R R t TrueR t FalseR t requirest schemast enabledR t test_schema( t clst metadata( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt define_tables sP c C s? | j | j j j � t d d � � | j | j j | � d S( NR s some data( t executet tablesR t insertt dictt _assert_round_trip( t selft connection( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_insert_roundtripR s %c C sG | j | j j j � t d d � � } t | j t j j j f � d S( NR s some data( R' R( R R) R* R t inserted_primary_keyR t dbt dialectt default_sequence_base( R, R- t r( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_insert_lastrowidV s !c C s8 | j | j j j j j � } t | t j j j � d S( N( R' R( R t cR t defaultR R R0 R1 R2 ( R, R- R3 ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_nextval_direct^ s c C s; | j | j j j � t d d � � } t | j d � d S( NR s some datai ( i ( R' R( R R) R* R R/ ( R, R- R3 ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_optional_seqb s !c C s; | j | j � � j � } t | t j j j d f � d S( Ns some data( R' t selectt firstR R R0 R1 R2 ( R, t tablet connt row( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR+ i s c C s? | j | j j j � t d d � � | j | j j | � d S( NR s some data( R' R( R R) R* R+ ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt+ test_insert_roundtrip_no_implicit_returningm s t argnamesR c C s� t d t � t d t t d d d �d t �t d t d � � d | d d �} | j d i t j d 6� } | j | j � t d d � � | j | | � d S( NR R R R t alt_schemaR R i2 R t schema_translate_maps some data( R R R R R R R t execution_optionsR R# R' R) R* R+ ( R, R- R R ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_insert_roundtrip_translates s c C sW t d d d �} | j d i t j d 6� } | j | � } t | t j j j � d S( NR R R@ RA ( R RB R R# R' R R R0 R1 R2 ( R, R- t seqR3 ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt$ test_nextval_direct_schema_translate� s ( R ( t __name__t __module__t __requires__R t __backend__t run_create_tablest classmethodR& R. R4 R7 R t sequences_optionalR8 R+ R> R t combinationsR R R! RC RE ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR s 6 t SequenceCompilerTestc B s e Z d Z e Z d � Z RS( R c C s� t d t � t d t t d � � t d t � � } | j � j d d � } | j j d d d | j � j t d � � } | j | d | f d t d | j �d S( Nt xt yt y_seqt qi t statementR1 s# INSERT INTO x (y, q) VALUES (%s, 5)t literal_binds( R R R R R R) t valuesR1 t statement_compilert Nonet visit_sequencet assert_compileR ( R, R- R; t stmtt seq_nextval( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt! test_literal_binds_inline_compile� s ( R ( RF RG RH R RI R\ ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyRN � s t HasSequenceTestc B s� e Z d Z d Z e Z e d � � Z d � Z d � Z e j j d � � Z d � Z e j j d � � Z e j j d � � Z e j j d � � Z d � Z e j j d � � Z e j j d � � Z RS( R c C s� t d d | �t d d | d t d t �t j j j rp t d d t j d | �t d d t j d | �n t d | t d t d t �� d S( Nt user_id_seqR% t other_seqt nomaxvaluet nominvalueR t schema_seqt user_id_tableR R ( R R R R R! R" R R# R R R ( R$ R% ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR& � s c C s t t | � j d � t � d S( NR^ ( R R t has_sequenceR ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_has_sequence� s c C s t t | � j d � t � d S( NRc ( R R Rd R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_has_sequence_other_object� s c C s) t t | � j d d t j �t � d S( NR^ R ( R R Rd R R# R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_has_sequence_schema� s c C s t t | � j d � t � d S( Nt some_sequence( R R Rd R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_has_sequence_neg� s c C s) t t | � j d d t j �t � d S( NRh R ( R R Rd R R# R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_has_sequence_schemas_neg� s c C s) t t | � j d d t j �t � d S( Nt other_sequenceR ( R R Rd R R# R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt' test_has_sequence_default_not_in_remote� s c C s t t | � j d � t � d S( NRb ( R R Rd R ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt' test_has_sequence_remote_not_in_default� s c C sQ d d h } t t | � j � � } t | j | � | k � t d | k � d S( NR_ R^ Rb ( t setR t get_sequence_namesR t intersection( R, R- t expt res( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt test_get_sequence_names� s c C s& t t | � j d t j � g � d S( NR ( R R Ro R t test_schema_2( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt* test_get_sequence_names_no_sequence_schema s c C s2 t t t | � j d t j � � d d g � d S( NR Rb R^ ( R t sortedR Ro R R# ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt( test_get_sequence_names_sequences_schema s N( R ( RF RG RW t run_deletesRH R RI RK R& Re Rf R R R! Rg Ri Rj Rl Rm Rs Ru Rw ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyR] � s t HasSequenceTestEmptyc B s e Z d Z e Z d � Z RS( R c C s t t | � j � g � d S( N( R R Ro ( R, R- ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt# test_get_sequence_names_no_sequence s ( R ( RF RG RH R RI Rz ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyRy s N( t R R t assertionsR R R R R R R R R R R R t TablesTestR t AssertsCompiledSQLt TestBaseRN R] Ry ( ( ( sY /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_sequence.pyt <module> s � i