File: //opt/alt/python38/lib/python3.8/site-packages/pymysql/tests/__pycache__/test_issues.cpython-38.pyc
U
��W O � @ s� d dl Z d dlZd dlZd dlZd dlZd dlmZ d dlmZ d dlm Z d dl
Z
zd dl Z e j Z W n e
k
rz Y nX dddgZG dd� de j�ZG d d� de j�ZG d
d� de j�ZdS ) � N)�cursors)� text_type)�base�
TestOldIssues�
TestNewIssues�TestGitHubIssuesc @ sf e Zd Zdd� Zdd� Zdd� Zdd� Zd d
� Zd d � Zd
d� Z dd� Z
dd� Z e �
d�dd� �ZdS )r c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z�|�dd� |�d� | �d |�� d � |�d
� | �d |�� d � |�d � | �d |�� d � |�d � | �t |�� d t
j
�� W 5 |�d� X d S )
z2 undefined methods datetime_or_None, date_or_None r �ignorezdrop table if exists issue3z?create table issue3 (d date, t time, dt datetime, ts timestamp)zdrop table issue3z6insert into issue3 (d, t, dt, ts) values (%s,%s,%s,%s))NNNNzselect d from issue3Nzselect t from issue3zselect dt from issue3zselect ts from issue3) � connections�cursor�warnings�catch_warnings�filterwarnings�execute� assertEqual�fetchone�
assertTrue�
isinstance�datetime��self�conn�c� r �J/opt/alt/python38/lib/python3.8/site-packages/pymysql/tests/test_issues.py� test_issue_3 s"
zTestOldIssues.test_issue_3c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z2|�d� |�d� | �t|�� d t j �� W 5 |�d� X dS ) z! can't retrieve TIMESTAMP fields r r zdrop table if exists issue4z"create table issue4 (ts timestamp)zdrop table issue4z&insert into issue4 (ts) values (now())zselect ts from issue4N)
r r
r r r
r r r r r r r r r � test_issue_4+ s
zTestOldIssues.test_issue_4c C s | j d }|�� }|�d� dS )z* query on information_schema.tables fails r z'select * from information_schema.tablesN)r r
r )r Zcon�curr r r � test_issue_5: s
zTestOldIssues.test_issue_5c C s@ | j d �� }d|d< tjf |�}|�� }|�d� |�� dS )zP exception: TypeError: ord() expected a character, but string of length 0 found r Zmysql�dbzselect * from userN)� databases�copy�pymysql�connectr
r �close)r �kwargsr r r r r � test_issue_6@ s
zTestOldIssues.test_issue_6c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z2| �d|�d�� |�d� | �d|�d�� W 5 |�d� X dS ) z1 Primary Key and Index error when selecting data r r zdrop table if exists testa CREATE TABLE `test` (`station` int(10) NOT NULL DEFAULT '0', `dh`
datetime NOT NULL DEFAULT '2015-01-01 00:00:00', `echeance` int(1) NOT NULL
DEFAULT '0', `me` double DEFAULT NULL, `mo` double DEFAULT NULL, PRIMARY
KEY (`station`,`dh`,`echeance`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;zdrop table testzSELECT * FROM testz6ALTER TABLE `test` ADD INDEX `idx_station` (`station`)N)r r
r r r
r r r r r r � test_issue_8J s
zTestOldIssues.test_issue_8c C s. z t t� W n tk
r( | �� Y nX dS )z' sets DeprecationWarning in Python 2.6 N)�reloadr! �DeprecationWarning�fail)r r r r � test_issue_9\ s zTestOldIssues.test_issue_9c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X zL|�d� d}|�dd| f� |�d � |�� d }| �d| |k� W 5 |�d� X d
S ) z" can't handle large result fields r r z drop table if exists issue13zdrop table issue13z create table issue13 (t text)i H z#insert into issue13 (t) values (%s)�xzselect t from issue13N)r r
r r r
r r r )r r r �size�rr r r �
test_issue_13c s
zTestOldIssues.test_issue_13c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z.|�dd� |�d� | �d |�� d � W 5 |�d� X d
S ) z< query should be expanded before perform character encoding r r z drop table if exists issue15z$create table issue15 (t varchar(32))zdrop table issue15z#insert into issue15 (t) values (%s))� äöüzselect t from issue15r/ N�r r
r r r
r r r r r r r �
test_issue_15v s
zTestOldIssues.test_issue_15c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z.|�d� |�dd� | �d |�� d � W 5 |�d� X d
S ) z% Patch for string and tuple escaping r r z drop table if exists issue16zFcreate table issue16 (name varchar(32) primary key, email varchar(32))zdrop table issue16z@insert into issue16 (name, email) values ('pete', 'floydophone')z'select email from issue16 where name=%s)ZpeteZ floydophoneNr0 r r r r �
test_issue_16� s
zTestOldIssues.test_issue_16zRtest_issue_17() requires a custom, legacy MySQL configuration and will not be run.c C s� | j d }| jd d }| jd d }|�� }z�t�� � t�d� |�d� W 5 Q R X |�d� |�d� |�d | � |�� tj |d
d |d �}|�� }|�d
� | �
d|� � d � W 5 |�d� X dS )z#could not connect mysql use passwodr �hostr zdrop table issue17r z drop table if exists issue17z0create table issue17 (x varchar(32) primary key)z0insert into issue17 (x) values ('hello, world!')zMgrant all privileges on %s.issue17 to 'issue17user'@'%%' identified by '1234'Z issue17userZ1234)r3 �user�passwdr zselect x from issue17z
hello, world!N) r r r
r r r r
�commitr! r" r r )r r r3 r r Zconn2Zc2r r r �
test_issue_17� s"
zTestOldIssues.test_issue_17N)�__name__�
__module__� __qualname__r r r r% r& r* r. r1 r2 � unittest2�skipr7 r r r r r s
c @ sN e Zd Zdd� Zdd� Ze�d�dd� �Zdd � Zd
d � Z d d
� Z
dd� Z dS )r c
C sr z t jdddd� | �� W nP t jk
rR } z| �d|jd � W 5 d }~X Y n tk
rl | �� Y nX d S )N� localhosti� �root)r3 �portr4 i� r )r! r" r) �OperationalErrorr �args� Exception)r �er r r �
test_issue_34� s "zTestNewIssues.test_issue_34c C s\ t jf ddi| jd ��}| �|dd� |�� }|�d� |�d� | �d|�� d � d S ) N�charset�utf8r u heißeu& create table heiße (name varchar(32))u, insert into heiße (name) values ('Pißata')u select name from heißeu Pißata)r! r" r �safe_create_tabler
r r r r r r r �
test_issue_33� s �
zTestNewIssues.test_issue_33z&This test requires manual interventionc
C sl | j d }|�� }td� z|�d� | �� W n6 tjk
rf } z| �d|jd � W 5 d }~X Y nX d S )Nr z1sudo killall -9 mysqld within the next 10 secondszselect sleep(10)i� ) r r
�printr r) r! r@ r rA )r r r rC r r r �
test_issue_35� s
zTestNewIssues.test_issue_35c C s | j d }|�� }|�d� d }|�� D ]$}|d }|d }|dkr(|} qNq(| �||�� � | j d �|� z|�d� | �� W n tk
r� Y nX |� � |� � zFt
� d� | j d �� }|�d� dd� |�� D �}| � ||k� W 5 | j d= X d S ) N� zshow processlistr � z show tablesg�������?c S s g | ] }|d �qS )r r )�.0�rowr r r �
<listcomp>� s z/TestNewIssues.test_issue_36.<locals>.<listcomp>)
r r
r �fetchallr � thread_id�killr) rB r# �time�sleep� assertFalse)r r r Zkill_idrN �id�infoZidsr r r �
test_issue_36� s4
zTestNewIssues.test_issue_36c C sT | j d }|�� }| �d|�d�� | �d|�� � | �d|�d�� |�d� d S )Nr rK z SELECT @foo)NzSET @foo = 'bar'zset @foo = 'bar')r r
r r r r r r r �
test_issue_37� s
zTestNewIssues.test_issue_37c C sp | j d }|�� }dd }zDt�� � t�d� |�d� W 5 Q R X |�d� |�d|f� W 5 |�d� X d S ) Nr A aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaai� zdrop table issue38r z drop table if exists issue38z2create table issue38 (id integer, data mediumblob)z"insert into issue38 values (1, %s))r r
r r r r
)r r r Zdatumr r r �
test_issue_38� s
zTestNewIssues.test_issue_38c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X d}|d�dd� tdd�D ��7 }z6|�d
� |�d � |�|� | �d |� � d � W 5 |�d � X d S )
Nr r z drop table if exists issue54z select * from issue54 where z and c s s | ]}d ||f V qdS )z%d=%dNr �rM �ir r r � <genexpr> s z7TestNewIssues.disabled_test_issue_54.<locals>.<genexpr>i�� zdrop table issue54z-create table issue54 (id integer primary key)z#insert into issue54 (id) values (7)rL )
r r
r r r
r �join�ranger r )r r r Zbig_sqlr r r �disabled_test_issue_54 s
z$TestNewIssues.disabled_test_issue_54N) r8 r9 r: rD rH r; r< rJ rX rY rZ r` r r r r r � s
$c @ sT e Zd Zdd� Zdd� Zdd� Zdd� Zd d
� Zd d � Zd
d� Z dd� Z
dd� Z dS )r c C s� | j d }|�� }| �d|�� � zZt�� � t�d� |�d� W 5 Q R X |�d� |�d� |�d� | �d|�� � W 5 |�d� X dS ) z2 'Connection' object has no attribute 'insert_id' r zdrop table issue66r z drop table if exists issue66zGcreate table issue66 (id integer primary key auto_increment, x integer)z"insert into issue66 (x) values (1)� N)r r
r � insert_idr r r r
r r r r �
test_issue_66 s
z TestGitHubIssues.test_issue_66c C s� | j d }|�tjj�}t�� �$ t�d� |�d� |�d� W 5 Q R X |�d� |�d� d}d}zb|�d |� |�d |� |�d
� |� � d }| �
|d d� | �
|d d� | �
|d d� W 5 |�d � |�d
� X dS )zI Duplicate field overwrites the previous one in the result of DictCursor r r zdrop table if exists azdrop table if exists bz"CREATE TABLE a (id int, value int)z"CREATE TABLE b (id int, value int))rK � )rK � z drop table az drop table bz insert into a values (%s, %s)z insert into b values (%s, %s)z+SELECT * FROM a inner join b on a.id = b.idrV rK �valuerd zb.valuere N) r r
r! r �
DictCursorr r r
r rP r )r r r �a�br- r r r �
test_issue_79' s(
z TestGitHubIssues.test_issue_79c C s� | j d }|�� }t�� � t�d� |�d� W 5 Q R X |�d� z,|�d� |�d� | �|�� d d� W 5 t�� � t�d� |�d� W 5 Q R X X dS ) z6 Leftover trailing OK packet for "CALL my_sp" queries r r z DROP PROCEDURE IF EXISTS `foo`zICREATE PROCEDURE `foo` ()
BEGIN
SELECT 1;
ENDz
CALL foo()zSELECT 1rK Nr0 )r r r r r r �
test_issue_95B s
z TestGitHubIssues.test_issue_95c C s� t jf ddi| jd ��}|�d� |�� }|�d� | �|�� d � |�� |� � |�d� | �|�� d � |�� t jf ddi| jd ��}|�� }|�d� | �|�� d � |�� |� � |�d� |�d� | �
|�� d � |�� dS )z6 autocommit is not set after reconnecting with ping() rE rF r Fzselect @@autocommit;TN) r! r" r �
autocommitr
r rU r r# �pingr r r r r �test_issue_114V s(
z TestGitHubIssues.test_issue_114c C s� | j d }|�� }dD ]|}d�dd� t|�D ��}d�|�}z*|�|� |�d � t |j
�|ksdt �W 5 t�� � t�d� |�d� W 5 Q R X X qd
S ) z> The number of fields returned by server is read in wrong way r )�� i, z, c s s | ]}d � |�V qdS )z c{0} integerN)�formatr[ r r r r] t s z2TestGitHubIssues.test_issue_175.<locals>.<genexpr>z#create table test_field_count ({0})r z%drop table if exists test_field_countz select * from test_field_countN) r r
r^ r_ rp r r r
r �len� description�AssertionError)r r r �length�columns�sqlr r r �test_issue_175o s
z TestGitHubIssues.test_issue_175c C s� t jf ddi| jd ��}| �|dd� d}d}d}d d
gd gd
gd ggd
d
�g}|�� }| �|�||d �d� | �|�||d �d� | �|�||d �d� | �|�|dd
g�d� | �|�� d� | �|�� d� | �|�� d� dS )z" Test iterable as query argument. rE rF r Zissue321z>create table issue321 (value_1 varchar(1), value_2 varchar(1))z7insert into issue321 (value_1, value_2) values (%s, %s)zIinsert into issue321 (value_1, value_2) values (%(value_1)s, %(value_2)s)z9select * from issue321 where value_1 in %s and value_2=%s)rh � аri r )Zvalue_1Zvalue_2rK ra )rh ri r � )rh rx )ri rx )r rx N)r! r" r rG r
r r r )r r Z
sql_insertZsql_dict_insertZ
sql_select�datar r r r �test_issue_321 s0 � � �z TestGitHubIssues.test_issue_321c C s� t jf ddi| jd ��}| �|dd� d}d}t �d�dg}|�� }|j||d � |�d
� | �|�� t |�� |j||d � |j
||||fd � |�d
� |� � D ]}| �|t |�� q�|j
||||fd � d S ) z5 Test mixed unicode/binary arguments in executemany. rE rF r Zissue364z`create table issue364 (value_1 binary(3), value_2 varchar(3)) engine=InnoDB default charset=utf8z7insert into issue364 (value_1, value_2) values (%s, %s)s � r/ )rA zselect * from issue364N) r! r" r rG �Binaryr
r r r �tuple� executemanyrP )r r rv Zusql�valuesr rN r r r �test_issue_364� s& �
z TestGitHubIssues.test_issue_364c C sB t jf ddi| jd ��}| �|dd� |�� }d}| �|d�rf| �t jj��}|� |� W 5 Q R X n
|� |� d}| �|d�r�| �t jj��}|� |� W 5 Q R X n
|� |� |�
� }| � |d � d
}| �|d�r�| �t jj��}|� |� W 5 Q R X n
|� |� |�
� }| � |d � |� d � |�
� }| � t
|d t�� d
S )z Test binary / geometry types. rE rF r Zissue363z�CREATE TABLE issue363 ( id INTEGER PRIMARY KEY, geom LINESTRING NOT NULL, SPATIAL KEY geom (geom)) ENGINE=MyISAM default charset=utf8zYINSERT INTO issue363 (id, geom) VALUES(1998, GeomFromText('LINESTRING(1.1 1.1,2.2 2.2)')))� rL r z!SELECT AsText(geom) FROM issue363)zLINESTRING(1.1 1.1,2.2 2.2)z#SELECT AsBinary(geom) FROM issue363)s) �������?�������?������@������@zSELECT geom FROM issue363N)r! r" r rG r
Zmysql_server_isZ assertWarns�err�Warningr r r r r �bytes)r r r �query�cmrN r r r �test_issue_363� s> �
�
z TestGitHubIssues.test_issue_363c C s� t jf ddi| jd ��}t�� �� t�d� tjdt jd� tjtj fD ]�}|�
|�}z�z|� d� |�
� W n^ t jk
r� } z>| �t|j�d� | �|jd d � | �t|jd
t�� W 5 d }~X Y n X | �d � W 5 |� � X qJW 5 Q R X d S )
z Test warning propagation rE rF r r �error)�categoryz SELECT CAST('124b' AS SIGNED)ra i rK NzShould raise Warning)r! r" r r r � simplefilterr� r �Cursor�SSCursorr
r# r rP r rq rA r r r r) )r r Z cursor_classr rC r r r �test_issue_491� s
(z TestGitHubIssues.test_issue_491N) r8 r9 r: rc rj rk rn rw r{ r� r� r� r r r r r s 4)r rS r �sysr! r Zpymysql._compatr Z
pymysql.testsr r; �impr' �AttributeError�__all__ZPyMySQLTestCaser r r r r r r �<module> s$
i