added double quote test case

Kareem Zidane · Kareem Zidane · commit 0e7958e853ea · 2019-10-28T11:32:09.000-04:00
diff --git a/tests/sql.py b/tests/sql.py
@@ -92,6 +92,7 @@ def test_string_literal_with_colon(self):
         self.assertEqual(self.db.execute("SELECT val FROM cs50 WHERE val = '  :baz'"), [{"val": "  :baz"}])
         self.assertEqual(self.db.execute("SELECT val FROM cs50 WHERE val = ':bar :baz'"), [{"val": ":bar :baz"}])
         self.assertEqual(self.db.execute("SELECT val FROM cs50 WHERE val = '  :bar :baz'"), [{"val": "  :bar :baz"}])
+        self.assertEqual(self.db.execute('SELECT val FROM cs50 WHERE val = "  :bar :baz"'), [{"val": "  :bar :baz"}])
 
     def tearDown(self):
         self.db.execute("DROP TABLE cs50")
