user.rs

use crate::db::Conn;
use crate::schema::users;
use chrono::{DateTime, Utc};
use diesel::{
    associations::{HasTable, Identifiable},
    delete, insert_into,
    result::QueryResult,
    ExpressionMethods, QueryDsl, RunQueryDsl,
};
use serde::{Deserialize, Serialize};
use uuid::Uuid;

#[derive(
    Debug,
    Eq,
    PartialEq,
    Insertable,
    Identifiable,
    Queryable,
    Serialize,
    Deserialize,
)]
#[primary_key(uuid)]
pub struct User {
    pub created_at: DateTime<Utc>,
    pub updated_at: DateTime<Utc>,
    pub uuid: Uuid,
    pub display_name: String,
    pub name: String,
    pub email: String,
}

impl User {
    pub fn create(
        conn: &Conn,
        display_name: &str,
        name: &str,
        email: &str,
    ) -> QueryResult<Self> {
        insert_into(users::table)
            .values((
                users::display_name.eq(display_name),
                users::name.eq(name),
                users::email.eq(email),
            ))
            .get_result(conn)
    }

    pub fn get<'ident>(
        conn: &Conn,
        pk: <&'ident Self as Identifiable>::Id,
    ) -> QueryResult<Self> {
        <Self as HasTable>::table().find(pk).first(conn)
    }

    pub fn delete(&self, conn: &Conn) -> QueryResult<usize> {
        delete(self).execute(conn)
    }
}