In reference to finding question marks in SQL queries and ignoring
string literals
M.-A. Lemburg wrote:
> Does anyone know a good implementation of such a search&replace
> mechanism ?
>
I've not seen any existing code to deal with this BUT there are a couple
of places to check:
* SnakeSQL <http://www.pythonweb.org/projects/snakesql/>
* gadfly <http://gadfly.sourceforge.net/>
as they are pure Python database engines and so have some SQL parsing
code in them already that maybe usable.
But you can always cheat and iterate through the SQL string and just
count (incrementing and decrementing) single quotes.
You need to remember to deal with the special case of embedded single
quotes (by keeping a mini back buffer) like this:
'it''s Monty Python'
Chris
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
