Hi all, Another question that may straddle the User / Developer groups. I am building an application where I want to do some set based data integration, in particular I want to be able to run an Insert Select statement. This is different to the bulk_insert, which loops through a set of rows, inserting one at a time. I need to insert them as a set as the data volume will be very large. I can't find this topic raised in the book or the groups.
I'm trying to figure out which is the best way of tackling this in a web2py environment. I have played around with creating some table / transform metadata tables, and using the response.render function with a script template enough to know that I can build a Insert Select script that I can run using "executesql" statement, or using a proprietary buld load / SQL tool from the os. I am quite impressd with how such an application comes together in web2py, but is this the right approach ? I believe the current Insert function does not support the Insert Select scenario. Is this something that the Insert function should support, in which case I don't mind contributing to make it happen ? Any other ideas or comments. Thanks Andrew P.S. I am trying to achieve a "Metadata driven Template Based SQL Generator", something similar to what I recently stumbled across at http://www.xdtl.org/. That is a Java / XML / MOF based approach so I believe it is not something I can easily "import" into web2py. I also think I can develop a solution simpler and faster in web2py.