Using Newtype pattern with sqlx.

[ijsgaus]

I try use newtype pattern, as described below:

use std::error::Error;
use sqlx::{query_as, postgres::{PgExecutor}, Database, Decode};
use sqlx::database::HasValueRef;
use uuid::Uuid;

#[derive(sqlx::Decode, sqlx::Encode)]
pub struct ResourceId(Uuid);

impl sqlx::Type<sqlx::Postgres> for ResourceId {
    fn type_info() -> <sqlx::Postgres as sqlx::Database>::TypeInfo {
        <uuid::Uuid as sqlx::Type<sqlx::Postgres>>::type_info()
    }
}

#[derive(sqlx::Decode, sqlx::Encode)]
pub struct ExternalResourceId(String);


pub struct Resource {
    pub id : ResourceId,
    pub kind : String,
    pub external_id : ExternalResourceId,
    pub description : serde_json::Value
}

impl Resource {
    pub async fn pg_load_id<T>(id: ResourceId, executor: T) -> sqlx::Result<Self>
        where for<'a> T : PgExecutor<'a>
    {
        query_as!(Resource, "select id, kind, external_id, description from resources")
            .fetch_one(executor)
            .await?
    }
}

I have this postgres table script:

create table if not exists resources (
  id uuid constraint pk_resources primary key,
  kind varchar(50) not null,
  external_id varchar(128) null,
  description jsonb null
);

And receive this error on compilation:
clinic-schedules/src/models.rs:30:9
|
30 | query_as!(Resource, "select id, kind, external_id, description from resources")
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ expected struct ResourceId, found struct Uuid
|
= note: this error originates in the macro $crate::sqlx_macros::expand_query which comes from the expansion of the macro query_as (in Nightly builds, run with -Z macro-backtrace for more info)
help: try wrapping the expression in models::ResourceId
--> /home/ijsgaus/.cargo/registry/src/github.com-1ecc6299db9ec823/sqlx-0.6.2/src/macros/mod.rs:558:9
|
558| models::ResourceId($crate::sqlx_macros::expand_query!(record = $out_struct, source = $query))
| +++++++++++++++++++

What is my mistake please?

[frederikhors]

Did you find a way?