mysql2sql/process_tokens.py

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