"get_result()" trait bound error.

[no-miso]

Hello, I am currently installing diesel and diesel_async and trying to test it.
As the title says.
I have some edits in the code.

diesel-async = { version = "0", features = ["postgres", "bb8", "tokio", "tokio-postgres"] }
diesel = { version = "2", features = ["postgres", "serde_json", "chrono", "uuid"]}

// schema
diesel::table! {
    users (id) {
        id -> Uuid,
        user_name -> Varchar,
        email -> Varchar,
        user_pass -> Varchar,
        created_at -> Timestamptz,
    }
}
// test code
#[derive(Debug, Deserialize, Serialize, Validate, Queryable, Insertable)]
#[table_name = "schema::users"]
pub struct User<'a> {
    pub id: uuid::Uuid,
    pub user_name: &'a str,
    pub email: &'a str,
    pub user_pass: &'a str,
    pub created_at: chrono::DateTime<Utc>,
}
    async fn insert_test() {
        use crate::schema::users::{self, dsl::*};
        use diesel_async::RunQueryDsl;
        use crate::{db::connection::MyDieselConn};

        let conn = MyDieselConn::new().await.unwrap();
        let mut pool = conn.get().await.unwrap();
        let new_user = User{
            id: uuid::Uuid::new_v4(),
            user_name: "testuser",
            email: "test@mail.com",
            user_pass: "Test1234",
            created_at: chrono::Utc::now(),
        };
        let insert = diesel::insert_into(users)
            .values(&new_user)
            .get_result::<User>(&mut pool)
            //.execute(&mut pool)
            .await;
        //...

error

the trait bound `(diesel::sql_types::Uuid, diesel::sql_types::Text, diesel::sql_types::Text, diesel::sql_types::Text, diesel::sql_types::Timestamptz): CompatibleType<models::User<'_>, _>` is not satisfied
the following other types implement trait `CompatibleType<U, DB>`:
  (ST0, ST1)
  (ST0, ST1, ST2)
  (ST0, ST1, ST2, ST3)
  (ST0, ST1, ST2, ST3, ST4)
  (ST0, ST1, ST2, ST3, ST4, ST5)
  (ST0, ST1, ST2, ST3, ST4, ST5, ST6)
  (ST0, ST1, ST2, ST3, ST4, ST5, ST6, ST7)
  (ST0, ST1, ST2, ST3, ST4, ST5, ST6, ST7, ST8)
and 24 others
required for `InsertStatement<table, ValuesClause<(DefaultableColumnInsertValue<...>, ..., ..., ..., ...), ...>>` to implement `diesel_async::methods::LoadQuery<'_, _, models::User<'_>>`
------
the trait bound `models::User<'_>: FromSqlRow<_, _>` is not satisfied
the following other types implement trait `FromSqlRow<ST, DB>`:
  <(T1, T0) as FromSqlRow<(ST1, Untyped), __DB>>
  <(T1, T2, T0) as FromSqlRow<(ST1, ST2, Untyped), __DB>>
  <(T1, T2, T3, T0) as FromSqlRow<(ST1, ST2, ST3, Untyped), __DB>>
  <(T1, T2, T3, T4, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T7, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, ST7, Untyped), __DB>>
  <(T1, T2, T3, T4, T5, T6, T7, T8, T0) as FromSqlRow<(ST1, ST2, ST3, ST4, ST5, ST6, ST7, ST8, Untyped), __DB>>
and 23 others
required for `InsertStatement<table, ValuesClause<(DefaultableColumnInsertValue<...>, ..., ..., ..., ...), ...>>` to implement `diesel_async::methods::LoadQuery<'_, _, models::User<'_>>`

However, I have confirmed that it works if get_result() is execute().
Thank you.

[weiznich]

That's a mismatch between what your query returns and what your struct expects that the query returns. In detail: your query returns 5 fields, while your struct expects 3 fields. Either adjust your query to only return 3 matching fields (in order + type) or adjust your return type to contain 5 matching files (again in order + type).

[no-miso]

Oh sorry, I just removed it in an edit.
I'll list all of them.

[no-miso]

solved. Type mismatch.
fromsql should have used string instead of &str.
thank you.