File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyc
�
���ec @ s� d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d
l m Z d d l
m Z d d l m
Z
d d
l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d! e j e f d" � � YZ d# e j f d$ � � YZ! d% S(& i ( t testingi ( t
assert_raises( t config( t engines( t eq_( t fixtures( t ne_( t provide_metadata( t requirements( t set_default_schema_on_connection( t Column( t Tablei ( t bindparam( t event( t exc( t Integer( t literal_column( t select( t String( t compatt
ExceptionTestc B sD e Z d Z d Z e Z e d � � Z e j d � � Z
d � Z RS( s� Test basic exception wrapping.
DBAPIs vary a lot in exception behavior so to actually anticipate
specific exceptions from real round trips, we need to be conservative.
t eachc
C s; t d | t d t d t d t �t d t d � � � d S( Nt manual_pkt idt primary_keyt
autoincrementt datai2 ( R R
R t Truet FalseR ( t clst metadata( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt
define_tables+ s
c C s� t j j � �z } | j � } | j | j j j � i d d 6d d 6� t t j
| j | j j j � i d d 6d d 6� | j � Wd QXd S( Ni R t d1R ( R t dbt connectt begint executet tablesR t insertR R t IntegrityErrort rollback( t selft connt trans( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_integrity_error4 s $c C s� t j j � �� } y) | j t t d � � � t s: t � WnC t j k
r� } t
| � } t
| j � t
| � k s� t � n Xt j
r� t | t
� s� t � n t | t
� s� t � Wd QXd S( Nu méil( R R! R" R$ R R R t AssertionErrorR t
DBAPIErrort strt origR t py2kt
isinstance( R) R* t errt err_str( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_exception_with_non_asciiG s % ( t __name__t
__module__t __doc__t run_deletesR t __backend__t classmethodR R t$ duplicate_key_raises_integrity_errorR, R5 ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyR s t IsolationLevelTestc B s8 e Z e Z d Z d � Z d � Z d � Z d � Z RS( t isolation_levelc C s_ t j t � } | d } | d } t | � j d | g � } | rN | j � St j d � d S( Nt defaultt supportedt
AUTOCOMMITs( no non-default isolation level available( R t get_isolation_levelsR t sett
differencet popt skip_test( R) t levelsR? R@ t s( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt _get_non_default_isolation_levelc s
c C s' t t j j j t j t � d � d S( NR? ( R R R! t dialectt default_isolation_levelR RB ( R) ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_default_isolation_levelo s c C s� | j � } t j j � �i } | j � } t | | � | j d | � t | j � | � | j j | j
� t | j � | � Wd QXd S( NR> ( RI R R! R" t get_isolation_levelR t execution_optionsR RJ t reset_isolation_levelt
connection( R) t non_defaultR* t existing( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_non_default_isolation_levelu s
c
C s� t j t � } | d } x� t | � j d g � D]� } t j j � �S } | j d | � t | j � | � | j
� } | j � t | j � | � Wd QXt j j � � } t | j � | d � Wd QXq2 Wd S( NR@ RA R> R? ( R RB R RC RD R! R" RN R RM R# R( ( R) RG t
all_levelst levelR* R+ ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_all_levels� s
( R> ( R6 R7 R R: t __requires__RI RL RS RV ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyR= ^ s t AutocommitIsolationTestc B sM e Z d Z d Z e Z e d � � Z d � Z d � Z d � Z
d � Z RS( R t
autocommitc
C sA t d | t d t d t d t �t d t d � � d t �d S( Nt
some_tableR R R R i2 t test_needs_acid( R R
R R R R ( R R ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyR � s c C s� | j � } | j | j j j � i d d 6d d 6� | j � t | j t | j j j j
� � | rm d n d � | j � � | j | j j j � � Wd QXd S( Ni R s some dataR (
R# R$ R% RZ R& R( R t scalarR t cR t Nonet delete( R) R* RY R+ ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt _test_conn_autocommits� s $
c C sO | } | j d d � } | j | t � | j j | j � | j | t � d S( NR> RA ( RN R` R RJ RO RP R ( R) t connection_no_transR* t c2( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_autocommit_on� s
c C s | } | j | t � d S( N( R` R ( R) Ra R* ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_autocommit_off� s c C sY | } | j d d � } | j | t � | j d t j t � d � | j | t � d S( NR> RA R? ( RN R` R R RB R R ( R) Ra R* ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt. test_turn_autocommit_off_via_default_iso_level� s ( RY ( R6 R7 R9 RW R R: R; R R` Rc Rd Re ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyRX � s
t EscapingTestc B s e Z e d � � Z RS( c
C s | j } t d | t d t d � � � } | j t j � t j j � �� } | j | j � t
d d � � | j | j � t
d d � � t | j t
| j j � j | j j t d � k � � d � t | j t
| j j � j | j j t d � k � � d � Wd QXd S( s| test that the DBAPI accommodates for escaped / nonescaped
percent signs in a way that matches the compiler
t tR i2 s some % values some %% other values 'some % value's 'some %% other value'N( R R R
R t createR R! R# R$ R& t dictR R\ R R] R t whereR ( R) t mRg R* ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_percent_sign_round_trip� s ! ( R6 R7 R Rl ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyRf � s t WeCanSetDefaultSchemaWEventsTestc B s8 e Z e Z d Z d � Z d � Z d � Z d � Z RS( t default_schema_name_switchc C sE t j j j } t j � } | j � � Wd QXt | j j | � d S( N( R R! RJ t default_schema_nameR t testing_engineR" R ( R) Ro t eng( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_control_case� s
c C s� t j j j } t j � } t j | d � d � � } | j � �) } | j j | � } t
| t j � Wd QXt
| j j | � d S( NR" c S s t t | t j � d S( N( R R t test_schema( t dbapi_connectiont connection_record( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt
on_connect
s ( R R! RJ Ro R Rp R
t listens_forR" t _get_default_schema_nameR Rs ( R) Ro Rq Rv R* t what_it_should_be( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_wont_work_wo_insert s c C s~ t j � } t j | d d t �d � � } | j � �) } | j j | � } t | t j
� Wd QXt | j j t j
� d S( NR" R& c S s t t | t j � d S( N( R R Rs ( Rt Ru ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyRv s ( R Rp R
Rw R R" RJ Rx R R Rs Ro ( R) Rq Rv R* Ry ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_schema_change_on_connect s !c C s� t j � } t j | d d t �d � � } | j � �a } | j � } | j j | � } t | t
j � | j � | j j | � } t | t
j � Wd QXt | j j
t
j � d S( NR" R& c W s t t | t j � d S( N( R R Rs ( Rt t arg( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyRv + s ( R Rp R
Rw R R" R# RJ Rx R R Rs R( Ro ( R) Rq Rv R* R+ Ry ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt' test_schema_change_works_w_transactions( s !
( Rn ( R6 R7 R R: RW Rr Rz R{ R} ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyRm � s t& FutureWeCanSetDefaultSchemaWEventsTestc B s e Z RS( ( R6 R7 ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyR~ = s t DifficultParametersTestc B s� e Z e Z e j d d d d d d d! d" d# d$ d% d& d' d( d) d* d+ d, d- d. d/ d d �Z e e j j d � � � Z
e j d � � Z e d � � Z
e d � � Z RS(0 t borings per cents
per % cents %percents par(ens)s percent%(ens)yahs col:onst _starts_with_underscores dot.ss more :: %colons%t _namet ___names [BracketsAndCase]t 42numberss
percent%signss
has spacess /slashes/s more/slashess q?markst 1params 1col:ont argnamest paramnamec C sb | } t d | t d t d t �t | t d � d t �� } | j | � | j | j � j i d d 6d | 6� � t
| j | � j | j | d k � } t
| j | � d � t
| j | � j | j | t | � k � } | j | i d | 6� j � } t
| j | d � t
| j | � j | j | j d d g � � } | j | � j � } d S( NRg R R i2 t nullablei s some names some other_name( R R
R R R R Rh R$ R& t valuesR R] Rj R R\ R t firstt _mappingt in_( R) R� RP R t nameRg t stmtt row( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt! test_round_trip_same_named_column_ s
*)/ c c s� t d | t d t � t d t d � � t d t d � � � } | j | � | j | j � i d d 6d d 6d d 6i d d 6d
d 6d d 6i d d 6d
d 6d d 6i d d 6d d 6d d 6g � | Vd S( Nt mytablet myidR� i2 t desci t at a_desci t bt b_desci R] t c_desci t dt d_desc( R R
R R Rh R$ R& ( R) R RP R� ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt multirow_fixture� s
c C sc | } t | j j � j | j j t | d d �k � } | j | i d | 6� } t | d � d S( Nt valuet xR] i ( R R] R� Rj R� R R\ R ( R) R� RP R� t tbl1R� t res( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt test_standalone_bindparam_escape� s
!c C s� | } t | j j � j | j j j t | d d d g �� � j | j j � } | j | i d d g | 6� j � } t
| d d g � d S( NR� R� R� R� i i ( R R] R� Rj R� R� R t order_byt scalarst allR ( R) R� RP R� R� R� R� ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt* test_standalone_bindparam_escape_expanding� s *%( R� ( s per cent( s
per % cent( s %percent( s par(ens)( s percent%(ens)yah( s col:ons( R� ( s dot.s( s more :: %colons%( R� ( R� ( s [BracketsAndCase]( R� ( s
percent%signs( s
has spaces( s /slashes/( s more/slashes( s q?marks( R� ( s 1col:on( R6 R7 R R: R t combinationst tough_parametersR R t unusual_column_name_charactersR� t fixtureR� R� R� ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyR C s: ' N(" t R R R R R R R R R t provisionR t schemaR
R R R
R R R R R t utilR t
TablesTestR t TestBaseR= RX Rf Rm t FutureEngineMixinR~ R ( ( ( sV /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/suite/test_dialect.pyt <module> s6 ?>=!C