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 <abasta...@gmail.com> 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 >> >> >> -- > > > > --