On Oct 11, 2008, at 12:49 PM, Andy Davidoff wrote:
> > On Sep 27, 2:28 pm, jason kirtland <[EMAIL PROTECTED]> wrote: >> Andy Davidoff wrote: >>> Reflectionof temporary tables underMySQLworks around revision 4000 >>> and probably as recently as May but doesn't seem to work under >>> revision 5000 or later; I get a NoSuchTableError. Is this change >>> intentional? >> >>> If the only change I make to my code is to create and reflect a >>> normal >>> tableversus a temporarytable, then SQLA works as expected. >>> Unfortunately, temporary tables offer me an easy concurrency crutch, >>> so I deeply regret this missing functionality. >> >>> I could dig deeper into when and where this stopped working, but >>> perhaps I'm the one missing something. What is it? :-) >> >> Give it a try with the trunk, r5129. > > This fixes the first part of this problem, but unfortunately the `show > create table` is performed in the connection, not the session in which > the temporary table was created. MySQL doesn't expose temporary > tables between sessions, so the `show create table` raises a MySQL > exception due to a non-existent table. you can reflect any table on a specific connection using autoload_with=<someconnection>. if by "Session" you mean ORM session, get the current connection using session.connection(). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
