Support for Vec<impl From<Value>> in models

[tqwewe]

Models should allow for columns which are arrays.

For example a Postgres array column called "images":

"images" VARCHAR[] NOT NULL DEFAULT ARRAY[]::VARCHAR[],

Should integrate with a type Vec<String> on a model.

pub struct Model {
    pub id: Uuid,
    pub images: Vec<String>,
}

Currently, it throws an error:

the trait From<Vec<std::string::String>> is not implemented for sea_orm::Value

[billy1624]

But all other databases (MySQL & SQLite) does not support array

[tqwewe]

Oh I see, I wonder if this feature could only be enabled when you have the postgres feature flag active.

I did see that MySQL has a JSON type and a JSON_ARRAY function... I wonder if it could also be implemented for MySQL and it works on JSON types, but if the JSON is an object, it will fail?

[BastienVigneron]

+1

I just test sea-orm-cli generate entity from my model (which work fine with Diesel.rs), and I obtain the following code for entities :

...
    #[sea_orm(column_type = "Custom(\"array\".to_owned())", nullable)]
    pub other_patient_ids: Option<String>,
...

for a column declared as other_patient_ids text[], in PostgreSQL.

Clearly, other_patient_ids should be a Option<Vec<String>>.
Is it planned to support ?

[tyt2y3]

Cont'd in #576

[emmiegit]

I'm confused, why was this closed? The other issue #576 is less detailed and is more recent. Is it because this is being worked on?

[tyt2y3]

just to consolidate the discussions