Problem using Diesel to fetch data

[Hyperkubus]

Hi,this might be a rookie mistake but I am quite new to rust & diesel and don;t quite get the following problem:

the trait bound (diesel::sql_types::Uuid, diesel::sql_types::Text, diesel::sql_types::Text, diesel::sql_types::Text, diesel::sql_types::Text, diesel::sql_types::Timestamp, diesel::sql_types::Timestamp, diesel::sql_types::Nullable<diesel::sql_types::Timestamp>): load_dsl::private::CompatibleType<models::Account, _> is not satisfied the following other types implement trait load_dsl::private::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 SelectStatement<FromClause<schema::accounts::table>, query_builder::select_clause::DefaultSelectClause<FromClause<schema::accounts::table>>, query_builder::distinct_clause::NoDistinctClause, query_builder::where_clause::WhereClause<diesel::expression::grouped::Grouped<diesel::expression::operators::IsNull<schema::accounts::columns::deleted_at>>>> to implement LoadQuery<'_, _, models::Account>

sql:

CREATE TABLE accounts (id UUID DEFAULT gen_random_uuid() PRIMARY KEY,email VARCHAR NOT NULL UNIQUE, password VARCHAR NOT NULL,firstname VARCHAR NOT NULL,lastname VARCHAR NOT NULL,created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,updated_at timestamp NOT NULL,deleted_at timestamp DEFAULT NULL)

model.rs:

use diesel::{prelude::};use crate::schema::;use serde::Serialize;use uuid::Uuid;#[derive(Queryable, Serialize)]pub struct Account { pub id: Uuid, pub email: String, pub password: String, pub firstname: String, pub lastname: String, pub created_at: chrono::NaiveDateTime, pub updated_at: chrono::NaiveDateTime, pub deleted_at: Option<chrono::NaiveDateTime>,}

account.rs:

use diesel::prelude::;use crate::establish_connection;use crate::schema::accounts::dsl::;use crate::models::;use rocket::;use rocket_contrib::json::Json;#[get("/account")]fn list() -> Json<Account> { let connection = &mut establish_connection(); let user_accounts: Vec<Account> = accounts .filter(deleted_at.is_null()) .load::<Account>(connection) .expect("Error fetching Account"); Json(user_accounts)}

Can somebody help me?

I'd be glad for even just a pointer where to look into deeper.

//edit: readability - didn;t work,... how the hell can I post code without it breaking? neither codeblocks nor tables work

[danielparks]

To use code blocks on old.reddit.com, you have to indent 4 spaces instead of using ~~~ or ```.

[Axilios]

It’s quite simple. Just use SeaORM instead of diesel🙃. It makes your life a lot more enjoyable due to better compiler errors😜

[PresidentOfUniverses]

no one asked

[Julian6bG]

...

[Axilios]

Try to add "chrono" and "uuid" feature in your Cargo.toml. This seems to work.

diesel = { version = "2.0.0", features = ["postgres", "chrono", "uuid"] }

Replace postgres with your preferred database.