That solves it. I assume that means I can use any of those SA parameters in an Elixir declaration (very useful).
Thank you Gaëtan. I'm pretty new to all these tools, but they're proving to be very well written. On Oct 10, 12:35 am, "Gaetan de Menten" <[EMAIL PROTECTED]> wrote: > Hello, > > You should try using the post_update argument on that relationship. > The use_alter flag solve the problem only at the table creation time, > but you need to solve it at "data-input" time. > > See:http://www.sqlalchemy.org/docs/04/sqlalchemy_orm.html#docstrings_sqla... > for details. > > Hope this helps, > > On 10/10/07, n-org <[EMAIL PROTECTED]> wrote: > > > > > > > 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. > > -- > Gaëtan de Mentenhttp://openhex.org --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
