relationship one-to-many

[matv864]

Hello, I need to create a one-to-many relationship. I searched info in documentation, but I found only many-to-many.

My project: I have tables "card" and "articles". I want to get a card with a list of articles,
card.id = article.card_id
There is foreign key to the card.id in the Article table.
But I didn't found what to do in this case.

get_join, how I understand, can give only 1 article, but I need many articles.

[BeaverNotACat]

Hello. As I understand, you need to use get_multi_joined
Here is the docs page

[igorbenav]

If you use get_joined or get_multi_joined you should be able to get the result you want. Simple usage:

from fastcrud import FastCRUD

card_crud = FastCRUD(Card)
card_with_articles = await card_crud.get_joined(
    db=db,
    join_model=Article,
    join_on=Article.card_id == Card.id,
    join_type="left",
    join_prefix="article_",
)

Or to get multiple results:

from fastcrud import FastCRUD

card_crud = FastCRUD(Card)
card_with_articles = await card_crud.get_multi_joined(
    db=db,
    join_model=Article,
    join_on=Article.card_id == Card.id,
    join_type="left",
    join_prefix="article_",
)