I suppose executesql would be fine in that case if you want to do it that way.
On Saturday, August 25, 2012 6:34:18 PM UTC-4, Yarin wrote: > > Yeah I could create them outside of web2py, was just wondering if there > was a good way to perform SQL 'prep' on a db along with the table > migrations.. not critical though. > > On Sat, Aug 25, 2012 at 6:29 PM, Anthony <[email protected] > <javascript:>>wrote: > >> Do they need to be created dynamically by your app? If not, you could >> just create them outside of web2py. >> >> Side note -- if you want web2py to generate SQL for any queries, you can >> form the queries as usual and call the ._select() method instead of >> .select() -- that will return the SQL as a string rather than actually >> running the query. >> >> Anthony >> >> >> On Saturday, August 25, 2012 5:56:10 PM UTC-4, Yarin wrote: >>> >>> I'm assuming there's probably no support for defining stored procedures >>> using DAL functions. Instead I was going to try to create them in raw sql >>> using executesql whenever migrate was turned on. Just wondering if this >>> is the best technique, or someone has another idea >>> >>> >>> -- >> >> >> >> > > --
