| Server IP : 118.27.122.248 / Your IP : 216.73.216.109 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 dlZd dlZd dlZd dlmZ G dd� dej�ZG dd� d�Z G dd� dej�Z
d d
� Z d d � Ze d
kr|e� dS )� N)�supportc @ s� e Zd Zdd� Zdd� Zdd� Zdd� Zd d
� Zd d � Zd
d� Z e
j e j
d=k d�dd� �Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d!� Zd"d#� Zd$d%� Zd&d'� Zd(d)� Zd*d+� Zd,d-� Zd.d/� Z d0d1� Z d2d3� Z d4d5� Z d6d7� Z d8d9� Z!d:d;� Z"d<S )>�RegressionTestsc C s t jd�| _d S )Nz:memory:)�sqlite�connect�con)�self� r �</opt/alt/python36/lib64/python3.6/sqlite3/test/regression.py�setUp s zRegressionTests.setUpc C s | j j� d S )N)r �close)r r r r �tearDown" s zRegressionTests.tearDownc C s | j j� }|jd� d S )Nzpragma user_version)r �cursor�execute)r �curr r r �CheckPragmaUserVersion% s
z&RegressionTests.CheckPragmaUserVersionc
C s@ t jdt jd�}z| jj� }|jd� W d |j� |j� X d S )Nz:memory:)� 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 jd� x.td�D ]"}|d jd d
d� td�D �� q<W x&td�D ]}|| jd | d � qlW � j� d S )
Nz:memory:� )Zcached_statementsc s g | ] }� j � �qS r )r
)�.0�x)r r r �
<listcomp>9 s 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 < s � zselect x from test)r r �ranger � executemany�rollback)r �cursors�ir )r r �CheckStatementReset4 s "z#RegressionTests.CheckStatementResetc C sN | j j� }|jd� | j|jd d d� |jd� | j|jd d d� d S )Nz select 1 as "foo bar [datetime]"r zfoo barzselect 1 as "foo baz"zfoo baz)r r
r � assertEqualZ description)r r r r r �CheckColumnNameWithSpacesC s
z)RegressionTests.CheckColumnNameWithSpacesc C sP t jd�}g }x4td�D ](}|j� }|j|� |jdt|� � qW |j� d S )Nz:memory:�i zselect 1 x union select )r r r r
�appendr �strr )r r r r r r r r �#CheckStatementFinalizationOnCloseDbK s
z3RegressionTests.CheckStatementFinalizationOnCloseDb� � zneeds sqlite 3.2.2 or newerc C s� t jd�}|jd� |jd� y|jd� W n t jk
rB Y nX |jd� y |j� W n t jk
rz | jd� Y nX d S )Nz:memory: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 �CheckOnConflictRollbackY s
z'RegressionTests.CheckOnConflictRollbackc C s( | j jd� | j jd� | j jd� dS )zm
pysqlite would crash with older SQLite versions unless
a workaround is implemented.
zcreate table foo(bar)zdrop table fooN)r r )r r r r �-CheckWorkaroundForBuggySqliteTransferBindingsh s z=RegressionTests.CheckWorkaroundForBuggySqliteTransferBindingsc C s | j jd� dS )z
pysqlite used to segfault with SQLite versions 3.5.x. These return NULL
for "no-operation" statements
� N)r r )r r r r �CheckEmptyStatementq s z#RegressionTests.CheckEmptyStatementc C sh d}t jdt jd�}|jd� |jdtjj� f� |j|� |jd� |jd� |jd� |j|� 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 fooz:memory:)r z create table foo(bar timestamp)z insert into foo(bar) values (?)zdrop table fooz create table foo(bar integer)z insert into foo(bar) values (5)N)r r �PARSE_DECLTYPESr �datetimeZnow)r ZSELECTr r r r �CheckTypeMapUsagex s
z!RegressionTests.CheckTypeMapUsagec C sP | j tj��$}| jjdttdg��f�j� W d Q R X d}| j|t |j
�� d S )Nz"select 'xxx' || ? || 'yyy' colname� z9Could not decode to UTF-8 column 'colname' with text 'xxx) � assertRaisesr r( r r �bytes� bytearray�fetchoneZassertInr# Z exception)r �cm�msgr r r �CheckErrorMsgDecodeError� s
z(RegressionTests.CheckErrorMsgDecodeErrorc C s | j ttji d� dS )z!
See issue 3312.
N)r1 � TypeErrorr Zregister_adapter)r r r r �CheckRegisterAdapter� s z$RegressionTests.CheckRegisterAdapterc s� G � fdd�dt �}tjd�� d � _xHdD ]@}| j|d��* |� _|j� � _|j� � _||�� _W d Q R X q*W d � _d� _d tfd
tfd tfd tfd
tfg}xR|D ]J\}}| j|d��0 | j |�� |� _W d Q R X | j
� jd� W d Q R X q�W d S )Nc s e Zd Zdd� Z� fdd�ZdS )z9RegressionTests.CheckSetIsolationLevel.<locals>.CustomStrc S s d S )Nr )r r r r �upper� s z?RegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.upperc s
d� _ d S )Nr+ )�isolation_level)r )r r r �__del__� s zARegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.__del__N)�__name__�
__module__� __qualname__r: r< r )r r r � CustomStr� s r@ z:memory:r+ �DEFERRED� IMMEDIATE� EXCLUSIVE)�level� � �abczIMMEDIATE EXCLUSIVE� é)r+ rA rB rC ) r# r r r; �subTest�lower�
capitalizer8 �
ValueErrorr1 r )r r@ rD Zpairs�value�excr )r r �CheckSetIsolationLevel� s$
z&RegressionTests.CheckSetIsolationLevelc C sp G dd� dt j�}t jd�}||�}| jt j�� |jd�j� W dQ R X | jt jd�� |j� W dQ 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 )Nr )r r r r r �__init__� s zHRegressionTests.CheckCursorConstructorCallCheck.<locals>.Cursor.__init__N)r= r> r? rP r r r r �Cursor� s rQ z:memory:z
select 4+5Nz$^Base Cursor\.__init__ not called\.$) r rQ r r1 �ProgrammingErrorr �fetchall�assertRaisesRegexr )r rQ r r r r r � CheckCursorConstructorCallCheck� s
z/RegressionTests.CheckCursorConstructorCallCheckc C s( G dd� dt �}| jjd|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)r= r> r? r r r r �MyStr� s rV zselect ?rG N)r# r r )r rV r r r �CheckStrSubclass� s z RegressionTests.CheckStrSubclassc C s> G dd� dt j�}|d�}| jt j�� |j� }W dQ 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 )Nr )r �namer r r rP � s zPRegressionTests.CheckConnectionConstructorCallCheck.<locals>.Connection.__init__N)r= r> r? rP r r r r �
Connection� s rY z:memory:N)r rY r1 rR r
)r rY r r r r r �#CheckConnectionConstructorCallCheck� s z3RegressionTests.CheckConnectionConstructorCallCheckc s� G � fdd�dt j�}G dd� dt j�� |d�}|j� }|jd� |jdd
ddg� |jd � |j� | jt j�� |j � W d 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 )Nr )r )rQ r r r
� s zBRegressionTests.CheckCursorRegistration.<locals>.Connection.cursorN)r= r> r? r
r )rQ r r rY � s rY c @ s e Zd Zdd� ZdS )z7RegressionTests.CheckCursorRegistration.<locals>.Cursorc S s t jj| |� d S )N)r rQ rP )r r r r r rP � s z@RegressionTests.CheckCursorRegistration.<locals>.Cursor.__init__N)r= r> r? rP r r r r rQ � s rQ z:memory:zcreate table foo(x)z insert into foo(x) values (?)r% � r zselect x from fooN)r% )r[ )r )
r rY rQ r
r r r r1 ZInterfaceErrorrS )r rY r r r )rQ 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.
z:memory:N)r; )r r )r r r r r �CheckAutoCommit� s z RegressionTests.CheckAutoCommitc C s4 | j j� }|jd� |jd� |jd� |j� }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.
zcreate table foo(bar)z insert into foo(bar) values (5)zpragma page_sizeN)r r
r r4 )r r �rowr r r �CheckPragmaAutocommit� s
z%RegressionTests.CheckPragmaAutocommitc C s | j tj| jd� dS )z}
Call a connection with a non-string SQL request: check error handling
of the statement constructor.
rE N)r1 r �Warningr )r r r r �CheckConnectionCall s z#RegressionTests.CheckConnectionCallc C s" dd� }| j tj| jjd|� d S )Nc S s dS )NrE r )�a�br r r � collation_cb s z4RegressionTests.CheckCollation.<locals>.collation_cbu �)r1 r rR r Zcreate_collation)r rd r r r �CheckCollation
s z RegressionTests.CheckCollationc sf t jd�}|j� � � jd� � jd� � fdd�}| jt j�� � jddd� |� D �� W d 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.
z:memory:zcreate table a (bar)zcreate table b (baz)c 3 s � j dd� dV d S )Nz insert into a (bar) values (?)rE )rE )r r )r r r �foo s z4RegressionTests.CheckRecursiveCursorUse.<locals>.fooz insert into b (baz) values (?)c s s | ] }|fV qd S )Nr )r r r r r � <genexpr>$ s z:RegressionTests.CheckRecursiveCursorUse.<locals>.<genexpr>N)r r r
r r1 rR r )r r rf r )r r �CheckRecursiveCursorUse s
z'RegressionTests.CheckRecursiveCursorUsec C s� t jdt jd�}|j� }|jd� |jd� |jd� |jd� dd� |j� D �}| j|tjd d
d
d d d
d�tjd 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".
z:memory:)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 r 9 s zKRegressionTests.CheckConvertTimestampMicrosecondPadding.<locals>.<listcomp>i� r[ � � r i@� i@� N)r r r- r
r rS r r. )r r r �valuesr r r �'CheckConvertTimestampMicrosecondPadding& s
z7RegressionTests.CheckConvertTimestampMicrosecondPaddingc C s | j ttjddd� d S )Nz:memory:�{ )r; )r1 r8 r r )r r r r � CheckInvalidIsolationLevelType@ s z.RegressionTests.CheckInvalidIsolationLevelTypec C sR t jd�}| jt|d� | jt|d� |j� }| jt|jd� | jt|jd� d S )Nz:memory:z select 1z select 1 z
select 2z select 2 )r r r1 rL r
r )r r r r r r �CheckNullCharacterF s
z"RegressionTests.CheckNullCharacterc C s� t jd�}|jd� | j|jd� d}x�t|jd��D ]�\}}| j||d��p |jd|f� |j� |dkr~| j|d d� n2|dkr�| j|d d� n|d kr�| j|d d � |d7 }W d
Q R X q6W | j|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.
z:memory: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 r^ z insert into t2(c) values (?)rE r& Nr% z'should have returned exactly three rows) r r Z
executescriptr r; � enumerater rI r' )r r Zcounterr r^ r r r �CheckCommitCursorResetO s"
z&RegressionTests.CheckCommitCursorResetc C sB dd� }t jd�}t j|�}tj||�}|j|� ~~tj� dS )zm
The interpreter shouldn't crash in case Cursor.__init__() is called
more than once.
c W s d S )Nr )�argsr r r �callbacks s z/RegressionTests.CheckBpo31770.<locals>.callbackz:memory:N)r r rQ �weakref�refrP r Z
gc_collect)r rs r r ru r r r �
CheckBpo31770n s
z RegressionTests.CheckBpo31770N)r% r& r& )#r= r> r? r
r r r r r r$ �unittestZskipIfr Zsqlite_version_infor) r* r, r/ r7 r9 rO rU rW rZ r\ r] r_ ra re rh rl rn ro rq rv r r r r r s8
r c @ s" e Zd ZdZddd�Zdd� ZdS )�UnhashableFuncNc C s d| _ || _d S )Nr )�calls� return_value)r rz r r r rP � s zUnhashableFunc.__init__c O s | j d7 _ | jS )NrE )ry rz )r rr �kwargsr r r �__call__� s zUnhashableFunc.__call__)N)r= r> r? �__hash__rP r| r r r r rx s
rx c @ s@ e Zd ZdZdd� Zdd� Zdd� Zdd � Zd
d � Zd d
� Z dS )�UnhashableCallbacksTestCasez�
https://bugs.python.org/issue34052
Registering unhashable callbacks raises TypeError, callbacks are not
registered in SQLite after such registration attempt.
c C s t jd�| _d S )Nz:memory:)r r r )r r r r r
� s z!UnhashableCallbacksTestCase.setUpc C s | j j� d S )N)r r )r r r r r � s z$UnhashableCallbacksTestCase.tearDownc
C sL t dd�}| jtd�� | jj|d� W d Q R X | jjd� | j|j� d S )Nr )rz zunhashable typerE zSELECT 1)rx rT r8 r Zset_progress_handlerr � assertFalsery )r �fr r r �test_progress_handler� s
z1UnhashableCallbacksTestCase.test_progress_handlerc C st d}t � }| jtd�� | jj|d|� W d Q R X d| }| jtj|�� | jjd| � W d Q R X | j|j � d S )N� func_namezunhashable typer zno such function: %sz SELECT %s())
rx rT r8 r Zcreate_functionr r( r r ry )r r� r� r6 r r r � test_func� s z%UnhashableCallbacksTestCase.test_funcc C sL t tjd�}| jtd�� | jj|� W d Q R X | jjd� | j|j � d S )N)rz zunhashable typezSELECT 1)
rx r Z SQLITE_DENYrT r8 r Zset_authorizerr r ry )r r� r r r �test_authorizer� s
z+UnhashableCallbacksTestCase.test_authorizerc C sz G dd� dt �}d}| jtd�� | jj|d|df i �� W d Q R X d| }| jtj|�� | jjd| � W d Q R X d S ) Nc @ s e Zd ZdZdS )z=UnhashableCallbacksTestCase.test_aggr.<locals>.UnhashableTypeN)r= r> r? r} r r r r �UnhashableType� s r� � aggr_namezunhashable typer ZAggrzno such function: %sz SELECT %s())�typerT r8 r Zcreate_aggregater r( r )r r� r� r6 r r r � test_aggr� s "z%UnhashableCallbacksTestCase.test_aggrN)
r= r> r? �__doc__r
r r� r� r� r� r r r r r~ � s
r~ c C s t jtd�} t j| t jt�f�S )NZCheck)rw Z makeSuiter Z TestSuiter~ )Zregression_suiter r r �suite� s r� c C s t j� } | jt� � d S )N)rw ZTextTestRunnerZrunr� )Zrunnerr r r �test� s r� �__main__)
r. rw Zsqlite3r rt r� r ZTestCaser rx r~ r� r= r r r r �<module> s c 0