|
Server : LiteSpeed System : Linux server51.dnsbootclub.com 4.18.0-553.62.1.lve.el8.x86_64 #1 SMP Mon Jul 21 17:50:35 UTC 2025 x86_64 User : nandedex ( 1060) PHP Version : 8.1.33 Disable Function : NONE Directory : /opt/cppython/lib/python3.8/sqlite3/test/__pycache__/ |
U
?��g�C � @ s� d dl Z d dlZd dlZd dlZd dlZd dlmZ d dlm Z G dd� dej
�Z G dd� dej
�Z dd � Z
d
d � Zed kr�e� dS )
� N)�support)�patchc @ 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 �6/opt/cppython/lib/python3.8/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 s@ t jdt jd�}z| j�� }|�d� W 5 |�� |�� X d S )Nr �Z detect_typeszpragma schema_version)r r �PARSE_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>= s z7RegressionTests.CheckStatementReset.<locals>.<listcomp>r zcreate table test(x)�
� insert into test(x) values (?)c S s g | ]
}|f�qS r r r r r r r @ s � zselect x from test)r r �ranger � executemany�rollback)r
�cursors�ir r r �CheckStatementReset8 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 �CheckColumnNameWithSpacesG 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 �#CheckStatementFinalizationOnCloseDbO s
z3RegressionTests.CheckStatementFinalizationOnCloseDb)� � r1 zneeds sqlite 3.2.2 or newerc C s� t �d�}|�d� |�d� z|�d� W n t jk
rB Y nX |�d� z |�� W n t jk
rz | �d� Y nX 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 �CheckOnConflictRollback] s
z'RegressionTests.CheckOnConflictRollbackc C s( | j �d� | j �d� | j �d� dS )zm
pysqlite would crash with older SQLite versions unless
a workaround is implemented.
�create table foo(bar)�drop table fooN�r r r r r r �-CheckWorkaroundForBuggySqliteTransferBindingsl s z=RegressionTests.CheckWorkaroundForBuggySqliteTransferBindingsc C s | j �d� dS )z
pysqlite used to segfault with SQLite versions 3.5.x. These return NULL
for "no-operation" statements
� Nr8 r r r r �CheckEmptyStatementu s z#RegressionTests.CheckEmptyStatementc C sh d}t jdt jd�}|�d� |�dtj�� f� |�|� |�d� |�d� |�d� |�|� d S )
z�
pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling
a statement. This test exhibits the problem.
zselect * from foor r z create table foo(bar timestamp)z insert into foo(bar) values (?)r7 z create table foo(bar integer)� insert into foo(bar) values (5)N)r r �PARSE_DECLTYPESr �datetimeZnow)r
ZSELECTr r r r �CheckTypeMapUsage| s
z!RegressionTests.CheckTypeMapUsagec s\ G � fdd�d�}|� dg� t jdt jd�}|�d� | �t�� |�d� � W 5 Q R X d S )Nc s e Zd Z� fdd�ZdS )z0RegressionTests.CheckBindMutatingList.<locals>.Xc s � � � dS )Nz...)�clear)r
�protocol�Z
parametersr r � __conform__� s z<RegressionTests.CheckBindMutatingList.<locals>.X.__conform__N)�__name__�
__module__� __qualname__rC r rB 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 rB r �CheckBindMutatingList� s
z%RegressionTests.CheckBindMutatingListc C sP | � tj��$}| j�dttdg��f��� W 5 Q R X d}| �|t |j
�� d S )Nz"select 'xxx' || ? || 'yyy' colname� z9Could not decode to UTF-8 column 'colname' with text 'xxx) rH r r3 r r �bytes� bytearray�fetchoneZassertInr. � exception)r
�cm�msgr r r �CheckErrorMsgDecodeError� s �z(RegressionTests.CheckErrorMsgDecodeErrorc C s | � ttji d� dS )z!
See issue 3312.
N)rH � TypeErrorr Zregister_adapterr r r r �CheckRegisterAdapter� s z$RegressionTests.CheckRegisterAdapterc s� G � fdd�dt �}t�d�� d � _dD ]@}| j|d��* |� _|�� � _|�� � _||�� _W 5 Q R X q(d � _d� _dtfdtfd tfd
tfd tfg}|D ]J\}}| j|d��0 | � |�� |� _W 5 Q R X | �
� jd� W 5 Q R X 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 )Nr: ��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 )r: �DEFERREDZ IMMEDIATEZ EXCLUSIVE)�levelrZ � � �abczIMMEDIATE EXCLUSIVE� é) r. r r rW �subTest�lower�
capitalizerS �
ValueErrorrH r) )r
rY r[ Zpairs�value�excr r r �CheckSetIsolationLevel� s,
� z&RegressionTests.CheckSetIsolationLevelc C sp G dd� dt j�}t �d�}||�}| �t j�� |�d��� W 5 Q R X | �t jd�� |�� W 5 Q R X dS )zd
Verifies that cursor methods check whether base class __init__ was
called.
c @ s e Zd Zdd� ZdS )z?RegressionTests.CheckCursorConstructorCallCheck.<locals>.Cursorc S s d S r r r4 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\.$N) r ri r rH �ProgrammingErrorr �fetchall�assertRaisesRegexr )r
ri r r r r r � CheckCursorConstructorCallCheck� s
�z/RegressionTests.CheckCursorConstructorCallCheckc C s( G dd� dt �}| j�d|d�f� dS )za
The Python 3.0 port of the module didn't cope with values of subclasses of str.
c @ s e Zd ZdS )z/RegressionTests.CheckStrSubclass.<locals>.MyStrN)rD rE rF r r r r �MyStr� s rn zselect ?r^ N)r. r r )r
rn r r r �CheckStrSubclass� s z RegressionTests.CheckStrSubclassc C s> G dd� dt j�}|d�}| �t j�� |�� }W 5 Q R X dS )zh
Verifies that connection methods check whether base class __init__ was
called.
c @ 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 rq r N)r rq rH rj r �r
rq r r r r r �#CheckConnectionConstructorCallCheck� s z3RegressionTests.CheckConnectionConstructorCallCheckc s� G � fdd�dt j�}G dd� dt j�� |d�}|�� }|�d� |�ddd d
g� |�d � |�� | �t j�� |� � W 5 Q R X d S )
z�
Verifies that subclassed cursor classes are correctly registered with
the connection object, too. (fetch-across-rollback problem)
c 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 rt r r rq � s rq c @ s e Zd Zdd� ZdS )z7RegressionTests.CheckCursorRegistration.<locals>.Cursorc S s t j�| |� d S r )r ri rg r4 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 (?))r0 )� )r zselect x from fooN)
r rq ri r r r$ r% rH ZInterfaceErrorrk rr r rt r �CheckCursorRegistration� s
z'RegressionTests.CheckCursorRegistrationc C s t jddd�}dS )z�
Verifies that creating a connection in autocommit mode works.
2.5.3 introduced a regression so that these could no longer
be created.
r NrV )r r r4 r r r �CheckAutoCommit s z RegressionTests.CheckAutoCommitc C s4 | j �� }|�d� |�d� |�d� |�� }dS )z�
Verifies that running a PRAGMA statement that does an autocommit does
work. This did not work in 2.5.3/2.5.4.
r6 r< zpragma page_sizeN)r r r rN )r
r �rowr r r �CheckPragmaAutocommit s
z%RegressionTests.CheckPragmaAutocommitc C s | � tj| jd� dS )z}
Call a connection with a non-string SQL request: check error handling
of the statement constructor.
r\ N)rH r �Warningr r r r r �CheckConnectionCall s z#RegressionTests.CheckConnectionCallc C s" dd� }| � tj| jjd|� d S )Nc S s dS )Nr\ 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 sf t �d�}|�� � � �d� � �d� � fdd�}| �t j�� � �ddd� |� D �� W 5 Q R X d S )
z�
http://bugs.python.org/issue10811
Recursively using a cursor, such as when reusing it from a generator led to segfaults.
Now we catch recursive cursor usage and raise a ProgrammingError.
r 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>5 s z:RegressionTests.CheckRecursiveCursorUse.<locals>.<genexpr>N)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� dS )z�
http://bugs.python.org/issue14720
The microsecond parsing of convert_timestamp() should pad with zeros,
since the microsecond string "456" actually represents "456000".
r 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 J s zKRegressionTests.CheckConvertTimestampMicrosecondPadding.<locals>.<listcomp>i� ru � � r i@� i@� N)r r r= r r rk r) r> )r
r r �valuesr r r �'CheckConvertTimestampMicrosecondPadding7 s
�z7RegressionTests.CheckConvertTimestampMicrosecondPaddingc C s | j ttjddd� d S )Nr �{ rV )rH rS r r r r r r � CheckInvalidIsolationLevelTypeQ 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 rc r r r r r r �CheckNullCharacterW s
z"RegressionTests.CheckNullCharacterc
C s� t �d�}|�d� | �|jd� d}t|�d��D ]�\}}| j||d��p |�d|f� |�� |dkr|| �|d d� n2|dkr�| �|d d� n|d kr�| �|d d � |d7 }W 5 Q R X q4| �|d
d � d S )
z�
Connection.commit() did reset cursors, which made sqlite3
to return rows multiple times when fetched from cursors
after commit. See issues 10513 and 23129 for details.
r z�
create table t(c);
create table t2(c);
insert into t values(0);
insert into t values(1);
insert into t values(2);
r: r zselect c from t)r' rx z insert into t2(c) values (?)r\ r1 r0 z'should have returned exactly three rowsN) r r Z
executescriptr) rW � enumerater r` r2 )r
r Zcounterr' rx r r r �CheckCommitCursorReset` s
z&RegressionTests.CheckCommitCursorResetc C sB dd� }t �d�}t �|�}t�||�}|�|� ~~t�� dS )zm
The interpreter shouldn't crash in case Cursor.__init__() is called
more than once.
c W s d S r r )�argsr r r �callback� s z/RegressionTests.CheckBpo31770.<locals>.callbackr N)r r ri �weakref�refrg r �
gc_collect)r
r� r r r� r r r �
CheckBpo31770 s
z RegressionTests.CheckBpo31770c C s | � t�� | j`W 5 Q R X 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_infor5 r9 r; r? rJ rR rT rf rm ro rs rv rw ry r{ r r� r� r� r� r� r� r� r� r r r r r " s@
r c @ s8 e Zd ZdZdd� Zdd� Zdd� Zdd � Zd
d � Zd S )
�RecursiveUseOfCursorsz$Recursive use of cursors not allowedc C s@ t jdt jd�| _| j�� | _| j�d� | j�dddg� d S )Nr r zcreate table test(x foo)r! )r� )Zbar)r r r r r r r r$ r r r r r
� s � �zRecursiveUseOfCursors.setUpc C s | j �� | j�� | ` | `d S r )r r r r r r r r � s
z RecursiveUseOfCursors.tearDownc
sV � fdd�}t �tjd|i��. � �tj� j�� � j�d� W 5 Q R X W 5 Q R X d S )Nc s � j �� j�S r )r rg r �r r r r �<lambda>� r] zBRecursiveUseOfCursors.test_recursive_cursor_init.<locals>.<lambda>ZINITz#select x as "x [INIT]", x from test� r �dictr �
convertersrl rj rQ r r �r
�convr r r �test_recursive_cursor_init� s z0RecursiveUseOfCursors.test_recursive_cursor_initc
sV � fdd�}t �tjd|i��. � �tj� j�� � j�d� W 5 Q R X W 5 Q R X d S )Nc s
� j �� S r )r r r� r r r r� � r] zCRecursiveUseOfCursors.test_recursive_cursor_close.<locals>.<lambda>ZCLOSEz$select x as "x [CLOSE]", x from testr� r� r r r �test_recursive_cursor_close� s z1RecursiveUseOfCursors.test_recursive_cursor_closec
sd g f� fdd� }t �tjd|i��8 � j�d� � �tj� j�� � j� � W 5 Q R X W 5 Q R X d S )Nc s |r� j �� S |�d �S r )r rN r- )r �lr r r r� � r] zCRecursiveUseOfCursors.test_recursive_cursor_fetch.<locals>.<lambda>ZITERz#select x as "x [ITER]", x from test)
r r� r r� r r rl rj rQ rk r� r r r �test_recursive_cursor_fetch� s
z1RecursiveUseOfCursors.test_recursive_cursor_fetchN) rD rE rF rQ r
r r� r� r� r r r r r� � s r� c C s$ t �td�} t �t�}t �| |f�S )NZCheck)r� Z makeSuiter r� Z TestSuite)Zregression_suiteZrecursive_cursorr 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 Z
unittest.mockr ZTestCaser r� r� rD r r r r �<module> s &