hi.
i have somewhat messy setup (~test case), about association with 
intermediate table/class, double pointing to one side and single 
pointing to another. i do set up both A-links in one item; and set up 
only first in another item, the other link (a2_link) is pre-set to None. 
And, i have the error below since r3695.
The error seems to disappear if i do not explicitly initiate the a2_link 
to None - dont touch it or set to some object.
Any idea what's wrong?

Traceback (most recent call last):
  File "a.py", line 91, in <module>
    s.flush()
  File "/home/az/src/hor-trunk/sqlalchemy/orm/session.py", line 683, in 
flush
    self.uow.flush(self, objects)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 209, 
in flush
    flush_context.execute()
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 436, 
in execute
    UOWExecutor().execute(self, head)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1055, 
in execute
    self.execute_save_steps(trans, task)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1074, 
in execute_save_steps
    self.execute_childtasks(trans, task, False)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1092, 
in execute_childtasks
    self.execute(trans, child, isdelete)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1055, 
in execute
    self.execute_save_steps(trans, task)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1072, 
in execute_save_steps
    self.execute_dependencies(trans, task, False)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1085, 
in execute_dependencies
    self.execute_dependency(trans, dep, False)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1066, 
in execute_dependency
    dep.execute(trans, isdelete)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/unitofwork.py", line 1021, 
in execute
    self.processor.process_dependencies(self.targettask, [elem.obj for 
elem in self.targettask.polymorphic_tosave_elements if elem.obj is not 
None], trans, delete=False)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/dependency.py", line 282, 
in process_dependencies
    self._synchronize(obj, child, None, False, uowcommit)
  File "/home/az/src/hor-trunk/sqlalchemy/orm/dependency.py", line 317, 
in _synchronize
    self.syncrules.execute(source, dest, obj, child, clearkeys)
  File "/home/az/src/dbcook/sqlalchemy/orm/sync.py", line 91, in execute
    rule.execute(source, dest, obj, child, clearkeys)
  File "/home/az/src/dbcook/sqlalchemy/orm/sync.py", line 139, in execute
    raise exceptions.AssertionError("Dependency rule tried to blank-out 
primary key column '%s' on instance '%s'" % (str(self.dest_column), 
mapperutil.instance_str(dest)))
sqlalchemy.exceptions.AssertionError: Dependency rule tried to blank-out 
primary key column 'IntermediateAB.a2_link_id' on instance 
'[EMAIL PROTECTED]'


--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to