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

Method test_escape_sequence

pymysql/tests/test_connection.py:918–932  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

916 self.assertEqual(con.escape("foo'bar"), "'foo''bar'")
917
918 def test_escape_sequence(self):
919 con = self.connect()
920 cur = con.cursor()
921 values = ("foo'bar", "foo\\bar", "foo\\'bar", "foo') OR 1=1 -- ")
922
923 for sql_mode in ("", "NO_BACKSLASH_ESCAPES"):
924 cur.execute("SET sql_mode=%s", (sql_mode,))
925 for container in (tuple, list, set, frozenset):
926 with self.subTest(sql_mode=sql_mode, container=container):
927 items = container(values)
928 for value in values:
929 cur.execute("SELECT %s IN %s", (value, items))
930 self.assertEqual(cur.fetchone(), (1,))
931 cur.execute("SELECT %s IN %s", ("not included", items))
932 self.assertEqual(cur.fetchone(), (0,))
933
934 def test_escape_nested_sequence(self):
935 con = self.connect()

Callers

nothing calls this directly

Calls 4

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

Tested by

no test coverage detected