From 2bd7658034545aa7db5752cd35d400526af5439e Mon Sep 17 00:00:00 2001
From: Andi Albrecht <albrecht.andi@gmail.com>
Date: Mon, 28 Feb 2011 21:23:41 +0100
Subject: Handle REPLACE as DML token and recognize hex numbers (thanks Ervin).

---
 sqlparse/keywords.py | 2 +-
 sqlparse/lexer.py    | 1 +
 2 files changed, 2 insertions(+), 1 deletion(-)

(limited to 'sqlparse')

diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 917601d..f518974 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -343,7 +343,6 @@ KEYWORDS = {
     'RELATIVE': tokens.Keyword,
     'RENAME': tokens.Keyword,
     'REPEATABLE': tokens.Keyword,
-    'REPLACE': tokens.Keyword,
     'RESET': tokens.Keyword,
     'RESTART': tokens.Keyword,
     'RESTRICT': tokens.Keyword,
@@ -528,6 +527,7 @@ KEYWORDS_COMMON = {
     'INSERT': tokens.Keyword.DML,
     'DELETE': tokens.Keyword.DML,
     'UPDATE': tokens.Keyword.DML,
+    'REPLACE': tokens.Keyword.DML,
     'DROP': tokens.Keyword.DDL,
     'CREATE': tokens.Keyword.DDL,
     'ALTER': tokens.Keyword.DDL,
diff --git a/sqlparse/lexer.py b/sqlparse/lexer.py
index d381e36..937cfbd 100644
--- a/sqlparse/lexer.py
+++ b/sqlparse/lexer.py
@@ -177,6 +177,7 @@ class Lexer:
             (r'@[a-zA-Z_][a-zA-Z0-9_]+', tokens.Name),
             (r'[<>=~!]+', tokens.Operator.Comparison),
             (r'[+/@#%^&|`?^-]+', tokens.Operator),
+            (r'0x[0-9a-fA-F]+', tokens.Number.Hexadecimal),
             (r'[0-9]*\.[0-9]+', tokens.Number.Float),
             (r'[0-9]+', tokens.Number.Integer),
             # TODO: Backslash escapes?
-- 
cgit v1.2.1