3 (hP @sddlZyddlmZddlZWn4ek rTejjdddlmZddlZYnXGdddejZ dgZ e dkrddl Z e j dS)N)basez ../pymysqlc@seZdZddZdS) TestSSCursorc Cs8d}|jd}d!d"d#d$d%d&d'd(d)d*g }z|jtjj}|jd|jx*|D]"}|jd||j|jddqPW|j d}|jdx`|j }|dkrP|d7}|j|j |dt ||j|j |dt ||j||kddqW|jd|jt|jt|d|jd|jt|jdddx|j }|dkr6Pq6W|jddg|j |j|j t|dt t||jd||j|j t|dt t||jd|jt|d+g|j|j|jt|d,g|j|j|jt|d-g|j|jWd|jd |jXdS).NlrAmericaAmerica/JamaicaAmerica/Los_Angeles America/LimaAmerica/New_YorkAmerica/MenomineeAmerica/HavanaAmerica/El_SalvadorAmerica/Costa_RicaAmerica/DenverAmerica/DetroitzKCREATE TABLE tz_data (region VARCHAR(64),zone VARCHAR(64),name VARCHAR(64))z'INSERT INTO tz_data VALUES (%s, %s, %s)zaffected_rows does not matchzSELECT * FROM tz_datazcursor.rowcount != %sTzRow not found in source dataz.fetchall failed. Number of rows does not matchz/fetchmany failed. Number of rows does not matchzUPDATE tz_data SET zone = %sZFooz"Update failed. affected_rows != %sz)executemany failed. cursor.rowcount != %szSELECT 1; SELECT 2; SELECT 3zDROP TABLE tz_data)rrr)rrr)rrr)rrr )rrr )rrr )rrr )rrr )rrr)rrr)r)r)r) connectionscursorpymysqlZcursorsZSSCursorexecutebeginZ assertEqual affected_rowscommitZfetchoneZrowcountstrZ rownumberlenZfetchallZ fetchmanyZ executemanyZassertListEquallistZ assertTrueZnextsetZ assertFalseclose) selfrconndatariiterrowresr%@/tmp/pip-install-q3hcpn_q/PyMySQL/pymysql/tests/test_SSCursor.py test_SSCursor sv               zTestSSCursor.test_SSCursorN)__name__ __module__ __qualname__r'r%r%r%r&r sr__main__)sysZ pymysql.testsrZpymysql.cursorsr ExceptionpathappendZPyMySQLTestCaser__all__r(Zunittestmainr%r%r%r&s    ^