From cca348e295fc2e00c745d3a8c1bac3e8d4a5d97e Mon Sep 17 00:00:00 2001 From: Victor Uriarte Date: Fri, 3 Jun 2016 11:32:15 -0700 Subject: Refactor regex Func/keyword exceptions together --- sqlparse/keywords.py | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (limited to 'sqlparse') diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py index 9c4495b..fb2f042 100644 --- a/sqlparse/keywords.py +++ b/sqlparse/keywords.py @@ -31,7 +31,6 @@ SQL_REGEX = { (r'\*', tokens.Wildcard), - (r'CASE\b', tokens.Keyword), # extended CASE(foo) (r"`(``|[^`])*`", tokens.Name), (r"´(´´|[^´])*´", tokens.Name), (r'\$([^\W\d]\w*)?\$', tokens.Name.Builtin), @@ -42,12 +41,11 @@ SQL_REGEX = { # FIXME(andi): VALUES shouldn't be listed here # see https://github.com/andialbrecht/sqlparse/pull/64 - (r'VALUES', tokens.Keyword), - (r'(@|##|#)[^\W\d_]\w+', tokens.Name), # IN is special, it may be followed by a parenthesis, but # is never a functino, see issue183 - (r'in\b(?=[ (])?', tokens.Keyword), - (r'USING(?=\()', tokens.Keyword), + (r'(CASE|IN|VALUES|USING)\b', tokens.Keyword), + + (r'(@|##|#)[^\W\d_]\w+', tokens.Name), (r'[^\W\d_]\w*(?=[.(])', tokens.Name), # see issue39 (r'[-]?0x[0-9a-fA-F]+', tokens.Number.Hexadecimal), (r'[-]?[0-9]*(\.[0-9]+)?[eE][-]?[0-9]+', tokens.Number.Float), -- cgit v1.2.1