The day after I hyped the Getting Started with PyParsing book, I got to use it. Here’s the script : from pyparsing import SkipTo, Suppress, CaselessLiteral import glob # Example to match # delete from TABLENAME # where CUSTOMER_ID = 'INTERNAL'; table_name = SkipTo("where") where_clause = SkipTo(';') delete_stmt = Suppress("delete") + Suppress("from") + table_name + Suppress("where") + where_clause + Suppress(";") for filename in glob.glob('*.sql'): f = open(filename) print '-- ', filename, ':' lines=f.
I just bought and read the Getting Started with Pyparsing PDF book. And it’s good. PyParsing is a way of building a parser using Python code. You should think Yacc/Lex, but readable. It can be used to parse text, and it can also handle HTML. This is the example from the PyParsing website : from pyparsing import Word, alphas greet = Word( alphas ) + "," + Word( alphas ) + "!
Copyright (c) 2023 Michel Hollands