How to use sqlx::Type with more complex scalar types?

[thomaseizinger]

I have a Rust type that consists of multiple fields, in particular it looks like this:

pub struct BitMexPriceEventId {
    /// The timestamp this price event refers to.
    timestamp: OffsetDateTime,
    digits: usize,
}

This type has a Display and FromStr implementation and hence can represent itself as a single scalar value. I would like to store this value in the database using its string representation AND use this type directly within SQL queries (which means sqlx needs to know how to handle it).

What is the best way of supporting this? Perhaps this would work?

#[derive(sqlx::Type)]
#[sqlx(display_fromstr)] // name subject to bike-shedding
pub struct BitMexPriceEventId {
    /// The timestamp this price event refers to.
    timestamp: OffsetDateTime,
    digits: usize,
}

[jplatte]

This seems more appropriate for the Q&A section of the discussions than an issue.

[thomaseizinger]

This seems more appropriate for the Q&A section of the discussions than an issue.

Makes sense, can someone with mod rights move it please?

[jplatte]

"Moving" it only copy-pastes it and and closes the issue, so you can do that too ;)

[thomaseizinger]

"Moving" it only copy-pastes it and and closes the issue, so you can do that too ;)

Does it? I swear I've been redirected to discussions before that were originally issues.

In any case, I can re-create this as a discussion.