@@ -413,43 +413,27 @@ def test_issue_364(self):
413
413
"create table issue364 (value_1 binary(3), value_2 varchar(3)) "
414
414
"engine=InnoDB default charset=utf8" )
415
415
416
- sql = "insert into issue364 (value_1, value_2) values (%s, %s)"
416
+ sql = "insert into issue364 (value_1, value_2) values (_binary %s, _binary %s)"
417
417
usql = u"insert into issue364 (value_1, value_2) values (_binary%s, _binary%s)"
418
418
values = [b"\x00 \xff \x00 " , u"\xe4 \xf6 \xfc " ]
419
419
420
420
# test single insert and select
421
421
cur = conn .cursor ()
422
- if sys .version_info [0 :2 ] >= (3 ,2 ) and self .mysql_server_is (conn , (5 , 7 , 0 )):
423
- with self .assertWarns (pymysql .err .Warning ) as cm :
424
- cur .execute (sql , args = values )
425
- else :
426
- cur .execute (sql , args = values )
422
+ cur .execute (sql , args = values )
427
423
cur .execute ("select * from issue364" )
428
424
self .assertEqual (cur .fetchone (), tuple (values ))
429
425
430
426
# test single insert unicode query
431
- if sys .version_info [0 :2 ] >= (3 ,2 ) and self .mysql_server_is (conn , (5 , 7 , 0 )):
432
- with self .assertWarns (pymysql .err .Warning ) as cm :
433
- cur .execute (usql , args = values )
434
- else :
435
- cur .execute (usql , args = values )
427
+ cur .execute (usql , args = values )
436
428
437
429
# test multi insert and select
438
- if sys .version_info [0 :2 ] >= (3 ,2 ) and self .mysql_server_is (conn , (5 , 7 , 0 )):
439
- with self .assertWarns (pymysql .err .Warning ) as cm :
440
- cur .executemany (sql , args = (values , values , values ))
441
- else :
442
- cur .executemany (sql , args = (values , values , values ))
430
+ cur .executemany (sql , args = (values , values , values ))
443
431
cur .execute ("select * from issue364" )
444
432
for row in cur .fetchall ():
445
433
self .assertEqual (row , tuple (values ))
446
434
447
435
# test multi insert with unicode query
448
- if sys .version_info [0 :2 ] >= (3 ,2 ) and self .mysql_server_is (conn , (5 , 7 , 0 )):
449
- with self .assertWarns (pymysql .err .Warning ) as cm :
450
- cur .executemany (usql , args = (values , values , values ))
451
- else :
452
- cur .executemany (usql , args = (values , values , values ))
436
+ cur .executemany (usql , args = (values , values , values ))
453
437
454
438
def test_issue_363 (self ):
455
439
""" Test binary / geometry types. """
0 commit comments