X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=demo%2Fgroup-sql.py;fp=demo%2Fgroup-sql.py;h=0000000000000000000000000000000000000000;hb=7f8299a9a17686456ae066ee46f91f64793e5866;hp=11f1f8cd002869745cd4b980856180016dceb249;hpb=30c39b60ae8289d0b974a4ebb767318773319867;p=sqlconvert.git diff --git a/demo/group-sql.py b/demo/group-sql.py deleted file mode 100755 index 11f1f8c..0000000 --- a/demo/group-sql.py +++ /dev/null @@ -1,46 +0,0 @@ -#! /usr/bin/env python -from __future__ import print_function - -import sys -from sqlconvert.print_tokens import print_tokens -from sqlconvert.process_tokens import find_error, StatementGrouper - - -def main(*queries): - grouper = StatementGrouper(encoding='utf-8') - for query in queries: - grouper.process_line(query) - if grouper.statements: - for statement in grouper.get_statements(): - print("----------") - if find_error(statement): - print("ERRORS IN QUERY") - print_tokens(statement, encoding='utf-8') - print() - statement._pprint_tree() - print("----------") - tokens = grouper.close() - if tokens: - for token in tokens: - print_tokens(token, encoding='utf-8') - print(repr(token)) - - -def test(): - main( - "SELECT * FROM `mytable`; -- line-comment", - "INSERT into /* inline comment */ mytable VALUES (1, 'one');", - "/*! directive*/ INSERT INTO `MyTable` (`Id`, `Name`) " - "VALUES (1, 'one');" - ) - - -if __name__ == '__main__': - if len(sys.argv) <= 1: - sys.exit("Usage: %s [-t | sql_query_string [; sql_query_string ...]]" % - sys.argv[0]) - if sys.argv[1] == '-t': - test() - else: - queries = sys.argv[1:] - main(*queries)