The rocket_db_pools::Connection doesn't work in sqlx::query_as() method.

[crystal-patronus]

#[macro_use] extern crate rocket;


use rocket::serde::{json::Json, Deserialize, Serialize};
use rocket::response::{Responder, Result as ResponseResult};
use rocket::Request;
use rocket_db_pools::{Connection, Database};
use rocket::http::Status;


#[derive(Deserialize, Serialize, sqlx::FromRow)]
#[serde(crate = "rocket::serde")]
struct Task {
   id: i64,
   item: String
}


#[derive(Deserialize, Serialize)]
#[serde(crate = "rocket::serde")]
struct TaskItem<'r> {
   item: &'r str
}


#[derive(Deserialize, Serialize)]
#[serde(crate = "rocket::serde")]
struct TaskId {
   id: u8
}


#[derive(Database)]
#[database("todo")]
struct TodoDatabase(rocket_db_pools::sqlx::PgPool);


struct DatabaseError(rocket_db_pools::sqlx::Error);


impl<'r> Responder<'r, 'r> for DatabaseError {
   fn respond_to(self, _: &Request<'_>) -> ResponseResult<'r> {
       Err(Status::InternalServerError)
   }
}


impl From<rocket_db_pools::sqlx::Error> for DatabaseError {
   fn from(error: rocket_db_pools::sqlx::Error) -> Self {
       DatabaseError(error)
   }
}


#[get("/")]
fn index() -> &'static str {
   "hello, world!"
}


#[allow(unused)]
#[post("/addtask", data="<task>")]
async fn add_task(task: Json<TaskItem<'_>>, mut db: Connection<TodoDatabase>) -> Result<Json<Task>, DatabaseError> {
   let added_task = sqlx::query_as::<_, Task>("INSERT INTO tasks (item) VALUES ($1) RETURNING *")
       .bind(task.item)
       .fetch_one(&mut *db)
       .await?;


   Ok(Json(added_task))
}


#[launch]
fn rocket() -> _ {
   rocket::build()
       .attach(TodoDatabase::init())
       .mount("/", routes![index, add_task])
}

This is the main.rs file from my project. But it gives me an error as following.

.fetch_all(&mut *db)
--------- ^^^^^^^^ the trait sqlx::Executor<'_> is not implemented for `&mut rocket_db_pools::sqlx::pool::PoolConnection<rocket_db_pools::sqlx::Postgres>

If anyone know how to fix it, please help me to fix this error.
Thank you in advance.

[SergioBenitez]

You need another *.

[crystal-patronus]

Yeah, I just solved it.
Thanks.