D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
3206095
/
root
/
lib
/
python2.7
/
site-packages
/
pymysql
/
tests
/
Filename :
test_load_local.pyo
back
Copy
� 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" $ c C s | j d } | j � } | j d � t j j t j j t j j t � � d d � } z� t j d t � �� } t j d � | j d d j | � � | j | d j t � d } | t | d j � k r� | j d | | d j f � n Wd QXWd | j d � | j � Xd S( s8 Test load local infile produces the appropriate warningsi s3 CREATE TABLE test_load_local (a INTEGER, b INTEGER)R s load_local_warn_data.txtt recordt alwayss( LOAD DATA LOCAL INFILE '{0}' INTO TABLE s( test_load_local FIELDS TERMINATED BY ','s Incorrect integer valuei����s %r not in %rNs DROP TABLE test_load_local( R R R R R R R R R t warningst catch_warningst Truet simplefilterR R t categoryR t strt messaget failR ( R R R R t wt expected_message( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyt test_load_warningsC s$ $ + ( t __name__t __module__R R R R) ( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyR s t __main__( t pymysqlR R R t pymysql.testsR R R t __all__t PyMySQLTestCaseR R* t unittestt main( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_load_local.pyt <module> s Q