[sqlalchemy] Association Object creation

2011-11-23 Thread Enrico Morelli
Dear all, I have to create an association object that have to relate elements of the same table. These are the table definition: ligand_table = Table('ligand', metadata, Column('id', types.Integer, primary_key=True), Column('number', types.Integer, nullable=False), Column('name',

Re: [sqlalchemy] Association Object creation

2011-11-23 Thread Enrico Morelli
On Wed, 23 Nov 2011 10:59:03 +0100 Enrico Morelli more...@cerm.unifi.it wrote: These are the mappers: mapper(Ligand, ligand_table, properties={ 'ligand':relationship(LigandLigand, primaryjoin=and_(ligand_table.c.id==ligand_ligand_table.c.ligand_id1,

Re: [sqlalchemy] Association Object creation

2011-11-23 Thread Michael Bayer
On Nov 23, 2011, at 5:20 AM, Enrico Morelli wrote: On Wed, 23 Nov 2011 10:59:03 +0100 Enrico Morelli more...@cerm.unifi.it wrote: These are the mappers: mapper(Ligand, ligand_table, properties={ 'ligand':relationship(LigandLigand,