ó
|
X\¬Qc @ s d d l Z d d l Z d d l Z d d l Z d Z d e j f d YZ d e j f d YZ d Z d Z
|
e d k r e
|
n d S(
|
iÿÿÿÿNc C s d S( Nt sqlite_testdb( ( ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt get_db_path s t TransactionTestsc B sk e 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 y t j t Wn t k
|
r' n Xt j t d d | _ | j j | _ t j t d d | _ | j j | _
|
d S( Nt timeoutg¹?( t ost removeR t OSErrort sqlitet connectt con1t cursort cur1t con2t cur2( t self( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt setUp s c C s` | j j | j j | j j | j j y t j t Wn t k
|
r[ n Xd S( N( R t closeR R R R t unlinkR R ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt tearDown, s c C si | j j d | j j d | j j d | j j d | j j } | j t | d d S( Ns create table test(i)s insert into test(i) values (5)s create table test2(j)s select i from testi ( R t executeR t fetchallt assertEqualt len( R t res( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckDMLdoesAutoCommitBefore8 s c C sY | j j d | j j d | j j d | j j } | j t | d d S( Ns create table test(i)s insert into test(i) values (5)s select i from testi ( R R R R R R ( R R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckInsertStartsTransaction@ s
|
c C st | j j d | j j d | j j | j j d | j j d | j j d } | j | d d S( Ns create table test(i)s insert into test(i) values (5)s update test set i=6s select i from testi i ( R R R t commitR t fetchoneR ( R R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckUpdateStartsTransactionG s c C sv | j j d | j j d | j j | j j d | j j d | j j } | j t | d d S( Ns create table test(i)s insert into test(i) values (5)s delete from tests select i from testi ( R R R R R R R R ( R R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckDeleteStartsTransactionP s c C s | j j d | j j d | j j | j j d | j j d | j j } | j t | d | j | d d d d S( Ns create table test(i)s insert into test(i) values (5)s replace into test(i) values (6)s select i from testi i i ( R R R R R R R R ( R R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckReplaceStartsTransactionY s c C sâ | j j d | j j d d | j _ | j | j j d | j j d | j j } | j t | d d | j _ | j | j j d | j j d | j j d | j j } | j t | d d S( Ns create table test(i)s insert into test(i) values (5)s select i from testi t DEFERRED( R R t NoneR t isolation_levelR R R R ( R R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckToggleAutoCommitc s c C s t j d k r d S| j j d | j j d y! | j j d | j d Wn' t j k
|
rj n | j d n Xd S( Ni i s create table test(i)s insert into test(i) values (5)s& should have raised an OperationalError( i i i ( R t sqlite_version_infoR R R t failt OperationalError( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckRaiseTimeouts s c C s t j d k r d S| j j d | j j d y! | j j d | j d Wn' t j k
|
rj n | j d n X| j j d S( s
|
This tests the improved concurrency with pysqlite 2.3.4. You needed
|
to roll back con2 before you could commit con1.
|
i i Ns create table test(i)s insert into test(i) values (5)s& should have raised an OperationalError( i i i ( R R# R R R R$ R% R R ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckLocking s c C s t j d } | j } | j d | j d | j d | j y | j | j d Wn) t j k
|
r } n | j d n Xd S( s
|
Checks if cursors on the connection are set into a "reset" state
|
when a rollback is done on the connection.
|
s :memory:s create table test(x)s insert into test(x) values (5)s& select 1 union select 2 union select 3s& InterfaceError should have been raisedN( R R R
|
R t rollbackR R$ t InterfaceError( R t cont curt e( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckRollbackCursorConsistency s
|
|
( t __name__t
|
__module__R R R R R R R R" R& R' R- ( ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyR s
|
t SpecialCommandTestsc B s5 e Z d Z d Z d Z d Z d Z RS( c C s( t j d | _ | j j | _ d S( Ns :memory:( R R R* R
|
R+ ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyR ¬ s c C s4 | j j d | j j d | j j d d S( Ns create table test(i)s insert into test(i) values (5)t vacuum( R+ R ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckVacuum° s c C s4 | j j d | j j d | j j d d S( Ns create table test(i)s insert into test(i) values (5)s drop table test( R+ R ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckDropTableµ s c C s4 | j j d | j j d | j j d d S( Ns create table test(i)s insert into test(i) values (5)s pragma count_changes=1( R+ R ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt CheckPragmaº s c C s | j j | j j d S( N( R+ R R* ( R ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyR ¿ s ( R. R/ R R2 R3 R4 R ( ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyR0 « s
|
c C s7 t j t d } t j t d } t j | | f S( Nt Check( t unittestt makeSuiteR R0 t TestSuite( t default_suitet special_command_suite( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt suiteà s c C s t j } | j t d S( N( R6 t TextTestRunnert runR; ( t runner( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt testÈ s t __main__( t sysR R6 t sqlite3R R t TestCaseR R0 R; R? R. ( ( ( sa /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/transactions.pyt <module> s
|
