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 -~----------~----~----~----~------~----~------~--~---