My goal is to have a one-to-many relation defined using the same name
as the foreign key column underneath. So that, if my Detection
table has a foreignkey column named sensor, the following mappers
should work, I think:
mapper(Sensor, sensor)
detectionmapper = mapper(Detection, detection,
allow_column_override=True, properties={
'sensor': relation(Sensor),
})
I'm getting the following exception, however, when I actually create
a Detection with a Sensor and try to flush the session:
Traceback (most recent call last):
File console, line 1, in module
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\scoping.py,
line 98, in do
return getattr(self.registry(), name)(*args, **kwargs)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\session.py,
line 757, in flush
self.uow.flush(self, objects)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 233, in flush
flush_context.execute()
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 445, in execute
UOWExecutor().execute(self, tasks)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 930, in execute
self.execute_save_steps(trans, task)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 948, in execute_save_steps
self.execute_dependencies(trans, task, False)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 959, in execute_dependencies
self.execute_dependency(trans, dep, False)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 942, in execute_dependency
dep.execute(trans, isdelete)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\unitofwork.py,
line 895, in execute
self.processor.process_dependencies(self.targettask, [elem.state
for elem in self.targettask.polymorphic_tosave_elements if elem
.state is not None], trans, delete=False)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\dependency.py,
line 332, in process_dependencies
self._synchronize(state, child, None, False, uowcommit)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\dependency.py,
line 374, in _synchronize
sync.populate(child, self.mapper, state, self.parent,
self.prop.synchronize_pairs)
File
c:\python25\lib\site-packages\SQLAlchemy-0.4.5-py2.5.egg\sqlalchemy\orm\sync.py,
line 27, in populate
self._raise_col_to_prop(True, source_mapper, l, dest_mapper, r)
NameError: global name 'self' is not defined
I am still using SQLAlchemy 0.4.5.
Thanks for any help!
Chris
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---