Nice! session.configure(expire_on_commit=False)
and the problem is solved! ...
but now I'm responsible for calling expire/refresh as needed.
Thank you Isaac for your tip ("happens in a new Session").
it appears that on default expire_on_commit =True ,
all objects expire after each commint.
Good day!
Yoav
On Mon, Jul 20, 2009 at 6:44 PM, Isaac Csandl <[email protected]> wrote:
>
> Sounds like your re-sort either happens in a new Session for some
> reason, and/or the sorting or rendering the display causes access to
> some relation which is set to lazy load upon access.
>
> If it's a lazyloading issue, you could try e.g.: Job.query.options
> (eagerload('some_relation.whatever')).all()
>
> I don't know anything about how wx apps work so I'm just guessing at a
> direction for you to look. HTH.
>
> --i
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" 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/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
