PATH:
usr
/
lib64
/
python2.7
/
sqlite3
/
test
� ��^c @ s� d d l Z d d l Z d d l Z d d l Z d d l m Z d e j f d � � YZ d f d � � YZ d e j f d � � YZ d � Z d � Z e d k r� e � n d S( i����N( t supportt RegressionTestsc 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 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 d � Z RS( c C s t j d � | _ d S( Ns :memory:( t sqlitet connectt con( t self( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt setUp s c C s | j j � d S( N( R t close( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt tearDown" s c C s | j j � } | j d � d S( Ns pragma user_version( R t cursort execute( R t cur( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckPragmaUserVersion% s c C sT t j d d t j �} z | j j � } | j d � Wd | j � | j � Xd S( Ns :memory:t detect_typess pragma schema_version( R R t PARSE_COLNAMESR R R R ( R R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckPragmaSchemaVersion* s c C s� t j d d d �} g t d � D] } | j � ^ q" } | d j d � xD t d � D]6 } | d j d g t d � D] } | f ^ qx � qX Wx- t d � D] } | | j d | d � q� W| j � d S( Ns :memory:t cached_statementsi i s create table test(x)i s insert into test(x) values (?)t s select x from test( R R t xrangeR R t ranget executemanyt rollback( R R t xt cursorst i( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckStatementReset4 s %4 c C sc | j j � } | j d � | j | j d d d � | j d � | j | j d d d � d S( Ns select 1 as "foo bar [datetime]"i s foo bars select 1 as "foo baz"s foo baz( R R R t assertEqualt description( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckColumnNameWithSpacesC s c C sj t j d � } g } xD t d � D]6 } | j � } | j | � | j d t | � � q" W| j � d S( Ns :memory:ii s select 1 x union select ( R R R R t appendR t strR ( R R R R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt# CheckStatementFinalizationOnCloseDbK s c C s� t j d k r d St j d � } | j d � | j d � y | j d � Wn t j k rc n X| j d � y | j � Wn! t j k r� | j d � n Xd S( Ni i s :memory:s3 create table foo(x, unique(x) on conflict rollback)s insert into foo(x) values (1)s insert into foo(x) values (2)s1 pysqlite knew nothing about the implicit ROLLBACK( i i i ( R t sqlite_version_infoR R t DatabaseErrort committ OperationalErrort fail( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckOnConflictRollbackY s c C s4 | j j d � | j j d � | j j d � d S( sm pysqlite would crash with older SQLite versions unless a workaround is implemented. s create table foo(bar)s drop table fooN( R R ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt- CheckWorkaroundForBuggySqliteTransferBindingsi s c C s | j j d � d S( s pysqlite used to segfault with SQLite versions 3.5.x. These return NULL for "no-operation" statements t N( R R ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckEmptyStatementr s c C s t j d � } | j � d S( s With pysqlite 2.4.0 you needed to use a string or an APSW connection object for opening database connections. Formerly, both bytestrings and unicode strings used to work. Let's make sure unicode strings work in the future. u :memory:N( R R R ( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckUnicodeConnecty s c C s� d } t j d d t j �} | j d � | j d t j j � f � | j | � | j d � | j d � | j d � | j | � d S( s� pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling a statement. This test exhibits the problem. s select * from foos :memory:R s create table foo(bar timestamp)s insert into foo(bar) values (?)s drop table foos create table foo(bar integer)s insert into foo(bar) values (5)N( R R t PARSE_DECLTYPESR t datetimet now( R t SELECTR ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckTypeMapUsage� s c C s | j t t j i d � d S( s! See issue 3312. N( t assertRaisest TypeErrorR t register_adaptert None( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckRegisterAdapter� s c C s, t j d � } | j t t | d d � d S( s! See issue 3312. s :memory:t isolation_levelu éN( R R R/ t UnicodeEncodeErrort setattr( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckSetIsolationLevel� s c C s� d t j f d � � Y} t j d � } | | � } y$ | j d � j � | j d � Wn' t j k rn n | j d � n X| j t j d � � | j � Wd QXd S( sd Verifies that cursor methods check whether base class __init__ was called. t Cursorc B s e Z d � Z RS( c S s d S( N( ( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt __init__� s ( t __name__t __module__R9 ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR8 � s s :memory:s select 4+5s# should have raised ProgrammingErrors$ ^Base Cursor\.__init__ not called\.$N( R R8 R R t fetchallR$ t ProgrammingErrort assertRaisesRegexpR ( R R8 R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckCursorConstructorCallCheck� s c C sp d t j f d � � Y} | d � } y | j � } | j d � Wn' t j k rX n | j d � n Xd S( sh Verifies that connection methods check whether base class __init__ was called. t Connectionc B s e Z d � Z RS( c S s d S( N( ( R t name( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR9 � s ( R: R; R9 ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR@ � s s :memory:s# should have raised ProgrammingErrorN( R R@ R R$ R= ( R R@ R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt# CheckConnectionConstructorCallCheck� s c s� d t j f � f d � � Y} d t j f d � � Y� | d � } | j � } | j d � | j d d d d g � | j d � | j � y | j � | j d � Wn' t j k r� n | j d � n Xd S( s� Verifies that subclassed cursor classes are correctly registered with the connection object, too. (fetch-across-rollback problem) R@ c s e Z � f d � Z RS( c s � | � S( N( ( R ( R8 ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR � s ( R: R; R ( ( R8 ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR@ � s R8 c B s e Z d � Z RS( c S s t j j | | � d S( N( R R8 R9 ( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR9 � s ( R: R; R9 ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR8 � s s :memory:s create table foo(x)s insert into foo(x) values (?)i i i s select x from foos! should have raised InterfaceErrorN( i ( i ( i ( R R@ R8 R R R R R< R$ t InterfaceError( R R@ R R ( ( R8 s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckCursorRegistration� s c C s t j d d d �} d S( s� Verifies that creating a connection in autocommit mode works. 2.5.3 introduced a regression so that these could no longer be created. s :memory:R4 N( R R R2 ( R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckAutoCommit� s c C sF | j j � } | j d � | j d � | j d � | j � } d S( s� Verifies that running a PRAGMA statement that does an autocommit does work. This did not work in 2.5.3/2.5.4. s create table foo(bar)s insert into foo(bar) values (5)s pragma page_sizeN( R R R t fetchone( R R t row( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckPragmaAutocommit� s c C s | j t j | j d � d S( s} Call a connection with a non-string SQL request: check error handling of the statement constructor. i N( R/ R t WarningR ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckConnectionCall� s c s~ t j d � } | j � � � j d � � j d � � f d � } | j t j � �" � j d d � | � D� � Wd QXd S( s� http://bugs.python.org/issue10811 Recursively using a cursor, such as when reusing it from a generator led to segfaults. Now we catch recursive cursor usage and raise a ProgrammingError. s :memory:s create table a (bar)s create table b (baz)c 3 s � j d d � d Vd S( Ns insert into a (bar) values (?)i ( i ( R ( ( R ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt foo s s insert into b (baz) values (?)c s s | ] } | f Vq d S( N( ( t .0R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pys <genexpr> s N( R R R R R/ R= R ( R R RK ( ( R s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckRecursiveCursorUse s c C s� t j d d t j �} | j � } | j d � | j d � | j d � | j d � g | j � D] } | d ^ qe } | j | t j d d d d d d d � t j d d d d d d d � g � d S( s� http://bugs.python.org/issue14720 The microsecond parsing of convert_timestamp() should pad with zeros, since the microsecond string "456" actually represents "456000". s :memory:R s CREATE TABLE t (x TIMESTAMP)s4 INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')s: INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')s SELECT * FROM ti i� i i i i@� i@� N( R R R* R R R< R R+ ( R R R R t values( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt' CheckConvertTimestampMicrosecondPadding s # c C s | j t t j d d d �d S( Ns :memory:R4 i{ ( R/ R0 R R ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckInvalidIsolationLevelType/ s c C sq t j d � } | j t | d � | j t | d � | j � } | j t | j d � | j t | j d � d S( Ns :memory:s select 1s select 1 s select 2s select 2 ( R R R/ t ValueErrorR R ( R R R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckNullCharacter5 s c C s t j d � } | j d � | j | j d � d } x� t | j d � � D]� \ } } | j d | f � | j � | d k r� | j | d d � nF | d k r� | j | d d � n# | d k r� | j | d d � n | d 7} qK W| j | d d � d S( s� Connection.commit() did reset cursors, which made sqlite3 to return rows multiple times when fetched from cursors after commit. See issues 10513 and 23129 for details. s :memory:s� create table t(c); create table t2(c); insert into t values(0); insert into t values(1); insert into t values(2); R' i s select c from ts insert into t2(c) values (?)i i i s' should have returned exactly three rowsN( R R t executescriptR R4 t enumerateR R" ( R R t counterR RG ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckCommitCursorReset> s " c C sZ d � } t j d � } t j | � } t j | | � } | j | � ~ ~ t j � d S( sm The interpreter shouldn't crash in case Cursor.__init__() is called more than once. c W s d S( N( ( t args( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt callbacka s s :memory:N( R R R8 t weakreft refR9 R t gc_collect( R RX R R RZ ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckBpo31770\ s c C s# | j t � � | j ` Wd QXd S( N( R/ t AttributeErrorR R4 ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt CheckDelIsolation_levelSegfaultl s ( R: R; R R R R R R R R% R& R( R) R. R3 R7 R? RB RD RE RH RJ RM RO RP RR RV R\ R^ ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR s6 t UnhashableFuncc B s& e Z d � Z d d � Z d � Z RS( c C s t d � � d S( Ns unhashable type( R0 ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt __hash__r s c C s d | _ | | _ d S( Ni ( t callst return_value( R Rb ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR9 u s c O s | j d 7_ | j S( Ni ( Ra Rb ( R RW t kwargs( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt __call__y s N( R: R; R` R2 R9 Rd ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR_ q s t UnhashableCallbacksTestCasec B sD e Z d Z d � Z d � Z d � Z d � Z d � Z d � Z RS( s� https://bugs.python.org/issue34052 Registering unhashable callbacks raises TypeError, callbacks are not registered in SQLite after such registration attempt. c C s t j d � | _ d S( Ns :memory:( R R R ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR � s c C s | j j � d S( N( R R ( R ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyR � s c C s_ t d d � } | j t d � � | j j | d � Wd QX| j j d � | j | j � d S( NRb i s unhashable typei s SELECT 1( R_ R> R0 R t set_progress_handlerR t assertFalseRa ( R t f( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt test_progress_handler� s c C s� d } t � } | j t d � � | j j | d | � Wd QXd | } | j t j | � � | j j d | � Wd QX| j | j � d S( Nt func_names unhashable typei s no such function: %ss SELECT %s()( R_ R> R0 R t create_functionR R# R Rg Ra ( R Rj Rh t msg( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt test_func� s c C s_ t d t j � } | j t d � � | j j | � Wd QX| j j d � | j | j � d S( NRb s unhashable types SELECT 1( R_ R t SQLITE_DENYR> R0 R t set_authorizerR Rg Ra ( R Rh ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt test_authorizer� s c C s� d t f d � � Y} d } | j t d � �' | j j | d | d d i � � Wd QXd | } | j t j | � � | j j d | � Wd QXd S( Nt UnhashableTypec B s e Z d Z RS( N( R: R; R2 R` ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyRq � s t aggr_names unhashable typei t Aggrs no such function: %ss SELECT %s()( ( t typeR> R0 R t create_aggregateR R# R ( R Rq Rr Rl ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt test_aggr� s ( ( R: R; t __doc__R R Ri Rm Rp Rv ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyRe ~ s c C s. t j t d � } t j | t j t � f � S( Nt Check( t unittestt makeSuiteR t TestSuiteRe ( t regression_suite( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt suite� s c C s t j � } | j t � � d S( N( Ry t TextTestRunnert runR} ( t runner( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt test� s t __main__( R+ Ry t sqlite3R RY R� R t TestCaseR R_ Re R} R: ( ( ( s/ /usr/lib64/python2.7/sqlite3/test/regression.pyt <module> s � T 0
[-] py25tests.py
[open]
[+]
..
[-] py25tests.pyo
[open]
[-] hooks.py
[open]
[-] dbapi.py
[open]
[-] hooks.pyc
[open]
[-] userfunctions.pyc
[open]
[-] transactions.py
[open]
[-] transactions.pyc
[open]
[-] py25tests.pyc
[open]
[-] userfunctions.py
[open]
[-] factory.py
[open]
[-] regression.py
[open]
[-] factory.pyo
[open]
[-] dump.pyo
[open]
[-] __init__.pyc
[open]
[-] dbapi.pyo
[open]
[-] factory.pyc
[open]
[-] types.pyc
[open]
[-] types.py
[open]
[-] transactions.pyo
[open]
[-] userfunctions.pyo
[open]
[-] regression.pyo
[open]
[-] regression.pyc
[open]
[-] __init__.py
[open]
[-] dbapi.pyc
[open]
[-] types.pyo
[open]
[-] hooks.pyo
[open]
[-] dump.pyc
[open]
[-] dump.py
[open]
[-] __init__.pyo
[open]