sqlconvert/process_mysql.py

   1
   2 from sqlparse.tokens import Name
   3
   4
   5 def requote_names(token_list):
   6     """Remove backticks, quote non-lowercase identifiers"""
   7     for token in token_list.flatten():
   8         if token.ttype is Name:
   9             value = token.value
  10             if (value[0] == "`") and (value[-1] == "`"):
  11                 value = value[1:-1]
  12             if value.islower():
  13                 token.normalized = token.value = value
  14             else:
  15                 token.normalized = token.value = '"%s"' % value