#[sqlx(default)] whit <Option<Vec<struct>>

[josejachuf]

This is similar to some consultations made, such as:

#2292
#1446

The difference is that they try a only one called to the database. In my case I am not worried about making two different query

#[derive(Debug, FromRow, Deserialize, Serialize)]
pub struct Foo {
    pub name: String,
    pub age: u8,
}


#[derive(Debug, FromRow, Deserialize, Serialize)]
pub struct Bar {
    pub name: String,
    #[sqlx(default)]
    pub foo: Option<Vec<Foo>>,
}

let sql = "select name, age from foo_table where a_field=10;";
let foo = sqlx::query_as::<_, Foo>(&sql).fetch_all(&pg_pool).await.unwrap();

let sql = "select name from bar_table where id=1;";
let mut bar = sqlx::query_as::<_, Bar>(&sql).fetch_all(&pg_pool).await.unwrap();

let bar = sqlx::query_as::<_, Bar>(&sql).fetch_one(&pg_pool).await;
| ^^^ the trait sqlx::Decode<'_, _> is not implemented for Foo
|
= help: the following other types implement trait sqlx::Decode<'r, DB>:
<&'r JsonRawValue as sqlx::Decode<'r, DB>>
<&'r [u8] as sqlx::Decode<'r, Postgres>>
<&'r str as sqlx::Decode<'r, Postgres>>
<() as sqlx::Decode<'r, Postgres>>
<(T1, T2) as sqlx::Decode<'r, Postgres>>
<(T1, T2, T3) as sqlx::Decode<'r, Postgres>>
<(T1, T2, T3, T4) as sqlx::Decode<'r, Postgres>>
<(T1, T2, T3, T4, T5) as sqlx::Decode<'r, Postgres>>
and 27 others
= note: required for std::option::Option<Foo> to implement sqlx::Decode<'_, _>
note: required for Bar to implement for<'r> FromRow<'r, _>

What I want to get is something like this, to be able to query Bar and then modify this strcut with:

bar.foo = foo

And then get this json:

{
  "name": "John",
  "foo": [
    {
      "name": "a",
      "age": 12
    },
    {
      "name": "b",
      "age": 15
    }
  ]
}

[frederikhors]

Hi @josejachuf! Did you read #2219? And then #1014 (comment)?

I'm working on it these days and after some tests things work but it can be really bad left alone without someone to help you.
@jb-alvarado helped me a lot. I couldn't have done it without him (and I still haven't finished it all). If we unite we can bring some light (and some docs) on these issues of this wonderful crate!

[josejachuf]

Hi @frederikhors
I had not seen this: #1014 (comment)

For now I resolved it in a way that is not what I wanted, but I am interested in the subject and I will follow it and try some things

#[derive(Debug, FromRow, Deserialize, Serialize)]
pub struct Foo {
    pub name: String,
    pub age: u8,
}


#[derive(Debug, FromRow, Deserialize, Serialize)]
pub struct Bar {
    pub name: String,
    #[sqlx(default)]
    pub foo: Option<serde_json::Value>,
}

let sql = "select name, age from foo_table where a_field=10;";
let foo = sqlx::query_as::<_, Foo>(&sql).fetch_all(&pg_pool).await.unwrap();

let sql = "select name from bar_table where id=1;";
let mut bar = sqlx::query_as::<_, Bar>(&sql).fetch_one(&pg_pool).await.unwrap();
bar.foo = Some(serde_json::to_value(foo).unwrap());

[frederikhors]

Let me know after all tries.