This could be expanded slightly to include 'prefixes=[]' support ala select() and insert(). Sqlite could use that for creating full text tables, e.g. 'CREATE VIRTUAL TABLE foo (...) USING ...'.
I haven't thought about this extensively but I think I'd prefer prefixes=['TEMPORARY'] to a temporary=True flag until such a time as we can guarantee that the temp tables are cleaned up when the defining connection is returned to the pool. Matthew Zwier wrote: > Thanks for the quick reply! I've always been quite impressed with the > quality of SA and its support. > > I'm a bit swamped at work at the moment but I'll see about putting a > 'CREATE TEMPORARY TABLE' patch together. > > MZ > > On Mon, Apr 28, 2008 at 4:09 PM, Michael Bayer <[EMAIL PROTECTED]> wrote: >> that's pretty good you came up with that. We haven't placed explicit >> support for multiple items as the subject of an IN statement. You can >> do what you have there without _Grouping by saying >> ClauseList(...).self_group(). I think you're safe with that for now >> though we should add a "public" function for this purpose at some point. >> >> >> >> if its just a matter of saying "CREATE TEMPORARY TABLE" instead of >> "CREATE TABLE", we can accept a patch for "temporary=True", sure. >> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---