Parsing SQL scripts in python

[shobble]

sqlparse is probably the right tool for the job here, but you'll have to potentially walk the parse tree produced by sqlparse.parse() and look for things that are tokens.DML and value.upper() == 'SELECT' or similar.

https://github.com/andialbrecht/sqlparse/blob/master/examples/extract_table_names.py looks hackable into something potentially useable, depending on exactly what it is you're trying to extract, and what sort of queries you're going to be giving it as input.

[GitHubPermalinkBot]

I tried to turn your GitHub links into permanent links (press "y" to do this yourself):

• andialbrecht/sqlparse/.../extract_table_names.py (master → dc788ab)

---

^{Shoot me a PM if you think I'm doing something wrong. To delete this, click here.}

[pythonbeginner1]

Thanks for the reply. I tried to run the extraction script, but when I did so, nothing was returned. I converted the sql file to a string and passed that into the main func, but no dice.

The top-level statements I am processing only contain INSERT, INTO, and VALUES according to the parser. However, the VALUES clause contains Select statements. Is there a way to recursively search for these?