Queries

Joinedload current translation

import sqlalchemy as sa


articles = (
    session.query(Article)
    .options(sa.orm.joinedload(Article.current_translation))
)

print articles[0].name

Joinedload arbitrary translations

import sqlalchemy as sa


articles = (
    session.query(Article)
    .options(sa.orm.joinedload(Article.translations['fi']))
    .options(sa.orm.joinedload(Article.translations['en']))
)

You can also use attribute accessors:

articles = (
    session.query(Article)
    .options(sa.orm.joinedload(Article.translations.fi))
    .options(sa.orm.joinedload(Article.translations.en))
)

Joinedload all translations

articles = (
    session.query(Article)
    .options(sa.orm.joinedload(Article.translations))
)