that's an ORM problem. you might want to look into the
"post_update" flag if you need to flush two mutually dependent rows.
See the relation() docs for details.
On Dec 6, 2008, at 3:41 PM, jose wrote:
>
> I gave it a name but now...
>
> raise FlushError("Circular dependency detected " + repr(edges) +
> repr(queue))
> sqlalchemy.exceptions.FlushError: Circular dependency detected
> <sqlalchemy.topological._EdgeCollection object at 0xb73f356c>[]
>
> jose wrote:
>
>> the use_alter=True raises this error:
>>
>> ForeignKeyConstraint(['id_operatore'],
>> ['operatore.id'],use_alter=True),
>> File "/usr/lib/python2.4/site-packages/sqlalchemy/schema.py", line
>> 701, in __init__
>> raise exceptions.ArgumentError("Alterable
>> ForeignKey/ForeignKeyConstraint requires a name")
>>
>>
>> Michael Bayer wrote:
>>
>>
>>
>>> specify use_alter=True to one or both ForeignKey constructs.
>>>
>>>
>>> On Dec 6, 2008, at 12:37 PM, jose wrote:
>>>
>>>
>>>
>>>
>>>
>>>> Hi all,
>>>>
>>>> I have two tables in my schema with circular references and I don't
>>>> know
>>>> hot to create them.
>>>>
>>>>
>>>> tbl['anagrafica']=Table('anagrafica',database.metadata,
>>>> Column('id', Integer, Sequence('anagrafica_id_seq'),
>>>> primary_key=True, nullable=False),
>>>> Column('nome', Unicode(200), nullable=False, index=True,
>>>> case_sensitive=True),
>>>> Column('id_operatore', Integer, ForeignKey('operatore.id'))
>>>> )
>>>> tbl['operatore']=Table('operatore',database.metadata,
>>>> Column('id', Integer, Sequence('operatore_id_seq'),
>>>> nullable=False, primary_key=True),
>>>> Column('id_anagrafica', Integer,
>>>> ForeignKeyConstraint('anagrafica.id'))
>>>> )
>>>>
>>>> thank you for any help.
>>>> j
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>>
>>
>>
>>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
