From: Kevin C. <ke...@us...> - 2005-09-28 15:53:34
|
Update of /cvsroot/mailmanager/mailmanager/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11192/sql Added Files: zsqlDebug.zsql Log Message: some regression tests for ways we are using ZSQL methods. Junk at present but this will get fleshed out a bit --- NEW FILE: zsqlDebug.zsql --- <dtml-comment> title:Debug ZSQL Methods connection_id: mailmanager_db max_rows:0 arguments:requestval hereval sqlparams This zsql method exists in order to debug common ZSQL issues, and provide queries for use in a test suite. It tests various types of scoping, type conversions and conditions. requestval - passed via request or should default to 0 s.has_key('sqlparam')"> <dtml-if "REQUEST.has_key('requestval')"> <dtml-sqlvar requestval type="int"> <dtml-else> 0 </dtml-if> AS requestval, <dtml-if "_.has_key('hereval')"> <dtml-sqlvar hereval type="int"> <dtml-else> 0 </dtml-if> AS hereval, THIS WORKS BUT IS HACKY <dtml-if sqlparams> SELECT <dtml-with sqlparams mapping> <dtml-if "sqlparams.has_key('sqlparam')"> <dtml-sqlvar sqlparam type="int"> <dtml-else> 5 </dtml-if> AS sqlparam, <dtml-if "sqlparams.has_key('reqparam')"> <dtml-sqlvar reqparam type="int"> <dtml-else> 0 </dtml-if> AS reqparam </dtml-with> <dtml-else> <dtml-let sqlparams="REQUEST"> SELECT <dtml-with sqlparams mapping> <dtml-if "sqlparams.has_key('sqlparam')"> <dtml-sqlvar sqlparam type="int"> <dtml-else> 0 </dtml-if> AS sqlparam, <dtml-if "sqlparams.has_key('reqparam')"> <dtml-sqlvar reqparam type="int"> <dtml-else> 0 </dtml-if> AS reqparam </dtml-with> </dtml-let> </dtml-if> <dtml-let vars="{}"> <dtml-if sqlparams> <dtml-call "setattr(vars, 'a', sqlparams)"> <dtml-else> <dtml-call "setattr(vars, 'a', REQUEST)"> </dtml-if> </dtml-let> </dtml-comment> <dtml-if missingvar> </dtml-if> <dtml-if missingarg> </dtml-if> SELECT <dtml-sqlvar sqlvar type="string" optional> |