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

Class TestEscape

pymysql/tests/test_connection.py:904–1042  ·  view source on GitHub ↗

Source from the content-addressed store, hash-verified

902
903
904class 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

Callers

nothing calls this directly

Calls

no outgoing calls

Tested by

no test coverage detected