How to use uuid with sqlite?

[woile]

Hello people!
First, thanks a lot for this awesome library, it brought me back to good ol' SQL and it feels super nice to use it.

I'm having an issue with sqlite and uuid's, I've asked around different discord servers with little to no success, and I've been stuck for a week with this issue, I'm quite new to rust and sqlx so I thought about opening this discussion (I do not know if it's an issue).

I'm trying to use uuid with sqlite::query_as!, but I get an error:

mismatched types
expected struct `uuid::Uuid`
   found struct `std::vec::Vec<u8>`

my understanding is that a struct with a uuid should be possible to convert to uuid and back when doing a query with query_as, something like:

#[derive(FromRow, Debug)]
pub struct User {
    pub uuid: uuid::Uuid,
}

async fn insert_user(pool: &SqlitePool) -> Result<User> {
  let uuid = uuid::Uuid::new_v4();
  let user = sqlx::query_as!(
        User,
        r#"
        INSERT INTO users__users (uuid) VALUES ($1) RETURNING uuid
        "#,
        uuid,
    )
    .fetch_one(pool)
    .await?;
  Ok(user)
}

Is this correct?

I checked the source code and it seems so (with my little understanding):

sqlx/sqlx-core/src/sqlite/types/uuid.rs

Lines 20 to 35 in 2182925

	impl<'q> Encode<'q, Sqlite> for Uuid {
	fn encode_by_ref(&self, args: &mut Vec<SqliteArgumentValue<'q>>) -> IsNull {
	args.push(SqliteArgumentValue::Blob(Cow::Owned(
	self.as_bytes().to_vec(),
	)));
	IsNull::No
	}
	}
	impl Decode<'_, Sqlite> for Uuid {
	fn decode(value: SqliteValueRef<'_>) -> Result<Self, BoxDynError> {
	// construct a Uuid from the returned bytes
	Uuid::from_slice(value.blob()).map_err(Into::into)
	}
	}

I built a repository with an example, just clone it and you'll see the error:
https://github.com/Woile/example-sqlx-sqlite

At this point I think I'm missing something, but I do not know what is it, some configuration? some trait?

Please help 🙏🏻

Thank you!

[dvob]

@woile query_as returns a String if you used TEXT and Vec<u8> if you used BLOB. To convert it to a Uuid you have to use the SELECT uuid as "uuid: uuid::Uuid" FROM ... syntax.
Here you can find an example: https://github.com/dvob/sqlx-test/blob/1da9e0bde140c247f862c0079c74ed30d6fa1919/src/user.rs#L55
Here is the documentation: https://docs.rs/sqlx/latest/sqlx/macro.query_as.html#column-type-override-infer-from-struct-field

[woile]

Thank you, I already found the answer and forgot to update this.