3  (ƒh­ã@s2ddlZddlmZddlZGdd„dejƒZdS)éN)Úbasecs4eZdZ‡fdd„Zdd„Zdd„Zdd„Z‡ZS) Ú CursorTestcsftt|ƒjƒ|jd}|j|ddƒ|jƒ}|jdƒ|jƒtj f|j dŽ|_ |j |j jƒdS)NrÚtestz$create table test (data varchar(10))zOinsert into test (data) values ('row1'), ('row2'), ('row3'), ('row4'), ('row5')) ÚsuperrÚsetUpÚ connectionsZsafe_create_tableÚcursorÚexecuteÚcloseÚpymysqlÚconnectZ databasesÚtest_connectionZ addCleanup)ÚselfÚconnr)Ú __class__©ú>/tmp/pip-install-q3hcpn_q/PyMySQL/pymysql/tests/test_cursor.pyrs zCursorTest.setUpcCs||j}|jtjjƒ}|jdƒxt|ƒD]\}}|dkr(Pq(W~|jƒ|jƒ}|jdƒ|j|j ƒdƒ|j |j ƒƒdS)Nz$select * from test as t1, test as t2é zselect 1é)r) r rr ÚcursorsZSSCursorr Ú enumerateÚsafe_gc_collectÚ assertEqualÚfetchoneÚ assertIsNone)rrrÚcounterÚrowÚc2rrrÚtest_cleanup_rows_unbuffereds  z'CursorTest.test_cleanup_rows_unbufferedcCs||j}|jtjjƒ}|jdƒxt|ƒD]\}}|dkr(Pq(W~|jƒ|jƒ}|jdƒ|j|j ƒdƒ|j |j ƒƒdS)Nz$select * from test as t1, test as t2rzselect 1r)r) r rr rÚCursorr rrrrr)rrrrrrrrrÚtest_cleanup_rows_buffered)s   z%CursorTest.test_cleanup_rows_bufferedc Cs‚|j}|jtjjƒ}tjjjdƒ}|j|dƒ|j|j dƒddƒtjjjdƒ}|j|dƒ|j|j dƒddƒtjjjdƒ}|j|d ƒ|j|j dƒddƒtjjjd ƒ}|j|d ƒ|j|j dƒd d ƒt d ƒ}|j d|ƒ|j |j jdƒdƒdd„t d ƒDƒ}|j d|ƒ|j |j jdƒdƒ|jdƒz@d}|jtjjj|ƒƒ|j |ddgƒ|j |j jdƒdƒWd|jdƒXdS)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?rz#insert into test (data) values (%s)s ,(7),(8),(9)z%execute many with %s not in one querycSsg|] }d|i‘qS)Údatar)Ú.0Úirrrú Ysz/CursorTest.test_executemany..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)z7INSERT INTO percent_test (`A%%`, `B%%`) VALUES (%s, %s)ééés (3, 4),(5, 6)z$executemany with %% not in one queryz!DROP TABLE IF EXISTS percent_test)r!r')r(r))r rr rrZRE_INSERT_VALUESÚmatchZassertIsNotNonerÚgroupÚrangeZ executemanyZ assertTrueZ _executedÚendswithr )rrrÚmr#Z data_dictÚqrrrÚtest_executemany>s8      zCursorTest.test_executemany)Ú__name__Ú __module__Ú __qualname__rrr r0Ú __classcell__rr)rrrs r)ÚwarningsZ pymysql.testsrZpymysql.cursorsr ZPyMySQLTestCaserrrrrÚs