File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyc
�
���ec
@ 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 ( ( sY /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt
setup_bind+ s
( t __name__t
__module__t classmethodR) ( ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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\ ( ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( ( sY /opt/alt/python27/lib/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< ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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" ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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_( ( sY /opt/alt/python27/lib/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 ( ( ( sY /opt/alt/python27/lib/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< ( ( sY /opt/alt/python27/lib/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< ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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( sY /opt/alt/python27/lib/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� sY /opt/alt/python27/lib/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� ( ( ( sY /opt/alt/python27/lib/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< ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR� s
!( R� ( R* R+ Rz R4 R] R, R= R� R� ( ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( ( sY /opt/alt/python27/lib/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< ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( ( sY /opt/alt/python27/lib/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� ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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 ( ( sY /opt/alt/python27/lib/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� ( ( ( sY /opt/alt/python27/lib/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__( ( ( sY /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt <module> sl �;�� � � 7� ,a�2