And again, sorry.
That does *not* actually work. It seems to work some of the time, but
I still get an exception some of the time. So, any ideas?
On Oct 9, 8:45 pm, n-org <[EMAIL PROTECTED]> wrote:
> Sorry to reply to myself, but I found that if I do a
> database.session.flush() in between creating the address and setting
> it to be the primary, it gets rid of the exception.
>
> (But as a feature request, it might be nice if Elixir/SA could avoid
> it automatically in cases like this. Maybe if some attribute is true,
> it could break the edge in the topological sort, so the Person op was
> performed first and then use an ALTER statement to update the second
> relationship.)
>
> On Oct 9, 8:41 pm, n-org <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I'm using Elixir with Turbogears.
>
> > I have a model which has an object that has a one-to-many and then a
> > belongs_to to set which of the many is primary:
>
> > Person
> > has_many('addresses', of_kind='Address', inverse='owner')
> > belongs_to('primary_address', of_kind='Address', use_alter=True)
>
> > Address
> > belongs_to('owner', of_kind='Person', inverse='photos')
>
> > I thought that the use_alter=True would prevent circular reference
> > problems. But, when I try to insert a new address, I get:
>
> > File "/Library/Frameworks/Python.framework/Versions/2.5/lib/
> > python2.5/site-packages/SQLAlchemy-0.3.10-py2.5.egg/sqlalchemy/
> > topological.py", line 225, in sort
> > raise CircularDependencyError("Circular dependency detected " +
> > repr(edges) + repr(queue))
> > CircularDependencyError: Circular dependency detected
>
> > I _could_ change Address to have a has_field('is_primary', Boolean),
> > but this would add an extra join and a huge amount of complexity to
> > some code I have elsewhere, so I'd like to avoid it.
>
> > Is there any way I can avoid getting the CircularDependencyError?
>
> > Thank you very much--I'm loving SA/Elixir so far.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
