From ece7c26727b28ea05feeeba3a9c2d1b4b7eb5c54 Mon Sep 17 00:00:00 2001 From: Victor Uriarte Date: Fri, 3 Jun 2016 11:39:29 -0700 Subject: Rewrite regex to allow spaces between `name` and `.` --- sqlparse/keywords.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'sqlparse') diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py index 34e4d80..38b7765 100644 --- a/sqlparse/keywords.py +++ b/sqlparse/keywords.py @@ -46,7 +46,11 @@ SQL_REGEX = { (r'(CASE|IN|VALUES|USING)\b', tokens.Keyword), (r'(@|##|#)[A-Z]\w+', tokens.Name), - (r'[A-Z]\w*(?=\.)', tokens.Name), # see issue39 + + # see issue #39 + # Spaces around period `schema . name` are valid identifier + # TODO: Spaces before period not implemented + (r'[A-Z]\w*(?=\s*\.)', tokens.Name), # 'Name' . (r'(?<=\.)[A-Z]\w*', tokens.Name), # .'Name' (r'[A-Z]\w*(?=\()', tokens.Name), # side effect: change kw to func -- cgit v1.2.1