| Server IP : 118.27.122.248 / Your IP : 216.73.216.164 Web Server : Apache System : Linux web0264.sh.tyo1 4.18.0-553.79.1.lve.el7h.x86_64 #1 SMP Wed Oct 15 16:34:46 UTC 2025 x86_64 User : c9415830 ( 11735) PHP Version : 8.4.17 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /opt/alt/python36/lib64/python3.6/sqlite3/test/__pycache__/ |
Upload File : |
3
x2_; � @ s� d dl Z d dlZdd� Zdd� Zdd� Zdd � Zd
d � Zd d
� Zdd� Z dd� Z
dd� Z dd� Z dd� Z
dd� Zdd� 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 d.d/� d/�ZG d0d1� d1e j�ZG d2d3� d3e j�Z G d4d5� d5e j�Z G d6d7� d7e �Z G d8d9� d9e �Z G d:d;� d;e �Z d<d=� Z!d>d?� Z"e#d@k�r~e"� dS )A� Nc C s dS )N�foo� r r r �?/opt/alt/python36/lib64/python3.6/sqlite3/test/userfunctions.py�func_returntext 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 )Ng ��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 )Ns blobr r r r r �func_returnblob& s r c C s dS )N� � l 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 | �tkS )N)�type�str)�vr r r �
func_isstring- s r c C s t | �tkS )N)r �int)r r r r �
func_isint/ s r c C s t | �tkS )N)r �float)r r r r � func_isfloat1 s r c C s t | �t d �kS )N)r )r r r r � func_isnone3 s r c C s t | ttf�S )N)�
isinstance�bytes�
memoryview)r r r r � func_isblob5 s r c C s t | t�o| dkS )Nr
r l )r r )r r r r �func_islonglong7 s r c G s t | �S )N)�len)�argsr r r �func: s r" c @ s e Zd Zdd� Zdd� ZdS )�
AggrNoStepc C s d S )Nr )�selfr r r �__init__> s zAggrNoStep.__init__c C s dS )Nr
r )r$ r r r �finalizeA s zAggrNoStep.finalizeN)�__name__�
__module__� __qualname__r% r& r r r r r# = s r# c @ s e Zd Zdd� Zdd� ZdS )�AggrNoFinalizec C s d S )Nr )r$ r r r r% E s zAggrNoFinalize.__init__c C s d S )Nr )r$ �xr r r �stepH s zAggrNoFinalize.stepN)r' r( r) r% r, r r r r r* D s r* c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�AggrExceptionInInitc C s dd d S )Nr r r )r$ r r r r% L s z AggrExceptionInInit.__init__c C s d S )Nr )r$ r+ r r r r, O s zAggrExceptionInInit.stepc C s d S )Nr )r$ r r r r& R s z AggrExceptionInInit.finalizeN)r' r( r) r% r, r& r r r r r- K s r- c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�AggrExceptionInStepc C s d S )Nr )r$ r r r r% V s z AggrExceptionInStep.__init__c C s dd d S )Nr r r )r$ r+ r r r r, Y s zAggrExceptionInStep.stepc C s dS )Nr r )r$ r r r r& \ s z AggrExceptionInStep.finalizeN)r' r( r) r% r, r& r r r r r. U s r. c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�AggrExceptionInFinalizec C s d S )Nr )r$ r r r r% ` s z AggrExceptionInFinalize.__init__c C s d S )Nr )r$ r+ r r r r, c s z AggrExceptionInFinalize.stepc C s dd d S )Nr r r )r$ r r r r& f s z AggrExceptionInFinalize.finalizeN)r' r( r) r% r, r& r r r r r/ _ s r/ c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�
AggrCheckTypec C s
d | _ d S )N)�val)r$ r r r r% j s zAggrCheckType.__init__c C s. t tttd �td�}t|| t|�k�| _d S )N)r r r �None�blob)r r r r r r1 )r$ � whichTyper1 �theTyper r r r, m s zAggrCheckType.stepc C s | j S )N)r1 )r$ r r r r& r s zAggrCheckType.finalizeN)r' r( r) r% r, r& r r r r r0 i s r0 c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�AggrCheckTypesc C s
d| _ d S )Nr )r1 )r$ r r r r% v s zAggrCheckTypes.__init__c G sD t tttd �td�}x*|D ]"}| jt|| t|�k�7 _qW d S )N)r r r r2 r3 )r r r r r r1 )r$ r4 �valsr5 r1 r r r r, y s
zAggrCheckTypes.stepc C s | j S )N)r1 )r$ r r r r& s zAggrCheckTypes.finalizeN)r' r( r) r% r, r& r r r r r6 u s r6 c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�AggrSumc C s
d| _ d S )Ng )r1 )r$ r r r r% � s zAggrSum.__init__c C s | j |7 _ d S )N)r1 )r$ r1 r r r r, � s z AggrSum.stepc C s | j S )N)r1 )r$ r r r r& � s zAggrSum.finalizeN)r' r( r) r% r, r& r r r r r8 � s r8 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'S )(�
FunctionTestsc C s t jd�| _| jjddt� | jjddt� | jjddt� | jjddt� | jjddt� | jjddt � | jjd dt
� | jjd
dt � | jjd d t � | jjd
d t
� | jjdd t� | jjdd t� | jjdd t� | jjdd t� | jjddt� d S )Nz:memory:Z
returntextr Z
returnunicodeZ returnintZ returnfloatZ
returnnullZ
returnblobZreturnlonglongZraiseexception�isstringr
ZisintZisfloatZisnoneZisblobZ
islonglongZspam���)�sqlite�connect�con�create_functionr r r r
r r r r r r r r r r r" )r$ r r r �setUp� s zFunctionTests.setUpc C s | j j� d S )N)r> �close)r$ r r r �tearDown� s zFunctionTests.tearDownc C s0 | j tj�� | jjdddd� � W d Q R X d S )N�bla�d c S s d| S )N� r )r+ r r r �<lambda>� s z6FunctionTests.CheckFuncErrorOnCreate.<locals>.<lambda>i����)� assertRaisesr< �OperationalErrorr> r? )r$ r r r �CheckFuncErrorOnCreate� s z$FunctionTests.CheckFuncErrorOnCreatec C s@ dd� }|� }|t � d< | jjdd|� | jj� }|jd� d S )Nc S s dd� } | S )Nc S s dS )Nr
r r r r r �f� s z;FunctionTests.CheckFuncRefCount.<locals>.getfunc.<locals>.fr )rJ r r r �getfunc� s z0FunctionTests.CheckFuncRefCount.<locals>.getfuncr Zreftestr zselect reftest())�globalsr> r? �cursor�execute)r$ rK rJ �curr r r �CheckFuncRefCount� s
z FunctionTests.CheckFuncRefCountc C s@ | j j� }|jd� |j� d }| jt|�t� | j|d� d S )Nzselect returntext()r r )r> rM rN �fetchone� assertEqualr r )r$ rO r1 r r r �CheckFuncReturnText� s
z!FunctionTests.CheckFuncReturnTextc C s@ | j j� }|jd� |j� d }| jt|�t� | j|d� d S )Nzselect returnunicode()r r )r> rM rN rQ rR r r )r$ rO r1 r r r �CheckFuncReturnUnicode� s
z$FunctionTests.CheckFuncReturnUnicodec C s@ | j j� }|jd� |j� d }| jt|�t� | j|d� d S )Nzselect returnint()r r )r> rM rN rQ rR r r )r$ rO r1 r r r �CheckFuncReturnInt� s
z FunctionTests.CheckFuncReturnIntc C sN | j j� }|jd� |j� d }| jt|�t� |dk s@|dkrJ| jd� d S )Nzselect returnfloat()r g�&1� @gT㥛� @z wrong value)r> rM rN rQ rR r r Zfail)r$ rO r1 r r r �CheckFuncReturnFloat� s
z"FunctionTests.CheckFuncReturnFloatc C sD | j j� }|jd� |j� d }| jt|�td �� | j|d � d S )Nzselect returnnull()r )r> rM rN rQ rR r )r$ rO r1 r r r �CheckFuncReturnNull� s
z!FunctionTests.CheckFuncReturnNullc C s@ | j j� }|jd� |j� d }| jt|�t� | j|d� d S )Nzselect returnblob()r s blob)r> rM rN rQ rR r r )r$ rO r1 r r r �CheckFuncReturnBlob� s
z!FunctionTests.CheckFuncReturnBlobc C s0 | j j� }|jd� |j� d }| j|d� d S )Nzselect returnlonglong()r r
r l )r> rM rN rQ rR )r$ rO r1 r r r �CheckFuncReturnLongLong� s
z%FunctionTests.CheckFuncReturnLongLongc
C sJ | j j� }| jtj��}|jd� |j� W d Q R X | jt|j �d� d S )Nzselect raiseexception()z&user-defined function raised exception)
r> rM rG r< rH rN rQ rR r � exception)r$ rO �cmr r r �CheckFuncException� s
z FunctionTests.CheckFuncExceptionc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect isstring(?)r r r
)r )r> rM rN rQ rR )r$ rO r1 r r r �CheckParamString� s
z FunctionTests.CheckParamStringc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect isint(?)r r r
)r )r> rM rN rQ rR )r$ rO r1 r r r �
CheckParamInt� s
zFunctionTests.CheckParamIntc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect isfloat(?)� ��Q� @r r
)r_ )r> rM rN rQ rR )r$ rO r1 r r r �CheckParamFloat� s
z FunctionTests.CheckParamFloatc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect isnone(?)r r
)N)r> rM rN rQ rR )r$ rO r1 r r r �CheckParamNone� s
z FunctionTests.CheckParamNonec C s8 | j j� }|jdtd�f� |j� d }| j|d� d S )Nzselect isblob(?)s blobr r
)r> rM rN r rQ rR )r$ rO r1 r r r �CheckParamBlob s
z FunctionTests.CheckParamBlobc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect islonglong(?)r
r r � )rc )r> rM rN rQ rR )r$ rO r1 r r r �CheckParamLongLong
s
z FunctionTests.CheckParamLongLongc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect spam(?, ?)r
rE r )r
rE )r> rM rN rQ rR )r$ rO r1 r r r �CheckAnyArguments s
z FunctionTests.CheckAnyArgumentsN)r' r( r) r@ rB rI rP rS rT rU rV rW rX rY r\ r] r^ r` ra rb rd re r r r r r9 � s& r9 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 S ) �AggregateTestsc C s� t jd�| _| jj� }|jd� |jddddd td�f� | jjdd t� | jjd
d t� | jjd d t � | jjd d t
� | jjd
d t � | jjddt � | jjddt
� | jjdd t� d S )Nz:memory:z�
create table test(
t text,
i integer,
f float,
n,
b blob
)
z6insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)r r g ��Q� @s blobZnostepr
Z
nofinalizeZexcInitZexcStepZ excFinalizeZ checkTyperE Z
checkTypesZmysumr; )r< r= r> rM rN r Zcreate_aggregater# r* r- r. r/ r0 r6 r8 )r$ rO r r r r@ s
zAggregateTests.setUpc C s d S )Nr )r$ r r r rB 0 s zAggregateTests.tearDownc C s, | j tj�� | jjddt� W d Q R X d S )NrC rD i����)rG r< rH r> r? r8 )r$ r r r �CheckAggrErrorOnCreate5 s z%AggregateTests.CheckAggrErrorOnCreatec
C s@ | j j� }| jt��}|jd� W d Q R X | jt|j�d� d S )Nzselect nostep(t) from testz+'AggrNoStep' object has no attribute 'step')r> rM rG �AttributeErrorrN rR r rZ )r$ rO r[ r r r �CheckAggrNoStep9 s
z AggregateTests.CheckAggrNoStepc
C sN | j j� }| jtj�� }|jd� |j� d }W d Q R X | jt|j �d� d S )Nz select nofinalize(t) from testr z7user-defined aggregate's 'finalize' method raised error)
r> rM rG r< rH rN rQ rR r rZ )r$ rO r[ r1 r r r �CheckAggrNoFinalize? s
z"AggregateTests.CheckAggrNoFinalizec
C sN | j j� }| jtj�� }|jd� |j� d }W d Q R X | jt|j �d� d S )Nzselect excInit(t) from testr z7user-defined aggregate's '__init__' method raised error)
r> rM rG r< rH rN rQ rR r rZ )r$ rO r[ r1 r r r �CheckAggrExceptionInInitF s
z'AggregateTests.CheckAggrExceptionInInitc
C sN | j j� }| jtj�� }|jd� |j� d }W d Q R X | jt|j �d� d S )Nzselect excStep(t) from testr z3user-defined aggregate's 'step' method raised error)
r> rM rG r< rH rN rQ rR r rZ )r$ rO r[ r1 r r r �CheckAggrExceptionInStepM s
z'AggregateTests.CheckAggrExceptionInStepc
C sN | j j� }| jtj�� }|jd� |j� d }W d Q R X | jt|j �d� d S )Nz select excFinalize(t) from testr z7user-defined aggregate's 'finalize' method raised error)
r> rM rG r< rH rN rQ rR r rZ )r$ rO r[ r1 r r r � CheckAggrExceptionInFinalizeT s
z+AggregateTests.CheckAggrExceptionInFinalizec C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect checkType('str', ?)r r r
)r )r> rM rN rQ rR )r$ rO r1 r r r �CheckAggrCheckParamStr[ s
z%AggregateTests.CheckAggrCheckParamStrc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect checkType('int', ?)r r r
)r )r> rM rN rQ rR )r$ rO r1 r r r �CheckAggrCheckParamInta s
z%AggregateTests.CheckAggrCheckParamIntc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nz select checkTypes('int', ?, ?)r � r rE )r rp )r> rM rN rQ rR )r$ rO r1 r r r �CheckAggrCheckParamsIntg s
z&AggregateTests.CheckAggrCheckParamsIntc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nz select checkType('float', ?)� ��Q� @r r
)rr )r> rM rN rQ rR )r$ rO r1 r r r �CheckAggrCheckParamFloatm s
z'AggregateTests.CheckAggrCheckParamFloatc C s2 | j j� }|jdd� |j� d }| j|d� d S )Nzselect checkType('None', ?)r r
)N)r> rM rN rQ rR )r$ rO r1 r r r �CheckAggrCheckParamNones s
z&AggregateTests.CheckAggrCheckParamNonec C s8 | j j� }|jdtd�f� |j� d }| j|d� d S )Nzselect checkType('blob', ?)s blobr r
)r> rM rN r rQ rR )r$ rO r1 r r r �CheckAggrCheckParamBloby s
z&AggregateTests.CheckAggrCheckParamBlobc C sL | j j� }|jd� |jdd d
d g� |jd� |j� d }| j|d� d S ) Nzdelete from testz insert into test(i) values (?)�
� � zselect mysum(i) from testr �< )rv )rw )rx )r> rM rN Z executemanyrQ rR )r$ rO r1 r r r �CheckAggrCheckAggrSum s
z$AggregateTests.CheckAggrCheckAggrSumN)r' r( r) r@ rB rg ri rj rk rl rm rn ro rq rs rt ru rz r r r r rf s rf 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)r< �
SQLITE_SELECTZ SQLITE_DENY� SQLITE_OK)�action�arg1�arg2�dbname�sourcer r r �
authorizer_cb� s
z AuthorizerTests.authorizer_cbc C s6 t jd�| _| jjd� | jjd� | jj| j� d S )Nz:memory: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)r< r= r> Z
executescriptrN Zset_authorizerr� )r$ r r r r@ � s
zAuthorizerTests.setUpc C s d S )Nr )r$ r r r rB � s zAuthorizerTests.tearDownc C s: | j tj��}| jjd� W d Q R X | jdt|j�� d S )Nzselect * from t2�
prohibited)rG r< �
DatabaseErrorr> rN �assertInr rZ )r$ r[ r r r �test_table_access� s z!AuthorizerTests.test_table_accessc C s: | j tj��}| jjd� W d Q R X | jdt|j�� d S )Nzselect c2 from t1r� )rG r< r� r> rN r� r rZ )r$ r[ r r r �test_column_access� s z"AuthorizerTests.test_column_accessN) r' r( r) � staticmethodr� r@ rB 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 )Nr| r} )r< r~ �
ValueErrorr )r� r� r� r� r� r r r r� � s
z+AuthorizerRaiseExceptionTests.authorizer_cbN)r' r( r) 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 )Ng r| r} )r< r~ r )r� r� r� r� r� r r r r� � s
z(AuthorizerIllegalTypeTests.authorizer_cbN)r' r( r) r� r� r r r r r� � s r� c @ s e Zd Zedd� �ZdS )�AuthorizerLargeIntegerTestsc C s( | t jkrdS |dks |dkr"dS t jS )NrE � r| r} l l )r< r~ r )r� r� r� r� r� r r r r� � s
z)AuthorizerLargeIntegerTests.authorizer_cbN)r' r( r) r� r� r r r r r� � s r� c C sJ t jtd�} t jtd�}t jt�}t j| ||t jt�t jt�t jt�f�S )NZCheck) �unittestZ makeSuiter9 rf r{ Z TestSuiter� r� r� )Zfunction_suiteZaggregate_suiteZauthorizer_suiter r r �suite� s
r� c C s t j� } | jt� � d S )N)r� ZTextTestRunnerZrunr� )Zrunnerr r r �test� s r� �__main__)$r� Zsqlite3r< r r r r
r r r r r r r r r r r" r# r* r- r. r/ r0 r6 r8 ZTestCaser9 rf r{ r� r� r� r� r� r' r r r r �<module> sF
p$