ó
|
X\¬Qc @ s" d d l Z d d l Z d d l Z y d d l Z Wn e k
|
rM d Z n Xd e j f d YZ d e j f d YZ d e j f d YZ
|
d e j f d YZ e j e d
|
d e j f d Y Z d e j f d YZ d Z d Z e d k r e n d S( iÿÿÿÿNt SqliteTypeTestsc 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 s8 t j d | _ | j j | _ | j j d d S( Ns :memory:s9 create table test(i integer, s varchar, f number, b blob)( t sqlitet connectt cont cursort curt execute( t self( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt setUp" s c C s | j j | j j d S( N( R t closeR ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt tearDown' s c C sJ | j j d d | j j d | j j } | j | d d d S( Ns insert into test(s) values (?)u Ãsterreichs select s from testi ( u Ãsterreich( R R t fetchonet assertEqual( R t row( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckString+ s c C sJ | j j d d | j j d | j j } | j | d d d S( Ns insert into test(i) values (?)i* s select i from testi ( i* ( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckSmallInt1 s c C sS d } | j j d | f | j j d | j j } | j | d | d S( Ni i( s insert into test(i) values (?)s select i from testi I ( R R R R ( R t numR ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckLargeInt7 s
|
c C sS d } | j j d | f | j j d | j j } | j | d | d S( Ng
ëQ¸ @s insert into test(f) values (?)s select f from testi ( R R R R ( R t valR ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt
|
CheckFloat> s
|
c C sY t d } | j j d | f | j j d | j j } | j | d | d S( Nt Guglhupfs insert into test(b) values (?)s select b from testi ( t bufferR R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckBlobE s
|
c C s7 | j j d | j j } | j | d d d S( Nu select 'Ãsterreich'i u Ãsterreich( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckUnicodeExecuteL s c C sH y- | j j d t d f | j d Wn t j k
|
rC n Xd S( Ns select ?i s% should have raised a ProgrammingError( R R t chrt failR t ProgrammingError( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckNonUtf8_DefaultQ s
|
c C sL | j j } z, t | j _ | j j d t d f Wd | | j _ Xd S( Ns select ?i ( R t text_factoryt strR R R ( R t orig_text_factory( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckNonUtf8_TextFactoryStringX s
|
c C sw | j j } zW y< t j | j _ | j j d t d f | j d Wn t j k
|
ra n XWd | | j _ Xd S( Ns select ?i s% should have raised a ProgrammingError( R R R t OptimizedUnicodeR R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt( CheckNonUtf8_TextFactoryOptimizedUnicode` s ( t __name__t
|
__module__R R
|
R R R R R R R R R! ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR ! s t DeclTypesTestsc B s e Z d d d YZ 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( t Fooc B s, e Z d Z d Z d Z d Z RS( c C s | | _ d S( N( R ( R t _val( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt __init__n s c C s9 t | t j s t n | j | j k r1 d Sd Sd S( Ni i ( t
|
isinstanceR$ R% t
|
ValueErrorR ( R t other( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt __cmp__q s
|
c C s | t j k r | j Sd Sd S( N( R t PrepareProtocolR t None( R t protocol( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt __conform__y s c C s d | j S( Ns <%s>( R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt __str__ s ( R" R# R' R+ R/ R0 ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR% m s c C s t j d d t j | _ | j j | _ | j j d d t j d <d t j d <t j t j d <d t j d
|
<t
|
t j d <d S( Ns :memory:t detect_typessg create table test(i int, s str, f float, b bool, u unicode, foo foo, bin blob, n1 number, n2 number(5))c S s d S( NgG@( ( t x( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt <lambda> s t FLOATc S s t t | S( N( t boolt int( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s t BOOLt FOOc S s d S( Nt WRONG( ( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s R9 t NUMBER( R R t PARSE_DECLTYPESR R R R t
|
convertersR$ R% t float( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR s c C sF t j d =t j d =t j d =t j d =| j j | j j d S( NR4 R7 R8 R: ( R R< R R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR
|
s
|
|
|
|
c C sJ | j j d d | j j d | j j } | j | d d d S( Ns insert into test(s) values (?)t foos! select s as "s [WRONG]" from testi ( R> ( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR s c C sJ | j j d d | j j d | j j } | j | d d d S( Ns insert into test(i) values (?)i* s select i from testi ( i* ( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR s c C sS d } | j j d | f | j j d | j j } | j | d | d S( Ni i( s insert into test(i) values (?)s select i from testi I ( R R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR ¦ s
|
c C sS d } | j j d | f | j j d | j j } | j | d d d S( Ng
ëQ¸ @s insert into test(f) values (?)s select f from testi gG@( R R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR ® s
|
c C s¦ | j j d t f | j j d | j j } | j | d t | j j d | j j d t f | j j d | j j } | j | d t d S( Ns insert into test(b) values (?)s select b from testi s delete from test( R R t FalseR R t True( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckBool¶ s c C sS d } | j j d | f | j j d | j j } | j | d | d S( Nu Ãsterreichs insert into test(u) values (?)s select u from testi ( R R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckUnicodeà s
|
c C s\ t j d } | j j d | f | j j d | j j } | j | d | d S( Nt blas insert into test(foo) values (?)s select foo from testi ( R$ R% R R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckFooË s
|
c C sq d d d Y} | } y' | j j d | f | j d Wn' t j k
|
rY n | j d n Xd S( Nt Barc B s e Z RS( ( R" R# ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRE Ó s s insert into test(f) values (?)s$ should have raised an InterfaceError( ( R R R R t InterfaceError( R RE R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckUnsupportedSeqÒ s c C su d d d Y} | } y+ | j j d i | d 6 | j d Wn' t j k
|
r] n | j d n Xd S( NRE c B s e Z RS( ( R" R# ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRE Þ s s! insert into test(f) values (:val)R s$ should have raised an InterfaceError( ( R R R R RF ( R RE R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckUnsupportedDictÝ s c C sY t d } | j j d | f | j j d | j j } | j | d | d S( NR s insert into test(bin) values (?)s select bin from testi ( R R R R R ( R R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR è s
|
c C sF | j j d | j j d j d } | j t | t d S( Ns insert into test(n1) values (5)s select n1 from testi ( R R R R t typeR= ( R t value( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckNumber1ð s c C sF | j j d | j j d j d } | j t | t d S( s; Checks wether converter names are cut off at '(' characterss insert into test(n2) values (5)s select n2 from testi N( R R R R RI R= ( R RJ ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckNumber2ö s ( ( R" R# R% R R
|
R R R R RA RB RD RG RH R RK RL ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR$ l s t ColNamesTestsc B sG e Z d Z d Z d Z d Z d Z d Z d Z RS( c C s t j d d t j | _ | j j | _ | j j d d t j d <d t j d <d t j d <d
|
t j d <d S( Ns :memory:R1 s create table test(x foo)c S s d | S( Ns [%s]( ( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s R8 c S s d | S( Ns <%s>( ( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s t BARc S s d d S( Ni i ( ( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s t EXCc S s d S( Nt MARKER( ( R2 ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR3 s t B1B1( R R t PARSE_COLNAMESR R R R R< ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR þ s c C sF t j d =t j d =t j d =t j d =| j j | j j d S( NR8 RN RO RQ ( R R< R R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR
|
s
|
|
|
|
c C sJ | j j d d | j j d | j j d } | j | d d S( se
|
Assures that the declared type is not used when PARSE_DECLTYPES
|
is not set.
|
s insert into test(x) values (?)t xxxs select x from testi N( RS ( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckDeclTypeNotUsed s c C sJ | j j d d | j j d | j j d } | j | d d S( Ns insert into test(x) values (?)s select x from testi ( N( R R R- R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckNone s c C sh | j j d d | j j d | j j d } | j | d | j | j j d d d d S( Ns insert into test(x) values (?)RS s select x as "x [bar]" from testi s <xxx>R2 ( s xxx( R R R R t description( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckColName s
|
c C s7 | j j d | j j d } | j | d d S( Ns select 'other' as "x [b1b1]"i RP ( R R R R ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckCaseInConverterName* s c C s2 | j j d | j | j j d d d d S( sq
|
cursor.description should at least provide the column name(s), even if
|
no row returned.
|
s select * from test where 0 = 1i R2 N( R R R RV ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckCursorDescriptionNoRow/ s ( R" R# R R
|
RT RU RW RX RY ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRM ý s
|
|
|
t ObjectAdaptationTestsc B s8 e Z d Z e e Z d Z d Z d Z RS( c C s
|
t | S( N( R= ( t obj( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt cast8 s c C sS t j d | _ y t j t =Wn n Xt j t t j | j j | _ d S( Ns :memory:(
|
R R R t adaptersR6 t register_adapterRZ R\ R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR < s c C s1 t j t t j f =| j j | j j d S( N( R R] R6 R, R R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR
|
E s c C s@ | j j d d | j j d } | j t | t d S( Ns select ?i i ( i ( R R R R RI R= ( R R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckCasterIsUsedJ s ( R" R# R\ t staticmethodR R
|
R_ ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRZ 7 s
|
s requires zlibt BinaryConverterTestsc B s8 e Z d Z e e Z d Z d Z d Z RS( c C s t j | S( N( t zlibt
|
decompress( t s( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt convertQ s c C s2 t j d d t j | _ t j d t j d S( Ns :memory:R1 t bin( R R RR R t register_converterRa Re ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR U s c C s | j j d S( N( R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR
|
Y s c C sO d d } | j j d t t j | f j d } | j | | d S( Nt abcdefgi
|
s select ? as "x [bin]"i ( R R R Rb t compressR R ( R t testdatat result( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckBinaryInputForConverter\ s
|
1( R" R# Re R` R R
|
Rl ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRa O s
|
t DateTimeTestsc B sG e Z d Z d Z d Z d Z d Z d Z d Z RS( c C sA t j d d t j | _ | j j | _ | j j d d S( Ns :memory:R1 s' create table test(d date, ts timestamp)( R R R; R R R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR b s c C s | j j | j j d S( N( R R R ( R ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyR
|
g s c C sb t j d d d } | j j d | f | j j d | j j d } | j | | d S( NiÔ i i s insert into test(d) values (?)s select d from testi ( R t DateR R R R ( R t dt d2( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckSqliteDatek s
|
c C sk t j d d d d d d } | j j d | f | j j d | j j d } | j | | d S( NiÔ i i i i i s insert into test(ts) values (?)s select ts from test( R t TimestampR R R R ( R t tst ts2( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckSqliteTimestampr s
|
c C s t j d k r d St j j } | j j d | j j d | j j d } | j t | t j | j | j | j d S( Ni i s/ insert into test(ts) values (current_timestamp)s select ts from testi ( i i (
|
R t sqlite_version_infot datetimet nowR R R R RI t year( R Rx Rs ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckSqlTimestampy s c C sn t j d d d d d d d } | j j d | f | j j d | j j d } | j | | d S(
|
NiÔ i i i i i i ¡ s insert into test(ts) values (?)s select ts from test( R Rr R R R R ( R Rs Rt ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt CheckDateTimeSubSeconds s
|
!c C sn t j d d d d d d d } | j j d | f | j j d | j j d } | j | | d S(
|
NiÔ i i i i i i!É s insert into test(ts) values (?)s select ts from test( R Rr R R R R ( R Rs Rt ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt$ CheckDateTimeSubSecondsFloatingPoint s
|
!( R" R# R R
|
Rq Ru Rz R{ R| ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyRm a s c C s t j t d } t j t d } t j t d } t j t d } t j t d } t j t d } t j | | | | | | f S( Nt Check( t unittestt makeSuiteR R$ RM RZ Ra Rm t TestSuite( t sqlite_type_suitet decltypes_type_suitet colnames_type_suitet adaptation_suitet bin_suitet
|
date_suite( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt suite s c C s t j } | j t d S( N( R~ t TextTestRunnert runR ( t runner( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt test s t __main__( Rw R~ t sqlite3R Rb t ImportErrorR- t TestCaseR R$ RM RZ t
|
skipUnlessRa Rm R R R" ( ( ( sZ /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/types.pyt <module> s"
|
K:3
|
