�
O��ac@s�
dd
lZdd
l
ZddlmZ
d�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�Zd
�Zd�Zd�Zd�Zdd.d��YZdd/d��YZdd0d��YZdd1d��YZdd2d��YZdd3d��YZdd4d��YZdejf
d ��YZd!ejf
d"��YZd#ejf
d$��YZd%ef
d&��YZd'ef
d(��YZd)ef
d*��YZ d+�Z!d,�Ze"d-kr�
e�
nd
S(5i����N(
ttest_supportc
Csd
S(Ntfoo((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returntexts
c
Csd
S(Nubar((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnunicodes
c
Csd
S(Ni*((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnint!s
c
Csd
S(Ng��Q�	@((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnfloat#s
c
CsdS(
N(
tNone(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnnull%s
cCs!tj
��
td
�
SWdQXdS(Ntblob(Rtcheck_py3k_warningstbuffer(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnblob's


cCsdS(Ni
iI�((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnlonglong*s
cCsd
d
dS(Nii((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_raiseexception,s
c

Cst|�
t
kS(
N(ttypetunicode(
t
v((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt
func_isstring/s
c

Cst|�
t
kS(
N(Rtint(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt
func_isint1s
c

Cst|�
t
kS(
N(Rtfloat(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isfloat3s
c

Cst|�
td�
kS(
N(RR(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isnone5s
c

Cst|�
t
kS(
N(RR
(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isblob7s
c

Cst|t
tf�o|dkS(Ni
iI�(t
isinstanceRtlong(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfunc_islonglong9s
t
AggrNoStepc
BseZ
d�Zd
�ZRS(c


CsdS(
N((
tself((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt__init__=s
c


Csd
S(Ni
((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytfinalize@s
(t__name__t
__module__RR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR<s
	tAggrNoFinalizec
BseZ
d�Zd
�ZRS(c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRDs
c
CsdS(
N((Rt
x((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytstepGs
(RR RR#(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR!Cs
	tAggrExceptionInInitc
Bs#eZ
d�Zd
�Zd�ZRS(c

Csd
d
dS(Nii((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRKs
c
CsdS(
N((RR"((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR#Ns
c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRQs
(RR RR#R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR$Js
		tAggrExceptionInStepc
Bs#eZ
d�Zd
�Zd�ZRS(c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRUs
cCsd
d
dS(Nii((RR"((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR#Xs
c


Csd
S(Ni*((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR[s
(RR RR#R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR%Ts
		tAggrExceptionInFinalizec
Bs#eZ
d�Zd
�Zd�ZRS(c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR_s
c
CsdS(
N((RR"((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR#bs
c

Csd
d
dS(Nii((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRes
(RR RR#R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR&^s
		t
AggrCheckTypec
Bs#eZ
d�Zd
�Zd�ZRS(c

Cs
d|_
dS(
N(Rtval(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRis
cCsRitd
6t
d6td6td�
d6td6}t
||
t|�
k�
|_dS(NtstrRRRR(RRRRRR
R((Rt	whichTypeR(ttheType((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR#ls
/
c


Cs|jS(
N(
R((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRps
(RR RR#R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR'hs
		tAggrSumc
Bs#eZ
d�Zd
�Zd�ZRS(c

Cs
d
|_dS(Ng(
R((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRts
cCs|j|
7_dS(
N(
R((RR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR#ws
c


Cs|jS(
N(
R((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRzs
(RR RR#R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR,ss
		t
FunctionTestsc
Bs�eZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�Zd
�Zd�Zd�Zd�Zd�ZRS(c

CsJ
tj
d
�
|_|jjddt�
|jjddt�
|jjddt�
|jjddt�
|jjddt�
|jjddt	�
|jjd	dt
�
|jjd
dt�
|jjddt�
|jjd
dt
�
|jjddt�
|jjddt�
|jjddt�
|jjddt�
dS(Ns:memory:t
returntextit
returnunicodet	returninttreturnfloatt
returnnullt
returnblobtreturnlonglongtraiseexceptiontisstringi
tisinttisfloattisnonetisblobt
islonglong(tsqlitetconnecttcontcreate_functionRRRRRRRR
RRRRRR(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytsetUp~s












c


Cs|jj
�
dS(
N(R>tclose(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyttearDown�s
c

CsEy*|jj
d
dd��
|jd�

Wntjk
r@


n
XdS(Ntblai����c

Ssd
|S(Ni((
R"((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt<lambda>�ts&should have raised an OperationalError(R>R?tfailR<tOperationalError(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncErrorOnCreate�s





c
CsUd
�}
|
�}|t�d<|j
jdd|�
|j
j�}|jd�

dS(Nc

Ss
d
�}|S(Nc
Ssd
S(Ni
((((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt
f�s
((
RI((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytgetfunc�s
	R
treftestisselect reftest()(tglobalsR>R?tcursortexecute(RRJRItcur((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncRefCount�s
		



c
CsV|jj
�}
|
jd
�

|
j�d}|jt|�
t�
|j|d�
dS(Nsselect returntext()iR
(R>RMRNtfetchonetassertEqualRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnText�s






c
CsV|jj
�}
|
jd
�

|
j�d}|jt|�
t�
|j|d�
dS(Nsselect returnunicode()iubar(R>RMRNRQRRRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnUnicode�s






c
CsV|jj
�}
|
jd
�

|
j�d}|jt|�
t�
|j|d�
dS(Nsselect returnint()ii*(R>RMRNRQRRRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnInt�s






c
Csn|jj
�}
|
jd
�

|
j�d}|jt|�
t�
|dksZ|dkrj|jd�

ndS(Nsselect returnfloat()ig�&1�	@gT㥛� 	@swrong value(R>RMRNRQRRRRRF(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnFloat�s






c
Cs\|jj
�}
|
jd
�

|
j�d}|jt|�
td�
�
|j|d�
dS(Nsselect returnnull()i(R>RMRNRQRRRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnNull�s






c
Cso|jj
�}
|
jd
�

|
j�d}tj��1
|jt|�
t�
|j|td�
�
WdQXdS(Nsselect returnblob()iR(	R>RMRNRQRR	RRRR
(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnBlob�s







c
Cs@|jj
�}
|
jd
�

|
j�d}|j|d�
dS(Nsselect returnlonglong()ii
iI�(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnLongLong�s




c
Csk|jj
�}
y(|
jd
�

|
j�
|jd�

Wn-tjk
rf
}
|j|jdd�
n
XdS(Nsselect raiseexception()s#should have raised OperationalErroris&user-defined function raised exception(	R>RMRNRQRFR<RGRRtargs(RROt
e((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncException�s








c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isstring(?)R
ii
(
R
(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamString�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isint(?)i*ii
(
i*(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt
CheckParamInt�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isfloat(?)g��Q�	@ii
(
g��Q�	@(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamFloat�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isnone(?)ii
(
N(R>RMRNRRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamNone�s



c
Cs_|jj
�}
tj��
|
jd
td�
f
�
WdQX|
j�d}|j|d�
dS(Nsselect isblob(?)Rii
(R>RMRR	RNR
RQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamBlob�s






c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect islonglong(?)i
i*iI(
I(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamLongLong

s



(RR R@RBRHRPRSRTRURVRWRXRYR\R]R^R_R`RaRb(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR-}s$
																		tAggregateTestsc
Bs�eZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�Zd
�ZRS(c
Cs
tj
d
�
|_|jj�}
|
jd�

tj��*
|
jdddddtd�
f�
WdQX|jj	dd	t
�
|jj	d
d	t�
|jj	dd	t�
|jj	dd	t
�
|jj	d
d	t�
|jj	ddt�
|jj	dd	t�
dS(Ns:memory:s�
            create table test(
                t text,
                i integer,
                f float,
                n,
                b blob
                )
            s6insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)R
ig��Q�	@Rtnostepi
t
nofinalizetexcInittexcSteptexcFinalizet	checkTypeitmysum(R<R=R>RMRNRR	RR
tcreate_aggregateRR!R$R%R&R'R,(RRO((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR@
s





	
"





c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRB 
sc

CsBy'|jj
d
dt�
|jd�

Wntjk
r=


n
XdS(NRCi����s&should have raised an OperationalError(R>R?R,RFR<RG(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrErrorOnCreate%
s





c
Cs^|jj
�}
y|
jd
�

|jd�

Wn*tk
rY
}
|j|jdd�
n
XdS(Nsselect nostep(t) from tests$should have raised an AttributeErroris+AggrNoStep instance has no attribute 'step'(R>RMRNRFtAttributeErrorRRRZ(RROR[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrNoStep,
s






c
Csq|jj
�}
y.|
jd
�

|
j�d}|jd�

Wn-tjk
rl
}
|j|jdd�
n
XdS(Nsselect nofinalize(t) from testis&should have raised an OperationalErrors7user-defined aggregate's 'finalize' method raised error(	R>RMRNRQRFR<RGRRRZ(RROR(R[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrNoFinalize4
s







c
Csq|jj
�}
y.|
jd
�

|
j�d}|jd�

Wn-tjk
rl
}
|j|jdd�
n
XdS(Nsselect excInit(t) from testis&should have raised an OperationalErrors7user-defined aggregate's '__init__' method raised error(	R>RMRNRQRFR<RGRRRZ(RROR(R[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInInit=
s







c
Csq|jj
�}
y.|
jd
�

|
j�d}|jd�

Wn-tjk
rl
}
|j|jdd�
n
XdS(Nsselect excStep(t) from testis&should have raised an OperationalErrors3user-defined aggregate's 'step' method raised error(	R>RMRNRQRFR<RGRRRZ(RROR(R[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInStepF
s







c
Csq|jj
�}
y.|
jd
�

|
j�d}|jd�

Wn-tjk
rl
}
|j|jdd�
n
XdS(Nsselect excFinalize(t) from testis&should have raised an OperationalErrors7user-defined aggregate's 'finalize' method raised error(	R>RMRNRQRFR<RGRRRZ(RROR(R[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInFinalizeO
s







c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('str', ?)R
ii
(
R
(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamStrX
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('int', ?)i*ii
(
i*(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamInt^
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('float', ?)g��Q�	@ii
(
g��Q�	@(R>RMRNRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamFloatd
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('None', ?)ii
(
N(R>RMRNRRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamNonej
s



c
Cs_|jj
�}
tj��
|
jd
td�
f
�
WdQX|
j�d}|j|d�
dS(Nsselect checkType('blob', ?)Rii
(R>RMRR	RNR
RQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamBlobp
s






c
Csf|jj
�}
|
jd
�

|
jdd	d
dg�
|
jd�

|
j�d}|j|d�
dS(Nsdelete from testsinsert into test(i) values (?)i
iisselect mysum(i) from testii<(
i
(
i(
i(R>RMRNtexecutemanyRQRR(RROR(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckAggrSumw
s







(RR R@RBRlRnRoRpRqRrRsRtRuRvRwRy(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRc
s
																	tAuthorizerTestscBs;eZ
ed��
Zd
�Zd�Zd�Zd�ZRS(cCs<|tj
krtjS|d
ks.|
dkr5tjStjS(Ntc2tt2(R<t
SQLITE_SELECTtSQLITE_DENYt	SQLITE_OK(tactiontarg1targ2tdbnametsource((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt
authorizer_cb�
s




c

CsItj
d
�
|_|jjd�

|jjd�

|jj|j�

dS(Ns:memory:s�
            create table t1 (c1, c2);
            create table t2 (c1, c2);
            insert into t1 (c1, c2) values (1, 2);
            insert into t2 (c1, c2) values (4, 5);
            sselect c2 from t2(R<R=R>t
executescriptRNtset_authorizerR�(
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR@�
s


	c


CsdS(
N((
R((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRB�
s
c
Cspy|jj
d
�

WnHtjk
r^
}

|
jdjd�
sZ|jd|
jd�

ndSX|jd�

dS(Nsselect * from t2it
prohibitedswrong exception text: %ss9should have raised an exception due to missing privileges(R>RNR<t
DatabaseErrorRZtendswithRF(RR[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyttest_table_access�
s






c
Cspy|jj
d
�

WnHtjk
r^
}

|
jdjd�
sZ|jd|
jd�

ndSX|jd�

dS(Nsselect c2 from t1iR�swrong exception text: %ss9should have raised an exception due to missing privileges(R>RNR<R�RZR�RF(RR[((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyttest_column_access�
s






(RR tstaticmethodR�R@RBR�R�(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyRz
s

				tAuthorizerRaiseExceptionTestscBseZ
ed��
ZRS(
cCs@|tj
krt�
n|d
ks0|
dkr9t�
ntjS(NR{R|(R<R}t
ValueErrorR(R�R�R�R�R�((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s

	

	
(RR R�R�(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s
tAuthorizerIllegalTypeTestscBseZ
ed��
ZRS(
cCs6|tj
krd
S|dks+|
dkr/d
StjS(NgR{R|(R<R}R(R�R�R�R�R�((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s




(RR R�R�(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s
tAuthorizerLargeIntegerTestscBseZ
ed��
ZRS(
cCs6|tj
krdS|dks+|
dkr/dStjS(Nii R{R|I
I
(R<R}R(R�R�R�R�R�((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s




(RR R�R�(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyR��
s
cCsmtj
td
�}tj
td
�}
tj
t�
}tj||
|tj
t�
tj
t�
tj
t�
f�
S(NtCheck(	tunittestt	makeSuiteR-RcRzt	TestSuiteR�R�R�(tfunction_suitetaggregate_suitetauthorizer_suite((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pytsuite�
s









c
Cs tj
�}|jt��

dS(
N(R�tTextTestRunnertrunR�(
trunner((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyttest�
s

t__main__((((((((#R�tsqlite3R<R�RRRRRRRRR
RRRRRRRR!R$R%R&R'R,tTestCaseR-RcRzR�R�R�R�R(((s6/usr/local/lib/python2.7/sqlite3/test/userfunctions.pyt<module>sB

														



�x,