Forum OpenACS Q&A: Autoextract SQL queries from TCL files

Collapse
1: Autoextract SQL queries from TCL files
Posted by Nima Mazloumi on 10/07/05 11:03 AM
Hi all,

has someone experimented with that before? I think it would be neat to have a proc in Package Manager that scans a package for not outsourced sql queries and generated xql files on the fly.

Any ideas how to do that? Also we would need to be able to distinguish between PostgreSQL and Oracle.

Greetings,
Nima

Collapse
2: Re: Autoextract SQL queries from TCL files (response to 1)
Posted by Vinod Kurup on 10/08/05 10:09 PM
My memory is quite foggy, but didn't the Query Extractor do some of this? The link on that page doesn't work anymore though, so I'm not sure if it's still around.
Collapse
3: Re: Autoextract SQL queries from TCL files (response to 1)
Posted by Nima Mazloumi on 10/13/05 05:12 PM
The link is broken