Does seaorm support nested structures?

[Raj2032]

According to chat ai, it claims it does support it and provided this code:

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "users")]
pub struct User {
    #[sea_orm(primary_key)]
    pub id: i32,
    pub name: String,
    pub address: Address,
}

#[derive(Clone, Debug, PartialEq)]
pub struct Address {
    pub street: String,
    pub city: String,
    pub state: String,
    pub zip: String,
}


let users = User::find()
    .filter(address.street.eq("123 Main St"))
    .all(db)
    .await?;

However I do not know if this is valid or not.

[seijikun]

I think this answers your question: #2015

[Raj2032]

ok thanks :)

[seijikun]

Correction: It's actually currently being worked on in #2179 for queries.

[Raj2032]

@seijikun I see so I can query my nested structure similar to this:

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "users")]
pub struct User {
    #[sea_orm(primary_key)]
    pub id: i32,
    pub name: String,
    pub address: Address,
}

#[derive(Clone, Debug, PartialEq)]
pub struct Address {
    pub street: String,
    pub city: String,
    pub state: String,
    pub zip: String,
}
let users = User::find()
    .filter(address.street.eq("123 Main St"))
    .all(db)
    .await?;

after it has been worked on?

[seijikun]

@Raj2032 You will need extra structs for querying, it can't be your normal entity models (afaik).
And you will have to annotate the fields with nested models.
You can look at the new examples added by #2179 >>here<<

[Raj2032]

ok thanks mate :)

…

On Saturday, 27 July 2024 at 22:38, Markus Ebner ***@***.***> wrote: ***@***.***(https://github.com/Raj2032) You will need extra structs for querying, it can't be your normal entity models (afaik). You can look at the new examples added by [#2179](#2179) [>>here<<](https://github.com/SeaQL/sea-orm/blob/984827a6de82f965b41a1d7eb36852702eac8755/tests/partial_model_tests.rs#L194) — Reply to this email directly, [view it on GitHub](#2289 (reply in thread)), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/AG7P2BVJ4GXLATFFKEG2CK3ZOOIDBAVCNFSM6AAAAABLBTOWCCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTAMJWG4YTOMY). You are receiving this because you were mentioned.Message ID: ***@***.***>