Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/sqlite3/test/__pycache__/userfunctions.cpython-39.pyc
Ðазад
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"G d>d?� d?e �Z#d@dA� Z$dBdC� Z%e&dDk�r�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 �<lambda>� � z6FunctionTests.CheckFuncErrorOnCreate.<locals>.<lambda>)� 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.<locals>.getfunc.<locals>.fr )r` r r r �getfunc� s z0FunctionTests.CheckFuncRefCount.<locals>.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|d��6 |�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|d��6 |�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 �<module> sL >z$
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка