JezK
Edit File: test_reflection.pyc
� 1��fc @ s d d l Z d d l Z d d l 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 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 d l m# Z# e$ e$ f \ Z% Z& d e j' f d � � YZ( d e( f d! � � YZ) d" e j' f d# � � YZ* d$ e j' f d% � � YZ+ d& e( f d' � � YZ, d( e j- f d) � � YZ. d* e j- f d+ � � YZ/ d, e j' f d- � � YZ0 d. e j1 f d/ � � YZ2 d0 e j' f d1 � � YZ3 d2 e j' f d3 � � YZ4 d& d* d( d$ d d" d, d. d0 d2 f Z5 d S(4 i����Ni ( t config( t engines( t eq_( t expect_warnings( t fixtures( t is_( t get_temp_table_name( t temp_table_keyword_args( t Column( t Tablei ( t event( t ForeignKey( t func( t Identity( t inspect( t Integer( t MetaData( t String( t testing( t types( t DDL( t Index( t quoted_name( t BLANK_SCHEMA( t is_false( t is_truet OneConnectionTablesTestc B s e Z e d � � Z RS( c C sL t j j j rA d d l m } t j d t d | j d d � � St j Sd S( Ni����( t poolt optionst poolclasst scopet class( R t requirementst independent_connectionst enabledt sqlalchemyR R t testing_enginet dictt StaticPoolt db( t clsR ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt setup_bind+ s ( t __name__t __module__t classmethodR) ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR * s t HasTableTestc B s e Z e Z e d � � Z e d � � Z e d � � Z e d � � Z d � Z e j j d � � Z e j d d � e j j d � � � Z e j j d � � Z e j j e j j e j j d � � � � Z e j d d � e j j e j j d � � � � Z RS( c C s� t d | t d t d t �t d t d � � � t j j j r} t d | t d t d t �t d t d � � d t j �n t j j r� | j | � n t j j j r� | j | � n d S( Nt test_tablet idt primary_keyt datai2 t test_table_st schema( R R R t TrueR R t requirest schemasR" R t test_schemat view_reflectiont define_viewst has_temp_tablet define_temp_tables( R( t metadata( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt define_tables= s c C s� d } t j | d t | � � t j | d t d � � t j j j r� d t j t j f } t j | d t | � � t j | d t d t j � � n d S( Ns1 CREATE VIEW vv AS SELECT id, data FROM test_tablet after_createt before_drops DROP VIEW vvs9 CREATE VIEW %s.vv AS SELECT id, data FROM %s.test_table_ss DROP VIEW %s.vv( R t listenR R R5 R6 R" R R7 ( R( R< t query( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR9 S s c C s t t t j d t j f � S( Ns user_tmp_%s( R R R' t ident( R( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt temp_table_namei s c C s� t t t j � } | j � } t | | t d t j d t �t d t j d � � | � } t j j j r� t j j j r� t j | d t d t j � � t j | d t d � � n d S( NR/ R0 t namei2 R> s= create temporary view user_tmp_v as select * from user_tmp_%sR? s drop view user_tmp_v( R R R' RC R R t sat INTR4 t VARCHARR R5 R8 R" t temporary_viewsR R@ R RB ( R( R< t kwt table_namet user_tmp( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR; o s" c C sp t j j � �[ } t t j j j | d � � t t j j j | d � � t t j j j | d � � Wd QXd S( NR. R2 t nonexistent_table( R R' t beginR t dialectt has_tableR ( t selft conn( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table� s c C s� t j j � �v } t t j j j | d d t j �� t t j j j | d d t j �� t t j j j | d d t j �� Wd QXd S( NR. R3 R2 RL ( R R' RM R RN RO R7 R ( RP RQ ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table_schema� s t oraclesJ per #8700 this remains at its previous behavior of not working within 1.4.c C s# t | � } t | j d � � d S( Nt vv( R R RO ( RP t connectiont insp( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table_view� s c C s/ t | � } | j � } t | j | � � d S( N( R RC R RO ( RP RV RW RC ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table_temp_table� s c C s# t | � } t | j d � � d S( Nt user_tmp_v( R R RO ( RP RV RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table_temp_view� s sI per #8700 this remains at its previous behavior of not working within 1.4c C s) t | � } t | j d t j � � d S( NRU ( R R RO R R7 ( RP RV RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table_view_schema� s ( R* R+ R4 t __backend__R, R= R9 RC R; RR R R5 R6 RS t fails_ont viewsRX R: RY R8 RH R[ R\ ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR- : s( t HasIndexTestc B s; e Z e Z e d � � Z d � Z e j j d � � Z RS( c C s� t d | t d t d t �t d t d � � � } t d | j j � t j j j r� t d | t d t d t �t d t d � � d t j �} t d | j j � n d S( NR. R/ R0 R1 i2 t my_idxR3 t my_idx_s( R R R R4 R R t cR1 R R5 R6 R" R R7 ( R( R< t tt( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= � s c C s� t j j � �� } t j j j | d d � s3 t � t j j j | d d � sU t � t j j j | d d � sw t � t j j j | d d � s� t � Wd QXd S( NR. Ra Rb RL t nonexistent_idx( R R' RM RN t has_indext AssertionError( RP RQ ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_index� s ! c C s� t j j � �� } t j j j | d d d t j �s< t � t j j j | d d d t j � sg t � t j j j | d d d t j � s� t � t j j j | d d d t j � s� t � Wd QXd S( NR. Rb R3 Ra RL t nonexistent_idx_s( R R' RM RN Rf R7 Rg ( RP RQ ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_index_schema� s ( R* R+ R4 R] R, R= Rh R R5 R6 Rj ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR` � s t QuotedNameArgumentTestc B s� e Z d Z e Z e d � � Z d � Z e d � � Z e e j j d � � � Z e d � � Z e d � � Z e d � � Z e d � � Z e e j j d � � � Z e e j j d � � � Z e e j j d � � � Z RS( t oncec C s t d | t d t � t d t d � � t d t d � � t d t � t j d d d �t j d d � t j d d d �t j d g d g d d �t j d d d �d d d t � t j j j r|t d | t d t � t d t d � � t d t d � � t d t � t j d d d �t j d d � t j d d d �t j d g d g d d �t j d d d �d d d t � n t d | t d t d t �t d t � d t �t j j j r{t j j j r�d d g } n d g } x� | D]� } d t j j j j d | � t j j j j | � f } t j | d t | � � t j | d t d t j j j j d | � � � q�Wn d S( Ns quote ' oneR/ RD i2 R1 t related_ids pk quote ' ones ix quote ' ones uq quote' ones related.ids fk quote ' ones name != 'foo's ck quote ' onet comments quote ' one commentt test_needs_fks quote " twos pk quote " twos ix quote " twos uq quote" twos fk quote " twos ck quote " two s quote " two commentt relatedR0 s" CREATE VIEW %s AS SELECT * FROM %ss view %sR> R? s DROP VIEW %s( R R R R RE t PrimaryKeyConstraintR t UniqueConstraintt ForeignKeyConstraintt CheckConstraintR4 R R5 t symbol_names_w_double_quoteR" t view_column_reflectionR R' RN t identifier_preparert quoteR R@ R ( R( R< t namesRD RA ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= sv c C s" t j d d t j j f � | � S( Ns quote ' ones quote " two( s quote ' one( R t combinationsR5 Ru ( t fn( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt quote_fixturesW s c C s t t j � } | j | � d S( N( R R R' t get_table_options( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_options] s c C s, t t j � } | j d | � s( t � d S( Ns view %s( R R R' t get_view_definitionRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_view_definitionc s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_columnsRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_columnsi s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_pk_constraintRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_pk_constraintn s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_foreign_keysRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_foreign_keyss s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_indexesRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_indexesx s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_unique_constraintsRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_unique_constraints} s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_table_commentRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_comment� s c C s( t t j � } | j | � s$ t � d S( N( R R R' t get_check_constraintsRg ( RP RD RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_check_constraints� s ( R* R+ t run_create_tablesR4 R] R, R= R| R~ R R5 Rv R� R� R� R� R� t unique_constraint_reflectionR� t comment_reflectionR� t check_constraint_reflectionR� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRk � s" T t ComponentReflectionTestc B s� e Z d, Z Z e Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e j j d � � Z e j j d � � Z e j j d � � Z e j j d � � Z e j j e j d, e e e f d, e e e e j j f d e e e f d, e e e f d, e e e e j j f d, e e e f d, e e e e j j f d d �d � � � Z e j j d � � Z e j j e j j e j j d � � � � Z e j j d � � Z e j j e j j d � � � Z d, d � Z! e j e e f e e e j j f e e e j j f e e e j j e j j f d d �d � � Z" e j j# d � � Z$ e j j# e j j% e j j d � � � � Z& e j e f e e j j f d d �e j j' d � � � Z( e j e f e e j j f d d �e j j d � � � Z) e j j* e j j d � � � Z+ d � Z, e j e f e e j j f d d �d � � Z- e j d- d. d d �e j j. e j j/ d! � � � � Z0 e j j# e j j1 d" � � � Z2 e j j3 d# � � Z4 e j e e j j f e f d d �e j j1 d$ � � � Z5 e j j e j e f e e j j f d d �d% � � � Z6 e j d& e f d& e e j j f d d' �e j7 d( d) � d* � � � Z8 e j j9 d+ � � Z: RS(/ c C s< | j | d � t j j j r8 | j | t j j � n d S( N( t define_reflected_tablest NoneR R5 R6 R" R R7 ( R( R< ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= � s c C s� | r | d } n d } t j j j r� t d | t d t j d t �t d t j d � d t �t d t j d � d t �t d t j t j d | d d �� d | d t �} nf t d | t d t j d t �t d t j d � d t �t d t j d � d t �d | d t �} t d | t d t j d t �t d t j t j d | � � t d t j d � � d | d t �t d | t d t j � t d t j t j | j j � � t d t j d � � t j d d d �d | d t �t d | t d t j d t d d �t d t j d � d d �t d t j d � d d! �d | d d" �t j j j r�| d k r�t d# | t d t j d t �t d t j d � � t d$ t d% t j j � � d t d t j j j �q�t d& | t d t j d t �t d' t d( t j j j � � t d t j d � � d | d t �t d) | t d t j d t �t d t j d � � d | d t �n t j j j r^| j | | � | s^t d* | t d+ t j d � � d t �} t d, | t d t j d t �t d+ t j d � � d t �} t j j j r[t d- | j j j � � t d. | j j j � � q[q^n t j j j r�| j | | � n | r�t j j! j r�| j" | � n d S(/ Nt .t t userst user_idR0 t test1i t nullablet test2t parent_user_ids %susers.user_idRD t user_id_fkR3 Ro t dingalingst dingaling_idt address_ids %semail_addresses.address_idR1 i t email_addressest remote_user_idt email_addressi t email_ad_pkt comment_testR/ Rn s id comments data % commentt d2s) Comment types type speedily ' " \ '' Fun!s the test % ' " \ table commentt local_tablet remote_ids %s.remote_table_2.idt remote_tablet local_ids %s.local_table.idt remote_table_2t noncol_idx_test_nopkt qt noncol_idx_test_pkt noncol_idx_nopkt noncol_idx_pk(# R R5 t self_referential_foreign_keysR" R R RE RF R4 t CHARt Falset FloatR R R Rc R� Rq t cross_schema_fk_reflectionR� R R7 R' RN t default_schema_namet index_reflectiont define_indext indexes_with_ascdescR R� t descRv R9 t temp_table_reflectionR; ( R( R< R3 t schema_prefixR� R� R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s� "c C s� t t t j � } t t t j d t j � } t | | t d t j d t �t d t j d � � t d t j � t j d d d t j �t j d d � | � } t j j j r� t j j j r� t j | d t d t j � � t j | d t d � � n d S( Ns user_tmp_%sR/ R0 RD i2 t foos user_tmp_uq_%st user_tmp_ixR> s= create temporary view user_tmp_v as select * from user_tmp_%sR? s drop view user_tmp_v( R R R' R RB R R RE RF R4 RG Rr R R R5 R8 R" RH R R@ R ( R( R< RI RJ RK ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR; + s* c C sE t d | j j | j j � t d | j j | j j | j j � d S( Nt users_t_idxt users_all_idx( R Rc R� R� R� ( R( R< R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� O s c C s� x} d D]u } | } | r, d | | f } n | d } d | | f } t j | d t | � � t j | d t d | � � q Wd S( NR� R� s %s.%st _vs" CREATE VIEW %s AS SELECT * FROM %sR> R? s DROP VIEW %s( R� R� ( R R@ R ( R( R< R3 RJ t fullnamet view_nameRA ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR9 T s c C s2 t | j � } | j t j j | j � k � d S( N( R t bindt assert_R R R7 t get_schema_names( RP RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_schema_namese s c C sU | j d i d d 6t j j t 6� } t | � } | j t j j | j � k � d S( s test #7300t schema_translate_mapt barR� N( t execution_optionsR R R7 R R R� R� ( RP RV RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt% test_get_schema_names_w_translate_mapk s c C s2 t j � } t | � t | j d � s. t � d S( NR� ( R R$ R t hasattrRN Rg ( RP t engine( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_dialect_initializey s c C s, t | j � } t | j | j j j � d S( N( R R� R R� RN ( RP RW ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_default_schema_name s t foreign_keyt argnamess/ order_by,include_plain,include_views,use_schemac C sD | r t j } n d } d d d d d d g } t | � } | r} | j | � } | j � d d g } t t | � | � n | r@| r� g | j | � D] } | d r� | d ^ q� } n | j | � } g | D] } | | k r� | ^ q� } | d k rd d d g } t | | � q@d d d g } t t | � | � n d S( NR� R� R� R� R� R� t email_addresses_vt users_vi R� R� R� R� ( R R7 R� R t get_view_namest sortR t sortedt get_sorted_table_and_fkc_namest get_table_names( RP RV t order_byt include_plaint include_viewst use_schemaR3 t _ignore_tablesRW t table_namest answert rect tablest t( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_names� s6 % c C s< t | j � } | j � } t t | � d t j g � d S( Ns user_tmp_%s( R R� t get_temp_table_namesR R� R RB ( RP RW t temp_table_names( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_table_names� s c C s5 t | j � } | j � } t t | � d g � d S( NRZ ( R R� t get_temp_view_namesR R� ( RP RW R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_view_names� s c C s | j � d S( N( t _test_get_comments( RP ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_comments� s c C s | j t j j � d S( N( R� R R R7 ( RP ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_comments_with_schema� s c C s� t | j � } t | j d d | �i d d 6� t | j d d | �i d d 6� t g | j d d | �D]" } i | d d 6| d d 6^ qn i d d 6d d 6i d d 6d d 6i d d 6d d 6g � d S( NR� R3 s the test % ' " \ table commentt textR� RD Rn s id commentR/ s data % commentR1 s) Comment types type speedily ' " \ '' Fun!R� ( R R� R R� R� R� ( RP R3 RW R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s #8s use_views,use_schemac C s | r t j } n d } | j j | j j } } | rF d d g } n d d g } t | � } x�t | | | f � D]�\ } } | } | j | d | �} | j t | � d k t | � � xKt | j � D]:\ } } t | j | | d � | | d j } | j } t | t j j � r,| j } n t j d � r_| t j t j f k r_t j } n | j t t | j � j | j � j t j t j t j t j t j t j t j! g � � d k d | j | j | | d | f � | j" s� | | d d k st# � q� q� Wqt Wd S( NR� R� R� R� R3 i RD t typeRT s %s(%s), %s(%s)t default($ R R7 R� R� R� R� R t zipR� R� t lent enumeratet columnsR RD t __class__R� t isinstanceRE R t TypeEngineR t againstt sql_typest Datet DateTimet sett __mro__t intersectionR t Numerict TimeR t _BinaryR0 Rg ( RP RV t use_viewsR� R3 R� t addressesR� RW RJ t tablet schema_namet colst it colt ctypet ctype_def( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � sL "" " c C s� t t | j d t j � } | j | } t | j � } | j | � } | j t | � d k t | � � x5 t | j � D]$ \ } } t | j | | d � qy Wd S( Ns user_tmp_%si RD ( R R R� RB R� R R� R� R� R� R� R RD ( RP RJ RK RW R R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_table_columns7 s " c C sO t | j � } | j d � } t g | D] } | d ^ q( d d d g � d S( NRZ RD R/ R� ( R R� R� R ( RP RW R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_view_columnsD s R� c C s� | r t j j } n d } | j j | j j } } t | � } | j | j d | �} | d } t | d g � | j | j d | �} | d } t | d g � t j j j � � t | d d � Wd QXd S( NR3 t constrained_columnsR� R� RD R� ( R R R7 R� R� R� R� R R� RD R R5 t reflects_pk_namest fail_if( RP RV R� R3 R� R RW t users_const users_pkeyst addr_const addr_pkeys( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� L s c C s� | r t j } n d } | j j | j j } } t | � } | } t j j j r | j | j d | �} | d } t j j j � � t | d d � Wd QXt | d | � t | d | j � t | d d g � t j j j r t | d d g � q n | j | j d | �} | d } t j j j � � | j | d d k � Wd QXt | d | � t | d | j � t | d d g � t | d d g � d S( NR3 i RD R� t referred_schemat referred_tablet referred_columnsR� R R� R� ( R R7 R� R� R� R� R R R5 R� R" R� RD t named_constraintsR R t implicitly_named_constraintsR� ( RP RV R� R3 R� R RW t expected_schemat users_fkeyst fkey1t addr_fkeys( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� d s0 c C sp | j d | j j j d t j j d t j j � \ } } } t | j � } | j | j � } t t | � d � | d } t | d t j j � t | d | j � t | d d g � t | d d g � | j | j d t j j �} t t | � d � | d } | d d | j j j f k s0t � t | d | j � t | d d g � t | d d g � d S( Ns %s.local_tables %s.remote_tables %s.remote_table_2i i R R R R/ R R� R3 R� ( R� R� RN R� R R R7 R R� RD R R� R� Rg ( RP R� R� R� RW t local_fkeysR t remote_fkeyst fkey2( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt" test_get_inter_schema_foreign_keys� s, c C s� g | D] } | d ^ q } xa | D]Y } | d | k s@ t � | | j | d � } x# | D] } t | | | | � q^ Wq$ Wd S( NRD ( Rg t indexR ( RP t indexest expected_indexest dt index_namest e_indexR t key( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _assert_insp_indexes� s c C s� | r t j } n d } t | j � } | j d d | �} i t d 6d d g d 6d d 6i t d 6d d d g d 6d d 6g } | j | | � d S( NR� R3 t uniqueR� R� t column_namesR� RD R� R� ( R R7 R� R R� R� R� R' ( RP RV R� R3 RW R! R" ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s R� R� R� R� s tname,ixnamec C s� t | � } | j | � } i t d 6| d 6g } | j | | � t | t � d | �} t t | j � d � t t | j � d j | � t t | j � d j | � d S( NR( RD t autoload_withi i ( R R� R� R' R R R R� R! R t listR RD ( RP RV t tnamet ixnameRW R! R" R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_noncol_index� s c C sr t | j � } | j d t j � } x | D] } | j d d � q, Wt | i d g d 6d t j d 6g � d S( Ns user_tmp_%st duplicates_indexRD R) s user_tmp_uq_%s( R R� R� R RB t popR� R ( RP RW t reflectedt refl( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt& test_get_temp_table_unique_constraints� s c C s� t | j � } t t t j d t j � } | j | � } x | D] } | j d d � qA Wi t d 6d g d 6d d 6g } t j j j r� g | d d <n t g | D] } | d d k r� | ^ q� | � d S( Ns user_tmp_%st dialect_optionsR( R� R) R� RD i t include_columns( R R� R R R' RB R� R0 R� R� R R5 t index_reflects_included_columnsR" R ( RP RW RJ R! t indt expectedt idx( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_table_indexes� s !&c C s� | r t j } n d } t i d d 6d g d 6i d d 6d d d g d 6i d d 6d d d g d 6i d d 6d d g d 6i d d 6d g d 6i d d 6d g d 6g d t j d � �} t d | t d t j d � � t d t j d � � t d t j � t d t j d � � t d t j d � � d | �} x2 | D]* } | j t j d | d | d � � q9W| j | � t | � } t | j d d | �d t j d � �} t � } t t | � t | � � xR t | | � D]A \ } } | j d d � } | r| j | � n t | | � q�Wt � } t d | d | d | �} t g | j D] } | j ^ qR� } t g | j D]! } t | t j � rw| j ^ qw� j d g � } | j | � s�t � | r�t | | � t | t � � n d S( Nt unique_aRD t aR) t unique_a_b_ct bRc t unique_c_a_bt unique_asc_keyt ascR& s i.have.dotss i have spacest testtbli i R3 R/ R* ( R R7 R� R� t operatort itemgetterR R RE R R t append_constraintRr t createR R� R� R R� R� R0 t addR R! RD t constraintsR� t differenceR� Rg ( RP R< RV R� R3 t uniquesR t uct inspectorR1 t names_that_duplicate_indext origR2 t dupet reflected_metadataR9 t idx_namest uqt uq_names( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� sf " % $ c C sx | r t j } n d } d } d } t | � } | j | d | �} | j | � | j | d | �} | j | � d S( NR� R� R3 ( R R7 R� R R R� ( RP RV R� R3 t view_name1t view_name2RW t v1t v2( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� g s R� s table_name,use_schemat postgresqls PG specific featurec C sP | r t j } n d } t | � } | j | | � } | j t | t � � d S( N( R R7 R� R t get_table_oidR� R� t int( RP RV RJ R� R3 RW t oid( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_oidy s c C sn t | j � } xX d d d g D]G \ } } | j | � } d � | D� | } | j d t � s t � q Wd S( s� test that 'autoincrement' is reflected according to sqla's policy. Don't mark this test as unsupported for any backend ! (technically it fails with MySQL InnoDB since "id" comes before "id2") A backend is better off not returning "autoincrement" at all, instead of potentially returning "False" for an auto-incrementing primary key column. R� R� R� R� R� R� c S s i | ] } | | d � q S( RD ( ( t .0Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <dictcomp>� s t autoincrementN( R� R� ( R� R� ( R� R� ( R R� R� t getR4 Rg ( RP RW R, t cnameR t id_( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_autoincrement_col� s N( R� R� ( R� R� (; R* R+ R� t run_insertst run_deletesR4 R] R, R= R� R; R� R9 R R5 t schema_reflectionR� R� R� R� t! foreign_key_constraint_reflectionRz R� R6 R� R� R� R8 RH R� R� R� R� R� R� R� R Rv R t! primary_key_constraint_reflectionR� R� R� R R' R� R� R� R. R� R3 t temp_table_reflect_indexesR: R� R� t only_onR\ t table_reflectionRb ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s� �$ . A % " * U - t TableNoColumnsTestc B s� e Z d Z e Z e j d � � Z e j d � � Z e j j d � � Z e j j d � � Z e j j d � � Z e j j e j j d � � � Z e j j e j j d � � � Z RS( t reflect_tables_no_columnsc C s t d | � | j | � d S( Nt empty( R t create_all( RP RV R< ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt table_no_columns� s c C sj t d | � | j | � t d | � t j | d t d � � t j | d t d � � | j | � d S( NRm R> s* CREATE VIEW empty_v AS SELECT * FROM emptyR? s DROP VIEW IF EXISTS empty_v( R Rn R R@ R ( RP RV R< ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt view_no_columns� s c C s2 t d t � d | �} t t | j � g � d S( NRm R* ( R R R R+ Rc ( RP RV Ro t t2( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_reflect_table_no_columns� s c C s t t | � j d � g � d S( NRm ( R R R� ( RP RV Ro ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_get_columns_table_no_columns� s c C s; t � } | j | � t | j � j d g � s7 t � d S( NRm ( R t reflectR� R� R� Rg ( RP RV Ro t m( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt" test_reflect_incl_table_no_columns� s c C s2 t d t � d | �} t t | j � g � d S( Nt empty_vR* ( R R R R+ Rc ( RP RV Rp Rq ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_reflect_view_no_columns� s c C s t t | � j d � g � d S( NRw ( R R R� ( RP RV Rp ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_columns_view_no_columns� s ( Rl ( R* R+ t __requires__R4 R] R t fixtureRo Rp R5 Rl Rr Rs Rv R_ Rx Ry ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRk � s t ComponentReflectionTestExtrac B sU e Z e Z e j e e j j f e f d d �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 e j j d � � Z e j d d d e j j f d d d e j j f i d d e j j f i d d e j j f d d d e j j f d d d e j j f d d �d � � Z RS( R� R� c C s | r t j } n d } t d | t d t � � t j d d d �t j d d d �d | �| j | � t | � } t | j d d | �d t j d � �} d � } g | D]( } i | d d 6| | d � d 6^ q� } t | i d d 6d d 6i d d 6d d 6g � d S( Nt sa_ccR< s a > 1 AND a < 5RD t cc1s a = 1 OR (a > 2 AND a < 5)t UsesCasingR3 R& c S s% d j t j d | j � t j � � S( Nt s and|\d|=|a|or|<|>( t joint ret findallt lowert I( t sqltext( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt normalize� s R� s a = 1 or a > 2 and a < 5s a > 1 and a < 5( R R7 R� R R R RE Rt Rn R R� R� RC RD R ( RP R< RV R� R3 RL R1 R� t item( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s. 2c C s! t d | t d t d � � t d t d � � � } t d t j | j j � t j | j j � � t d | j j � | j | � t | � } i d d 6d g d 6t d 6i d 6g } t j j j r� g | d d <i g d | j j 6| d d <n t d � � t | j d � | � Wd QXd S( NR� t xi t yt t_idxt t_idx_2RD R) R( R4 i R5 s %s_includes> Skipped unsupported reflection of expression-based index t_idx( R R R R R R� Rc R� R� Rn R R� R R5 R6 R" R� RD R R R� ( RP R< RV R� RW R8 ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt% test_reflect_expression_based_indexes s* . c C s t d | t d t d � � t d t d � � � } t d | j j � } d g | j | j j d <| j | � t | � } t | j d � i d d 6d g d 6d g d 6t d 6i d g d | j j 6d 6g � t d t � d | �} t t | j � d j | j j d d g � d S( NR� R� i R� R� t includeRD R) R5 R( s %s_includeR4 R* i ( R R R R Rc R� R4 R� RD Rn R R R� R� R R+ R! ( RP R< RV R� R9 RW Rq ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_reflect_covering_index3 s. c G su t d | g t | � D] \ } } t d | | � ^ q � } | j | � g t | � j d � D] } | d ^ qa S( NR� s t%dR� ( R R� R RF R R� ( RP RV R< R R t type_R� Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _type_round_tripY s 5 c C sh xa | j | | t j d d � � D]> } t | t j � s@ t � t | j d � t | j d � q" Wd S( Ni i ( R� R� R� R� Rg R t precisiont scale( RP RV R< t typ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_numeric_reflectionc s c C sN | j | | t j d � � d } t | t j � s: t � t | j d � d S( Ni4 i ( R� R� R R� Rg R t length( RP RV R< R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_varchar_reflectionl s c C s~ t d | t d t d t �t d t d t �� } | j | � t t d � t | � j d � D� � i t d 6t d 6� d S( NR� R< R� R> c s s# | ] } | d | d f Vq d S( RD R� N( ( R] R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <genexpr> s ( R R R R4 R� RF R R% R R� ( RP RV R< R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_nullable_reflectiont s t CASCADEs SET NULLs NO ACTIONt RESTRICTs expected,ondelete,onupdatec s� i } | r | | d <n | r, | | d <n | d k rA | } n t d | t d t d t �d t �t d | t d t d t �t d t t j d d d �� t d t d � � d t �t d | t d t d t �t d t d � d t �t d t � t j d g d g d d | �d t �| j | � t | � } | j d � d d � t t � f d � � D� � i � | j d � d d � t � | � d S( Nt ondeletet onupdateR� R/ R0 Ro R t x_ids x.idRD t xidt testi t useri2 R� t tids table.idt myfki R c 3 s) | ] } � | r | � | f Vq d S( N( ( R] t k( t opts( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <genexpr>� s ( R� R R R R4 RE R R R� Rs Rn R R� R R% ( RP RV R< R8 R� R� R RW ( ( R� s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_foreign_key_options� sD * #N( R* R+ R4 R] R Rz R5 R6 R� R� R� t indexes_with_expressionsR� R6 R� R� Rj R� R� R� R� t1 foreign_key_constraint_option_reflection_ondeletet1 foreign_key_constraint_option_reflection_onupdatet1 fk_constraint_option_reflection_ondelete_noactiont1 fk_constraint_option_reflection_onupdate_restrictt1 fk_constraint_option_reflection_ondelete_restrictR� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR| � sH .%& t NormalizedNameTestc B s5 e Z d Z e Z e d � � Z d � Z d � Z RS( t denormalized_namesc C sl t t d d t �| t d t d t �� t t d d t �| t d t d t �t d t d � � � d S( Nt t1Rx R/ R0 Rq t t1ids t1.id( R R R4 R R R ( R( R< ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= � s c C s� t � } t t d d t �| d t j �} | j d } | j j j | j j � s[ t � t � } | j t j d d � �| j d j j j | j d j j � s� t � d S( NRq Rx R* R� t onlyc S s | j � d k S( NR� Rq ( R� Rq ( R� ( RD Ru ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt <lambda> R� ( R R R R4 R R' R� Rc R� t referencesR/ Rg Rt ( RP t m2t t2_reft t1_reft m3( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt$ test_reflect_lowercase_forced_tables� s ! ! c C s� g t t j � j � D] } | j � d k r | ^ q } t | d j � | d j � � t | d j � | d j � � d S( NR� Rq i i ( R� Rq ( R R R' R� R� R t upper( RP R� t tablenames( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� s !( R� ( R* R+ Rz R4 R] R, R= R� R� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s t ComputedReflectionTestc B sA e Z d � Z d � Z d � Z d � Z e j j d � � Z RS( c C st t t j � } | j d � } d � | D� } t d | d d k � t | d d d � t | d d d � d S( Nt computed_default_tablec S s i | ] } | | d � q S( RD ( ( R] Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <dictcomp> s t 42t with_defaultR� t normalt computed_col( R R R' R� R R R� ( RP RW R t col_data( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_computed_col_default_not_set s c C s� t t j � } | j d � } d � | D� } x" d D] } t d | | k � q5 W| d } t d | k � t d | d k � t | j | d d � d � t d | d k t j j j � t j j j r� t | d d t j j j � n d S( NR� c S s i | ] } | | d � q S( RD ( ( R] Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <dictcomp> s R/ R� R� t computedR� R� s normal+42t persisted( R/ R� R� ( R R R' R� R R R� R R5 t" computed_columns_reflect_persistedR" t" computed_columns_default_persisted( RP RW R R1 R& t compData( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_column_returns_computed s c C ss t d | | k � | | d } t | j | d � | � t j j j ro t d | k � t | d | � n d S( NR� R� R� ( R R R� R R5 R� R" R ( RP R1 t columnR� R� R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt check_column. s c C s� t t j � } | j d � } d � | D� } | j | d d t j j j � t j j j ru | j | d d t � n t j j j r� | j | d d t � n d S( Nt computed_column_tablec S s i | ] } | | d � q S( RD ( ( R] Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <dictcomp>: s t computed_no_flags normal+42t computed_virtuals normal+2t computed_storeds normal-42( R R R' R� R� R R5 R� R" t computed_columns_virtualR� t computed_columns_storedR4 ( RP RW R R1 ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_get_column_returns_persisted6 s( c C s� t t j � } | j d d t j �} d � | D� } | j | d d t j j j � t j j j r~ | j | d d t � n t j j j r� | j | d d t � n d S( NR� R3 c S s i | ] } | | d � q S( RD ( ( R] Rc ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys <dictcomp>X s R� s normal/42R� s normal/2R� s normal*42( R R R' R� R7 R� R R5 R� R" R� R� R� R4 ( RP RW R R1 ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt- test_get_column_returns_persisted_with_schemaQ s* ( R* R+ R� R� R� R� R R5 R6 R� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� s t IdentityReflectionTestc B sT e Z d Z Z e Z d Z e d � � Z d � Z d � Z e j j d � � Z RS( t identity_columnsRj c C s� t d | t d t � t d t t � � � t d | t d t t d t d d d d d d d d d t d d � � � t j j j r� t d | t d t � t d t t d t d d � � d t j �n d S( NR� R� t id1Rq t id2t alwayst starti t incrementi t minvaluei����t maxvaluei* t cyclet cachei i R3 ( R R R R R4 R R5 R6 R" R R7 ( R( R< ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= v s4 !c C s% t j j j r� d } x0 t | � D]" } | | k r" | j | � q" q" W| r� t t | � t | � � x� | D]r } | d k r� t | | | | k � qn | d d h k r� t | | | | k � qn t | | | | | � qn Wq!t | | � n* t | d | d � t | d | d � d S( NR� R� R� R� R� R� R� ( R� R� R� R� R� R� R� ( R R5 t identity_columns_standardR" R+ R0 R R� R ( RP t valuet expt approxt common_keysR� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt check� s, c C s� t t j � } | j d � | j d � } x[| D]S} | d d k r[ t d | k � q2 | d d k r� t | d t d f k � t | d d � t d | k � | j | d t d t d d d d d d d d d t d d � d t �q2 | d d k r2 t | d t d f k � t | d d � t d | k � | j | d t d t d d d d d d d d d t d d � d t �q2 q2 Wd S( NR� Rq RD R� t identityR� R^ t autoR� R� R� i R� R� R� i���R� R� R� R� i i i����i* i ( R R R' R� R R R4 R R� R� R% R� ( RP RW R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_reflect_identity� sF c C s� t t j � } | j d d t j �} x� | D]� } | d d k rW t d | k � q. | d d k r. t | d t d f k � t | d d � t d | k � | j | d t d t d d d d d d d d d t d d � d t �q. q. Wd S( NR� R3 RD R� R� R� R^ R� R� R� R� i R� i R� R� i���R� R� R� ( R R R' R� R7 R R R4 R R� R� R% R� ( RP RW R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_reflect_identity_schema� s( N( R� Rj ( R* R+ R� Rc Rd R4 R] Rz R, R= R� R� R R5 R6 R� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� p s " *t CompositeKeyReflectionTestc B sG e Z e Z e d � � Z e j j d � � Z e j j d � � Z RS( c C s� t d | t d t � t d t � t d t j d � � t j d d d d d �d d d t �} t d | t d t d t �t d t � t d t � t d t j d � � t j d d d g | j j | j j | j j g d d �d d d t �d S( Nt tb1R/ t attrRD i t pk_tb1R3 Ro t tb2R0 t pidt pattrt pnamet fk_tb1_name_id_attr( R R R R� RG RE Rq R� R4 Rs Rc RD R/ R� ( R( R< R� ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR= � s, ! c C sJ t | j � } | j | j j j � } t | j d � d d d g � d S( NR RD R/ R� ( R R� R� R� R� RD R R_ ( RP RW R0 ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_pk_column_order s c C s� t | j � } | j | j j j � } t t | � d � | d } t | j d � d d d g � t | j d � d d d g � d S( Ni i R RD R/ R� R R� R� R� ( R R� R� R� R� RD R R� R_ ( RP RW t foreign_keysR ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_fk_column_order s ( R* R+ R4 R] R, R= R R5 Rg R� Rf R� ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� � s (6 RC R� R# RE R� R R R R R R t provisionR R R3 R R R R R R R R R R R R R� R R t sql.elementsR t sql.schemaR R R R� R< R� t TablesTestR R- R` Rk R� t TestBaseRk R| R� t ComputedReflectionFixtureTestR� R� R� t __all__( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt <module> sl �;�� � � 7� ,a�2