that is the way to do it as far as switching engines. your example doesn't work because the state of "p1" is "persistent" as opposed to "pending", so the example updates a row that isn't there.
you need to build a copy constructor on Person and make a new, non-persistent Person object for your second engine. the Session can't implicitly figure out what your intent is. Koen Bok wrote: > > Hey I was wondering if it was possible to replace an engine in a > session. It does not seem to work, but maybe I'm doing something > really stupid. > > http://pastie.org/322501 > > Kindest regards, > > Koen Bok - madebysofa.com > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
