Recognize backticks quoting identifiers.

andialbrecht · andialbrecht · commit 1fd167879df0 · 2009-04-29T21:18:03.000+02:00
diff --git a/CHANGES b/CHANGES
@@ -1,3 +1,8 @@
-Release 0.1.0 (In Development)
-------------------------------
+In Development
+--------------
+ * Recognize backticks quoting identifiers.
+
+
+Release 0.1.0
+-------------
  * Initial.
diff --git a/sqlparse/lexer.py b/sqlparse/lexer.py
@@ -1,3 +1,5 @@
+# -*- coding: utf-8 -*-
+
 # Copyright (C) 2008 Andi Albrecht, albrecht.andi@gmail.com
 #
 # This module is part of python-sqlparse and is released under
@@ -162,6 +164,8 @@ class Lexer:
             (r':=', Assignment),
             (r'::', Punctuation),
             (r'[*]', Wildcard),
+            (r"`(``|[^`])*`", Name),
+            (r"´(´´|[^´])*´", Name),
             (r'[+/<>=~!@#%^&|`?^-]', Operator),
             (r'[0-9]+', Number.Integer),
             # TODO: Backslash escapes?
diff --git a/tests/test_tokenize.py b/tests/test_tokenize.py
@@ -19,3 +19,8 @@ def test_simple(self):
         self.assertEqual(tokens[0], (Keyword.DML, u'select'))
         self.assertEqual(tokens[-1], (Punctuation, u';'))
 
+    def test_backticks(self):
+        sql = '`foo`.`bar`'
+        tokens = list(lexer.tokenize(sql))
+        self.assertEqual(len(tokens), 3)
+        self.assertEqual(tokens[0], (Name, u'`foo`'))
