File: //opt/alt/python38/lib/python3.8/site-packages/pymysql/tests/__pycache__/test_cursor.cpython-38.pyc
U
��W� � @ s2 d dl Z d dlmZ d dlZG dd� dej�ZdS )� N)�basec s4 e Zd Z� fdd�Zdd� Zdd� Zdd� Z� ZS ) �
CursorTestc sf t t| ��� | jd }| �|dd� |�� }|�d� |�� tj f | j
d �| _ | � | j j� d S )Nr Ztestz$create table test (data varchar(10))zOinsert into test (data) values ('row1'), ('row2'), ('row3'), ('row4'), ('row5'))
�superr �setUpZ connectionsZsafe_create_table�cursor�execute�close�pymysqlZconnectZ databases�test_connectionZ
addCleanup)�self�connr �� __class__� �/test_cursor.pyr s
��zCursorTest.setUpc C sz | j }|�tjj�}|�d� t|�D ]\}}|dkr& q<q&~| �� |�� }|�d� | �|� � d� | �
|� � � d S �Nz$select * from test as t1, test as t2�
zselect 1)� ) r
r r �cursorsZSSCursorr � enumerate�safe_gc_collect� assertEqual�fetchone� assertIsNone�r r r Zcounter�rowZc2r r r � test_cleanup_rows_unbuffered s
z'CursorTest.test_cleanup_rows_unbufferedc C sz | j }|�tjj�}|�d� t|�D ]\}}|dkr& q<q&~| �� |�� }|�d� | �|� � d� | �
|� � � d S r ) r
r r r �Cursorr r r r r r r r r r �test_cleanup_rows_buffered) s
�z%CursorTest.test_cleanup_rows_bufferedc C s� | j }|�tjj�}tjj�d�}| �|d� | �|� d�dd� tjj�d�}| �|d� | �|� d�dd� tjj�d�}| �|d � | �|� d�dd� tjj�d
�}| �|d � | �|� d�d d � t
d
�}|� d|� | � |j
�d�d� dd� t
d
�D �}|� d|� | � |j
�d�d� |�d� z@d}| �tjj�|�� |� |ddg� | � |j
�d�d� W 5 |�d� X d S ) Nz+INSERT INTO TEST (ID, NAME) VALUES (%s, %s)zerror parse %s� � z+group 3 not blank, bug in RE_INSERT_VALUES?z5INSERT INTO TEST (ID, NAME) VALUES (%(id)s, %(name)s)zerror parse %(name)sz:INSERT INTO TEST (ID, NAME) VALUES (%(id_name)s, %(name)s)zerror parse %(id_name)szNINSERT INTO TEST (ID, NAME) VALUES (%(id_name)s, %(name)s) ON duplicate updatez ON duplicate updatez9group 3 not ON duplicate update, bug in RE_INSERT_VALUES?r z#insert into test (data) values (%s)s ,(7),(8),(9)z%execute many with %s not in one queryc S s g | ] }d |i�qS )�datar )�.0�ir r r �
<listcomp>Y s z/CursorTest.test_executemany.<locals>.<listcomp>z)insert into test (data) values (%(data)s)z+execute many with %(data)s not in one queryzc CREATE TABLE percent_test (
`A%` INTEGER,
`B%` INTEGER)z!DROP TABLE IF EXISTS percent_testz7INSERT INTO percent_test (`A%%`, `B%%`) VALUES (%s, %s))r � )� � s
(3, 4),(5, 6)z$executemany with %% not in one query)r
r r r r ZRE_INSERT_VALUES�matchZassertIsNotNoner �group�rangeZ executemanyZ
assertTrueZ _executed�endswithr )r r r �mr! Z data_dict�qr r r �test_executemany> s6
zCursorTest.test_executemany)�__name__�
__module__� __qualname__r r r r. �
__classcell__r r r
r r s r )�warningsZ
pymysql.testsr Zpymysql.cursorsr ZPyMySQLTestCaser r r r r �<module> s