insert with vector of uuids as a column?

[digevgreg]

Hi,

I'm trying to do a very basic Insert. It works perfectly if I only insert "Id" and "Owner" which are both of type uuid (from the uuid crate). So these support the "into()" trait so it just converts these uuid values to whatever values_panic wants (I guess?).

The problem is with my "categories" column which is an array of UUID in Postgres and a Vec in Rust. So how do I convert this Vec into whatever "values_panic" is looking for? Which according to the documentation takes a: IntoIterator<Item = SimpleExpr>

Thank you!

    let (sql, values) = Query::insert()
    .into_table(MyTable::Table)
    .columns([
        MyTable::Id,
        MyTable::Owner,
        MyTable::Categories,
    ])
    .values_panic(
        manager.unwrap().into(),
        owner.unwrap().into(),
        ???categories????
)
    .returning_col(MyTable::Id)
    .build_sqlx(PostgresQueryBuilder);

[billy1624]

Hey @digevgreg, welcome! A sanity check: are you on SeaQuery 0.27 and enabled postgres-array feature?

[digevgreg]

Cargo.toml looks like:

sea-query = { version = "^0", features = ["derive"] }
sea-query-binder = { version = "^0", features = ["sqlx-postgres","with-uuid","with-json","runtime-tokio-rustls"] }

[digevgreg]

So I guess probably the newest version but no postgres-array

[digevgreg]

Adding postgres-array to sea-query-binder seems to have solved my problem! Thank you Billy!