How to parse JSONB automatically?

[ollyde]

On my project we have files where we use a default file object. Using PostGresql.

On other structures we include the file.

Basic file:

#[derive(Serialize, Deserialize, Debug, Clone)]
pub struct File {
    pub id: String,
    // pub name: String,
    // Fully quality path from gcloud, such gs://bucket-name/path/to/file
    pub path: String,
}

Now, I want to include the file on the User Object (this is just for testing)

#[derive(Debug, FromRow, Serialize, Deserialize)]
pub struct User {
    pub id: String,
    pub name: String,
    pub created_at: OffsetDateTime,
    pub updated_at: OffsetDateTime,
    // Bug cannot use Json<type> https://github.com/launchbadge/sqlx/issues/1037
    pub files: sqlx::types::Json<File>,
}

I try to make a query, and I get the following error: ``expected struct sqlx::types::Json, found enum `JsonValue```

The query is like so:

 match sqlx::query_as!(
            User,
            "
                SELECT *
                FROM users
            "
        )

Now I know this works, if I use JsonValue, but JsonValue has no way to know the reference object..

[ollyde]

@abonander no worries it's a discussion. I think this is a fairly critical function; SQLx is great though apart from this 🕺🏿