/opt/imh-python/lib/python3.9/sqlite3/test/__pycache__
Edit: /opt/imh-python/lib/python3.9/sqlite3/test/__pycache__/userfunctions.cpython-39.pyc (23240B)
a
cæh®G ã @ s d dl Z d dlZ d dlZdd„ Zdd„ Zdd„ Zdd „ Zd
d „ Zd d
„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ Zdd„ Zd d „ Zd d „ Zd d!„ ZG d"d#„ d#ƒZG d$d%„ d%ƒZG d&d'„ d'ƒZG d(d)„ d)ƒZG d*d+„ d+ƒZG d,d-„ d-ƒZG d.d/„ d/ƒZG d0d1„ d1ƒZG d2d3„ d3ƒZ G d4d5„ d5e j ƒZ G d6d7„ d7e j ƒZ G d8d9„ d9e j ƒZ G d:d;„ d;e ƒZ!G d
d?„ d?e ƒZ#d@dA„ Z$dBdC„ Z%e&dDkrœe%ƒ dS )Eé Nc C s dS )NÚfoo© r r r ú;/opt/imh-python/lib/python3.9/sqlite3/test/userfunctions.pyÚfunc_returntext s r c C s dS )Nú1 2r r r r r Úfunc_returntextwithnull s r c C s dS )NÚbarr r r r r Úfunc_returnunicode s r c C s dS ©Né* r r r r r Úfunc_returnint" s r c C s dS )Nç …ëQ¸ @r r r r r Úfunc_returnfloat$ s r c C s d S ©Nr r r r r Úfunc_returnnull& s r c C s dS )Nó blobr r r r r Úfunc_returnblob( s r c C s dS ©Nì r r r r r Úfunc_returnlonglong* s r c C s dd d S ©Né r r r r r r Úfunc_raiseexception, s r c C s t | ƒtu S r )ÚtypeÚstr©Úvr r r Ú
func_isstring/ s r c C s t | ƒtu S r )r Úintr r r r Ú
func_isint1 s r c C s t | ƒtu S r )r Úfloatr r r r Ú func_isfloat3 s r! c C s t | ƒt d ƒu S r )r r r r r Ú func_isnone5 s r" c C s t | ttfƒS r )Ú
isinstanceÚbytesÚ
memoryviewr r r r Ú func_isblob7 s r& c C s t | tƒo| dkS r )r# r r r r r Úfunc_islonglong9 s r' c G s t | ƒS r )Úlen)Úargsr r r Úfunc< s r* c @ s e Zd Zdd„ Zdd„ ZdS )Ú
AggrNoStepc C s d S r r ©Úselfr r r Ú__init__@ s zAggrNoStep.__init__c C s dS ©Né r r, r r r ÚfinalizeC s zAggrNoStep.finalizeN)Ú__name__Ú
__module__Ú __qualname__r. r1 r r r r r+ ? s r+ c @ s e Zd Zdd„ Zdd„ ZdS )ÚAggrNoFinalizec C s d S r r r, r r r r. G s zAggrNoFinalize.__init__c C s d S r r ©r- Úxr r r ÚstepJ s zAggrNoFinalize.stepN)r2 r3 r4 r. r8 r r r r r5 F s r5 c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrExceptionInInitc C s dd d S r r r, r r r r. N s z AggrExceptionInInit.__init__c C s d S r r r6 r r r r8 Q s zAggrExceptionInInit.stepc C s d S r r r, r r r r1 T s z AggrExceptionInInit.finalizeN©r2 r3 r4 r. r8 r1 r r r r r9 M s r9 c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrExceptionInStepc C s d S r r r, r r r r. X s z AggrExceptionInStep.__init__c C s dd d S r r r6 r r r r8 [ s zAggrExceptionInStep.stepc C s dS r
r r, r r r r1 ^ s z AggrExceptionInStep.finalizeNr: r r r r r; W s r; c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrExceptionInFinalizec C s d S r r r, r r r r. b s z AggrExceptionInFinalize.__init__c C s d S r r r6 r r r r8 e s z AggrExceptionInFinalize.stepc C s dd d S r r r, r r r r1 h s z AggrExceptionInFinalize.finalizeNr: r r r r r< a s r< c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )Ú
AggrCheckTypec C s
d | _ d S r ©Úvalr, r r r r. l s zAggrCheckType.__init__c C s. t tttd ƒtdœ}t|| t|ƒu ƒ| _d S ©N)r r r ÚNoneZblob©r r r r r$ r? )r- Ú whichTyper? ÚtheTyper r r r8 o s ÿzAggrCheckType.stepc C s | j S r r> r, r r r r1 t s zAggrCheckType.finalizeNr: r r r r r= k s r= c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrCheckTypesc C s
d| _ d S )Nr r> r, r r r r. x s zAggrCheckTypes.__init__c G s@ t tttd ƒtdœ}|D ]"}| jt|| t|ƒu ƒ7 _qd S r@ rB )r- rC ZvalsrD r? r r r r8 { s
ÿzAggrCheckTypes.stepc C s | j S r r> r, r r r r1 s zAggrCheckTypes.finalizeNr: r r r r rE w s rE c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrSumc C s
d| _ d S )Nç r> r, r r r r. … s zAggrSum.__init__c C s | j |7 _ d S r r> )r- r? r r r r8 ˆ s z AggrSum.stepc C s | j S r r> r, r r r r1 ‹ s zAggrSum.finalizeNr: r r r r rF „ s rF c @ s$ e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚAggrTextc C s
d| _ d S )NÚ ©Útxtr, r r r r. s zAggrText.__init__c C s | j | | _ d S r rJ )r- rK r r r r8 ‘ s z
AggrText.stepc C s | j S r rJ r, r r r r1 “ s zAggrText.finalizeNr: r r r r rH Ž s rH c @ s e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ Zdd „ Zd d „ Zd d „ Zd!d"„ Zd#d$„ Zd%d&„ Zd'd(„ Ze ejd)k d*¡d+d,„ ƒZe ejd)k d*¡d-d.„ ƒZ e ejd)kd/¡d0d1„ ƒZ d2d3„ Z d4S )5Ú
FunctionTestsc C s t d¡| _| j ddt¡ | j ddt¡ | j ddt¡ | j ddt¡ | j ddt¡ | j ddt ¡ | j d dt
¡ | j d
dt ¡ | j d dt ¡ | j d d
t
¡ | j dd
t¡ | j dd
t¡ | j dd
t¡ | j dd
t¡ | j dd
t¡ | j ddt¡ | j d¡ d S )Nú:memory:Z
returntextr ZreturntextwithnullZ
returnunicodeZ returnintZ returnfloatZ
returnnullZ
returnblobZreturnlonglongZraiseexceptionÚisstringr0 ZisintZisfloatZisnoneZisblobZ
islonglongZspaméÿÿÿÿzcreate table test(t text))ÚsqliteÚconnectÚconÚcreate_functionr r r r r r r r r r r r! r" r& r' r* Úexecuter, r r r ÚsetUp˜ s$ zFunctionTests.setUpc C s | j ¡ d S r )rR Úcloser, r r r ÚtearDown® s zFunctionTests.tearDownc C sD | tj¡$ | j dddd„ ¡ W d ƒ n1 s60 Y d S )NÚblaéœÿÿÿc S s d| S )Né r )r7 r r r Ú³ ó z6FunctionTests.CheckFuncErrorOnCreate..)Ú assertRaisesrP ÚOperationalErrorrR rS r, r r r ÚCheckFuncErrorOnCreate± s z$FunctionTests.CheckFuncErrorOnCreatec C s@ dd„ }|ƒ }|t ƒ d< | j dd|¡ | j ¡ }| d¡ d S )Nc S s dd„ } | S )Nc S s dS r/ r r r r r Úf· s z;FunctionTests.CheckFuncRefCount..getfunc..fr )r` r r r Úgetfunc¶ s z0FunctionTests.CheckFuncRefCount..getfuncr Zreftestr zselect reftest())ÚglobalsrR rS ÚcursorrT )r- ra r` Úcurr r r ÚCheckFuncRefCountµ s
z FunctionTests.CheckFuncRefCountc C s@ | j ¡ }| d¡ | ¡ d }| t|ƒt¡ | |d¡ d S )Nzselect returntext()r r ©rR rc rT ÚfetchoneÚ assertEqualr r ©r- rd r? r r r ÚCheckFuncReturnTextÁ s
z!FunctionTests.CheckFuncReturnTextc C s< | j ¡ }| d¡ ¡ d }| t|ƒt¡ | |d¡ d S )Nzselect returntextwithnull()r r rf )r- rd Úresr r r Ú CheckFuncReturnTextWithNullCharÈ s
z-FunctionTests.CheckFuncReturnTextWithNullCharc C s@ | j ¡ }| d¡ | ¡ d }| t|ƒt¡ | |d¡ d S )Nzselect returnunicode()r r rf ri r r r ÚCheckFuncReturnUnicodeÎ s
z$FunctionTests.CheckFuncReturnUnicodec C s@ | j ¡ }| d¡ | ¡ d }| t|ƒt¡ | |d¡ d S )Nzselect returnint()r r )rR rc rT rg rh r r ri r r r ÚCheckFuncReturnIntÕ s
z FunctionTests.CheckFuncReturnIntc C sN | j ¡ }| d¡ | ¡ d }| t|ƒt¡ |dk s@|dkrJ| d¡ d S )Nzselect returnfloat()r gé&1¬ @gTã¥›Ä @z wrong value)rR rc rT rg rh r r Úfailri r r r ÚCheckFuncReturnFloatÜ s
z"FunctionTests.CheckFuncReturnFloatc C sD | j ¡ }| d¡ | ¡ d }| t|ƒtd ƒ¡ | |d ¡ d S )Nzselect returnnull()r )rR rc rT rg rh r ri r r r ÚCheckFuncReturnNullä s
z!FunctionTests.CheckFuncReturnNullc C s@ | j ¡ }| d¡ | ¡ d }| t|ƒt¡ | |d¡ d S )Nzselect returnblob()r r )rR rc rT rg rh r r$ ri r r r ÚCheckFuncReturnBlobë s
z!FunctionTests.CheckFuncReturnBlobc C s0 | j ¡ }| d¡ | ¡ d }| |d¡ d S )Nzselect returnlonglong()r r ©rR rc rT rg rh ri r r r ÚCheckFuncReturnLongLongò s
z%FunctionTests.CheckFuncReturnLongLongc C s^ | j ¡ }| tj¡"}| d¡ | ¡ W d ƒ n1 s>0 Y | t|j ƒd¡ d S )Nzselect raiseexception()z&user-defined function raised exception©
rR rc r] rP r^ rT rg rh r Ú exception©r- rd Úcmr r r ÚCheckFuncExceptionø s
&z FunctionTests.CheckFuncExceptionc C sp | j ¡ }dtƒ fD ]V}| j|d6 | d|f¡ | ¡ d }| |d¡ W d ƒ q1 s`0 Y qd S )Nr )Útextzselect isstring(?)r r0 )rR rc r ÚsubTestrT rg rh )r- rd rz r? r r r ÚCheckParamStringÿ s
z FunctionTests.CheckParamStringc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect isint(?)©r r r0 rs ri r r r Ú
CheckParamInt s
zFunctionTests.CheckParamIntc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect isfloat(?)©r
r r0 rs ri r r r ÚCheckParamFloat
s
z FunctionTests.CheckParamFloatc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect isnone(?)r r r0 rs ri r r r ÚCheckParamNone s
z FunctionTests.CheckParamNonec C s8 | j ¡ }| dtdƒf¡ | ¡ d }| |d¡ d S )Nzselect isblob(?)r r r0 ©rR rc rT r% rg rh ri r r r ÚCheckParamBlob s
z FunctionTests.CheckParamBlobc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect islonglong(?))l r r0 rs ri r r r ÚCheckParamLongLong s
z FunctionTests.CheckParamLongLongc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect spam(?, ?))r0 rZ r rZ rs ri r r r ÚCheckAnyArguments% s
z FunctionTests.CheckAnyArguments)é é r† z Requires SQLite 3.8.3 or higherc C s„ t jjd d}| jjdd|dd tjdk rH| j d¡ | |j d¡ n8|
tj ¡ | j d ¡ W d ƒ n1 sv0 Y d S )
N©Z return_valueZnondeterministicr F©Ú
deterministic©r† é r z.select nondeterministic() = nondeterministic()rZ z>create index t on test(t) where nondeterministic() is not null) ÚunittestÚmockÚMockrR rS rP Úsqlite_version_inforT rh Ú
call_countr] r^ ©r- rŽ r r r ÚCheckFuncNonDeterministic2 s
z'FunctionTests.CheckFuncNonDeterministicc C s| t jjd d}| jjdd|dd tjdk rH| j d¡ | |j d¡ n0z| j d ¡ W n tj
yv | d
¡ Y n0 d S ) Nrˆ rŠ r Tr‰ r‹ z(select deterministic() = deterministic()r0 z;create index t on test(t) where deterministic() is not nullz/Unexpected failure while creating partial index) r rŽ r rR rS rP r rT rh r‘ r^ ro r’ r r r ÚCheckFuncDeterministic= s
z$FunctionTests.CheckFuncDeterministiczSQLite < 3.8.3 neededc C sD | tj¡$ | jjddtdd W d ƒ n1 s60 Y d S )NrŠ r Tr‰ )r] rP ZNotSupportedErrorrR rS r r, r r r Ú"CheckFuncDeterministicNotSupportedJ s z0FunctionTests.CheckFuncDeterministicNotSupportedc C s@ | t¡" | j ddtd¡ W d ƒ n1 s20 Y d S )NrŠ r T)r] Ú TypeErrorrR rS r r, r r r Ú!CheckFuncDeterministicKeywordOnlyO s z/FunctionTests.CheckFuncDeterministicKeywordOnlyN) r2 r3 r4 rU rW r_ re rj rl rm rn rp rq rr rt ry r| r~ r€ r rƒ r„ r… r ZskipIfrP r r“ r” r• r— r r r r rL — s6
rL c @ sŒ e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd d
„ Zd d „ Zd
d„ Z dd„ Z
dd„ Z dd„ Z dd„ Z
dd„ Zdd„ Zdd „ Zd d „ Zd d „ Zd!S )"ÚAggregateTestsc C sÎ t d¡| _| j ¡ }| d¡ | ddddd tdƒf¡ | j dd t¡ | j d
d t¡ | j d d t ¡ | j d d t
¡ | j d
d t ¡ | j ddt ¡ | j ddt
¡ | j dd t¡ | j dd t¡ d S )NrM z´
create table test(
t text,
i integer,
f float,
n,
b blob
)
z6insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)r r r
r Znostepr0 Z
nofinalizeZexcInitZexcStepZ excFinalizeZ checkTyperZ Z
checkTypesrO ZmysumZaggtxt)rP rQ rR rc rT r% Zcreate_aggregater+ r5 r9 r; r< r= rE rF rH )r- rd r r r rU U s
ÿzAggregateTests.setUpc C s d S r r r, r r r rW n s zAggregateTests.tearDownc C s@ | tj¡ | j ddt¡ W d ƒ n1 s20 Y d S )NrX rY )r] rP r^ rR rS rF r, r r r ÚCheckAggrErrorOnCreates s z%AggregateTests.CheckAggrErrorOnCreatec C sT | j ¡ }| t¡}| d¡ W d ƒ n1 s40 Y | t|jƒd¡ d S )Nzselect nostep(t) from testz+'AggrNoStep' object has no attribute 'step')rR rc r] ÚAttributeErrorrT rh r rv rw r r r ÚCheckAggrNoStepw s
(z AggregateTests.CheckAggrNoStepc C sb | j ¡ }| tj¡&}| d¡ | ¡ d }W d ƒ n1 sB0 Y | t|j ƒd¡ d S )Nz select nofinalize(t) from testr ú7user-defined aggregate's 'finalize' method raised errorru ©r- rd rx r? r r r ÚCheckAggrNoFinalize} s
*z"AggregateTests.CheckAggrNoFinalizec C sb | j ¡ }| tj¡&}| d¡ | ¡ d }W d ƒ n1 sB0 Y | t|j ƒd¡ d S )Nzselect excInit(t) from testr z7user-defined aggregate's '__init__' method raised errorru r r r r ÚCheckAggrExceptionInInit„ s
*z'AggregateTests.CheckAggrExceptionInInitc C sb | j ¡ }| tj¡&}| d¡ | ¡ d }W d ƒ n1 sB0 Y | t|j ƒd¡ d S )Nzselect excStep(t) from testr z3user-defined aggregate's 'step' method raised errorru r r r r ÚCheckAggrExceptionInStep‹ s
*z'AggregateTests.CheckAggrExceptionInStepc C sb | j ¡ }| tj¡&}| d¡ | ¡ d }W d ƒ n1 sB0 Y | t|j ƒd¡ d S )Nz select excFinalize(t) from testr rœ ru r r r r Ú CheckAggrExceptionInFinalize’ s
*z+AggregateTests.CheckAggrExceptionInFinalizec C s8 | j ¡ }| ddtƒ f¡ | ¡ d }| |d¡ d S )Nz select checkTypes('str', ?, ?)r r rZ )rR rc rT r rg rh ri r r r ÚCheckAggrCheckParamStr™ s
z%AggregateTests.CheckAggrCheckParamStrc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect checkType('int', ?)r} r r0 rs ri r r r ÚCheckAggrCheckParamIntŸ s
z%AggregateTests.CheckAggrCheckParamIntc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nz select checkTypes('int', ?, ?))r é r rZ rs ri r r r ÚCheckAggrCheckParamsInt¥ s
z&AggregateTests.CheckAggrCheckParamsIntc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nz select checkType('float', ?)r r r0 rs ri r r r ÚCheckAggrCheckParamFloat« s
z'AggregateTests.CheckAggrCheckParamFloatc C s2 | j ¡ }| dd¡ | ¡ d }| |d¡ d S )Nzselect checkType('None', ?)r r r0 rs ri r r r ÚCheckAggrCheckParamNone± s
z&AggregateTests.CheckAggrCheckParamNonec C s8 | j ¡ }| dtdƒf¡ | ¡ d }| |d¡ d S )Nzselect checkType('blob', ?)r r r0 r‚ ri r r r ÚCheckAggrCheckParamBlob· s
z&AggregateTests.CheckAggrCheckParamBlobc C sJ | j ¡ }| d¡ | dg d¢¡ | d¡ | ¡ d }| |d¡ d S )Nzdelete from testz insert into test(i) values (?)))é
)é )é zselect mysum(i) from testr é< )rR rc rT Z executemanyrg rh ri r r r ÚCheckAggrCheckAggrSum½ s
z$AggregateTests.CheckAggrCheckAggrSumc C sj | j ¡ }dD ]V}| j|d6 | d|f¡ | ¡ d }| ||¡ W d ƒ q1 sZ0 Y qd S )N)r r rJ zselect aggtxt(?) from testr )rR rc r{ rT rg rh )r- rd rK r? r r r Ú
CheckAggrTextÅ s
z AggregateTests.CheckAggrTextN)r2 r3 r4 rU rW r™ r› rž rŸ r r¡ r¢ r£ r¥ r¦ r§ r¨ r r® r r r r r˜ T s r˜ c @ s8 e Zd Zedd„ ƒZdd„ Zdd„ Zdd„ Zd d
„ Zd S ) ÚAuthorizerTestsc C s, | t jkrt jS |dks |dkr&t jS t jS ©NÚc2Út2)rP Ú
SQLITE_SELECTZ SQLITE_DENYÚ SQLITE_OK©ÚactionZarg1Zarg2ZdbnameÚsourcer r r Ú
authorizer_cbÏ s
z AuthorizerTests.authorizer_cbc C s6 t d¡| _| j d¡ | j d¡ | j | j¡ d S )NrM z¿
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);
zselect c2 from t2)rP rQ rR Z
executescriptrT Zset_authorizerr¸ r, r r r rU × s zAuthorizerTests.setUpc C s d S r r r, r r r rW å s zAuthorizerTests.tearDownc C sN | tj¡ }| j d¡ W d ƒ n1 s.0 Y | dt|jƒ¡ d S )Nzselect * from t2Ú
prohibited©r] rP Z
DatabaseErrorrR rT ZassertInr rv ©r- rx r r r Útest_table_accessè s *z!AuthorizerTests.test_table_accessc C sN | tj¡ }| j d¡ W d ƒ n1 s.0 Y | dt|jƒ¡ d S )Nzselect c2 from t1r¹ rº r» r r r Útest_column_accessí s *z"AuthorizerTests.test_column_accessN) r2 r3 r4 Ú staticmethodr¸ rU rW r¼ r½ r r r r r¯ Î s
r¯ c @ s e Zd Zedd„ ƒZdS )Ú AuthorizerRaiseExceptionTestsc C s( | t jkrt‚|dks |dkr"t‚t jS r° )rP r³ Ú
ValueErrorr´ rµ r r r r¸ ó s
z+AuthorizerRaiseExceptionTests.authorizer_cbN©r2 r3 r4 r¾ r¸ r r r r r¿ ò s r¿ c @ s e Zd Zedd„ ƒZdS )ÚAuthorizerIllegalTypeTestsc C s( | t jkrdS |dks |dkr"dS t jS )NrG r± r² ©rP r³ r´ rµ r r r r¸ ü s
z(AuthorizerIllegalTypeTests.authorizer_cbNrÁ r r r r r û s r c @ s e Zd Zedd„ ƒZdS )ÚAuthorizerLargeIntegerTestsc C s( | t jkrdS |dks |dkr"dS t jS )Nl r± r² rà rµ r r r r¸ s
z)AuthorizerLargeIntegerTests.authorizer_cbNrÁ r r r r rÄ s rÄ c
C sJ t td¡} t td¡}t t¡}t | ||t t¡t t¡t t¡f¡S )NZCheck) r Z makeSuiterL r˜ r¯ Z TestSuiter¿ r rÄ )Zfunction_suiteZaggregate_suiteZauthorizer_suiter r r Úsuite s
úrÅ c C s t ¡ } | tƒ ¡ d S r )r ZTextTestRunnerÚrunrÅ )Zrunnerr r r Útest s rÇ Ú__main__)'r Z
unittest.mockZsqlite3rP r r r r r r r r r r r r! r" r& r' r* r+ r5 r9 r; r< r= rE rF rH ZTestCaserL r˜ r¯ r¿ r rÄ rÅ rÇ r2 r r r r Ú sL
>z$