Python backtick_unicode示例

示例#1

 def test_backtick_unicode(self):
     cases = [
         ("SELECT (1) as foo WHERE 1=1", "SELECT (1) as foo WHERE 1=1"),
         ("SELECT (1) as föö", "SELECT (1) as `föö`"),
         ("SELECT (1) as `föö`", "SELECT (1) as `föö`"),
         ("SELECT (1) as `föö` `umläut", "SELECT (1) as `föö` `umläut"),
         ("SELECT (1) as `föö", "SELECT (1) as `föö"),
     ]
     for sql, want in cases:
         with self.subTest(sql=sql):
             got = backtick_unicode(sql)
             self.assertEqual(got, want)

示例#2

文件： test_utils.py 项目： zoercai/python-spanner

    def test_backtick_unicode(self):
        from google.cloud.spanner_dbapi.utils import backtick_unicode

        cases = [
            ("SELECT (1) as foo WHERE 1=1", "SELECT (1) as foo WHERE 1=1"),
            ("SELECT (1) as föö", "SELECT (1) as `föö`"),
            ("SELECT (1) as `föö`", "SELECT (1) as `föö`"),
            ("SELECT (1) as `föö` `umläut", "SELECT (1) as `föö` `umläut"),
            ("SELECT (1) as `föö", "SELECT (1) as `föö"),
        ]
        for sql, want in cases:
            with self.subTest(sql=sql):
                got = backtick_unicode(sql)
                self.assertEqual(got, want)