/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite
Edit: /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyo (37345B)
4]c @ 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 e e f \ Z! Z" d e
j# f d YZ$ d e
j# f d YZ% d e
j# f d YZ& d d d f Z' d S( iNi ( t assert_raises_message( t config( t engines( t eq_( t expect_warnings( t fixtures( t is_( t Column( t Tablei ( t event( t exc( t
ForeignKey( t inspect( t Integer( t MetaData( t String( t testing( t types( t Inspector( t DDL( t Index( t quoted_namet HasTableTestc B s& e Z e Z e d Z d Z RS( c C s5 t d | t d t d t t d t d d S( Nt
test_tablet idt primary_keyt datai2 ( R R R
t TrueR ( t clst metadata( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt
define_tables# s
c C s t j j } Wd QXd S( N( R t dbt begin( t selft conn( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_has_table, s ( t __name__t
__module__R t __backend__t classmethodR R# ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR s t ComponentReflectionTestc B sZ e Z dE Z Z e Z e d 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 dE d dE 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 e j j d Z e j j e j j! d Z" dE d Z# e j j 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( dE d d Z) e j j d Z* e j d Z+ e j j d Z, e j j d Z- e j j e j d Z. e j j e j j! d Z/ e j j0 d Z1 e j j0 e j j% e j j d Z2 e j j% d Z3 e j j% e j j! d Z4 e j dE d! Z5 e j j6 d" Z7 e j j e j j6 e j j! d# Z8 e j j e j d$ Z9 e j dE d% Z: e j j d& Z; e j j e j j! d' Z< e j j= e j j! d( Z> e j j? d) Z@ e j jA d* ZB e j d+ ZC d, ZD e j dE d- ZE e j jF d. ZG e j jF e j j! d/ ZH e j d0 ZI e j jF d1 ZJ e j jF d2 ZK e j jL e j d3 ZM e j jN d4 ZO e j j0 e j jN d5 ZP e j j0 d6 ZQ e j jN e j j! d7 ZR e j dE d8 ZS e j jT d9 ZU e j jT e j j! d: ZV e j dE d; ZW e j dE d< ZX e j j d= ZY e j j e j j! d> ZZ e j[ d? d@ e j dE dA Z\ dB Z] e j j! dC Z^ e j j e j dD Z_ RS(F c C sF t j j j r; d d l m } t j d t d | j St j
Sd S( Ni( t poolt optionst poolclass( R t requirementst independent_connectionst enabledt
sqlalchemyR) R t testing_enginet dictt
StaticPoolR ( R R) ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt
setup_bind7 s
c C s< | j | d t j j j r8 | j | t j j n d S( N( t define_reflected_tablest NoneR t requirest schemasR. R t test_schema( R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR B 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 rt 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 qt 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 rL| j | | | sLt d* | t d+ t j d d t } t d, | t d t j d t t d+ t j d d t } t d- | j j j t d. | j j j qLn t j j j rn| j | | n | rt j j j r| j! | n d S(/ Nt .t t userst user_idR t test1i t nullablet test2t parent_user_ids %susers.user_idt namet
user_id_fkt schemat
test_needs_fkt
dingalingst dingaling_idt
address_ids %semail_addresses.address_idR i t email_addressest remote_user_idt
email_addressi t email_ad_pkt comment_testR t comments
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 R6 t self_referential_foreign_keysR. R R t sat INTR t CHARt Falset FloatR
R R t cR< t PrimaryKeyConstraintt cross_schema_fk_reflectionR5 R R8 R t dialectt default_schema_namet index_reflectiont define_indexR RU t desct view_column_reflectiont define_viewst temp_table_reflectiont define_temp_tables( R R RC t
schema_prefixR; RT RV ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR4 H s
c
C s t j d r) i d g d 6d d 6} n i d g d 6} t d | t d t j d t t d
t j d t d t j t j d
d
d
t j d d | } t j
j j r t j
j
j r t j | d t d t j | d t d n d S( Nt oracles GLOBAL TEMPORARYt prefixess
PRESERVE ROWSt oracle_on_committ TEMPORARYt user_tmpR R RA i2 t foot user_tmp_uqt user_tmp_ixt after_creates: create temporary view user_tmp_v as select * from user_tmpt before_drops drop view user_tmp_v( R t againstR R RZ R[ R t VARCHARt UniqueConstraintR R6 t view_reflectionR. t temporary_viewsR t listenR ( R R t kwRp ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRj 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 R_ R= R? R< ( R R R; ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRe 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; RH s %s.%st _vs" CREATE VIEW %s AS SELECT * FROM %sRt Ru s DROP VIEW %s( R; RH ( R R{ R ( R R RC t
table_namet fullnamet view_namet query( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRh s
c C s2 t t j } | j t j j | j k d S( N( R R R t assert_R R8 t get_schema_names( R! t insp( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_schema_names s c C s t j } t | d S( N( R R0 R ( R! t engine( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_dialect_initialize s
c C s, t t j } t | j t j j j d S( N( R R R R Rc Rb ( R! R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_default_schema_name s t tablec C s5 d d d d d d g } | j } t | j } | d k rw | j | } | j d d g } t t | | n | r g | j | D] } | d
r | d
^ q }
n | j | }
g |
D] } | | k r | ^ q } | d k rd d
d g } t | | n" d d
d g } t t | | d S( NRL RV RT RO RQ RS t viewt email_addresses_vt users_vi t foreign_keyR; RH RE ( R R t bindt get_view_namest sortR t sortedt get_sorted_table_and_fkc_namest get_table_names( R! RC t
table_typet order_byt _ignore_tablest metaR 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" s0
% c C s5 t | j } | j } t t | d g d S( NRp ( R R t get_temp_table_namesR R ( R! R t temp_table_names( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_table_namesI s c C s5 t | j } | j } t t | d g d S( Nt
user_tmp_v( R R t get_temp_view_namesR R ( R! R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_view_namesO s c C s | j d S( N( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_namesW s c C s | j d d d S( NR R ( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_names_fks[ s c C s | j d S( N( t _test_get_comments( R! ( ( 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 R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_comments_with_schemad s c C s t 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( NRL RC s the test % ' " \ table commentt textR; RA RM s
id commentR s data % commentR s) Comment types type speedily ' " \ '' Fun!RN ( R R R R t get_table_commentR5 t get_columns( R! RC R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR i s #8c C s | j t j j d S( N( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_names_with_schema s c C s | j d d d S( NR R ( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_view_names s c C s | j t j j d d d S( NR R ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_view_names_with_schema s c C s | j | j d d d S( NR R ( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_tables_and_views s
c C s t t j } | j j | j j } } d d g } | d k rO d d g } n t | j } xt | | | f D]}\ } } | }
| j | d |
} | j
t | d k t | x1t | 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 q q Wqt Wd S( NR; RH R R R RC i RA t typeRl s %s(%s), %s(%s)(# R R R R R; RH R R t zipR R t lent enumeratet columnsR RA t __class__R t
isinstanceRZ R t
TypeEngineRv t sql_typest Datet DateTimet sett __mro__t intersectionR
t Numerict TimeR t _BinaryR ( R! RC R R R; t addressesR R R R t schema_namet colst it colt ctypet ctype_def( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_columns sH "" " c C s | j d S( N( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_columns s c G s{ t d | j g t | D] \ } } t d | | ^ q } | j g t | j j j d D] } | d ^ qg S( NR s t%dR ( R R R R t createR R R ( R! R R t type_R R_ ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _type_round_trip s 5
c C sJ xC | j t j d d D]& } t | j d t | j d q Wd S( Ni i ( R R R R t precisiont scale( R! t typ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_numeric_reflection s "c C s0 | j t j d d } t | j d d S( Ni4 i ( R R R R t length( R! R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_varchar_reflection s c C s t d | j t d t d t t d t d t } | j t t d t | j j
j d D i t d 6t d 6 d S( NR t aR> t bc s s# | ] } | d | d f Vq d S( RA R> N( ( t .0R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys
s ( R R R R
R R] R R R1 R R R ( R! R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_nullable_reflection s
c C s | j d t j j d S( NRC ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_columns_with_schema s c C s t | j } | j j } t | j } | j d } | j t | d k t | x5 t | j D]$ \ } } t
| j | | d qk Wd S( NRp i RA ( R R R Rp R R R R R R R RA ( R! R Rp R R R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_table_columns s " c C sO t | j } | j d } t g | D] } | d ^ q( d d d g d S( NR RA R Rq ( R R R R ( R! R R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_temp_view_columns s c C s | j d d d S( NR R ( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_view_columns s c C s | j d t j j d d d S( NRC R R ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_get_view_columns_with_schema s c
C s | j } | j j | j j } } t | j } | j | j d | } | d } t | d g | j | j d | } | d } t | d g t j
j j t | d d Wd QXd S( NRC t constrained_columnsR< RG RA RK (
R R R; RH R R t get_pk_constraintRA R R R6 t reflects_pk_namest fail_if(
R! RC R R; R R t
users_const users_pkeyst addr_const
addr_pkeys( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_pk_constraint% s
c C s | j d S( N( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_pk_constraint6 s c C s | j d t j j d S( NRC ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt" test_get_pk_constraint_with_schema: s c C sD | j } | j j } t | j } t t j d | j | j d S( Ns+ .*get_primary_keys\(\) method is deprecated(
R R R; R R R t sa_exct SADeprecationWarningt get_primary_keysRA ( R! R R; R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_deprecated_get_primary_keys@ s c
C s | j } | j j | j j } } t | j } | } 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( NRC i RA RB t referred_schemat referred_tablet referred_columnsR< R R@ RI ( R R R; RH R R R R6 RY R. t get_foreign_keysRA t named_constraintsR R t implicitly_named_constraintsR R5 (
R! RC R R; R R t expected_schemat users_fkeyst fkey1t
addr_fkeys( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_foreign_keysM s,
c C s | j d S( N( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_foreign_keysn s c C s | j d t j j d S( NRC ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_get_foreign_keys_with_schemar s c C sK | j d t j j j d t j j d t j j \ } } } t 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 } 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 RP RC RR ( R R R Rb Rc R R8 R R RA R R ( R! RO RQ RS R 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_keysw s&
c C s | j d d d S( Nt ondeletet CASCADE( t _test_get_foreign_key_options( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt% test_get_foreign_key_options_ondelete s c C s | j d d d S( Nt onupdates SET NULL( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt% test_get_foreign_key_options_onupdate s c s{ | j } 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 } | j
d d d t t f d D i | j
d d d t t f d D | d S( Nt xR R RD R t x_ids x.idRA 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 s c 3 s) | ] } | r | | f Vq d S( N( ( R R ( R ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys s ( R R R R
R RZ R R R] t ForeignKeyConstraintt
create_allR R R R R1 ( R! R* R R ( ( R s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR s8
#c C so g | D] } | d ^ q } xK | D]C } | | j | d } x# | D] } t | | | | qH Wq$ Wd S( NRA ( t indexR ( R! 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 | j } 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; RC t uniqueR= R? t column_namesR} RA R< R~ ( R R R t get_indexesR] R ( R! RC R R R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_indexes s
c C s | j d S( N( R ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_indexes s c C s | j d t j j d S( NRC ( R R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_indexes_with_schema s c C s | j } t | j } | j | } i t d 6| d 6g } | j | | t | | d | j } t t | j d t
t | j d j | t t | j d j
| d S( NR RA t
autoload_withi i ( R R R R R] R R R R R R t listR RA ( R! t tnamet ixnameR R 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 s | j d d d S( NRT RW ( R! ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_noncol_index_no_pk s c C s | j d d d S( NRV RX ( R! ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_noncol_index_pk s c C s t d | j t d t d t d t d t j | j d t d t j | j d t d | j j t | j j } t
d 6 t | j d i d d
6d g d 6d d
6g Wd QXd S( NR R i t yRt s+ CREATE INDEX t_idx ON t(lower(x), lower(y))s CREATE INDEX t_idx_2 ON t(x)s> Skipped unsupported reflection of expression-based index t_idxt t_idx_2RA R i R (
R R R R R R{ R R R R R R R ( R! R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt% test_reflect_expression_based_indexes s$
c C s | j d S( N( t _test_get_unique_constraints( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_unique_constraints, s c C sd t | j } | j d } x | D] } | j d d q% Wt | i d g d 6d d 6g d S( NRp t duplicates_indexRA R Rr ( R R t get_unique_constraintst popR5 R ( R! R t reflectedt refl( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt& test_get_temp_table_unique_constraints0 s
c C s t | j } | j d } x | D] } | j d d q% Wt g | D] } | d d k rI | ^ qI i t d 6d g d 6d d 6g d S( NRp t dialect_optionsRA Rs R Rq R ( R R R R+ R5 R R] ( R! R R t indt 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 | j d t j j d S( NRC ( R' R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt' test_get_unique_constraints_with_schemaN s c C s 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 } | j } 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 q*W| j t | j
} t | j d d | d t j d } t } xR t | | D]A \ } }
|
j d d } | r| j | n t | |
qWt } t d | d | j
d | } t g | j D] }
|
j ^ q- } t g | j D]! } t | t j
rR| j ^ qR j d g } | rt | | t | t n d S( Nt unique_aRA R R t unique_a_b_cR R_ t unique_c_a_bt unique_asc_keyt ascR s i.have.dotss
i have spacest testtbli i RC R) R ( R t operatort
itemgetterR R R RZ R R
t append_constraintRx R R R R* R R R+ R5 t addR R R RA t constraintsR t
difference( R! RC t uniquest orig_metaR t uct inspectorR, t names_that_duplicate_indext origR- t dupet reflected_metadataR1 t idx_namest uqt uq_names( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR' S s^
"
%
$
c C s | j d S( N( t _test_get_check_constraints( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_check_constraints s c C s | j d t j j d S( NRC ( RK R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt! test_get_check_constraints_schema s c C s | j } t d | t d t t j d d d t j d d d d | | j t | j } 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 < 5RA t cc1s a = 1 OR (a > 2 AND a < 5)t cc2RC 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 RW s a > 1 and a < 5s a = 1 or a > 2 and a < 5( R R R R
RZ t CheckConstraintR R R R t get_check_constraintsR: R; R ( R! RC RA RC R, RX t item( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyRK s(
2c C sl | j } d } d } t | j } | j | d | } | j | | j | d | } | j | d S( NR R RC ( R R R t get_view_definitionR ( R! RC R t
view_name1t
view_name2R t v1t v2( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_view_definition s
c C s | j d S( N( Ra ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_view_definition s c C s | j d t j j d S( NRC ( Ra R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt$ test_get_view_definition_with_schema s t
postgresqls PG specific featurec C sD | j } t | j } | j | | } | j t | t d S( N( R R R t
get_table_oidR R t int( R! R RC R R t oid( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt _test_get_table_oid s c C s | j d d S( NR; ( Rh ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_oid s c C s | j d d t j j d S( NR; RC ( Rh R R R8 ( R! ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt test_get_table_oid_with_schema s c C s_ | j } t | j } x@ d d
d g D]/ \ } } | j | } d | D | } 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< RH RG RE RF c S s i | ] } | | d q S( RA ( ( R R_ ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pys
s N( R; R< ( RH RG ( RE RF ( R R R R ( R! R R 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% R5 t run_insertst run_deletesR R& R' R3 R R4 Rj Re Rh R R6 t schema_reflectionR R R t provide_metadataR R R Ry Rz R t table_reflectionR t! foreign_key_constraint_reflectionR t comment_reflectionR R7 R R R Rg R R R R R R R R R R Ri R R R R R t! primary_key_constraint_reflectionR R R R R R Ra R t1 foreign_key_constraint_option_reflection_ondeleteR t1 foreign_key_constraint_option_reflection_onupdateR R R R Rd R R R! R" R# t indexes_with_expressionsR& t unique_constraint_reflectionR( R. R2 R3 R' t check_constraint_reflectionRL RM RK Ra Rb Rc t only_onRh Ri Rj Rm ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR( 2 s
$% 8
"-
N '
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 t1t quoteR R t t2t t1ids t1.id( R R R R R
R ( R R ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR s c C sc t t j } t t d d t | d t } | j d } t t j } | j d d d S( NR R t autoloadR~ t onlyc S s | j d k S( NR~ R ( R~ R ( RU ( RA t m( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt , R: ( R R R R R R R t reflect( R! 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~ R i i ( R~ R ( R R R R RU R t upper( R! R t
tablenames( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR / s
!( R} ( R$ R% t __requires__R R& R' R R R ( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyR| s
(( R: RS R/ RZ R: R R R R R R R RC R R R R
R R R R
R R R R R t engine.reflectionR R R t sql.elementsR R5 R R; t
TablesTestR R( R| t __all__( ( ( s[ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/suite/test_reflection.pyt s@ (