[sqlalchemy] Re: reflection unavailable for mysql temporary tables?

2008-10-13 Thread Andy Davidoff
On Oct 11, 1:29 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Oct 11, 2008, at 12:49 PM, AndyDavidoffwrote: > > 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.

[sqlalchemy] Re: reflection unavailable for mysql temporary tables?

2008-10-11 Thread Andy Davidoff
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 N

[sqlalchemy] Re: gratuitous deletes since r5058?

2008-09-28 Thread Andy Davidoff
On Sep 28, 12:06 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > I dont really see how you could get this exact SQL out of the session,   > since its literally attempting to delete the same orange object twice,   > which should be impossible.   I thought you meant that your MySQL   > database has O

[sqlalchemy] gratuitous deletes since r5058?

2008-09-28 Thread Andy Davidoff
I have a MySQL table structure in which an apple relates to many oranges, which relate to many bananas. DELETE an apple, and oranges and bananas are DELETED via cascade. I'm seeing a successful DELETE of a single orange followed by a SELECT of the orange's related bananas and then a second attem

[sqlalchemy] Re: reflection unavailable for mysql temporary tables?

2008-09-27 Thread Andy Davidoff
Perfect, thank you! On Sep 27, 2:28 pm, jason kirtland <[EMAIL PROTECTED]> wrote: > Andy Davidoff wrote: > > Reflection of temporary tables under MySQL works around revision 4000 > > and probably as recently as May but doesn't seem to work under > >

[sqlalchemy] reflection unavailable for mysql temporary tables?

2008-09-26 Thread Andy Davidoff
Reflection of temporary tables under MySQL works 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 table versus a