��Qc@sT
dd
lZdd
l
Z
dd
lZydd
lZWnek
rM


eZn
Xdejf
d��YZdejf
d��YZ	dejf
d��YZ
ejed�d	ejf
d
��Y�Zdejf
d��YZ
d
ejf
d��YZdejf
d��YZdejf
d��YZd�Zd�ZedkrP
e�
nd
S(i�NtModuleTestsc
Bs}eZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�ZRS(
c

Cs!|jt
jd
dt
j�
dS(Ns2.0sapilevel is %s, should be 2.0(tassertEqualtsqlitetapilevel(
tself((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckAPILevel!s

c

Cs!|jt
jd
dt
j�
dS(Ni
sthreadsafety is %d, should be 1(R
Rtthreadsafety(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckThreadSafety%s

c

Cs!|jt
jd
dt
j�
dS(Ntqmarks%paramstyle is '%s', should be 'qmark'(R
Rt
paramstyle(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckParamStyle)s


c

Cs |jt
tjt�d
�
dS(Ns*Warning is not a subclass of StandardError(t
assertTruet
issubclassRtWarningt
StandardError(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckWarning.s

c

Cs |jt
tjt�d
�
dS(Ns(Error is not a subclass of StandardError(RRRtErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckError2s

c

Cs#|jt
tjtj�d
�
dS(Ns)InterfaceError is not a subclass of Error(RRRtInterfaceErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckInterfaceError6s

c

Cs#|jt
tjtj�d
�
dS(Ns(DatabaseError is not a subclass of Error(RRRt
DatabaseErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckDatabaseError:s

c

Cs#|jt
tjtj�d
�
dS(Ns,DataError is not a subclass of DatabaseError(RRRt	DataErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckDataError>s

c

Cs#|jt
tjtj�d
�
dS(Ns3OperationalError is not a subclass of DatabaseError(RRRtOperationalErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckOperationalErrorBs

c

Cs#|jt
tjtj�d
�
dS(Ns1IntegrityError is not a subclass of DatabaseError(RRRtIntegrityErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckIntegrityErrorFs

c

Cs#|jt
tjtj�d
�
dS(Ns0InternalError is not a subclass of DatabaseError(RRRt
InternalErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckInternalErrorJs

c

Cs#|jt
tjtj�d
�
dS(Ns3ProgrammingError is not a subclass of DatabaseError(RRRtProgrammingErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckProgrammingErrorNs

c

Cs#|jt
tjtj�d
�
dS(Ns4NotSupportedError is not a subclass of DatabaseError(RRRtNotSupportedErrorR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckNotSupportedErrorRs

	
(t__name__t
__module__RRR
RRRRRRRRRR!(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR s
												tConnectionTestsc
BsbeZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�ZRS(
c
CsBtj
d
�|_|jj�}
|
jd�
|
jdd�
dS(Ns:memory:s4create table test(id integer primary key, name text)s!insert into test(name) values (?)tfoo(
sfoo(Rtconnecttcxtcursortexecute(Rtcu((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytsetUpXs




c


Cs|jj
�
dS(
N(R'tclose(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyttearDown^s
c


Cs|jj
�
dS(
N(R'tcommit(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCommitas
c


Cs|jj
�
|jj
�
d
S(sV
        A commit should also work when no changes were made to the database.
        N(R'R.(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCommitAfterNoChangesds

c


Cs|jj
�
dS(
N(R'trollback(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckRollbackks
c


Cs|jj
�
|jj
�
d
S(sX
        A rollback should also work when no changes were made to the database.
        N(R'R1(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckRollbackAfterNoChangesns

c

Cs|jj
�}
dS(
N(R'R((RR*((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCursorus
c
CsBd
}
ytj
|
�}Wntjk
r0


dSX|jd�
dS(Ns/foo/bar/bla/23534/mydb.dbs&should have raised an OperationalError(RR&Rtfail(RtYOU_CANNOT_OPEN_THIStcon((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckFailedOpenxs





c


Cs|jj
�
dS(
N(R'R,(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckClose�s
c

Cs�|j|j
jtj�
|j|j
jtj�
|j|j
jtj�
|j|j
jtj�
|j|j
jtj�
|j|j
jtj�
|j|j
j	tj	�
|j|j
j
tj
�
|j|j
jtj�
|j|j
jtj�
dS(
N(
R
R'R
RRRRRRRRRR (
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExceptions�s








(R"R#R+R-R/R0R2R3R4R8R9R:(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR$Ws
									tCursorTestsc
Bs�eZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�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

CsKtj
d
�|_|jj�|_|jjd�
|jjdd�
dS(Ns:memory:sCcreate table test(id integer primary key, name text, income number)s!insert into test(name) values (?)R%(
sfoo(RR&R'R(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR+�s



c


Cs|jj
�
|jj
�
dS(
N(R*R,R'(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR-�s


c

Cs|jj
d
�
dS(Nsdelete from test(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteNoArgs�s
c

CsPy!|jj
d
�
|jd�
Wn(tjk
r8


dS


|jd�
n
XdS(Nsselect asdfs&should have raised an OperationalErrorsraised wrong exception(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteIllegalSql�s






c

CsPy!|jj
d
�
|jd�
Wn(tjk
r8


dS


|jd�
n
XdS(Nsselect 5+4; select 4+5sshould have raised a Warningsraised wrong exception(R*R)R5RR
(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteTooMuchSql�s






c

Cs|jj
d
�
dS(Nsselect 5+4; -- foo bar(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteTooMuchSql2�s
c

Cs|jj
d
�
dS(NsT
            select 5+4;

            /*
            foo
            */
            (R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteTooMuchSql3�s
	c

CsMy!|jj
d
�
|jd�
Wn%tk
r5


dS


|jd�
n
XdS(Ni*sshould have raised a ValueErrorsraised wrong exception.(R*R)R5t
ValueError(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteWrongSqlArg�s







c

Cs|jj
d
d�
dS(Nsinsert into test(id) values (?)i*(
i*(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteArgInt�s
c

Cs|jj
d
d�
dS(Ns#insert into test(income) values (?)gp=
ף�@(
gp=
ף�@(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteArgFloat�s
c

Cs|jj
d
d�
dS(Ns!insert into test(name) values (?)tHugo(
RE(R*R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteArgString�s
c
CsV|jj
d
d�
|jj
d|jjf
�
|jj�}
|j|
dd�
dS(Ns!insert into test(name) values (?)tHugos select name from test where id=?i(
RG(R*R)t	lastrowidtfetchoneR
(Rtrow((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt!CheckExecuteArgStringWithZeroByte�s


c

Cs?y$|jj
d
d�
|jd�
Wntjk
r:


n
XdS(Nsinsert into test(id) values (?)itEgons#should have raised ProgrammingError(iRL(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs1�s




c

Cs<y!|jj
d
�
|jd�
Wntjk
r7


n
XdS(Nsinsert into test(id) values (?)s#should have raised ProgrammingError(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs2�s




c

Cs<y!|jj
d
�
|jd�
Wntjk
r7


n
XdS(Nsinsert into test(id) values (?)s#should have raised ProgrammingError(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs3�s




c
CsM|jj
d
�
|jj
ddg
�
|jj�}
|j|
dd�
dS(Ns%insert into test(name) values ('foo')s"select name from test where name=?R%i(R*R)RIR
(RRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteParamList�s



c
Cscd
tf
d��Y}
|j
jd�
|j
jd|
��
|j
j�}|j|dd�
dS(Nt
Lc
BseZ
d�Zd
�ZRS(c


Ssd
S(Ni
((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt__len__�s
c
Ssd
S(NR%((Rt
x((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt__getitem__�s(R"R#RRRT(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyRQ�s
	s%insert into test(name) values ('foo')s"select name from test where name=?iR%(tobjectR*R)RIR
(RRQRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteParamSequence�s




c
CsQ|jj
d
�
|jj
di
dd6�
|jj�}
|j|
dd�
dS(Ns%insert into test(name) values ('foo')s&select name from test where name=:nameR%tnamei(R*R)RIR
(RRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteDictMapping
s



c
Csvtj
d	krdSdtf
d��Y}
|jjd�
|jjd|
��
|jj�}|j|dd�
dS(
Niiit
Dc
BseZ
d�ZRS(
c
Ssd
S(NR%((Rtkey((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt__missing__
s
(R"R#R[(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyRY
s
s%insert into test(name) values ('foo')s&select name from test where name=:nameR%(iii(tsystversion_infotdictR*R)RIR
(RRYRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteDictMapping_Mapping
s



c

CsV|jj
d
�
y+|jj
di
dd6�
|jd�
Wntjk
rQ


n
XdS(Ns%insert into test(name) values ('foo')s1select name from test where name=:name and id=:idR%RWs#should have raised ProgrammingError(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt$CheckExecuteDictMappingTooLittleArgs
s





c

CsL|jj
d
�
y!|jj
d�
|jd�
Wntjk
rG


n
XdS(Ns%insert into test(name) values ('foo')s&select name from test where name=:names#should have raised ProgrammingError(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteDictMappingNoArgs
s





c

CsV|jj
d
�
y+|jj
di
dd6�
|jd�
Wntjk
rQ


n
XdS(Ns%insert into test(name) values ('foo')s"select name from test where name=?R%RWs#should have raised ProgrammingError(R*R)R5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteDictMappingUnnamed$
s





c


Cs|jj
�
dS(
N(R*R,(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR9,
s
c

CsZ|jj
d
�
|jj
d�
|jj
d�
|jj
d�
|j|jjd�
dS(Nsdelete from tests%insert into test(name) values ('foo')supdate test set name='bar'i(R*R)R
trowcount(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckRowcountExecute/
s





c

Cs*|jj
d
�
|j|jjd�
dS(s�
        pysqlite does not know the rowcount of SELECT statements, because we
        don't fetch all rows after executing the select statement. The rowcount
        has thus to be -1.
        sselect 5 union select 6i�N(R*R)R
Rc(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckRowcountSelect6
s
c

CsF|jj
d
�
|jjddddg�
|j|jjd�
dS(	Nsdelete from tests!insert into test(name) values (?)i
ii(
i
(
i(
i(R*R)texecutemanyR
Rc(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckRowcountExecutemany?
s


c

CsF|jj
d
�
|jj
d
�
|jjdkrB|jd�
ndS(Ns%insert into test(name) values ('foo')is"total changes reported wrong value(R*R)R't
total_changesR5(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckTotalChangesD
s



c
Cs6|jj
d
gtdd�D]}
|
f
^q�
dS(Ns#insert into test(income) values (?)idin(R*Rftrange(RRS((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManySequenceN
s
c
Cs-d
dd��Y}
|jj
d|
��
dS(NtMyIterc
BseZ
d�Zd
�ZRS(c

Ss
d
|_dS(Ni(
tvalue(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt__init__S
s
c

Ss5|jd
krt
�n|jd7_|jf
SdS(Ni
i
(Rmt
StopIteration(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytnextV
s

	
(R"R#RnRp(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyRlR
s
	s#insert into test(income) values (?)((R*Rf(RRl((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManyIteratorQ
s
c
Cs#d
�}
|jj
d|
��
dS(Nc
ss#xtd
�D]}|f
V
q
WdS(Ni(
Rj(
t
i((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytmygen`
s

s#insert into test(income) values (?)(R*Rf(RRs((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManyGenerator_
s
	c

CsSy'|jj
d
dg
�
|jd�
Wn%tk
r;


dS


|jd�
n
XdS(Ni*isshould have raised a ValueErrorsraised wrong exception.(
i(R*RfR5RA(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManyWrongSqlArgf
s







c

CsVy'|jj
d
dg
�
|jd�
Wn(tjk
r>


dS


|jd�
n
XdS(Nsselect ?is%should have raised a ProgrammingErrorsraised wrong exception.(
i(R*RfR5RR(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManySelecto
s






c
Cshy$|jj
d
d�
|jd�
Wn=tk
r8


dStk
rc
}

dG|
jGH|jd�
n
XdS(Ns#insert into test(income) values (?)i*sshould have raised a TypeErrortraisedsraised wrong exception.(R*RfR5t	TypeErrort	Exceptiont	__class__(Rt
e((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckExecuteManyNotIterablex
s








c
Cs�|jj
d
�
|jj
dd�
|jj
dd	�
|jj
d�
g}
x"|jD]}|
j|d�
qVW|j|
dd�
|j|
dd�
dS(
Nsdelete from testsinsert into test(id) values (?)iisselect id from test order by idii
(
i(
i(R*R)tappendR
(RtlstRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckFetchIter�s







c
CsV|jj
d
�
|jj�}
|j|
dd�
|jj�}
|j|
d�
dS(Nsselect name from testiR%(R*R)RIR
tNone(RRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckFetchone�s





c
Cs/|jj
�}
|
j�}|j|d�
dS(
N(R'R(RIR
R�(RtcurRJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckFetchoneNoStatement�s


c
Cs�|j|j
jd
�
d|j
_|j
jd�
|j
jd�
|j
jd�
|j
jd�
|j
jd�
|j
j�}
|jt|
�d�
dS(Ni
isdelete from tests#insert into test(name) values ('A')s#insert into test(name) values ('B')s#insert into test(name) values ('C')sselect name from test(R
R*t	arraysizeR)t	fetchmanytlen(Rtres((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckArraySize�s




c
Cs^|jj
d
�
|jjd�}
|jt|
�d�
|jjd�}
|j|
g�
dS(Nsselect name from testidi
(R*R)R�R
R�(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckFetchmany�s





c
Cs?|jj
d
�
|jjdd�
}
|jt|
�d�
dS(s0Checks if fetchmany works with keyword argumentssselect name from testtsizeidi
N(R*R)R�R
R�(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckFetchmanyKwArg�s

c
CsX|jj
d
�
|jj�}
|jt|
�d�
|jj�}
|j|
g�
dS(Nsselect name from testi
(R*R)tfetchallR
R�(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckFetchall�s





c

Cs|jj
d
ddg�
dS(Niii(R*t
setinputsizes(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckSetinputsizes�s
c

Cs|jj
d
d�
dS(Nii(R*t
setoutputsize(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckSetoutputsize�s
c

Cs|jj
d
�
dS(Ni*(R*R�(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckSetoutputsizeNoColumn�s
c

Cs|j|j
j|j�
dS(
N(R
R*t
connectionR'(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCursorConnection�sc
CsRy,d
�}
|jj
|
�}|jd�
Wntk
r@


dSX|jd�
dS(Nc
SsdS(
N((((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
f�ssshould have raised a TypeErrorsshould have raised a ValueError(R'R(R5Rx(RR�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckWrongCursorCallable�s

	





c
CsTd
dd��Y}
|
�}y tj
|�}|jd�
Wntk
rO


n
XdS(NtFooc
BseZ
RS((R"R#(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR��ssshould have raised a ValueError((RtCursorR5Rx(RR�R%R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCursorWrongClass�s

	





(0R"R#R+R-R<R=R>R?R@RBRCRDRFRKRMRNRORPRVRXR_R`RaRbR9RdReRgRiRkRqRtRuRvR|RR�R�R�R�R�R�R�R�R�R�R�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR;�s\
																					
											
								
													sThis test requires threading.tThreadTestsc
BsbeZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�ZRS(
c

Cs8tj
d
�|_|jj�|_|jjd�
dS(Ns:memory:s\create table test(id integer primary key, name text, bin binary, ratio number, ts timestamp)(RR&R7R(R�R)(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR+�s


c


Cs|jj
�
|jj
�
dS(
N(R�R,R7(
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR-�s


c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsPy!|j�}|
j
d
�
dSWn(tjk
r8


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R(R}RR(R7terrorsR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytrun�s








ttargettkwargsR7R�is

(t	threadingtThreadR7tstarttjoinR�R5(RR�R�t
t((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConCursor�s
	

)





c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsNy|j�
|
j
d
�
dSWn(tjk
r6


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R.R}RR(R7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR��s









R�R�R7R�is

(R�R�R7R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConCommit�s
	

)





c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsNy|j�
|
j
d
�
dSWn(tjk
r6


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R1R}RR(R7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�s









R�R�R7R�is

(R�R�R7R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConRollback
s
	

)





c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsNy|j�
|
j
d
�
dSWn(tjk
r6


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R,R}RR(R7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR� s









R�R�R7R�is

(R�R�R7R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckConCloses
	

)





c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsQy"|jd
�
|
j
d�
dSWn(tjk
r9


dS


|
j
d�
n
XdS(Ns#insert into test(name) values ('a')sdid not raise ProgrammingErrorsraised wrong exception(R)R}RR(R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�2s









R�R�R�R�is

(R�R�R�R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCurImplicitBegin1s
	

)





c
Cs{d
�}
g}tj
d|
di|jd6|d6�}|j�
|j�
t|�dkrw|jdj|��
ndS(NcSsNy|j�
|
j
d
�
dSWn(tjk
r6


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R,R}RR(R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�Ds









R�R�R�R�is

(R�R�R�R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
CheckCurCloseCs
	

)





c
Cs�d
�}
g}|jj
d�
tjd|
di|jd6|d6�}|j�
|j�
t|�dkr�|jdj|��
ndS(	NcSsQy"|jd
�
|
j
d�
dSWn(tjk
r9


dS


|
j
d�
n
XdS(Nsselect name from testsdid not raise ProgrammingErrorsraised wrong exception(R)R}RR(R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�Vs









s#insert into test(name) values ('a')R�R�R�R�is

(R�R)R�R�R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCurExecuteUs
	


)





c
Cs�d
�}
g}|jj
d�
|jj
d�
tjd|
di|jd6|d6�}|j�
|j�
t|�dkr�|jd	j|��
ndS(
NcSsPy!|j�}|
j
d
�
dSWn(tjk
r8


dS


|
j
d�
n
XdS(Nsdid not raise ProgrammingErrorsraised wrong exception(RIR}RR(R�R�RJ((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�is








s#insert into test(name) values ('a')sselect name from testR�R�R�R�is

(R�R)R�R�R�R�R�R5(RR�R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckCurIterNexths
	



)





(R"R#R+R-R�R�R�R�R�R�R�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR��s									tConstructorTestsc
BsGeZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�ZRS(c
Cstj
d
dd�}
dS(Ni�i
i(RtDate(Rt
d((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt	CheckDate}s
c
Cstj
d
dd�}
dS(Nii'i#(RtTime(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt	CheckTime�s
c
Cs"tj
d
ddddd�}
dS(Ni�i
iii'i#(Rt	Timestamp(Rtts((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckTimestamp�s
c
Cstj
d
�}
dS(Ni*(Rt
DateFromTicks(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckDateFromTicks�s
c
Cstj
d
�}
dS(Ni*(Rt
TimeFromTicks(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckTimeFromTicks�s
c
Cstj
d
�}
dS(Ni*(RtTimestampFromTicks(RR�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckTimestampFromTicks�s
c
Cstj
td
�d�}
dS(Nit
'(RtBinarytchr(Rt
b((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckBinary�s
(	R"R#R�R�R�R�R�R�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�|s
						tExtensionTestsc
BsGeZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�ZRS(c
CsYtj
d
�}
|
j�}|jd�
|jd�
|j�d}|j|d�
dS(Ns:memory:s�
            -- bla bla
            /* a stupid comment */
            create table a(i);
            insert into a(i) values (5);
            sselect i from aii(RR&R(t
executescriptR)RIR
(RR7R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckScriptStringSql�s






c
CsYtj
d
�}
|
j�}|jd�
|jd�
|j�d}|j|d�
dS(Ns:memory:u�
            create table a(i);
            insert into a(i) values (5);
            select i from a;
            delete from a;
            insert into a(i) values (6);
            sselect i from aii(RR&R(R�R)RIR
(RR7R�R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckScriptStringUnicode�s






c
Csftj
d
�}
|
j�}t}y|jd�
Wntjk
rN


t}n
X|j|td�
dS(Ns:memory:s1create table test(x); asdf; create table test2(x)sshould have raised an exception(RR&R(tFalseR�RtTrueR
(RR7R�Rw((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckScriptSyntaxError�s








c
Csftj
d
�}
|
j�}t}y|jd�
Wntjk
rN


t}n
X|j|td�
dS(Ns:memory:s5create table test(sadfsadfdsa); select foo from hurz;sshould have raised an exception(RR&R(R�R�RR�R
(RR7R�Rw((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckScriptErrorNormal�s








c
Cs?tj
d
�}
|
jd�j�d}|j|dd�
dS(Ns:memory:sselect 5iis Basic test of Connection.execute(RR&R)RIR
(RR7tresult((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConnectionExecute�s


c
Cs�tj
d
�}
|
jd�
|
jdd
dg�
|
jd�j�}|j|dddd�
|j|d	ddd�
dS(Ns:memory:screate table test(foo)s insert into test(foo) values (?)iis!select foo from test order by foois$Basic test of Connection.executemanyi
(
i(
i(RR&R)RfR�R
(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConnectionExecutemany�s






c
CsLtj
d
�}
|
jd�
|
jd�j�d}|j|dd�
dS(Ns:memory:s9create table test(foo); insert into test(foo) values (5);sselect foo from testiis&Basic test of Connection.executescript(RR&R�R)RIR
(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckConnectionExecutescript�s




(	R"R#R�R�R�R�R�R�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR��s
	
		
	
		tClosedConTestsc
BskeZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�ZRS(c


CsdS(
N((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR+�s
c


CsdS(
N((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR-�s
c
Csdtj
d
�}
|
j�
y|
j�}|jd�
Wn'tjk
rL


n


|jd�
n
XdS(Ns:memory:s%Should have raised a ProgrammingError(RR&R,R(R5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedConCursor�s









c
Csbtj
d
�}
|
j�
y|
j�
|jd�
Wn'tjk
rJ


n


|jd�
n
XdS(Ns:memory:s%Should have raised a ProgrammingError(RR&R,R.R5R(RR7((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedConCommit�s










c
Csbtj
d
�}
|
j�
y|
j�
|jd�
Wn'tjk
rJ


n


|jd�
n
XdS(Ns:memory:s%Should have raised a ProgrammingError(RR&R,R1R5R(RR7((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedConRollback�s










c
Csqtj
d
�}
|
j�}|
j�
y|jd�
|jd�
Wn'tjk
rY


n


|jd�
n
XdS(Ns:memory:sselect 4s%Should have raised a ProgrammingError(RR&R(R,R)R5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedCurExecute�s











c
Csttj
d
�}
|
j�
d�}y$|
jdd|�
|jd�
Wn'tjk
r\


n


|jd�
n
XdS(Ns:memory:c


Ssd
S(Ni((
RS((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�sR%i
s%Should have raised a ProgrammingError(RR&R,tcreate_functionR5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedCreateFunction	s



	






c
Cs~tj
d
�}
|
j�
ddd��Y}y$|
jdd|�
|jd�
Wn'tjk
rf


n


|jd�
n
XdS(Ns:memory:tAggc
Bs#eZ
d�Zd
�Zd�ZRS(c


SsdS(
N((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyRns
c
SsdS(
N((RRS((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytsteps
c


Ssd
S(Ni((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytfinalizes
(R"R#RnR�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�s
		R%i
s%Should have raised a ProgrammingError((RR&R,tcreate_aggregateR5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedCreateAggregates









c
Csntj
d
�}
|
j�
d�}y|
j|�
|jd�
Wn'tjk
rV


n


|jd�
n
XdS(Ns:memory:c

Wstj
S(
N(RtDENY(
targs((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt
authorizer*s
s%Should have raised a ProgrammingError(RR&R,tset_authorizerR5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedSetAuthorizer's



	






c
Csqtj
d
�}
|
j�
d�}y!|
j|d�
|jd�
Wn'tjk
rY


n


|jd�
n
XdS(Ns:memory:c
SsdS(
N((((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytprogress7sids%Should have raised a ProgrammingError(RR&R,tset_progress_handlerR5R(RR7R�((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedSetProgressCallback4s



	






c
Cs_tj
d
�}
|
j�
y|
�
|jd�
Wn'tjk
rG


n


|jd�
n
XdS(Ns:memory:s%Should have raised a ProgrammingError(RR&R,R5R(RR7((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedCall@s









(
R"R#R+R-R�R�R�R�R�R�R�R�R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR��s
									
	tClosedCurTestsc
Bs#eZ
d�Zd
�Zd�ZRS(c


CsdS(
N((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR+Ls
c


CsdS(
N((
R((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR-Os
c
Cs�tj
d
�}
|
j�}|j�
x�dD]�}|dkrGd}n'|dkrhd	ddgf}ng}y.t||�}||�
|jd|�
Wq,tjk
r�


q,


|jd
|�
q,Xq,WdS(Ns:memory:R)RfR�R�R�RIsselect 4 union select 5sinsert into foo(bar) values (?)iis.Should have raised a ProgrammingError: method s'Should have raised a ProgrammingError: (sexecutesexecutemanys
executescriptsfetchalls	fetchmanysfetchone(sexecutes
executescript(
sselect 4 union select 5(
i(
i(RR&R(R,tgetattrR5R(RR7R�tmethod_nametparamstmethod((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytCheckClosedRs"






	








(R"R#R+R-R�(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyR�Ks
		c	Cs�tj
td
�}tj
td
�}
tj
td
�}tj
td
�}tj
td
�}tj
td
�}tj
td
�}tj
t	d
�}tj
||
||||||f�S(NtCheck(tunittestt	makeSuiteRR$R;R�R�R�R�R�t	TestSuite(tmodule_suitetconnection_suitetcursor_suitetthread_suitetconstructor_suitet	ext_suitetclosed_con_suitetclosed_cur_suite((s(/sys/lib/python2.7/sqlite3/test/dbapi.pytsuiteis








c
Cs tj
�}|jt��
dS(
N(R�tTextTestRunnerR�R�(
trunner((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyttestts

t__main__(R�R\tsqlite3RR�tImportErrorR�tTestCaseRR$R;t
skipUnlessR�R�R�R�R�R�R�R"(((s(/sys/lib/python2.7/sqlite3/test/dbapi.pyt<module>s(







79�
�Cv