On May 7, 2008, at 2:08 PM, Werner F. Bruhin wrote:
> > I have a problem with refresh, doing something along these lines: > > object.subobject > object.otherviewofsubobject (this is actually a Firebird SQL view - > which I use for read only access) > > do some update to subobject > session.flush() > > refresh(object) > > object.subobject > object.otherviewofsubobject - at this point this one does not show > the > update done to subobject > > I replaced the session.flush() with a session.commit() to see if the > data makes it to the database correctly, which it does. > > Is this just a "got you" with me trying to keep using db views or > can I > make SA give me the correct data for the view by doing some > additional step. > uh it depends on what "object.otherviewofsubobject" is...is that a relation() ? a python descriptor ? if the latter, how does it work ? where does it get context from ? seems like this is a simple issue of issuing a SELECT on a connection outside of the current transaction. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
