Join demo scripts; add argparse parameters parsing

[sqlconvert.git] / demo / group-sql.py

diff --git a/demo/group-sql.py b/demo/group-sql.py
deleted file mode 100755 (executable)
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)