How can I get a REAL field in sqlite as DECIMAL in Rust?

[Froidoh]

Hola!

Defining my struct with:

pub price: rust_decimal::Decimal,

fails because

#[derive(Debug, Default, Clone, WeldsModel)]
| ^^^^^^^^^^ the trait sqlx::Type<sqlx::Sqlite> is not implemented for rust_decimal::Decimal

I have

sqlx = { version = "0.8.3", features = [
    "runtime-tokio-rustls", "sqlite", "rust_decimal"
  ]}

in my Cargo.toml though

[lex148]

So unfortunately this is an sqlx issue not welds. We are just a wrapper on top. They do not support rust_decimal for sqlite. You will notice it will work if you change it from sqlite to postgres in your Cargo.toml

There are two workarounds you might want to consider.

Option 1)
Store your decimal values as strings. this is less than ideal I know, but is really what you would expect if loading a value from sqlite.

Option 2)
We have several examples of making wrapper struct to convert to and from sql transparently. You could make your own type that hold the value. You could then pick exactly how you want it stored in sqlite. This would require a little extra coding, but would get you exactly what you want.