X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=mysql2sql%2Fprocess_tokens.py;fp=mysql2sql%2Fprocess_tokens.py;h=c395b37df0cd94bb1cb9b09df2f4b0fd21cd3583;hb=3289238688d9c3dfefccf143d21f6c406faad9e4;hp=0000000000000000000000000000000000000000;hpb=b4bfb63ecab0ee594247c576a3414c4cdd133058;p=sqlconvert.git

diff --git a/mysql2sql/process_tokens.py b/mysql2sql/process_tokens.py
new file mode 100644
index 0000000..c395b37
--- /dev/null
+++ b/mysql2sql/process_tokens.py
@@ -0,0 +1,18 @@
+
+from sqlparse.sql import TokenList
+from sqlparse.tokens import Name
+
+
+def requote_names(token_list):
+    """Remove backticks, quote non-lowercase identifiers"""
+    for token in token_list:
+        if isinstance(token, TokenList):
+            requote_names(token)
+        else:
+            if token.ttype is Name:
+                value = token.value
+                if (value[0] == "`") and (value[-1] == "`"):
+                    value = value[1:-1]
+                    token.normalized = token.value = value
+                if not value.islower():
+                    token.normalized = token.value = '"%s"' % value