| 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() |