Hi all, i want to retrieve columns from table used as secondary in a n:m join.
For Example, in this case how to retrieda data_fine, data_inizio from secondary tables ? my mapper respect correclty this property: 'associated_unita_aziendale' : relation( UnitaAziendale, secondary=tbl['azienda_veterinario'], primaryjoin=tbl['azienda_veterinario'].c.id_veterinario == tbl['operatore'].c.id, lazy = False, backref="veterinari_associati", i've already tried with add_column and add_entity, but SA do always the wrond cartesian product. only solution i found is to add a .filter at the end with the explicit join relation. operatore: { u'id': Column(u'id',PGInteger(),primary_key=True,nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause object at 0xb714da2c>)), u'logname': Column(u'logname',PGText(length=None,convert_unicode=False)), u'password': Column(u'password',PGText(length=None,convert_unicode=False)), u'zoperoles': Column(u'zoperoles',PGText(length=None,convert_unicode=False))} secondary table: {u'data_fine': Column(u'data_fine',PG2Date()), u'data_inizio': Column(u'data_inizio',PG2Date()), u'id': Column(u'id',PGInteger(),primary_key=True,nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause object at 0xb715e0ec>)), u'id_veterinario': Column(u'id_veterinario',PGInteger(),ForeignKey(u'operatore.id')), u'id_unita_aziendale': Column(u'id_unita_aziendale',PGInteger(),ForeignKey(u'unita_aziendale.id')), } unita_aziendale { u'id': Column(u'id',PGInteger(),primary_key=True,nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause object at 0xb717842c>)), bla..bla... } Thank You Glauco -- +------------------------------------------------------------+ Glauco Uri - Programmatore glauco(at)allevatori.com Sfera Carta Software® [EMAIL PROTECTED] Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054 +------------------------------------------------------------+ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---