Derive Macro FromQueryResult

#[derive(FromQueryResult)]
{
    // Attributes available to this derive:
    #[sea_orm]
}

Convert a query result into the corresponding Model.

Attributes

• skip: will not try to pull this field from the query result. And set it to the default value of the type.
• nested: allows nesting models. can be any type that implements FromQueryResult
• from_alias: get the value from this column alias

Usage

For more complete examples, please refer to https://github.com/SeaQL/sea-orm/blob/master/tests/from_query_result_tests.rs

use sea_orm::{entity::prelude::*, FromQueryResult};

#[derive(FromQueryResult)]
struct Cake {
    id: i32,
    name: String,
    #[sea_orm(nested)]
    bakery: Option<CakeBakery>,
    #[sea_orm(skip)]
    skip_me: i32,
}

#[derive(FromQueryResult)]
struct CakeBakery {
    #[sea_orm(from_alias = "bakery_id")]
    id: i32,
    #[sea_orm(from_alias = "bakery_name")]
    title: String,
}

You can compose this with regular Models, if there’s no column collision:

#[derive(FromQueryResult)]
struct CakePlain {
    id: i32,
    name: String,
    price: Decimal,
    #[sea_orm(nested)]
    baker: Option<cakes_bakers::Model>,
}