this mapper setup would imply that the InvasiveName is mapped to the
"languages" table. which im guessing is not the case. is there a
Languages object ?
it seems like youre looking for the "association object" pattern here
instead of the straight many-to-many.
On Jul 26, 2006, at 3:29 AM, Julien Cigar wrote:
> Hello !
>
> I have three tables (not everything is shown, for legibility):
>
> invasives (pk: id)
> languages (pk: id)
> invasive_names (pk: (fk: invasive_id, fk: language_id), invasive_name)
>
> invasives contains specimens and invasives_names are the names for
> that
> specimen (in french, dutch, german, latin, ...)
>
> The scientific name for the specimen is in 'latin', and I'd like to
> have
> a property 'scientific_name' in the invasive mapper whit the latin
> name.
> I tried :
>
> mapper(Invasive, invasives, properties = {
> (...)
> 'scientific_name' : relation(InvasiveName,
> secondary=invasive_names,
> primaryjoin=invasives.c.id==invasive_names.c.invasive_id,
> secondaryjoin=and_
> (invasive_names.c.language_id==languages.c.id,
> languages.c.iso_code=='la')),
> (...)
> }
> )
>
> ... but I got an error :
>
> ArgumentError: No syncrules generated for join criterion
> invasive_names.language_id = languages.id AND languages.iso_code = %
> (languages_iso_code)s
>
> Any idea what I did wrong ?
>
> Thanks !
>
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> opinions on IT & business topics through brief surveys -- and earn
> cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
