Forgot to mention this is SQLAlchemy 0.5.5
David Gardner wrote:
> I just ran across something I believe maybe a bug in session.refresh()
> dealing with adjacency lists.
> The situation is after a session.refresh() on a node (in my case a
> 'job'), the children and grandchildren
> have some of their values overridden by the refreshed node. Calling
> session.expire_all() fixes this.
>
> Also in this case I am using joined table inheritance, and fields in
> question are in the base table.
> Unfortunately I haven't been able to come up with a simple example that
> isn't based on my schema.
>
> >>> from asset.farm.farmdb import *
> >>> session=create_session()
> >>> job=session.query(Job).get('testshow/201/s22/t04/lgt/cA')
> >>> type(job)
> <class 'asset.farm.farmdb.CamJob'>
> >>> type(job.Children[0])
> <class 'asset.farm.farmdb.CmpJob'>
> >>> type(job.Children[0].Children[0])
> <class 'asset.farm.farmdb.PassJob'>
> >>> job.end_frame
> 2063.0
> >>> job.Children[0].end_frame
> 25.0
> >>> job.Children[0].Children[0].end_frame
> 25.0
> >>> session.refresh(job)
> >>> job.end_frame
> 2063.0
> >>> job.Children[0].end_frame
> 2063.0
> >>> job.Children[0].Children[0].end_frame
> 2063.0
> >>> type(job.Children[0])
> <class 'asset.farm.farmdb.CmpJob'>
> >>> session.expire_all()
> >>> job.Children[0].end_frame
> 25.0
> >>> job.Children[0].Children[0].end_frame
> 25.0
> >>>
>
>
--
David Gardner
Pipeline Tools Programmer
Jim Henson Creature Shop
dgard...@creatureshop.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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
