MCPcopy Create free account
hub / github.com/PyMySQL/PyMySQL / test_issue_321

Method test_issue_321

pymysql/tests/test_issues.py:395–421  ·  view source on GitHub ↗

Test iterable as query argument.

(self)

Source from the content-addressed store, hash-verified

393 cur.execute("drop table if exists test_field_count")
394
395 def test_issue_321(self):
396 """Test iterable as query argument."""
397 conn = pymysql.connect(charset="utf8", **self.databases[0])
398 self.safe_create_table(
399 conn,
400 "issue321",
401 "create table issue321 (value_1 varchar(1), value_2 varchar(1))",
402 )
403
404 sql_insert = "insert into issue321 (value_1, value_2) values (%s, %s)"
405 sql_dict_insert = (
406 "insert into issue321 (value_1, value_2) values (%(value_1)s, %(value_2)s)"
407 )
408 sql_select = "select * from issue321 where value_1 in %s and value_2=%s"
409 data = [
410 [("a",), "\u0430"],
411 [["b"], "\u0430"],
412 {"value_1": [["c"]], "value_2": "\u0430"},
413 ]
414 cur = conn.cursor()
415 self.assertEqual(cur.execute(sql_insert, data[0]), 1)
416 self.assertEqual(cur.execute(sql_insert, data[1]), 1)
417 self.assertEqual(cur.execute(sql_dict_insert, data[2]), 1)
418 self.assertEqual(cur.execute(sql_select, [("a", "b", "c"), "\u0430"]), 3)
419 self.assertEqual(cur.fetchone(), ("a", "\u0430"))
420 self.assertEqual(cur.fetchone(), ("b", "\u0430"))
421 self.assertEqual(cur.fetchone(), ("c", "\u0430"))
422
423 def test_issue_364(self):
424 """Test mixed unicode/binary arguments in executemany."""

Callers

nothing calls this directly

Calls 5

safe_create_tableMethod · 0.80
cursorMethod · 0.80
executeMethod · 0.80
connectMethod · 0.45
fetchoneMethod · 0.45

Tested by

no test coverage detected