Upgrade SeaORM dependency to 0.10.x

[billy1624]

Motivation

SeaORM 0.10.x is released (chnagelog). We should upgrade SeaORM dependency on seaography side as well.

Tasks

• Upgrade to SeaORM 0.10.x
• Support Vec<T> for Postgres
• Anything else...?

[Musbell]

Got this error while building a Docker image.

------
 > [cacher 3/3] RUN cargo chef cook --release --recipe-path recipe.json:
#17 1.318     Updating crates.io index
#17 218.3 error: failed to select a version for the requirement `sea-orm = "^0.9"`
#17 218.3 candidate versions found which didn't match: 0.8.0, 0.7.1, 0.7.0, ...
#17 218.3 location searched: crates.io index
#17 218.3 required by package `planta-api v0.0.1 (/app)`
#17 218.3 thread 'main' panicked at 'Exited with status code: 101', /usr/local/cargo/registry/src/github.com-1ecc6299db9ec823/cargo-chef-0.1.35/src/recipe.rs:145:27
#17 218.3 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
------

I believe upgrading the SeaORM dependency to 0.10.x will fix it.

[billy1624]

Hey @Musbell, try upgrading your Rust to at least 1.60. SeaORM need Rust 1.60 to compile.

[Musbell]

Thanks, @billy1624 it worked : )

[karatakis]

@billy1624 what do you mean by support Vec for PostgreSQL? Do you have an example ?

[tyt2y3]

I think Billy meant https://github.com/SeaQL/sea-orm/blob/master/tests/collection_tests.rs

Since this is a Postgres-only feature, may be we can think about it later, as I don't want to create hassle in Seaography for handling database-specific behaviour.

[karatakis]

In order to add new types we currently need to both https://github.com/SeaQL/seaography/blob/main/src/lib.rs#L146-L205 and https://github.com/SeaQL/seaography/blob/main/derive/src/filter.rs#L53-L81. This #87 will solve to maintain the list only on the first file. I merge the update for the moment and wait for more progress on other areas

[billy1624]

We can wait #87 resolved before considering the support of Vec<T> for Postgres.

But I imagine it's readonly and we won't support filtering operation that's specific to array column of Postgres.

I think all we have to do is just implement some trait on seaography side and enable the "postgres-array" feature on sea-orm and perhaps introduce "postgres-array" feature on seaography side as well

[billy1624]

Okay, with #87 resolved now we can get back to this.

[karatakis]

This needs more work because of the Vec, I noticed this problem yesterday when I was trying to generate the postgres example

[karatakis]

This is update has been applied to the code base, but only #128 is needed, so I close this issue