| 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 : |
3
�
�^8& � @ sh d dl Z d dlZG dd� de j�ZG dd� de j�ZG dd� de j�Zdd � Zd
d � Ze d krde� dS )
� Nc @ s^ e Zd Zdd� Zdd� Zdd� Zdd� Zeje j
dk d �d
d� �Z dd� Z dd� Z
dd� ZdS )�CollationTestsc C s4 t jd�}| jt�� |jd dd� � W d Q R X d S )Nz:memory:c S s | |k| |k S )N� )�x�yr r �*/opt/alt/python36/lib64/python3.6/hooks.py�<lambda> s z>CollationTests.CheckCreateCollationNotString.<locals>.<lambda>)�sqlite�connect� assertRaises� TypeError�create_collation)�self�conr r r � CheckCreateCollationNotString s
z,CollationTests.CheckCreateCollationNotStringc
C sB t jd�}| jt��}|jdd� W d Q R X | jt|j�d� d S )Nz:memory:�X�* zparameter must be callable)r r r
r r � assertEqual�str� exception)r
r �cmr r r � CheckCreateCollationNotCallable! s
z.CollationTests.CheckCreateCollationNotCallablec C s6 t jd�}| jt j�� |jddd� � W d Q R X d S )Nz:memory:u colläc S s | |k| |k S )Nr )r r r r r r * s z=CollationTests.CheckCreateCollationNotAscii.<locals>.<lambda>)r r r
ZProgrammingErrorr )r
r r r r � CheckCreateCollationNotAscii' s
z+CollationTests.CheckCreateCollationNotAsciic C sl G dd� dt �}tjd�}dd� }|j|d�|� |jd�j� }| j|d d d � | j|d
d d � d S ) Nc @ s e Zd Zdd� ZdS )z@CollationTests.CheckCreateCollationBadUpper.<locals>.BadUpperStrc S s d S )Nr )r
r r r �upper. s zFCollationTests.CheckCreateCollationBadUpper.<locals>.BadUpperStr.upperN)�__name__�
__module__� __qualname__r r r r r � BadUpperStr- s r z:memory:c S s | |k| |k S )Nr )r r r r r r 1 s z=CollationTests.CheckCreateCollationBadUpper.<locals>.<lambda>�mycollz�
select x from (
select 'a' as x
union
select 'b' as x
) order by x collate mycoll
r �b� �a)r r r r �execute�fetchallr )r
r r r �resultr r r � CheckCreateCollationBadUpper, s
z+CollationTests.CheckCreateCollationBadUpper� � r z&old SQLite versions crash on this testc
C s� dd� }t jd�}|jd|� d}|j|�j� }| j|d d
dgd d
� |jdd � | jt j��}|j|�j� }W d Q R X | jt|j �d � d S )Nc S s | |k| |k S )Nr )r r r r r r @ s z3CollationTests.CheckCollationIsUsed.<locals>.mycollz:memory:r z�
select x from (
select 'a' as x
union
select 'b' as x
union
select 'c' as x
) order by x collate mycoll
�cr r z#the expected order was not returned)�msgz"no such collation sequence: mycoll)r' )r )r )
r r r r! r" r r
�OperationalErrorr r )r
r r �sqlr# r r r r �CheckCollationIsUsed= s
z#CollationTests.CheckCollationIsUsedc C sJ dd� }t jd�}|jd|� d}|j|�j� }| j|d d d
gd d
� d S )Nc S s | |k| |k d S )Nr& � l r )r r r r r r Y s z@CollationTests.CheckCollationReturnsLargeInteger.<locals>.mycollz:memory:r z�
select x from (
select 'a' as x
union
select 'b' as x
union
select 'c' as x
) order by x collate mycoll
r' r r z#the expected order was not returned)r( )r' )r )r )r r r r! r" r )r
r r r* r# r r r �!CheckCollationReturnsLargeIntegerX s
z0CollationTests.CheckCollationReturnsLargeIntegerc C sd t jd�}|jddd� � |jddd� � |jd�j� }| j|d d d� | j|d d d
� d S ) Nz:memory:r c S s | |k| |k S )Nr )r r r r r r q s z<CollationTests.CheckCollationRegisterTwice.<locals>.<lambda>c S s | |k| |k S )Nr )r r r r r r r s zi
select x from (select 'a' as x union select 'b' as x) order by x collate mycoll
r r r r )r r r r! r" r )r
r r# r r r �CheckCollationRegisterTwicek s
z*CollationTests.CheckCollationRegisterTwicec
C s^ t jd�}|jddd� � |jdd � | jt j��}|jd� W d Q R X | jt|j�d� d S )Nz:memory:r c S s | |k| |k S )Nr )r r r r r r s z9CollationTests.CheckDeregisterCollation.<locals>.<lambda>z?select 'a' as x union select 'b' as x order by x collate mycollz"no such collation sequence: mycoll) r r r r
r) r! r r r )r
r r r r r �CheckDeregisterCollationy s
z'CollationTests.CheckDeregisterCollationN)r% r& r )r r r r r r r$ �unittestZskipIfr Zsqlite_version_infor+ r- r. r/ r r r r r s r c @ s, e Zd Zdd� Zdd� Zdd� Zdd� Zd S )
�
ProgressTestsc s> t jd�}g � � fdd�}|j|d� |jd� | j� � d S )Nz:memory:c s � j d � dS )Nr )�appendr )�progress_callsr r �progress� s
z8ProgressTests.CheckProgressHandlerUsed.<locals>.progressr z0
create table foo(a, b)
)r r �set_progress_handlerr! �
assertTrue)r
r r4 r )r3 r �CheckProgressHandlerUsed� s
z&ProgressTests.CheckProgressHandlerUsedc sr t jd�}g � � fdd�}|j|d� |j� }|jd� t� �}g � |j|d� |jd� t� �}| j||� d S )Nz:memory:c s � j d � dS )Nr )r2 r )r3 r r r4 � s
z0ProgressTests.CheckOpcodeCount.<locals>.progressr z1
create table foo (a, b)
r& z1
create table bar (a, b)
)r r r5 �cursorr! �lenZassertGreaterEqual)r
r r4 �cursZ first_countZ second_countr )r3 r �CheckOpcodeCount� s
z ProgressTests.CheckOpcodeCountc sD t jd�}g � � fdd�}|j|d� |j� }| jt j|jd� d S )Nz:memory:c s � j d � dS )Nr )r2 r )r3 r r r4 � s
z4ProgressTests.CheckCancelOperation.<locals>.progressr zcreate table bar (a, b))r r r5 r8 r
r) r! )r
r r4 r: r )r3 r �CheckCancelOperation� s
z"ProgressTests.CheckCancelOperationc sR t jd�}d� � fdd�}|j|d� |jd d� |jd�j� | j� dd� d S )Nz:memory:r c s d� dS )Nr r r r )�actionr r r4 � s z1ProgressTests.CheckClearHandler.<locals>.progressr z&select 1 union select 2 union select 3z progress handler was not cleared)r r r5 r! r" r )r
r r4 r )r= r �CheckClearHandler� s
z ProgressTests.CheckClearHandlerN)r r r r7 r; r< r> r r r r r1 � s r1 c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�TraceCallbackTestsc sT t jd�}g � � fdd�}|j|� |jd� | j� � | jtdd� � D ��� d S )Nz:memory:c s � j | � d S )N)r2 )� statement)�traced_statementsr r �trace� s z8TraceCallbackTests.CheckTraceCallbackUsed.<locals>.tracezcreate table foo(a, b)c s s | ]}d |kV qdS )zcreate table fooNr )�.0�stmtr r r � <genexpr>� s z<TraceCallbackTests.CheckTraceCallbackUsed.<locals>.<genexpr>)r r �set_trace_callbackr! r6 �any)r
r rB r )rA r �CheckTraceCallbackUsed� s
z)TraceCallbackTests.CheckTraceCallbackUsedc sH t jd�}g � � fdd�}|j|� |jd � |jd� | j� d� d S )Nz:memory:c s � j | � d S )N)r2 )r@ )rA r r rB � s z9TraceCallbackTests.CheckClearTraceCallback.<locals>.tracezcreate table foo(a, b)z trace callback was not cleared)r r rF r! Z assertFalse)r
r rB r )rA r �CheckClearTraceCallback� s
z*TraceCallbackTests.CheckClearTraceCallbackc s� d�t jd�}g � � fdd�}|j|� |jd� |jd� � |j� | jt�fdd�� D ��d t��d
jt t� ��f � d S ) Nu öäüÖÄÜ߀z:memory:c s � j | � d S )N)r2 )r@ )rA r r rB � s z5TraceCallbackTests.CheckUnicodeContent.<locals>.tracezcreate table foo(x)z insert into foo(x) values ("%s")c 3 s | ]}� |kV qd S )Nr )rC rD )�
unicode_valuer r rE � s z9TraceCallbackTests.CheckUnicodeContent.<locals>.<genexpr>z-Unicode data %s garbled in trace callback: %sz, )
r r rF r! Zcommitr6 rG �ascii�join�map)r
r rB r )rA rJ r �CheckUnicodeContent� s
z&TraceCallbackTests.CheckUnicodeContentN)r r r rH rI rN r r r r r? � s
r? c C s4 t jtd�} t jtd�}t jtd�}t j| ||f�S )NZCheck)r0 Z makeSuiter r1 r? Z TestSuite)Zcollation_suiteZprogress_suiteZ trace_suiter r r �suite� s rO c C s t j� } | jt� � d S )N)r0 ZTextTestRunnerZrunrO )Zrunnerr r r �test s rP �__main__)
r0 Zsqlite3r ZTestCaser r1 r? rO rP r r r r r �<module> s jG1