two tricks here - set up SpeciesSynonym as:
class SpeciesSynonym(object):
def __init__(self, species):
self.synonym = species
that it wasnt raising an exception for no constructor is a bug -
ticket #908 added.
The other thing that helps here is to set up your bidirectional
relation using a backref, so that the opposite side is set
automatically:
mapper(Species, species_table,
properties = \
{'_synonyms':
relation(SpeciesSynonym,
primaryjoin=species_table.c.id==species_synonym_table.c.species_id,
cascade='all, delete-orphan', uselist=True,
backref="species"
)})
mapper(SpeciesSynonym, species_synonym_table,
properties = \
{
'synonym':
relation(Species, uselist=False,
primaryjoin=species_synonym_table.c.synonym_id==species_table.c.id),
})
8 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: association object t...
.py