demo/parse-file.py

   1 #! /usr/bin/env python
   2 from __future__ import print_function
   3
   4 import sys
   5 from sqlparse import parse
   6 from mysql2sql.print_tokens import print_tokens
   7 from mysql2sql.process_tokens import requote_names, find_error
   8
   9
  10 def main(filename):
  11     with open(filename) as infile:
  12         for query in infile:
  13             for parsed in parse(query):
  14                 print("----------")
  15                 if find_error(parsed):
  16                     print("ERRORS IN QUERY")
  17                 requote_names(parsed)
  18                 print_tokens(parsed)
  19                 print()
  20                 parsed._pprint_tree()
  21     print("----------")
  22
  23 if __name__ == '__main__':
  24     if len(sys.argv) <= 1:
  25         sys.exit("Usage: %s file" % sys.argv[0])
  26     main(sys.argv[1])