�
L�Wc @ s� d d l m Z m Z m Z d d l m Z d d l Z d d l Z d g Z d e j f d � � YZ
e d k r� d d l Z e j
� n d S( i����( t cursorst OperationalErrort Warning( t baseNt
TestLoadLocalc B s, e Z d � Z d � Z d � Z d � Z RS( c C s_ | j d } | j � } | j d � z | j t | j d � Wd | j d � | j � Xd S( s3 Test load local infile when the file does not existi s3 CREATE TABLE test_load_local (a INTEGER, b INTEGER)sX LOAD DATA LOCAL INFILE 'no_data.txt' INTO TABLE test_load_local fields terminated by ','Ns DROP TABLE test_load_local( t connectionst cursort executet assertRaisesR t close( t selft connt c( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyt test_no_file s
c C s� | j d } | j � } | j d � t j j t j j t j j t � � d d � } zE | j d d j | � � | j d � | j
d | j � d � Wd | j d
� Xd S( s( Test load local infile with a valid filei s3 CREATE TABLE test_load_local (a INTEGER, b INTEGER)t datas load_local_data.txts( LOAD DATA LOCAL INFILE '{0}' INTO TABLE s( test_load_local FIELDS TERMINATED BY ','s$ SELECT COUNT(*) FROM test_load_locali�X Ns DROP TABLE test_load_local( R R R t ost patht joint dirnamet realpatht __file__t formatt assertEqualt fetchone( R
R R t filename( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyt test_load_file s
$
c C s� | j d } | j t j � } | j d � t j j t j j t j j t
� � d d � } zE | j d d j | � � | j d � | j d | j
� d � Wd | j � | j � | j � | j � } | j d
� Xd S( s3 Test unbuffered load local infile with a valid filei s3 CREATE TABLE test_load_local (a INTEGER, b INTEGER)R s load_local_data.txts( LOAD DATA LOCAL INFILE '{0}' INTO TABLE s( test_load_local FIELDS TERMINATED BY ','s$ SELECT COUNT(*) FROM test_load_locali�X Ns DROP TABLE test_load_local( R R R t SSCursorR R R R R R R R R R R t connect( R
R R R ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyt test_unbuffered_load_file- s"