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_tokens import 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, encoding='utf-8'):
  14                 print("----------")
  15                 if find_error(parsed):
  16                     print("ERRORS IN QUERY")
  17                 print_tokens(parsed, encoding='utf-8')
  18                 print()
  19                 parsed._pprint_tree()
  20     print("----------")
  21
  22 if __name__ == '__main__':
  23     if len(sys.argv) <= 1:
  24         sys.exit("Usage: %s file" % sys.argv[0])
  25     main(sys.argv[1])