[Zope-DB] accessing the SQL used

T. Muddletin x@Vex.Net
Mon, 10 Mar 2003 05:38:26 -0500


T. wrote on Monday, March 10, 2003, 5:20:27 AM:
> a ZSQL method generates has to be accessible somewhere. Where?  How?

Okay, i finally found it in DA.py and figured it out. For anyone else
that has been wondering this, it's actually quite simple...

>From python product code you can call your ZSQL method to get just the
rendered SQL source string back like this:

src = self.your_sql_method(self.REQUEST, src__=1)

-- 
Tim Middleton | Cain Gang Ltd | There is a wisdom that is woe; but there
x@veX.net     | www.Vex.Net   | is a woe that is madness. --Melville (MD)