Skip to content

Commit 42e9ada

Browse files
committed
purge off warnings
1 parent 8522474 commit 42e9ada

File tree

1 file changed

+5
-21
lines changed

1 file changed

+5
-21
lines changed

pymysql/tests/test_issues.py

Lines changed: 5 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -413,43 +413,27 @@ def test_issue_364(self):
413413
"create table issue364 (value_1 binary(3), value_2 varchar(3)) "
414414
"engine=InnoDB default charset=utf8")
415415

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)"
417417
usql = u"insert into issue364 (value_1, value_2) values (_binary%s, _binary%s)"
418418
values = [b"\x00\xff\x00", u"\xe4\xf6\xfc"]
419419

420420
# test single insert and select
421421
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)
427423
cur.execute("select * from issue364")
428424
self.assertEqual(cur.fetchone(), tuple(values))
429425

430426
# 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)
436428

437429
# 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))
443431
cur.execute("select * from issue364")
444432
for row in cur.fetchall():
445433
self.assertEqual(row, tuple(values))
446434

447435
# 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))
453437

454438
def test_issue_363(self):
455439
""" Test binary / geometry types. """

0 commit comments

Comments
 (0)