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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
