��Qc@s�dd
lZdd
l
Zd�Zd�Zd�Zd�Zd�Zd�Zd�Z	d	�Z
d
�Zd�Zd�Z
d
�Zd�Zd�Zdd-d��YZdd.d��YZdd/d��YZdd0d��YZdd1d��YZdd2d��YZdd3d��YZdejf
d��YZd ejf
d!��YZd"ejf
d#��YZd$ef
d%��YZd&ef
d'��YZd(ef
d)��YZd*�Zd+�Z e!d,kr�e �
nd
S(4i�Nc
Csd
S(Ntfoo((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returntexts
c
Csd
S(Nubar((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnunicodes
c
Csd
S(Ni*((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnint s
c
Csd
S(Ng�Q�	@((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnfloat"s
c
CsdS(
N(
tNone(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnnull$s
cCs
td
�S(Ntblob(
tbuffer(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnblob&s
cCsdS(Ni
il((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_returnlonglong(s
cCsd
d
dS(Nii((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_raiseexception*s
c

Cst|�t
kS(
N(ttypetunicode(
t
v((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt
func_isstring-s
c

Cst|�t
kS(
N(Rtint(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt
func_isint/s
c

Cst|�t
kS(
N(Rtfloat(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isfloat1s
c

Cst|�td�kS(
N(RR(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isnone3s
c

Cst|�t
kS(
N(RR(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_isblob5s
c

Cst|t
tf�o|dkS(Ni
il(t
isinstanceRtlong(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfunc_islonglong7s
t
AggrNoStepc
BseZ
d�Zd
�ZRS(c


CsdS(
N((
tself((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt__init__;s
c


Csd
S(Ni
((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytfinalize>s
(t__name__t
__module__RR(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR:s
	tAggrNoFinalizec
BseZ
d�Zd
�ZRS(c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRBs
c
CsdS(
N((Rt
x((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytstepEs
(RRRR!(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRAs
	tAggrExceptionInInitc
Bs#eZ
d�Zd
�Zd�ZRS(c

Csd
d
dS(Nii((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRIs
c
CsdS(
N((RR ((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR!Ls
c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyROs
(RRRR!R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR"Hs
		tAggrExceptionInStepc
Bs#eZ
d�Zd
�Zd�ZRS(c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRSs
cCsd
d
dS(Nii((RR ((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR!Vs
c


Csd
S(Ni*((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRYs
(RRRR!R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR#Rs
		tAggrExceptionInFinalizec
Bs#eZ
d�Zd
�Zd�ZRS(c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR]s
c
CsdS(
N((RR ((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR!`s
c

Csd
d
dS(Nii((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRcs
(RRRR!R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR$\s
		t
AggrCheckTypec
Bs#eZ
d�Zd
�Zd�ZRS(c

Cs
d|_
dS(
N(Rtval(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRgs
cCsRitd
6t
d6td6td�d6td6}t
||
t|�k�|_dS(NtstrRRRR(R
RRRRRR&(Rt	whichTypeR&ttheType((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR!js
/
c


Cs|jS(
N(
R&(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRns
(RRRR!R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR%fs
		tAggrSumc
Bs#eZ
d�Zd
�Zd�ZRS(c

Cs
d
|_dS(Ng(
R&(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRrs
cCs|j|
7_dS(
N(
R&(RR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR!us
c


Cs|jS(
N(
R&(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRxs
(RRRR!R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR*qs
		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_functionR
RRRRR	R
RRRRRRR(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytsetUp|s












c


Cs|jj
�
dS(
N(R<tclose(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyttearDown�s
c

CsEy*|jj
d
dd��
|jd�
Wntjk
r@


n
XdS(Ntblai��
Ssd
|S(Ni((
R ((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt<lambda>�ss&should have raised an OperationalError(R<R=tfailR:tOperationalError(
R((s0/sys/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
((((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt
f�s
((
RF((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytgetfunc�s
	Rtreftestisselect reftest()(tglobalsR<R=tcursortexecute(RRGRFtcur((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncRefCount�s
		



c
CsV|jj
�}
|
jd
�
|
j�d}|jt|�t�
|j|d�
dS(Nsselect returntext()iR(R<RJRKtfetchonetassertEqualRR
(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnText�s






c
CsV|jj
�}
|
jd
�
|
j�d}|jt|�t�
|j|d�
dS(Nsselect returnunicode()iubar(R<RJRKRNRORR
(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnUnicode�s






c
CsV|jj
�}
|
jd
�
|
j�d}|jt|�t�
|j|d�
dS(Nsselect returnint()ii*(R<RJRKRNRORR(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnInt�s






c
Csn|jj
�}
|
jd
�
|
j�d}|jt|�t�
|dksZ|dkrj|jd�
ndS(Nsselect returnfloat()ig��	@gS㥛�	@swrong value(R<RJRKRNRORRRC(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnFloat�s






c
Cs\|jj
�}
|
jd
�
|
j�d}|jt|�td��
|j|d�
dS(Nsselect returnnull()i(R<RJRKRNRORR(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnNull�s






c
Cs\|jj
�}
|
jd
�
|
j�d}|jt|�t�
|j|td��
dS(Nsselect returnblob()iR(R<RJRKRNRORR(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncReturnBlob�s






c
Cs@|jj
�}
|
jd
�
|
j�d}|j|d�
dS(Nsselect returnlonglong()ii
il(R<RJRKRNRO(RRLR&((s0/sys/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<RJRKRNRCR:RDROtargs(RRLt
e((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckFuncException�s








c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isstring(?)Rii
(
sfoo(R<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamString�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isint(?)i*ii
(
i*(R<RJRKRNRO(RRLR&((s0/sys/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<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamFloat�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect isnone(?)ii
(
N(R<RJRKRRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamNone�s



c
CsL|jj
�}
|
jd
td�f
�
|
j�d}|j|d�
dS(Nsselect isblob(?)Rii
(R<RJRKRRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamBlob�s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect islonglong(?)i
i*il(
l(R<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckParamLongLong�s



(RRR>R@RERMRPRQRRRSRTRURVRYRZR[R\R]R^R_(((s0/sys/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�
|
jdddddtd�f�
|jjdd	t�
|jjd
d	t	�
|jjdd	t
�
|jjdd	t�
|jjd
d	t�
|jjddt
�
|jjdd	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 (?, ?, ?, ?, ?)Rig�Q�	@Rtnostepi
t
nofinalizetexcInittexcSteptexcFinalizet	checkTypeitmysum(R:R;R<RJRKRRtcreate_aggregateRRR"R#R$R%R*(RRL((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR>
s



	






c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR@
sc

CsBy'|jj
d
dt�
|jd�
Wntjk
r=


n
XdS(NRAi��should have raised an OperationalError(R<R=R*RCR:RD(
R((s0/sys/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<RJRKRCtAttributeErrorRORW(RRLRX((s0/sys/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<RJRKRNRCR:RDRORW(RRLR&RX((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrNoFinalize/
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<RJRKRNRCR:RDRORW(RRLR&RX((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInInit8
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<RJRKRNRCR:RDRORW(RRLR&RX((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInStepA
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<RJRKRNRCR:RDRORW(RRLR&RX((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrExceptionInFinalizeJ
s







c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('str', ?)Rii
(
sfoo(R<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamStrS
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('int', ?)i*ii
(
i*(R<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamIntY
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('float', ?)g�Q�	@ii
(
g�Q�	@(R<RJRKRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamFloat_
s



c
CsC|jj
�}
|
jd
d�
|
j�d}|j|d�
dS(Nsselect checkType('None', ?)ii
(
N(R<RJRKRRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamNonee
s



c
CsL|jj
�}
|
jd
td�f
�
|
j�d}|j|d�
dS(Nsselect checkType('blob', ?)Rii
(R<RJRKRRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckParamBlobk
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<RJRKtexecutemanyRNRO(RRLR&((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytCheckAggrCheckAggrSumq
s







(RRR>R@RiRkRlRmRnRoRpRqRrRsRtRv(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR`
s
																	tAuthorizerTestscBs;eZ
ed��Zd
�Zd�Zd�Zd�ZRS(cCs<|tj
krtjS|d
ks.|
dkr5tjStjS(Ntc2tt2(R:t
SQLITE_SELECTtSQLITE_DENYt	SQLITE_OK(tactiontarg1targ2tdbnametsource((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt
authorizer_cbz
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
executescriptRKtset_authorizerR�(
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR>�s


	c


CsdS(
N((
R((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR@�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<RKR:t
DatabaseErrorRWtendswithRC(RRX((s0/sys/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<RKR:R�RWR�RC(RRX((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyttest_column_access�s






(RRtstaticmethodR�R>R@R�R�(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyRwy
s

				tAuthorizerRaiseExceptionTestscBseZ
ed��ZRS(
cCs@|tj
krt�n|d
ks0|
dkr9t�ntjS(NRxRy(R:Rzt
ValueErrorR|(R}R~RR�R�((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR��s

	

	
(RRR�R�(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR��s
tAuthorizerIllegalTypeTestscBseZ
ed��ZRS(
cCs6|tj
krd
S|dks+|
dkr/d
StjS(NgRxRy(R:RzR|(R}R~RR�R�((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR��s




(RRR�R�(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR��s
tAuthorizerLargeIntegerTestscBseZ
ed��ZRS(
cCs6|tj
krdS|dks+|
dkr/dStjS(Nii RxRyll(R:RzR|(R}R~RR�R�((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyR��s




(RRR�R�(((s0/sys/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+R`Rwt	TestSuiteR�R�R�(tfunction_suitetaggregate_suitetauthorizer_suite((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pytsuite�s









c
Cs tj
�}|jt��
dS(
N(R�tTextTestRunnertrunR�(
trunner((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyttest�s

t__main__(((((((("R�tsqlite3R:R
RRRRR	R
RRRRRRRRRR"R#R$R%R*tTestCaseR+R`RwR�R�R�R�R�R(((s0/sys/lib/python2.7/sqlite3/test/userfunctions.pyt<module>s@
														



�v,