Add binary field type test to basic tests (PyMySQL#596)

JanKlopper · methane · commit 2b1448846e0c · 2017-12-19T22:14:22.000+09:00
diff --git a/pymysql/tests/test_basic.py b/pymysql/tests/test_basic.py
@@ -91,8 +91,20 @@ def test_integer(self):
         finally:
             c.execute("drop table test_dict")
 
-    def test_blob(self):
+    def test_binary(self):
         """test binary data"""
+        data = bytes(bytearray(range(255)))
+        conn = self.connections[0]
+        self.safe_create_table(
+            conn, "test_binary", "create table test_binary (b binary(255))")
+
+        with conn.cursor() as c:
+            c.execute("insert into test_binary (b) values (%s)", (data,))
+            c.execute("select b from test_binary")
+            self.assertEqual(data, c.fetchone()[0])
+
+    def test_blob(self):
+        """test blob data"""
         data = bytes(bytearray(range(256)) * 4)
         conn = self.connections[0]
         self.safe_create_table(
