Skip to content

Monthly Archives: November 2007

Kew

Monday, November 5, 2007

On a lovely autumn day, I went to see the Henry Moore statues at Kew gardens.
Here are the pictures :

Filed in Travel | | Comments (0)

Using pyparsing – 2

Friday, November 2, 2007

Parsing sql statements like the following is dead simple with PyParsing.

INSERT INTO table_a VALUES (’A', ‘B’, ‘C’);
INSERT INTO table_a VALUES (’D', ‘E’, ‘F’);

This is the program :

from pyparsing import Suppress, delimitedList, sglQuotedString, removeQuotes
 
sglQuotedString.setParseAction( removeQuotes )
stmt = Suppress("INSERT INTO table_a VALUES (") + delimitedList(sglQuotedString) \
[...]

Filed in Python | | Comments (0)