�
���Wc @ s� d d l m Z d d l Z d d l Z d d l Z d e j f d � � YZ d e f d � � YZ e d k r� d d l
Z
e
j � n d S( i����( t baseNt TestDictCursorc B s� e Z i d d 6d d 6e j d d d d d d � d
6Z i d d 6d d 6e j d d
d d d d � d
6Z i d d 6d d 6e j d d d d d d � d
6Z e j j Z d � Z
d � Z d � Z d � Z
d � Z RS( t bobt namei t agei� i i i i i8 t DOBt jimi� i i i
i i- t fredid iw i c C s� t t | � j � | j d | _ } | j | j � } t j � �, t j d � | j
d � | j
d � Wd QXd d d g } | j d | � d S( Ni t ignores drop table if exists dictcursors? CREATE TABLE dictcursor (name char(20), age int , DOB datetime)R i s 1990-02-06 23:04:56R i8 s 1955-05-09 13:12:45R id s 1911-09-12 01:01:01s( insert into dictcursor values (%s,%s,%s)( R i s 1990-02-06 23:04:56( R i8 s 1955-05-09 13:12:45( R id s 1911-09-12 01:01:01( t superR t setUpt connectionst connt cursort cursor_typet warningst catch_warningst filterwarningst executet executemany( t selfR t ct data( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR
s
c C s3 | j j � } | j d � t t | � j � d S( Ns drop table dictcursor( R R
R R R t tearDown( R R ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR s
c C s d S( N( ( R R
( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyt _ensure_cursor_expired% s c C s� | j j � | j j � | j j � } } } | j } | j | j � } | j d � d | d <| j d � | j � } | j | | d � | j
| � | j d � | j � } | j | g | d � | j d � x! | D] } | j | | d � q� W| j d � | j � } | j | | | g | d � | j d � t | � } | j | | | g | d
� | j d � | j
d � } | j | | g | d � | j
| � d S(
Ns- update dictcursor set age=20 where name='bob'i R s) SELECT * from dictcursor where name='bob's fetchone via DictCursor faileds7 fetch a 1 row result via fetchall failed via DictCursors8 fetch a 1 row result via iteration failed via DictCursors SELECT * from dictcursors fetchall failed via DictCursors DictCursor should be iterablei s fetchmany failed via DictCursor( R t copyR R R R
R R t fetchonet assertEqualR t fetchallt listt fetchmany( R R R R R R t r( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyt test_DictCursor( s2 /
c s� d t f d � � Y� d | j f � f d � � Y} d d d g } � g | D] } | | j | f ^ qN � } � g | D] } | | j | f ^ qz � } � g | D] } | | j | f ^ q� � } | j j | � } | j d � | j � } | j | | d � | j
| � | j d
� | j � } | j | | | g | d � | j d
� t | � } | j | | | g | d � | j d
� | j
d
� } | j | | g | d � | j
| � d S( Nt MyDictc B s e Z RS( ( t __name__t
__module__( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR! N s t MyDictCursorc s e Z � Z RS( ( R" R# t dict_type( ( R! ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR$ P s R R R s) SELECT * FROM dictcursor WHERE name='bob's fetchone() returns MyDictCursors SELECT * FROM dictcursors fetchall failed via MyDictCursors list failed via MyDictCursori ( t dictR R R R R R
R R R R R R R ( R R$ t keyst kR R R t curR ( ( R! sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyt test_custom_dictM s0 ,,,
( R" R# t datetimeR R R t pymysqlt cursorst
DictCursorR R
R R R R* ( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR s 333 %t TestSSDictCursorc B s e Z e j j Z d � Z RS( c C s t | j � � d S( N( R t fetchall_unbuffered( R R
( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR r s ( R" R# R, R- t SSDictCursorR R ( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyR/ o s t __main__( t
pymysql.testsR t pymysql.cursorsR, R+ R t PyMySQLTestCaseR R/ R" t unittestt main( ( ( sA /usr/lib/python2.7/site-packages/pymysql/tests/test_DictCursor.pyt <module> s g 