Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/sqlite3/test/__pycache__/regression.cpython-39.opt-2.pyc
Ðазад
a c�h�< � @ sh d dl Z d dlZd dlZd dlZd dlZd dlmZ G dd� dej�Z dd� Z dd� Ze d krde� dS ) � N)�supportc @ s e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z e � e j dk d�dd� �Zdd� Zdd� Zdd� Zdd� Zdd � Zd d � Zd d � Zd!d"� Zd#d$� Zd%d&� Zd'd(� Zd)d*� Zd+d,� Zd-d.� Z d/d0� Z d1d2� Z d3d4� Z d5d6� Z d7d8� Z!d9d:� Z"d;d<� Z#d=d>� Z$d?d@� Z%dAS )B�RegressionTestsc C s t �d�| _d S )N�:memory:)�sqlite�connect�con��self� r �8/opt/imh-python/lib/python3.9/sqlite3/test/regression.py�setUp s zRegressionTests.setUpc C s | j �� d S �N)r �closer r r r �tearDown# s zRegressionTests.tearDownc C s | j �� }|�d� d S )Nzpragma user_version)r �cursor�execute�r �curr r r �CheckPragmaUserVersion& s z&RegressionTests.CheckPragmaUserVersionc C sP t jdt jd�}z(| j�� }|�d� W |�� |�� n|�� |�� 0 d S )Nr �Z detect_typeszpragma schema_version)r r ZPARSE_COLNAMESr r r r �r r r r r r �CheckPragmaSchemaVersion+ s �z(RegressionTests.CheckPragmaSchemaVersionc s� t jddd�� � fdd�td�D �}|d �d� td�D ]"}|d �d d d� td�D �� q:td�D ]}|| �d | d � qf� �� d S ) Nr � )Zcached_statementsc s g | ] }� � � �qS r )r ��.0�x�r r r � <listcomp>: � z7RegressionTests.CheckStatementReset.<locals>.<listcomp>r zcreate table test(x)� z insert into test(x) values (?)c S s g | ] }|f�qS r r r r r r r = r � zselect x from test)r r �ranger � executemany�rollback)r �cursors�ir r r �CheckStatementReset5 s z#RegressionTests.CheckStatementResetc C sN | j �� }|�d� | �|jd d d� |�d� | �|jd d d� d S )Nz select 1 as "foo bar [datetime]"r zfoo bar [datetime]zselect 1 as "foo baz"zfoo baz)r r r � assertEqual� descriptionr r r r �CheckColumnNameWithSpacesD s z)RegressionTests.CheckColumnNameWithSpacesc C sL t �d�}g }td�D ](}|�� }|�|� |�dt|� � q|�� d S )Nr �i zselect 1 x union select )r r r! r �appendr �strr )r r r$ r% r r r r �#CheckStatementFinalizationOnCloseDbL s z3RegressionTests.CheckStatementFinalizationOnCloseDb)� � r/ zneeds sqlite 3.2.2 or newerc C s| t �d�}|�d� |�d� z|�d� W n t jy@ Y n0 |�d� z |�� W n t jyv | �d� Y n0 d S )Nr z3create table foo(x, unique(x) on conflict rollback)z insert into foo(x) values (1)z insert into foo(x) values (2)z1pysqlite knew nothing about the implicit ROLLBACK)r r r Z DatabaseError�commit�OperationalErrorZfail�r r r r r �CheckOnConflictRollbackZ s z'RegressionTests.CheckOnConflictRollbackc C s( | j �d� | j �d� | j �d� d S )N�create table foo(bar)�drop table foo�r r r r r r �-CheckWorkaroundForBuggySqliteTransferBindingsi s z=RegressionTests.CheckWorkaroundForBuggySqliteTransferBindingsc C s | j �d� d S �N� r6 r r r r �CheckEmptyStatementr s z#RegressionTests.CheckEmptyStatementc C sp d}t jdt jd�}|�d� |�dtj�� f� |�|��� |�d� |�d� |�d� |�|��� d S ) Nzselect * from foor r z create table foo(bar timestamp)z insert into foo(bar) values (?)r5 z create table foo(bar integer)� insert into foo(bar) values (5))r r �PARSE_DECLTYPESr �datetimeZnowr )r ZSELECTr r r r �CheckTypeMapUsagey s z!RegressionTests.CheckTypeMapUsagec sp G � fdd�d�}|� dg� t jdt jd�}|�d� | �t�� |�d� � W d � n1 sb0 Y d S )Nc s e Zd Z� fdd�ZdS )z0RegressionTests.CheckBindMutatingList.<locals>.Xc s � � � dS )Nz...)�clear)r �protocol�� parametersr r � __conform__� s z<RegressionTests.CheckBindMutatingList.<locals>.X.__conform__N)�__name__� __module__� __qualname__rC r rA r r �X� s rG r r r z$create table foo(bar X, baz integer)z'insert into foo(bar, baz) values (?, ?))r r r< r � assertRaises� IndexError)r rG r r rA r �CheckBindMutatingList� s z%RegressionTests.CheckBindMutatingListc C sd | � tj��.}| j�dttdg��f��� W d � n1 s@0 Y d}| �|t |j �� d S )Nz"select 'xxx' || ? || 'yyy' colname� z9Could not decode to UTF-8 column 'colname' with text 'xxx) rH r r1 r r �bytes� bytearray�fetchoneZassertInr, � exception)r �cm�msgr r r �CheckErrorMsgDecodeError� s �&z(RegressionTests.CheckErrorMsgDecodeErrorc C s | � ttji d � d S r )rH � TypeErrorr Zregister_adapterr r r r �CheckRegisterAdapter� s z$RegressionTests.CheckRegisterAdapterc s* G � fdd�dt �}t�d�� d � _dD ]T}| j|d��4 |� _|�� � _|�� � _||�� _W d � q(1 sr0 Y q(d � _d� _dtfdtfd tfd tfd tfg}|D ]t\}}| j|d��N | � |�� |� _W d � n1 s�0 Y | � � jd� W d � q�1 �s0 Y q�d S ) Nc s e Zd Zdd� Z� fdd�ZdS )z9RegressionTests.CheckSetIsolationLevel.<locals>.CustomStrc S s d S r r r r r r �upper� s z?RegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.upperc s d� _ d S r8 ��isolation_levelr r r r �__del__� s zARegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.__del__N)rD rE rF rU rX r r r r � CustomStr� s rY r )r9 �DEFERREDZ IMMEDIATEZ EXCLUSIVE)�levelrZ � r �abczIMMEDIATE EXCLUSIVE� é) r, r r rW �subTest�lower� capitalizerS � ValueErrorrH r' )r rY r[ �pairs�value�excr r r �CheckSetIsolationLevel� s& * � $z&RegressionTests.CheckSetIsolationLevelc C s� G dd� dt j�}t �d�}||�}| �t j�� |�d��� W d � n1 sT0 Y | �t jd�� |�� W d � n1 s�0 Y d S )Nc @ s e Zd Zdd� ZdS )z?RegressionTests.CheckCursorConstructorCallCheck.<locals>.Cursorc S s d S r r r2 r r r �__init__� s zHRegressionTests.CheckCursorConstructorCallCheck.<locals>.Cursor.__init__N�rD rE rF rg r r r r �Cursor� s ri r z select 4+5z$^Base Cursor\.__init__ not called\.$) r ri r rH �ProgrammingErrorr �fetchallZassertRaisesRegexr )r ri r r r r r � CheckCursorConstructorCallCheck� s ,�z/RegressionTests.CheckCursorConstructorCallCheckc C s( G dd� dt �}| j�d|d�f� d S )Nc @ s e Zd ZdS )z/RegressionTests.CheckStrSubclass.<locals>.MyStrN)rD rE rF r r r r �MyStr� r rm zselect ?r] )r, r r )r rm r r r �CheckStrSubclass� s z RegressionTests.CheckStrSubclassc C sR G dd� dt j�}|d�}| �t j�� |�� }W d � n1 sD0 Y d S )Nc @ s e Zd Zdd� ZdS )zGRegressionTests.CheckConnectionConstructorCallCheck.<locals>.Connectionc S s d S r r )r �namer r r rg � s zPRegressionTests.CheckConnectionConstructorCallCheck.<locals>.Connection.__init__Nrh r r r r � Connection� s rp r )r rp rH rj r �r rp r r r r r �#CheckConnectionConstructorCallCheck� s z3RegressionTests.CheckConnectionConstructorCallCheckc s� G � fdd�dt j�}G dd� dt j�� |d�}|�� }|�d� |�dg d�� |�d � |�� | �t j�� |� � W d � n1 s�0 Y d S ) Nc s e Zd Z� fdd�ZdS )z;RegressionTests.CheckCursorRegistration.<locals>.Connectionc s � | �S r r r �ri r r r � s zBRegressionTests.CheckCursorRegistration.<locals>.Connection.cursorN)rD rE rF r r rs r r rp � s rp c @ s e Zd Zdd� ZdS )z7RegressionTests.CheckCursorRegistration.<locals>.Cursorc S s t j�| |� d S r )r ri rg r2 r r r rg � s z@RegressionTests.CheckCursorRegistration.<locals>.Cursor.__init__Nrh r r r r ri � s ri r zcreate table foo(x)z insert into foo(x) values (?)))r. )� )r zselect x from foo) r rp ri r r r" r# rH ZInterfaceErrorrk rq r rs r �CheckCursorRegistration� s z'RegressionTests.CheckCursorRegistrationc C s t jdd d�}d S )Nr rV )r r r2 r r r �CheckAutoCommit� s z RegressionTests.CheckAutoCommitc C s4 | j �� }|�d� |�d� |�d� |�� }d S )Nr4 r; zpragma page_size)r r r rN )r r �rowr r r �CheckPragmaAutocommit s z%RegressionTests.CheckPragmaAutocommitc C s | � t| jd� d S �Nr\ )rH rS r r r r r �CheckConnectionCall s z#RegressionTests.CheckConnectionCallc C s" dd� }| � tj| jjd|� d S )Nc S s dS ry r )�a�br r r � collation_cb s z4RegressionTests.CheckCollation.<locals>.collation_cbu �)rH r rj r Zcreate_collation)r r} r r r �CheckCollation s �z RegressionTests.CheckCollationc sz t �d�}|�� � � �d� � �d� � fdd�}| �t j��( � �ddd� |� D �� W d � n1 sl0 Y d S ) Nr zcreate table a (bar)zcreate table b (baz)c 3 s � � dd� dV d S )Nz insert into a (bar) values (?))r\ r\ )r r �r r r �foo, s z4RegressionTests.CheckRecursiveCursorUse.<locals>.fooz insert into b (baz) values (?)c s s | ] }|fV qd S r r )r r% r r r � <genexpr>2 r z:RegressionTests.CheckRecursiveCursorUse.<locals>.<genexpr>)r r r r rH rj r" )r r r� r r r �CheckRecursiveCursorUse s �z'RegressionTests.CheckRecursiveCursorUsec C s� t jdt jd�}|�� }|�d� |�d� |�d� |�d� dd� |�� D �}| �|t�d d d d d d d�t�d d d d d d d�g� d S )Nr r z CREATE TABLE t (x TIMESTAMP)z4INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')z:INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')zSELECT * FROM tc S s g | ] }|d �qS )r r r r r r r G r zKRegressionTests.CheckConvertTimestampMicrosecondPadding.<locals>.<listcomp>i� rt � � r i@� i@� )r r r< r r rk r' r= )r r r �valuesr r r �'CheckConvertTimestampMicrosecondPadding4 s �z7RegressionTests.CheckConvertTimestampMicrosecondPaddingc C s | j ttjddd� d S )Nr �{ rV )rH rS r r r r r r � CheckInvalidIsolationLevelTypeN s �z.RegressionTests.CheckInvalidIsolationLevelTypec C sR t �d�}| �t|d� | �t|d� |�� }| �t|jd� | �t|jd� d S )Nr z select 1z select 1 z select 2z select 2 )r r rH rb r r r r r r �CheckNullCharacterT s z"RegressionTests.CheckNullCharacterc C s� t �d�}|�d� | �|jd� d}t|�d��D ]�\}}| j||d��z |�d|f� |�� |dkr|| �|d d� n2|dkr�| �|d d� n|d kr�| �|d d � |d7 }W d � q41 s�0 Y q4| �|d d � d S ) Nr z� create table t(c); create table t2(c); insert into t values(0); insert into t values(1); insert into t values(2); r9 r zselect c from t)r% rw z insert into t2(c) values (?)r\ r/ r. z'should have returned exactly three rows) r r Z executescriptr' rW � enumerater r_ r0 )r r Zcounterr% rw r r r �CheckCommitCursorReset] s (z&RegressionTests.CheckCommitCursorResetc C sB dd� }t �d�}t �|�}t�||�}|�|� ~~t�� d S )Nc W s d S r r )�argsr r r �callback� s z/RegressionTests.CheckBpo31770.<locals>.callbackr )r r ri �weakref�refrg r � gc_collect)r r� r r r� r r r � CheckBpo31770| s z RegressionTests.CheckBpo31770c C s4 | � t�� | j`W d � n1 s&0 Y d S r )rH �AttributeErrorr rW r r r r � CheckDelIsolation_levelSegfault� s z/RegressionTests.CheckDelIsolation_levelSegfaultc C sf G dd� d�}| j jtj| j jdd�| j jfD ]2}|� }||j� ||j� | j �d� |d � q.d S )Nc @ s e Zd Zdd� ZdS )z.RegressionTests.CheckBpo37347.<locals>.Printerc W s t jS r )r Z SQLITE_OK)r r� r r r �log� s z2RegressionTests.CheckBpo37347.<locals>.Printer.logN)rD rE rF r� r r r r �Printer� s r� r\ )�nzselect 1)r Zset_trace_callback� functools�partialZset_progress_handlerZset_authorizerr� r )r r� �methodZprinter_instancer r r � CheckBpo37347� s � z RegressionTests.CheckBpo37347N)&rD rE rF r r r r r& r) r- �unittestZskipIfr Zsqlite_version_infor3 r7 r: r> rJ rR rT rf rl rn rr ru rv rx rz r~ r� r� r� r� r� r� r� r� r r r r r s@ r c C s t �td�} t �| f�S )NZCheck)r� Z makeSuiter Z TestSuite)Zregression_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= r� Zsqlite3r r� r� r� r ZTestCaser r� rD r r r r �<module> s
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка