X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=sqlconvert%2Fprocess_mysql.py;fp=sqlconvert%2Fprocess_mysql.py;h=b11eccb38f4376f526a7b8b3130e618f7ff58c8f;hb=dbc9220a2b29725f94637607f8d8b00c762deb67;hp=0000000000000000000000000000000000000000;hpb=9b966fd37e7a38b655feaf7c77e2adf5de4fa95d;p=sqlconvert.git

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