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 sqlconvert.print_tokens import print_tokens
   7 from sqlconvert.process_mysql import process_statement
   8 from sqlconvert.process_tokens import find_error
   9
  10
  11 def main(filename):
  12     with open(filename) as infile:
  13         for query in infile:
  14             for parsed in parse(query):
  15                 print("----------")
  16                 if find_error(parsed):
  17                     print("ERRORS IN QUERY")
  18                 process_statement(parsed)
  19                 print_tokens(parsed)
  20                 print()
  21                 parsed._pprint_tree()
  22     print("----------")
  23
  24 if __name__ == '__main__':
  25     if len(sys.argv) <= 1:
  26         sys.exit("Usage: %s file" % sys.argv[0])
  27     main(sys.argv[1])