Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/sqlite3/test/__pycache__/dbapi.cpython-39.pyc
Ðазад
a c�h�� � @ s& d dl Z d dlZd dlZd dlZd dlZd dlmZmZm Z G dd� dej �Z G dd� dej �Z G dd� dej �Z G d d � d ej �ZG d d � d ej �ZG d d� dej �ZG dd� dej �ZG dd� dej �ZG dd� dej �ZG dd� dej �ZG dd� dej �Zdd� Zdd � Zed k�r"e� dS ) � N)� SHORT_TIMEOUT�TESTFN�unlinkc @ st e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z dd� Z dd� Z dd� Z dd� Zdd� ZdS ) � ModuleTestsc C s | � tjddtj � d S )Nz2.0z apilevel is %s, should be 2.0)� assertEqual�sqliteZapilevel��self� r �3/opt/imh-python/lib/python3.9/sqlite3/test/dbapi.py� CheckAPILevel" s �zModuleTests.CheckAPILevelc C s | � tjddtj � d S )N� z threadsafety is %d, should be 1)r r Z threadsafetyr r r r �CheckThreadSafety& s �z ModuleTests.CheckThreadSafetyc C s | � tjddtj � d S )NZqmarkz%paramstyle is '%s', should be 'qmark')r r Z paramstyler r r r �CheckParamStyle* s ��zModuleTests.CheckParamStylec C s | � ttjt�d� d S )Nz&Warning is not a subclass of Exception)� assertTrue� issubclassr �Warning� Exceptionr r r r � CheckWarning/ s �zModuleTests.CheckWarningc C s | � ttjt�d� d S )Nz$Error is not a subclass of Exception)r r r �Errorr r r r r � CheckError3 s �zModuleTests.CheckErrorc C s | � ttjtj�d� d S )Nz)InterfaceError is not a subclass of Error)r r r �InterfaceErrorr r r r r �CheckInterfaceError7 s �z ModuleTests.CheckInterfaceErrorc C s | � ttjtj�d� d S )Nz(DatabaseError is not a subclass of Error)r r r � DatabaseErrorr r r r r �CheckDatabaseError; s �z ModuleTests.CheckDatabaseErrorc C s | � ttjtj�d� d S )Nz,DataError is not a subclass of DatabaseError)r r r � DataErrorr r r r r �CheckDataError? s �zModuleTests.CheckDataErrorc C s | � ttjtj�d� d S )Nz3OperationalError is not a subclass of DatabaseError)r r r �OperationalErrorr r r r r �CheckOperationalErrorC s �z!ModuleTests.CheckOperationalErrorc C s | � ttjtj�d� d S )Nz1IntegrityError is not a subclass of DatabaseError)r r r �IntegrityErrorr r r r r �CheckIntegrityErrorG s �z ModuleTests.CheckIntegrityErrorc C s | � ttjtj�d� d S )Nz0InternalError is not a subclass of DatabaseError)r r r � InternalErrorr r r r r �CheckInternalErrorK s �z ModuleTests.CheckInternalErrorc C s | � ttjtj�d� d S )Nz3ProgrammingError is not a subclass of DatabaseError)r r r �ProgrammingErrorr r r r r �CheckProgrammingErrorO s �z!ModuleTests.CheckProgrammingErrorc C s | � ttjtj�d� d S )Nz4NotSupportedError is not a subclass of DatabaseError)r r r �NotSupportedErrorr r r r r �CheckNotSupportedErrorS s ��z"ModuleTests.CheckNotSupportedErrorN)�__name__� __module__� __qualname__r r r r r r r r r r r" r$ r& r r r r r ! s r 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 � Ze�ejd kd �d d � �Zd!S )"�ConnectionTestsc C s0 t �d�| _| j�� }|�d� |�dd� d S )N�:memory:z4create table test(id integer primary key, name text)�!insert into test(name) values (?)��foo)r �connect�cx�cursor�execute�r �cur r r �setUpZ s zConnectionTests.setUpc C s | j �� d S �N�r0 �closer r r r �tearDown` s zConnectionTests.tearDownc C s | j �� d S r6 �r0 �commitr r r r � CheckCommitc s zConnectionTests.CheckCommitc C s | j �� | j �� dS )zV A commit should also work when no changes were made to the database. Nr: r r r r �CheckCommitAfterNoChangesf s z)ConnectionTests.CheckCommitAfterNoChangesc C s | j �� d S r6 �r0 �rollbackr r r r � CheckRollbackm s z ConnectionTests.CheckRollbackc C s | j �� | j �� dS )zX A rollback should also work when no changes were made to the database. Nr> r r r r �CheckRollbackAfterNoChangesp s z+ConnectionTests.CheckRollbackAfterNoChangesc C s | j �� }d S r6 �r0 r1 r3 r r r � CheckCursorw s zConnectionTests.CheckCursorc C s> d}| � tj�� t�|�}W d � n1 s00 Y d S )Nz/foo/bar/bla/23534/mydb.db)� assertRaisesr r r/ )r ZYOU_CANNOT_OPEN_THIS�conr r r �CheckFailedOpenz s z ConnectionTests.CheckFailedOpenc C s | j �� d S r6 r7 r r r r � CheckClose s zConnectionTests.CheckClosec C s� | � | jjtj� | � | jjtj� | � | jjtj� | � | jjtj� | � | jjtj� | � | jjtj� | � | jj tj � | � | jj tj � | � | jj tj � | � | jj tj � d S r6 ) r r0 r r r r r r r r r! r# r% r r r r �CheckExceptions� s z ConnectionTests.CheckExceptionsc C s� t �d�}|�� }| �|jd� |�d� | �|jd� |�dd� | �|jd� |�ddg� |�� }| �|jd� |�� | �|jd� |�ddg� |�� }| �|jd� d S ) Nr+ Fz?create table transactiontest(id integer primary key, name text)z,insert into transactiontest(name) values (?)r- Tz-select name from transactiontest where name=?r. )r r/ r1 r �in_transactionr2 �fetchoner; )r r0 r4 �rowr r r �CheckInTransaction� s z"ConnectionTests.CheckInTransactionc C s6 | � t�� d| j_W d � n1 s(0 Y d S )NT)rD �AttributeErrorr0 rI r r r r �CheckInTransactionRO� s z$ConnectionTests.CheckInTransactionROc C sX | � tt� G dd� d�}|� }t�|��}|�d� W d � n1 sJ0 Y dS )z| Checks that we can successfully connect to a database using an object that is PathLike, i.e. has __fspath__(). c @ s e Zd Zdd� ZdS )z9ConnectionTests.CheckOpenWithPathLikeObject.<locals>.Pathc S s t S r6 )r r r r r � __fspath__� s zDConnectionTests.CheckOpenWithPathLikeObject.<locals>.Path.__fspath__N)r' r( r) rO r r r r �Path� s rP � create table test(id integer)N)� addCleanupr r r r/ r2 )r rP �pathr0 r r r �CheckOpenWithPathLikeObject� s z+ConnectionTests.CheckOpenWithPathLikeObjectc C s8 t jdk rH| �t j�� t jddd� W d � n1 s:0 Y d S | �tt� t �t��}|�d� W d � n1 s~0 Y t jdt dd��}|�d� W d � n1 s�0 Y t jdt d dd��H}| �t j �� |�d � W d � n1 �s 0 Y W d � n1 �s*0 Y d S ) N)� � rV r+ T)ZurirQ zfile:z insert into test(id) values(0)z?mode=roz insert into test(id) values(1)) r �sqlite_version_inforD r% r/ rR r r r2 r )r r0 r r r � CheckOpenUri� s , ((z ConnectionTests.CheckOpenUri)rU rU r z&needs sqlite versions older than 3.3.1c C sP | � tj�� }tjddd� W d � n1 s00 Y | �t|j�d� d S )Nr+ F)Zcheck_same_threadz shared connections not available)rD r r% r/ r �str� exception�r �cmr r r � CheckSameThreadErrorOnOldVersion� s ,z0ConnectionTests.CheckSameThreadErrorOnOldVersionN)r' r( r) r5 r9 r< r= r@ rA rC rF rG rH rL rN rT rX �unittestZskipIfr rW r] r r r r r* X s$ �r* c @ s e Zd Zdd� Zdd� ZdS )� UninitialisedConnectionTestsc C s t j�t j�| _d S r6 )r � Connection�__new__r0 r r r r r5 � s z"UninitialisedConnectionTests.setUpc s� � fdd�� fdd�� fdd�� fdd�� fdd�� fdd�f}|D ]@}� j |d�� � �tjd |� W d � qD1 sz0 Y qDd S ) Nc s � j jS r6 )r0 �isolation_levelr r r r �<lambda>� � zEUninitialisedConnectionTests.test_uninit_operations.<locals>.<lambda>c s � j jS r6 )r0 � total_changesr r r r rc � rd c s � j jS r6 )r0 rI r r r r rc � rd c s � j �� S r6 )r0 Ziterdumpr r r r rc � rd c s � j �� S r6 rB r r r r rc � rd c s � j �� S r6 r7 r r r r rc � rd )�funcz#Base Connection.__init__ not called)�subTestZassertRaisesRegexr r# )r Zfuncsrf r r r �test_uninit_operations� s ��z3UninitialisedConnectionTests.test_uninit_operationsN)r' r( r) r5 rh r r r r r_ � s r_ 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(� Zd)d*� Zd+d,� Zd-d.� Zd/d0� Zd1d2� Zd3d4� Z d5d6� Z d7d8� Z d9d:� Z d;d<� Z d=d>� Z!d?d@� Z"dAdB� Z#dCdD� Z$dEdF� Z%dGdH� Z&dIdJ� Z'dKdL� Z(dMdN� Z)dOdP� Z*dQdR� Z+dSdT� Z,dUdV� Z-dWdX� Z.dYdZ� Z/d[d\� Z0d]d^� Z1d_d`� Z2dadb� Z3dcdd� Z4dedf� Z5dgS )h� CursorTestsc C s6 t �d�| _| j�� | _| j�d� | j�dd� d S )Nr+ z\create table test(id integer primary key, name text, income number, unique_test text unique)r, r- �r r/ r0 r1 r4 r2 r r r r r5 � s �zCursorTests.setUpc C s | j �� | j�� d S r6 �r4 r8 r0 r r r r r9 � s zCursorTests.tearDownc C s | j �d� d S )N�delete from test�r4 r2 r r r r �CheckExecuteNoArgs� s z CursorTests.CheckExecuteNoArgsc C s< | � tj�� | j�d� W d � n1 s.0 Y d S )Nz select asdf)rD r r r4 r2 r r r r �CheckExecuteIllegalSql� s z"CursorTests.CheckExecuteIllegalSqlc C s< | � tj�� | j�d� W d � n1 s.0 Y d S )Nzselect 5+4; select 4+5)rD r r r4 r2 r r r r �CheckExecuteTooMuchSql� s z"CursorTests.CheckExecuteTooMuchSqlc C s | j �d� d S )Nzselect 5+4; -- foo barrm r r r r �CheckExecuteTooMuchSql2� s z#CursorTests.CheckExecuteTooMuchSql2c C s | j �d� d S )NzT select 5+4; /* foo */ rm r r r r �CheckExecuteTooMuchSql3� s z#CursorTests.CheckExecuteTooMuchSql3c C s: | � t�� | j�d� W d � n1 s,0 Y d S �N�* )rD � TypeErrorr4 r2 r r r r �CheckExecuteWrongSqlArg� s z#CursorTests.CheckExecuteWrongSqlArgc C s | j �dd� d S )N� insert into test(id) values (?))rt rm r r r r �CheckExecuteArgInt s z CursorTests.CheckExecuteArgIntc C s | j �dd� d S )N�#insert into test(income) values (?))gq= ף��@rm r r r r �CheckExecuteArgFloat s z CursorTests.CheckExecuteArgFloatc C s | j �dd� d S )Nr, )ZHugorm r r r r �CheckExecuteArgString s z!CursorTests.CheckExecuteArgStringc C s@ | j �dd� | j �d| j jf� | j �� }| �|d d� d S )Nr, )�Hu goz select name from test where id=?r r| )r4 r2 � lastrowidrJ r �r rK r r r �!CheckExecuteArgStringWithZeroByte s z-CursorTests.CheckExecuteArgStringWithZeroBytec C sN | � t�� }| j�dd� W d � n1 s.0 Y | �t|j�d� d S )Nrw rt z"parameters are of unsupported type)rD � ValueErrorr4 r2 r rY rZ r[ r r r �CheckExecuteNonIterable s ,z#CursorTests.CheckExecuteNonIterablec C s> | � tj�� | j�dd� W d � n1 s00 Y d S )Nrw )� ZEgon�rD r r# r4 r2 r r r r �CheckExecuteWrongNoOfArgs1 s z&CursorTests.CheckExecuteWrongNoOfArgs1c C s< | � tj�� | j�d� W d � n1 s.0 Y d S �Nrw r� r r r r �CheckExecuteWrongNoOfArgs2 s z&CursorTests.CheckExecuteWrongNoOfArgs2c C s< | � tj�� | j�d� W d � n1 s.0 Y d S r� r� r r r r �CheckExecuteWrongNoOfArgs3" s z&CursorTests.CheckExecuteWrongNoOfArgs3c C s: | j �d� | j �ddg� | j �� }| �|d d� d S )N�%insert into test(name) values ('foo')�"select name from test where name=?r. r �r4 r2 rJ r r~ r r r �CheckExecuteParamList' s z!CursorTests.CheckExecuteParamListc C sH G dd� d�}| j �d� | j �d|� � | j �� }| �|d d� d S )Nc @ s e Zd Zdd� Zdd� ZdS )z0CursorTests.CheckExecuteParamSequence.<locals>.Lc S s dS )Nr r r r r r �__len__/ s z8CursorTests.CheckExecuteParamSequence.<locals>.L.__len__c S s |dks J �dS )Nr r. r �r �xr r r � __getitem__1 s z<CursorTests.CheckExecuteParamSequence.<locals>.L.__getitem__N�r' r( r) r� r� r r r r �L. s r� r� r� r r. r� )r r� rK r r r �CheckExecuteParamSequence- s z%CursorTests.CheckExecuteParamSequencec C sX G dd� d�}| j �d� | �t�� | j �d|� � W d � n1 sJ0 Y d S )Nc @ s e Zd Zdd� Zdd� ZdS )z6CursorTests.CheckExecuteParamSequenceBadLen.<locals>.Lc S s dd d S )Nr r r r r r r r� = s z>CursorTests.CheckExecuteParamSequenceBadLen.<locals>.L.__len__c S s t �d S r6 )�AssertionError)Zslfr� r r r r� ? s zBCursorTests.CheckExecuteParamSequenceBadLen.<locals>.L.__getitem__Nr� r r r r r� < s r� r� r� )r4 r2 rD �ZeroDivisionError)r r� r r r � CheckExecuteParamSequenceBadLen: s z+CursorTests.CheckExecuteParamSequenceBadLenc C s< | j �d� | j �dddi� | j �� }| �|d d� d S )Nr� �&select name from test where name=:name�namer. r r� r~ r r r �CheckExecuteDictMappingF s z#CursorTests.CheckExecuteDictMappingc C sJ G dd� dt �}| j�d� | j�d|� � | j�� }| �|d d� d S )Nc @ s e Zd Zdd� ZdS )z6CursorTests.CheckExecuteDictMapping_Mapping.<locals>.Dc S s dS �Nr. r )r �keyr r r � __missing__N s zBCursorTests.CheckExecuteDictMapping_Mapping.<locals>.D.__missing__N)r' r( r) r� r r r r �DM s r� r� r� r r. )�dictr4 r2 rJ r )r r� rK r r r � CheckExecuteDictMapping_MappingL s z+CursorTests.CheckExecuteDictMapping_Mappingc C sN | j �d� | �tj��" | j �dddi� W d � n1 s@0 Y d S )Nr� z1select name from test where name=:name and id=:idr� r. �r4 r2 rD r r# r r r r �$CheckExecuteDictMappingTooLittleArgsV s z0CursorTests.CheckExecuteDictMappingTooLittleArgsc C sH | j �d� | �tj�� | j �d� W d � n1 s:0 Y d S )Nr� r� r� r r r r � CheckExecuteDictMappingNoArgs[ s z)CursorTests.CheckExecuteDictMappingNoArgsc C sN | j �d� | �tj��" | j �dddi� W d � n1 s@0 Y d S )Nr� r� r� r. r� r r r r � CheckExecuteDictMappingUnnamed` s z*CursorTests.CheckExecuteDictMappingUnnamedc C s | j �� d S r6 )r4 r8 r r r r rG e s zCursorTests.CheckClosec C sD | j �d� | j �d� | j �d� | j �d� | �| j jd� d S )Nrl r� zupdate test set name='bar'� �r4 r2 r �rowcountr r r r �CheckRowcountExecuteh s z CursorTests.CheckRowcountExecutec C s | j �d� | �| j jd� dS )z� pysqlite does not know the rowcount of SELECT statements, because we don't fetch all rows after executing the select statement. The rowcount has thus to be -1. zselect 5 union select 6���Nr� r r r r �CheckRowcountSelecto s z CursorTests.CheckRowcountSelectc C s2 | j �d� | j �dg d�� | �| j jd� d S )Nrl r, ))r )r� �rU rU )r4 r2 � executemanyr r� r r r r �CheckRowcountExecutemanyx s z$CursorTests.CheckRowcountExecutemanyc C s0 | j �d� | j �d� | jd| jjdd� d S )Nr� r� z"total changes reported wrong value)�msg)r4 r2 Z assertLessr0 re r r r r �CheckTotalChanges} s z CursorTests.CheckTotalChangesc C s" | j �ddd� tdd�D �� d S )Nry c S s g | ] }|f�qS r r )�.0r� r r r � <listcomp>� rd z8CursorTests.CheckExecuteManySequence.<locals>.<listcomp>�d �n )r4 r� �ranger r r r �CheckExecuteManySequence� s z$CursorTests.CheckExecuteManySequencec C s" G dd� d�}| j �d|� � d S )Nc @ s$ e Zd Zdd� Zdd� Zdd� ZdS )z4CursorTests.CheckExecuteManyIterator.<locals>.MyIterc S s d| _ d S �N� )�valuer r r r �__init__� s z=CursorTests.CheckExecuteManyIterator.<locals>.MyIter.__init__c S s | S r6 r r r r r �__iter__� s z=CursorTests.CheckExecuteManyIterator.<locals>.MyIter.__iter__c S s* | j dkrt�n| j d7 _ | j fS d S )N� r )r� � StopIterationr r r r �__next__� s z=CursorTests.CheckExecuteManyIterator.<locals>.MyIter.__next__N)r' r( r) r� r� r� r r r r �MyIter� s r� ry �r4 r� )r r� r r r �CheckExecuteManyIterator� s z$CursorTests.CheckExecuteManyIteratorc C s dd� }| j �d|� � d S )Nc s s t d�D ] } | fV qd S r� )r� )�ir r r �mygen� s z4CursorTests.CheckExecuteManyGenerator.<locals>.mygenry r� )r r� r r r �CheckExecuteManyGenerator� s z%CursorTests.CheckExecuteManyGeneratorc C s> | � t�� | j�ddg� W d � n1 s00 Y d S )Nrt r� �rD ru r4 r� r r r r �CheckExecuteManyWrongSqlArg� s z'CursorTests.CheckExecuteManyWrongSqlArgc C s@ | � tj�� | j�ddg� W d � n1 s20 Y d S )Nzselect ?r� )rD r r# r4 r� r r r r �CheckExecuteManySelect� s z"CursorTests.CheckExecuteManySelectc C s< | � t�� | j�dd� W d � n1 s.0 Y d S )Nry rt r� r r r r �CheckExecuteManyNotIterable� s z'CursorTests.CheckExecuteManyNotIterablec C sv | j �d� | j �dd� | j �dd� | j �d� g }| j D ]}|�|d � q>| �|d d� | �|d d � d S ) Nrl rw )r� )� z select id from test order by idr r� r r� )r4 r2 �appendr )r ZlstrK r r r �CheckFetchIter� s zCursorTests.CheckFetchIterc C s@ | j �d� | j �� }| �|d d� | j �� }| �|d � d S )N�select name from testr r. r� r~ r r r � CheckFetchone� s zCursorTests.CheckFetchonec C s" | j �� }|�� }| �|d � d S r6 )r0 r1 rJ r )r �currK r r r �CheckFetchoneNoStatement� s z$CursorTests.CheckFetchoneNoStatementc C sr | � | jjd� d| j_| j�d� | j�d� | j�d� | j�d� | j�d� | j�� }| � t|�d� d S )Nr r� rl z#insert into test(name) values ('A')z#insert into test(name) values ('B')z#insert into test(name) values ('C')r� )r r4 Z arraysizer2 � fetchmany�len�r �resr r r �CheckArraySize� s zCursorTests.CheckArraySizec C sD | j �d� | j �d�}| �t|�d� | j �d�}| �|g � d S )Nr� r� r �r4 r2 r� r r� r� r r r �CheckFetchmany� s zCursorTests.CheckFetchmanyc C s. | j �d� | j jdd�}| �t|�d� dS )z0Checks if fetchmany works with keyword argumentsr� r� )�sizer Nr� r� r r r �CheckFetchmanyKwArg� s z CursorTests.CheckFetchmanyKwArgc C s@ | j �d� | j �� }| �t|�d� | j �� }| �|g � d S )Nr� r )r4 r2 �fetchallr r� r� r r r � CheckFetchall� s zCursorTests.CheckFetchallc C s | j �g d�� d S )N)rU � r� )r4 Z setinputsizesr r r r �CheckSetinputsizes� s z CursorTests.CheckSetinputsizesc C s | j �dd� d S )Nr� r �r4 Z setoutputsizer r r r �CheckSetoutputsize� s z CursorTests.CheckSetoutputsizec C s | j �d� d S rs r� r r r r �CheckSetoutputsizeNoColumn� s z&CursorTests.CheckSetoutputsizeNoColumnc C s | � | jj| j� d S r6 )r r4 � connectionr0 r r r r �CheckCursorConnection� s z!CursorTests.CheckCursorConnectionc C sB | � t��$ dd� }| j�|�}W d � n1 s40 Y d S )Nc S s d S r6 r r r r r �f� rd z/CursorTests.CheckWrongCursorCallable.<locals>.f)rD ru r0 r1 )r r� r� r r r �CheckWrongCursorCallable� s z$CursorTests.CheckWrongCursorCallablec C sL G dd� d�}|� }| � t�� t�|�}W d � n1 s>0 Y d S )Nc @ s e Zd ZdS )z.CursorTests.CheckCursorWrongClass.<locals>.FooN)r' r( r) r r r r �Foo� rd r� )rD ru r ZCursor)r r� r. r� r r r �CheckCursorWrongClass� s z!CursorTests.CheckCursorWrongClassc C sb d}dD ]T}| j |d��4 | j�|�|�d� | �| jjd� W d � q1 sR0 Y qdS )zV INSERT OR REPLACE and REPLACE INTO should produce the same behavior. z+{} INTO test(id, unique_test) VALUES (?, ?))zINSERT OR REPLACEZREPLACE�� statement)r r. r N)rg r4 r2 �formatr r} )r �sqlr� r r r �CheckLastRowIDOnReplace s z#CursorTests.CheckLastRowIDOnReplacec C s@ | j �dd� | �| j jd� | j �dd� | �| j jd� d S )Nz2insert or ignore into test(unique_test) values (?))�testr� )r4 r2 r r} r r r r �CheckLastRowIDOnIgnore s ��z"CursorTests.CheckLastRowIDOnIgnorec C s� g }dD ]�}d}| j d�|�d��� | j�|�|�|f� |�|| jjf� | �tj��& | j�|�|�|f� W d � n1 s�0 Y |�|| jjf� W d � q1 s�0 Y qg d�}| � ||� d S )N)�FAIL�ABORT�ROLLBACKz.INSERT OR {} INTO test(unique_test) VALUES (?)z INSERT OR {}r� )�r� r� r� �r� rU r� �r� r� r� ) rg r� r4 r2 r� r} rD r r r )r �resultsr� r� Zexpectedr r r �CheckLastRowIDInsertOR s 42z"CursorTests.CheckLastRowIDInsertORN)6r' r( r) r5 r9 rn ro rp rq rr rv rx rz r{ r r� r� r� r� r� r� r� r� r� r� r� r� rG r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r ri � sf ri c @ s\ e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z dd� Z dd� Z dS )� ThreadTestsc C s( t �d�| _| j�� | _| j�d� d S )Nr+ z\create table test(id integer primary key, name text, bin binary, ratio number, ts timestamp))r r/ rE r1 r� r2 r r r r r5 ) s zThreadTests.setUpc C s | j �� | j�� d S r6 )r� r8 rE r r r r r9 . s zThreadTests.tearDownc C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sH z| � � }|�d� W d S tjy. Y d S |�d� Y n0 d S �N� did not raise ProgrammingError�raised wrong exception)r1 r� r r# )rE �errorsr� r r r �run3 s z'ThreadTests.CheckConCursor.<locals>.run�rE r� ��target�kwargsr � �� threading�ThreadrE �start�joinr� �fail�r r� r� �tr r r �CheckConCursor2 s zThreadTests.CheckConCursorc C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sH z| � � |�d� W d S tjy. Y d S |�d� Y n0 d S r� )r; r� r r# r� r r r r� E s z'ThreadTests.CheckConCommit.<locals>.runr� r� r r� r� r r r r �CheckConCommitD s zThreadTests.CheckConCommitc C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sH z| � � |�d� W d S tjy. Y d S |�d� Y n0 d S r� )r? r� r r# r� r r r r� W s z)ThreadTests.CheckConRollback.<locals>.runr� r� r r� r� r r r r �CheckConRollbackV s z ThreadTests.CheckConRollbackc C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sH z| � � |�d� W d S tjy. Y d S |�d� Y n0 d S r� �r8 r� r r# r� r r r r� i s z&ThreadTests.CheckConClose.<locals>.runr� r� r r� r� r r r r � CheckConCloseh s zThreadTests.CheckConClosec C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sJ z| � d� |�d� W d S tjy0 Y d S |�d� Y n0 d S )N�#insert into test(name) values ('a')r� r� �r2 r� r r# �r� r� r r r r� { s z.ThreadTests.CheckCurImplicitBegin.<locals>.runr r� r r� �r� r� r� r r r� r r r r r �CheckCurImplicitBeginz s z!ThreadTests.CheckCurImplicitBeginc C sR dd� }g }t j|| j|d�d�}|�� |�� t|�dkrN| �d�|�� d S )Nc S sH z| � � |�d� W d S tjy. Y d S |�d� Y n0 d S r� r r r r r r� � s z&ThreadTests.CheckCurClose.<locals>.runr r� r r� r r r r r � CheckCurClose� s zThreadTests.CheckCurClosec C s^ dd� }g }| j �d� tj|| j |d�d�}|�� |�� t|�dkrZ| �d�|�� d S )Nc S sJ z| � d� |�d� W d S tjy0 Y d S |�d� Y n0 d S )Nr� r� r� r r r r r r� � s z(ThreadTests.CheckCurExecute.<locals>.runr r r� r r� �r� r2 r� r� r r r� r r r r r �CheckCurExecute� s zThreadTests.CheckCurExecutec C sj dd� }g }| j �d� | j �d� tj|| j |d�d�}|�� |�� t|�dkrf| �d�|�� d S ) Nc S sH z| � � }|�d� W d S tjy. Y d S |�d� Y n0 d S r� )rJ r� r r# )r� r� rK r r r r� � s z)ThreadTests.CheckCurIterNext.<locals>.runr r� r r� r r� r r r r r �CheckCurIterNext� s z ThreadTests.CheckCurIterNextN) r' r( r) r5 r9 r r r r r r r r r r r r r� ( s r� c @ sD e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dS )�ConstructorTestsc C s t �ddd�}d S )N�� r� � )r ZDate�r �dr r r � CheckDate� s zConstructorTests.CheckDatec C s t �ddd�}d S )N� �' �# )r ZTime�r r r r r � CheckTime� s zConstructorTests.CheckTimec C s t �dddddd�}d S )Nr r� r r r r )r Z Timestamp�r �tsr r r �CheckTimestamp� s z ConstructorTests.CheckTimestampc C s t �d�}d S rs )r Z DateFromTicksr r r r �CheckDateFromTicks� s z#ConstructorTests.CheckDateFromTicksc C s t �d�}d S rs )r Z TimeFromTicksr r r r �CheckTimeFromTicks� s z#ConstructorTests.CheckTimeFromTicksc C s t �d�}d S rs )r ZTimestampFromTicksr r r r �CheckTimestampFromTicks� s z(ConstructorTests.CheckTimestampFromTicksc C s t �d�}d S )Ns ')r ZBinary)r �br r r � CheckBinary� s z ConstructorTests.CheckBinaryN) r' r( r) r r r r! r" r# r% r r r r r � s r c @ sD e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dS )�ExtensionTestsc C sB t �d�}|�� }|�d� |�d� |�� d }| �|d� d S )Nr+ z� -- bla bla /* a stupid comment */ create table a(i); insert into a(i) values (5); zselect i from ar r� )r r/ r1 � executescriptr2 rJ r )r rE r� r� r r r �CheckScriptStringSql� s z#ExtensionTests.CheckScriptStringSqlc C sL t �d�}|�� }| �t j�� |�d� W d � n1 s>0 Y d S )Nr+ z1create table test(x); asdf; create table test2(x)�r r/ r1 rD r r' �r rE r� r r r �CheckScriptSyntaxError� s z%ExtensionTests.CheckScriptSyntaxErrorc C sL t �d�}|�� }| �t j�� |�d� W d � n1 s>0 Y d S )Nr+ z5create table test(sadfsadfdsa); select foo from hurz;r) r* r r r �CheckScriptErrorNormal� s z%ExtensionTests.CheckScriptErrorNormalc C s\ t �d�}|�� }| �t��}|�d� W d � n1 s<0 Y | �t|j�d� d S )Nr+ s9 create table test(foo); insert into test(foo) values (5);z script argument must be unicode.) r r/ r1 rD r� r' r rY rZ )r rE r� r\ r r r � CheckCursorExecutescriptAsBytes� s (z.ExtensionTests.CheckCursorExecutescriptAsBytesc C s. t �d�}|�d��� d }| �|dd� d S )Nr+ zselect 5r r� z Basic test of Connection.execute)r r/ r2 rJ r �r rE �resultr r r �CheckConnectionExecute� s z%ExtensionTests.CheckConnectionExecutec C sb t �d�}|�d� |�dddg� |�d��� }| �|d d dd � | �|d d d d � d S ) Nr+ zcreate table test(foo)z insert into test(foo) values (?)r� �r� z!select foo from test order by foor rU z$Basic test of Connection.executemanyr r� )r r/ r2 r� r� r r. r r r �CheckConnectionExecutemany s z)ExtensionTests.CheckConnectionExecutemanyc C s8 t �d�}|�d� |�d��� d }| �|dd� d S )Nr+ z9create table test(foo); insert into test(foo) values (5);zselect foo from testr r� z&Basic test of Connection.executescript)r r/ r' r2 rJ r r. r r r � CheckConnectionExecutescript s z+ExtensionTests.CheckConnectionExecutescriptN) r' r( r) r( r+ r, r- r0 r2 r3 r r r r r& � s r& c @ sT e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z dd� Z dS )�ClosedConTestsc C sJ t �d�}|�� | �t j�� |�� }W d � n1 s<0 Y d S �Nr+ )r r/ r8 rD r# r1 r* r r r �CheckClosedConCursor s z#ClosedConTests.CheckClosedConCursorc C sJ t �d�}|�� | �t j�� |�� W d � n1 s<0 Y d S r5 )r r/ r8 rD r# r; �r rE r r r �CheckClosedConCommit s z#ClosedConTests.CheckClosedConCommitc C sJ t �d�}|�� | �t j�� |�� W d � n1 s<0 Y d S r5 )r r/ r8 rD r# r? r7 r r r �CheckClosedConRollback s z%ClosedConTests.CheckClosedConRollbackc C sT t �d�}|�� }|�� | �t j�� |�d� W d � n1 sF0 Y d S )Nr+ zselect 4)r r/ r1 r8 rD r# r2 r* r r r �CheckClosedCurExecute" s z$ClosedConTests.CheckClosedCurExecutec C sX t �d�}|�� dd� }| �t j�� |�dd|� W d � n1 sJ0 Y d S )Nr+ c S s dS �Nr� r )r� r r r r� , rd z3ClosedConTests.CheckClosedCreateFunction.<locals>.fr. r )r r/ r8 rD r# Zcreate_function)r rE r� r r r �CheckClosedCreateFunction) s z(ClosedConTests.CheckClosedCreateFunctionc C s^ t �d�}|�� G dd� d�}| �t j�� |�dd|� W d � n1 sP0 Y d S )Nr+ c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )z6ClosedConTests.CheckClosedCreateAggregate.<locals>.Aggc S s d S r6 r r r r r r� 4 s z?ClosedConTests.CheckClosedCreateAggregate.<locals>.Agg.__init__c S s d S r6 r r� r r r �step6 s z;ClosedConTests.CheckClosedCreateAggregate.<locals>.Agg.stepc S s dS r; r r r r r �finalize8 s z?ClosedConTests.CheckClosedCreateAggregate.<locals>.Agg.finalizeN)r' r( r) r� r= r> r r r r �Agg3 s r? r. r )r r/ r8 rD r# Zcreate_aggregate)r rE r? r r r �CheckClosedCreateAggregate0 s z)ClosedConTests.CheckClosedCreateAggregatec C sT t �d�}|�� dd� }| �t j�� |�|� W d � n1 sF0 Y d S )Nr+ c W s t jS r6 )r ZDENY)�argsr r r � authorizer@ s z;ClosedConTests.CheckClosedSetAuthorizer.<locals>.authorizer)r r/ r8 rD r# Zset_authorizer)r rE rB r r r �CheckClosedSetAuthorizer= s z'ClosedConTests.CheckClosedSetAuthorizerc C sV t �d�}|�� dd� }| �t j�� |�|d� W d � n1 sH0 Y d S )Nr+ c S s d S r6 r r r r r �progressH rd z?ClosedConTests.CheckClosedSetProgressCallback.<locals>.progressr� )r r/ r8 rD r# Zset_progress_handler)r rE rD r r r � CheckClosedSetProgressCallbackE s z-ClosedConTests.CheckClosedSetProgressCallbackc C sH t �d�}|�� | �t j�� |� W d � n1 s:0 Y d S r5 )r r/ r8 rD r# r7 r r r �CheckClosedCallL s z ClosedConTests.CheckClosedCallN) r' r( r) r6 r8 r9 r: r< r@ rC rE rF r r r r r4 s r4 c @ s e Zd Zdd� ZdS )�ClosedCurTestsc C s� t �d�}|�� }|�� dD ]j}|dv r0d}n|dkrFdddgf}ng }| �t j��" t||�}||� W d � q 1 s~0 Y q d S ) Nr+ )r2 r� r' r� r� rJ )r2 r' )zselect 4 union select 5r� z insert into foo(bar) values (?)r� r1 )r r/ r1 r8 rD r# �getattr)r rE r� Z method_name�params�methodr r r � CheckClosedS s zClosedCurTests.CheckClosedN)r' r( r) rK r r r r rG R s rG c @ sX e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z dd� Z dd� Z dS )�SqliteOnConflictTestszz Tests for SQLite's "insert on conflict" feature. See https://www.sqlite.org/lang_conflict.html for details. c C s( t �d�| _| j�� | _| j�d� d S )Nr+ zz CREATE TABLE test( id INTEGER PRIMARY KEY, name TEXT, unique_name TEXT UNIQUE ); rj r r r r r5 l s zSqliteOnConflictTests.setUpc C s | j �� | j�� d S r6 rk r r r r r9 u s z SqliteOnConflictTests.tearDownc C s� d | j _| j �� | _| j�d� | j�d� | j�d� | �tj�� | j�d� W d � n1 sf0 Y | j �� | j�d� | � | j� � g � d S )N�BEGIN�,INSERT INTO test(name) VALUES ('abort_test')�8INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')z"SELECT name, unique_name from test� r0 rb r1 r4 r2 rD r r r; r r� r r r r �.CheckOnConflictRollbackWithExplicitTransactiony s * zDSqliteOnConflictTests.CheckOnConflictRollbackWithExplicitTransactionc C s� d | j _| j �� | _| j�d� | j�d� | j�d� | �tj�� | j�d� W d � n1 sf0 Y | j �� | j�d� | � | j� � ddg� d S )NrM rN �5INSERT OR ABORT INTO test(unique_name) VALUES ('foo')�"SELECT name, unique_name FROM test�Z abort_testNr� rP r r r r �2CheckOnConflictAbortRaisesWithExplicitTransactions� s * zHSqliteOnConflictTests.CheckOnConflictAbortRaisesWithExplicitTransactionsc C sr | j �d� | j �d� | �tj�� | j �d� W d � n1 sF0 Y | j �d� | �| j �� g � d S )NrN rO rS �r4 r2 rD r r r r� r r r r �)CheckOnConflictRollbackWithoutTransaction� s * z?SqliteOnConflictTests.CheckOnConflictRollbackWithoutTransactionc C sv | j �d� | j �d� | �tj�� | j �d� W d � n1 sF0 Y | j �d� | �| j �� ddg� d S )NrN rR rS rT r� rV r r r r �-CheckOnConflictAbortRaisesWithoutTransactions� s * zCSqliteOnConflictTests.CheckOnConflictAbortRaisesWithoutTransactionsc C sZ | j �d� | �tj�� | j �d� W d � n1 s:0 Y | �| j �� g � d S )Nz4INSERT OR FAIL INTO test(unique_name) VALUES ('foo')rV r r r r �CheckOnConflictFail� s *z)SqliteOnConflictTests.CheckOnConflictFailc C s< | j �d� | j �d� | j �d� | �| j �� dg� d S )Nz6INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')z SELECT unique_name FROM testr- �r4 r2 r r� r r r r �CheckOnConflictIgnore� s z+SqliteOnConflictTests.CheckOnConflictIgnorec C s< | j �d� | j �d� | j �d� | �| j �� dg� d S )NzFINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Data!', 'foo')zUINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Very different data!', 'foo')rS )zVery different data!r. rZ r r r r �CheckOnConflictReplace� s z,SqliteOnConflictTests.CheckOnConflictReplaceN) r' r( r) �__doc__r5 r9 rQ rU rW rX rY r[ r\ r r r r rL e s rL c @ s$ e Zd Zed Zdd� Zdd� ZdS )�MultiprocessTestsg @�@c C s t t� d S r6 )r r r r r r r9 � s zMultiprocessTests.tearDownc C sN dt � d| j� d�}tjtjd|gddtjtjd�}| �|j� | � d|j � � � � � t jt | jd �}z�z2|� |�d � W d � n1 s�0 Y W n6 t jy� } z |j�t|�� W Y d }~nd }~0 0 |j�d � W |�� n |�� 0 | �|j� z|jd td � W n( tj�y: |�� |�� � Y n0 | � |jd� d S )Nz�if 1: import sqlite3 def wait(): print("started") assert "database is locked" in input() cx = sqlite3.connect("z ", timeout=a� ) cx.create_function("wait", 0, wait) with cx: cx.execute("create table t(t)") try: # execute two transactions; both will try to lock the db cx.executescript(''' -- start a transaction and wait for parent begin transaction; select * from t; select wait(); rollback; -- start a new transaction; would fail if parent holds lock begin transaction; select * from t; rollback; ''') finally: cx.close() z-czutf-8r )�encoding�bufsize�stdin�stdout�started)�timeoutz insert into t values('test')zno error�end)�inputrd )r �CONNECTION_TIMEOUT� subprocess�Popen�sys� executable�PIPErR � communicater rb �readline�stripr r/ r2 r ra �writerY r8 Z assertIsNone� returncoder �TimeoutExpired�kill)r ZSCRIPT�procr0 �excr r r �&test_ctx_mgr_rollback_if_commit_failed� s< �� � ,& z8MultiprocessTests.test_ctx_mgr_rollback_if_commit_failedN)r' r( r) r rg r9 rv r r r r r^ � s r^ c C s� t �td�} t �td�}t �td�}t �td�}t �td�}t �td�}t �td�}t �t d�}t �t d�}t �t �} t �t �} t � | ||||||||| | f �S )NZCheck)r^ Z makeSuiter r* ri r� r r& r4 rG rL r_ r^ Z TestSuite) Z module_suiteZconnection_suiteZ cursor_suiteZ thread_suiteZconstructor_suiteZ ext_suiteZclosed_con_suiteZclosed_cur_suiteZon_conflict_suiteZuninit_con_suiteZmultiproc_con_suiter r r �suite s �rw c C s t �� } | �t� � d S r6 )r^ ZTextTestRunnerr� rw )Zrunnerr r r r� s r� �__main__)rh r� r^ Zsqlite3r rj Z test.supportr r r ZTestCaser r* r_ ri r� r r& r4 rG rL r^ rw r� r' r r r r �<module> s. 7n P 4C]G
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка