Every line of 'sql escape character' code snippets is scanned for vulnerabilities by our powerful machine learning engine that combs millions of open source libraries, ensuring your Python code is secure.
187 def escape(self, s): 188 if s is None: 189 return s 190 return self.handle.escape_string(s)
12 @staticmethod 13 def escape(expression, quote=True): 14 """ 15 >>> Syntax.escape("SELECT 'abcdefgh' FROM foobar") == "SELECT CHAR(97)+CHAR(98)+CHAR(99)+CHAR(100)+CHAR(101)+CHAR(102)+CHAR(103)+CHAR(104) FROM foobar" 16 True 17 >>> Syntax.escape(u"SELECT 'abcd\xebfgh' FROM foobar") == "SELECT CHAR(97)+CHAR(98)+CHAR(99)+CHAR(100)+NCHAR(235)+CHAR(102)+CHAR(103)+CHAR(104) FROM foobar" 18 True 19 """ 20 21 def escaper(value): 22 return "+".join("%s(%d)" % ("CHAR" if _ < 128 else "NCHAR", _) for _ in getOrds(value)) 23 24 return Syntax._escape(expression, quote, escaper)
12 @staticmethod 13 def escape(expression, quote=True): 14 """ 15 >>> Syntax.escape("SELECT 'abcdefgh' FROM foobar") == "SELECT CHAR(97)+CHAR(98)+CHAR(99)+CHAR(100)+CHAR(101)+CHAR(102)+CHAR(103)+CHAR(104) FROM foobar" 16 True 17 >>> Syntax.escape(u"SELECT 'abcd\xebfgh' FROM foobar") == "SELECT CHAR(97)+CHAR(98)+CHAR(99)+CHAR(100)+TO_UNICHAR(235)+CHAR(102)+CHAR(103)+CHAR(104) FROM foobar" 18 True 19 """ 20 21 def escaper(value): 22 return "+".join("%s(%d)" % ("CHAR" if _ < 128 else "TO_UNICHAR", _) for _ in getOrds(value)) 23 24 return Syntax._escape(expression, quote, escaper)
12 @staticmethod 13 def escape(expression, quote=True): 14 """ 15 >>> Syntax.escape("SELECT 'abcdefgh' FROM foobar") == "SELECT CHAR(97)||CHAR(98)||CHAR(99)||CHAR(100)||CHAR(101)||CHAR(102)||CHAR(103)||CHAR(104) FROM foobar" 16 True 17 """ 18 19 def escaper(value): 20 return "||".join("CHAR(%d)" % _ for _ in getOrds(value)) 21 22 return Syntax._escape(expression, quote, escaper)