feat: implement unsigned int support for sqlite

[dignifiedquire]

No description provided.

[mehcode]

Thank you ❤️

[markazmierczak]

This will result in data loss for u64 larger than std::i64::MAX.

[mehcode]

This should be try_into() but Encode is not fallible (yet).

[mehcode]

@dignifiedquire Does your use case need u64 ? It might be safer to remove this one until we have a fallible Encode.

[dignifiedquire]

Ah yes, you are right. I am fine not having u64 supported for the moment, so likely better to remove this.

[dignifiedquire]

@mehcode there is still an issue with this code I am afraid, but I am not sure where it is coming from (sorry for not mentioning earlier here)

Caused by:
    0: error occurred while decoding column 2: mismatched types; Rust type `deltachat::contact::Origin` (as SQL type `INTEGER`) is not compatible with SQL type `INTEGER`
    1: mismatched types; Rust type `deltachat::contact::Origin` (as SQL type `INTEGER`) is not compatible with SQL type `INTEGER`', src/qr.rs:523:23
n

happens when I try to use this with

#[derive(sqlx::Type)]
#[repr(u32)]
enum Origin {
  Foo = 1,
  Bar = 2,
  // ... 
}

[dignifiedquire]

@mehcode any ideas on the above?

[w4]

@dignifiedquire I ran into that one recently, try using a signed integer instead ie. #[repr(i32)], not sure why this is the way it is but the workaround works for my scenario at least.

[mehcode]

Thanks for pinging me. I'll look into this.