Ñò
…=vIc @ s{ d d k Z d d k Z d d k Z d d k Z d d k Z d d k l Z l Z d d k l Z
d d k l Z e e i
i d ƒ ƒ Z e i
i d d ƒ Z e i i d ƒ d d
d g j Z e Z d e f d
„ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ e i e ƒ Z e i e ƒ Z e op e i e i d e d e
i ƒ d e d e d e ƒ ƒ Z e i e i d e
i ƒ d e d e d e ƒ ƒ Z! n e oX e i e i d e d e
i ƒ d e ƒ ƒ Z e i e i d e
i ƒ d e ƒ ƒ Z! n e i" ƒ Z# e i$ d e# e i% d e i& d e ƒe i% d e i' d ƒ ƒ e i% d e i' d ƒ ƒ ƒ Z( e i$ d e# e i% d e i& d e ƒe i% d e i& ƒ e i% d e i' d ƒ ƒ e i) d f d f ƒ ƒ Z* e i+ e e( d! h e i, e d" e( i- d e* i- d j ƒd# 6ƒe i+ e e* ƒ e i" e ƒ Z. e i" e ƒ Z/ e i$ d$ e. e i% d e i& d e ƒƒ Z0 e i$ d% e/ e i% d e i& d e ƒƒ Z1 d& e f d' „ ƒ YZ2 d( e f d) „ ƒ YZ3 e i+ e2 e0 ƒ e i+ e3 e1 ƒ d* e4 f d+ „ ƒ YZ5 d, e5 f d- „ ƒ YZ6 d. e5 f d/ „ ƒ YZ7 d0 e f d1 „ ƒ YZ8 d2 e i9 f d3 „ ƒ YZ: d4 e i9 f d5 „ ƒ YZ; d6 „ Z< d7 „ Z= d S(8 iÿÿÿÿN( t ormt sql( t datamanager( t mark_changedt
TEST_TWOPHASEt TEST_DSNs sqlite:///:memory:t .i t 0t 4t SimpleModelc B s e Z d „ Z d „ Z RS( c K s1 x* | i ƒ D] \ } } t | | | ƒ q
Wd S( N( t itemst setattr( t selft kwt kt v( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt __init__- s
c C s t d „ | i i ƒ Dƒ ƒ S( Nc s s9 x2 | ]+ \ } } | i d ƒ p | | f Vq q Wd S( t _N( t
startswith( t .0R R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pys 1 s ( t dictt __dict__R
( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt asDict0 s ( t __name__t
__module__R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR , s t Userc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR 3 s t Skillc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR 4 s t bindt extensiont
transactionalt autoflusht twophaset
test_userst idt primary_keyt firstnameiÿ t lastnamet test_skillst user_idt names
test_users.idt
propertiest primaryjoint skillst test_onet test_twot TestOnec B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR- o s t TestTwoc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR. p s t DummyExceptionc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR/ v s t DummyTargetRaisedc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR0 y s t DummyTargetResultc B s e Z RS( ( R R ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR1 | s t DummyDataManagerc B sY e Z d d h d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z
RS(
c C s( | | _ | | _ | | _ | | _ d S( N( t keyt targett argst kwargs( R R3 R4 R5 R6 ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR € s c C s d S( N( ( R t trans( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt abort† s c C s d S( N( ( R R7 ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt tpc_begin‰ s c C s d S( N( ( R R7 ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt commitŒ s c C sp | i d j oP y | i | i | i Ž } Wn! t j
o } t | ƒ ‚ n Xt | ƒ ‚ n
t d ƒ ‚ d S( Ns DummyDataManager cannot commit( R4 t NoneR5 R6 t ExceptionR0 R1 R/ ( R R7 t resultt e( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt tpc_vote s c C s d S( N( ( R R7 ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
tpc_finish™ s c C s d S( N( ( R R7 ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt tpc_abortœ s c C s | i S( N( R3 ( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt sortKeyŸ s N( ( R R R; R R8 R9 R: R? R@ RA RB ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR2 s
t ZopeSQLAlchemyTestsc B s} e Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z
d „ Z d
„ Z d „ Z
d „ Z RS(
c C s t i t ƒ t i t ƒ d S( N( t metadatat drop_allt enginet
create_all( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt setUp¥ s
c C s t i ƒ t i t ƒ d S( N( t transactionR8 RD RE RF ( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt tearDown© s
c C s¥ t i ƒ t ƒ } | i ƒ } | i t | i d ƒ t | ƒ y t i ƒ Wn t i ƒ n Xt i ƒ t ƒ } | i ƒ } | i d ƒ t | ƒ t i ƒ d S( Ns BAD SQL SYNTAXs SELECT 1(
RI t begint Sessiont
connectiont assertRaisesR< t executeR R: R8 ( R t sessiont conn( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testAbortAfterCommit s
c C sG t ƒ } | i t ƒ } | i ƒ } | i t | ƒ d ƒ | i t d d d d d d ƒ ƒ | i t d d d d d d
ƒ ƒ | i ƒ | i t i ƒ i ƒ } | i t | ƒ d ƒ | d } | i
ƒ } | i | h d d 6d d 6d d 6ƒ t i t
i ƒ i d ƒ } | i ƒ } | i | ƒ } | i | i ƒ d d g ƒ d S( Ni R! i R# t udoR$ t juergensi t heinos n/au udou juergensu heinou n/a( i u udou juergens( i u heinou n/a( RL t queryR t allt assertEqualt lent addt flusht order_byR! R R t selectR t columnsRM RO t fetchall( R RP RV t rowst row1t dt stmtRQ t results( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testSimplePopulationÇ s ""
% c C sw t ƒ } | i t d d d d d d ƒ ƒ | i t ƒ i d d ƒ d } | i i t d d d d ƒ ƒ | i ƒ d S(
NR! i R# t fooR$ t bari R' t Zope( RL RZ R RV t filter_byR* t appendR R[ ( R RP t user( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
testRelationsÝ s
" c
C s9 t i ƒ t i ƒ } | i g } | i D]$ } t | t i ƒ o | | q* q* ~ d ƒ t ƒ } | i t
d d d d d d ƒ ƒ t i ƒ } | i g } | i D]$ } t | t i ƒ o | | q¦ q¦ ~ d ƒ t i ƒ t ƒ i ƒ } | i g } | i D]$ } t | t i ƒ o | | qq~ d ƒ d S( Ns Joined transaction too earlyR! i R# RS R$ RT s Not joined transaction(
RI R8 t gett failIft
_resourcest
isinstancet txt SessionDataManagerRL RZ R t
failUnlessRM ( R t tt _[1]t rRP t _[2]RQ t _[3]( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testTransactionJoiningå s
> " >
>c C s„ t i i t i j } t i ƒ } t ƒ } | i t ƒ } | i
| i ƒ d ƒ | i d t
ƒ } | p | i t | i ƒ d S| i ƒ } | i t d d d d d d ƒ ƒ | i ƒ | i t | i ƒ ƒ d j d ƒ | i ƒ } | i t d d
d d d d ƒ ƒ | i ƒ | i t | i ƒ ƒ d
j d
ƒ | i ƒ | i t | i ƒ ƒ d j d ƒ | i ƒ | i
| i ƒ d ƒ d S( Ns Users table should be emptyt
optimisticR! i R# RS R$ RT s Users table should have one rowi RU s n/as Users table should have two rows( RF t urlt
drivernameRq t NO_SAVEPOINT_SUPPORTRI Rm RL RV R Rn RW t savepointt TrueRN t TypeErrorRZ R[ Rs RY t rollback( R t
use_savepointRt RP RV t s0t s1t s2( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
testSavepointõ s* "
" "
"
"
c C sŒ t ƒ } t i i t i j } | i t ƒ } | i ƒ } | i t
| ƒ d ƒ t i ƒ t ƒ } | i t ƒ } | i
t d d d d d d ƒ ƒ | i
t d d d d d d
ƒ ƒ | i ƒ | i t i ƒ i ƒ } | i t
| ƒ d ƒ t i ƒ t ƒ } | i t ƒ } | i t i ƒ i ƒ } | i t
| ƒ d ƒ | i
t d d d d d d ƒ ƒ | i
t d d d d d d
ƒ ƒ | i ƒ | i t i ƒ i ƒ } | d } | i ƒ } | i | h d d 6d d 6d d 6ƒ t i ƒ | i t i ƒ i ƒ } | i t
| ƒ d ƒ | d } | i ƒ } | i | h d d 6d d 6d d 6ƒ t i ƒ i t i ƒ ƒ } | i t
| i ƒ ƒ d ƒ d S( Ni R! i R# RS R$ RT i RU s n/a( RL RF R{ R| Rq R} RV R RW RX RY RI R: RZ R[ R\ R! R8 R t connectRO R R] R_ ( R RP R‚ RV R` Ra Rb Rd ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
testCommit sB
""
""
%
%c C s$ t i i t i j o d St ƒ } | i t d d d d d d ƒ ƒ | i t d d d d d d ƒ ƒ | i ƒ t i
ƒ t ƒ } | i t ƒ } t i ƒ } | i
t i ƒ i ƒ } | i ƒ } | i | d ƒ | i ƒ t i
ƒ t i ƒ i t i ƒ ƒ } | i t | i ƒ ƒ d ƒ d S(
NR! i R# RS R$ RT i RU s n/a( RF R{ R| Rq R} RL RZ R R[ RI R: RV Rm R\ R! RW R~ t deleteR‡ RO R R] RX RY R_ ( R RP RV Rt R` R„ Rd ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testCommitWithSavepoint@ s" ""
c C sŒ t ƒ } | i p d S| i t d d d d d d ƒ ƒ | i t d d d d d d ƒ ƒ | i ƒ t i ƒ t i ƒ } d
„ } t d d d
| ƒ } | i | ƒ t ƒ } | i
t ƒ } | i ƒ } | i | d ƒ | i ƒ d } y | i ƒ WnC t j
o } | i d } n# t j
o } | i d ‚ n X| i t | ƒ d d ƒ t i ƒ | i t t i ƒ i ƒ ƒ d d ƒ d S( NR! i R# RS R$ RT i RU s n/ac S s t i ƒ i ƒ S( N( RF R‡ t recover_twophase( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR4 d s R3 s
~~~dummy.lastR4 i s< Should have been one prepared transaction when dummy aborteds) Test no outstanding prepared transactions( RL R RZ R R[ RI R: Rm R2 t joinRV RW R‰ R; R1 R5 R0 RX RY RK RF R‡ R‹ ( R RP Rt R4 t dummyRV R` R= R> ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testTwoPhaseX s4
""
c s` t i ƒ d a ‡ f d † } t i d | ƒ } | i ƒ | i ƒ t d j o
t ‚ n d S( Nc s; yt ƒ } t i t ƒ t i t ƒ | i t ƒ } | i ƒ } ˆ i t | ƒ d ƒ | i
t d d d d d d ƒ ƒ | i
t d d d d d d
ƒ ƒ | i ƒ | i t i
ƒ i ƒ } ˆ i t | ƒ d ƒ | d } | i ƒ } ˆ i | h d d 6d d 6d d 6ƒ Wn t j
o } | a n Xt i ƒ d S( Ni R! i R# RS R$ RT i RU s n/a( RL RD RE RF RG RV R RW RX RY RZ R[ R\ R! R R< t thread_errorRI R8 ( RP RV R` Ra Rb t err( R ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR4 s$
""
) R4 ( RI R8 R; R t threadingt Threadt startRΠ( R R4 t thread( ( R s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
testThread} s
c C s¸ t ƒ } | i t d d d d d d ƒ ƒ | i t d d d d d d ƒ ƒ t i ƒ t ƒ } | i t ƒ i ƒ t i ƒ t i ƒ i t
i ƒ ƒ } | i t
| i ƒ ƒ d
ƒ d S( NR! i R# RS R$ RT i RU s n/ai ( RL RZ R RI R: RV R‰ RF R‡ RO R R] RX RY R_ ( R RP Rd ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testBulkDeleteŸ s ""
c C sÓ t ƒ } | i t d d d d d d ƒ ƒ | i t d d d d d d ƒ ƒ t i ƒ t ƒ } | i t ƒ i t d d
ƒ ƒ t i ƒ t i ƒ i
t i t i
i d
j ƒ ƒ } | i t | i ƒ ƒ d ƒ d S( NR! i R# RS R$ RT i RU s n/at smith( RL RZ R RI R: RV t updateR RF R‡ RO R R] t cR$ RX RY R_ ( R RP Rd ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testBulkUpdateª s ""
*( R R RH RJ RR Re Rl Ry R† Rˆ RŠ RŽ R• R– Rš ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyRC £ s . % " t MultipleEngineTestsc B s# e Z d „ Z d „ Z d „ Z RS( c C s, t i ƒ t i ƒ t i ƒ t i ƒ d S( N( t bound_metadata1RE RG t bound_metadata2( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyRH ¸ s
c C s" t i ƒ t i ƒ t i ƒ d S( N( RI R8 Rœ RE R ( R ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyRJ ¾ s
c C s¬ t ƒ } | i t d d ƒ ƒ | i t d d ƒ ƒ | i ƒ t i ƒ t ƒ } | i t ƒ i ƒ } | i t
| ƒ d ƒ | i t ƒ i ƒ } | i t
| ƒ d ƒ d S( NR! i i ( t UnboundSessionRZ R- R. R[ RI R: RV RW RX RY ( R RP R` ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt testTwoEnginesà s
( R R RH RJ RŸ ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyR› ¶ s c C s. | i d } | i d } | i i | ƒ d S( Nt BaseRF ( t globsRD RE ( t testR RF ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt tearDownReadMeÏ s
c C s d d k l } l } d d k } | i | i B} | ƒ } x' t t f D] } | i | | ƒ ƒ qH W| i | i d d | d t
d h t d 6t d 6t
d 6t d
6ƒƒ | S( Niÿÿÿÿ( t TestSuitet makeSuites
README.txtt optionflagsRJ R¡ R R t SA_0_4t SA_0_5( t unittestR¤ R¥ t doctestt NORMALIZE_WHITESPACEt ELLIPSISRC R› t addTestt DocFileSuiteR£ R R R§ R¨ ( R¤ R¥ Rª R¦ t suitet cls( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt
test_suiteÔ s
&(> t osR© RI R‘ t
sqlalchemyt saR R t zope.sqlalchemyR Rq R t boolt environRm R R t __version__t splitR§ R¨ t objectR R R t
create_engineRF t engine2t scoped_sessiont sessionmakert ZopeTransactionExtensionR RL Rž t MetaDataRD t Tablet Columnt Integert VARCHARR t ForeignKeyConstraintR% t mappert relationR^ Rœ R R+ R, R- R. R< R/ R0 R1 R2 t TestCaseRC R› R£ R± ( ( ( s9 /usr/lib/python2.6/site-packages/zope/sqlalchemy/tests.pyt sˆ " "**$ÿ