In fact what I want to be able to do is :
select a.id, (select b.name from invasive_names b, languages c where
b.invasive_id=a.id and b.language_id=c.id and c.iso_code='en') as
name_en from invasives a order by foo;
where mappers are : a = Invasive, b = InvasiveName, c = Language
Julien Cigar wrote:
> Hello,
>
> I'm using SQLAlchemy 0.3.3.
> I have 3 tables :
> - "invasives" (mapped to class Invasive)
> - "languages" (mapped to class Language)
> - "invasive_names" (mapper to class InvasiveName)
>
> In other words, I have a table with species which could have a
> scientific name, English name, etc
> I'm using the active mapper extension and I have a problem when I sort
> on the English name of the species with the following :
>
> Invasive.select(
> and_(
> Invasive.join_to('names'), InvasiveName.join_to('language')
> Language.c.iso_code=='en', ) order_by=InvasiveName.c.name)
>
> The problem I have is when a species has no English name, it is not
> selected ...
> In other words, I want to do a LEFT JOIN in place of a JOIN with the
> mapper ...
>
> How can I do this ?
>
> In advance, thanks
>
> Julien
>
--
Julien Cigar
Belgian Biodiversity Platform
http://www.biodiversity.be
Université Libre de Bruxelles
Campus de la Plaine CP 257
Bâtiment NO, Bureau 4 N4 115C (Niveau 4)
Boulevard du Triomphe, entrée ULB 2
B-1050 Bruxelles
office: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
