X-Git-Url: https://git.phdru.name/?p=sqlconvert.git;a=blobdiff_plain;f=scripts%2Fparse-sql.py;fp=scripts%2Fparse-sql.py;h=0000000000000000000000000000000000000000;hp=f34178a706b5c894f7bead750561c0e6ed1efe31;hb=33ccb6237b3791b181d9589549c34f66960c5b4d;hpb=7d3342fc8ae5d217736c9c055b53445c628da765 diff --git a/scripts/parse-sql.py b/scripts/parse-sql.py deleted file mode 100755 index f34178a..0000000 --- a/scripts/parse-sql.py +++ /dev/null @@ -1,40 +0,0 @@ -#! /usr/bin/env python -from __future__ import print_function - -import sys -from sqlparse import parse -from mysql2sql.print_tokens import print_tokens -from mysql2sql.process_tokens import requote_names, find_error - - -def main(*queries): - for query in queries: - for parsed in parse(query): - print("----------") - if find_error(parsed): - print("ERRORS IN QUERY") - requote_names(parsed) - print_tokens(parsed) - print() - parsed._pprint_tree() - print("----------") - - -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)