| 902 | |
| 903 | |
| 904 | class TestEscape(base.PyMySQLTestCase): |
| 905 | def test_escape_string(self): |
| 906 | con = self.connect() |
| 907 | cur = con.cursor() |
| 908 | |
| 909 | self.assertEqual(con.escape("foo'bar"), "'foo\\'bar'") |
| 910 | # added NO_AUTO_CREATE_USER as not including it in 5.7 generates warnings |
| 911 | # mysql-8.0 removes the option however |
| 912 | if self.mysql_server_is(con, (8, 0, 0)): |
| 913 | cur.execute("SET sql_mode='NO_BACKSLASH_ESCAPES'") |
| 914 | else: |
| 915 | cur.execute("SET sql_mode='NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER'") |
| 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() |
| 936 | cur = con.cursor() |
| 937 | cur.execute("SET sql_mode='NO_BACKSLASH_ESCAPES'") |
| 938 | rows = (("foo'bar", "foo\\bar"), ("baz", "qux")) |
| 939 | cur.execute("SELECT (%s, %s) IN %s", ("foo'bar", "foo\\bar", rows)) |
| 940 | self.assertEqual(cur.fetchone(), (1,)) |
| 941 | cur.execute("SELECT (%s, %s) IN %s", ("foo'bar", "qux", rows)) |
| 942 | self.assertEqual(cur.fetchone(), (0,)) |
| 943 | |
| 944 | def test_escape_builtin_encoders(self): |
| 945 | con = self.connect() |
| 946 | |
| 947 | val = datetime.datetime(2012, 3, 4, 5, 6) |
| 948 | self.assertEqual(con.escape(val, con.encoders), "'2012-03-04 05:06:00'") |
| 949 | self.assertEqual(con.escape(val.timetuple()), "'2012-03-04 05:06:00'") |
| 950 | |
| 951 | def test_escape_custom_object(self): |
| 952 | con = self.connect() |
| 953 | |
| 954 | mapping = {Foo: escape_foo} |
| 955 | self.assertEqual(con.escape(Foo(), mapping), "bar") |
| 956 | |
| 957 | def test_escape_fallback_encoder(self): |
| 958 | con = self.connect() |
| 959 | |
| 960 | class Custom(str): |
| 961 | pass |
nothing calls this directly
no outgoing calls
no test coverage detected