miniorm 0.4.1

a *very* simple ORM built on top of sqlx
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

use async_trait::async_trait;

use crate::WithId;

/// \[C\]reate CRUD operation
#[async_trait]
pub trait Create<E> {
    /// Create an object in the database and returns its `id`.
    async fn create(&self, entity: E) -> sqlx::Result<WithId<E>>;
}

/// \[R\]ead CRUD operation
#[async_trait]
pub trait Read<E> {
    /// Reads and returns an object from the database
    async fn read(&self, id: i64) -> sqlx::Result<WithId<E>>;

    /// Lists and return all object from the database
    async fn list(&self) -> sqlx::Result<Vec<WithId<E>>>;

    /// Count and return the number of object in the database
    async fn count(&self) -> sqlx::Result<u64>;
}

/// \[U\]pdate CRUD operation
#[async_trait]
pub trait Update<E> {
    /// Update an object in the database and returns its `id`.
    async fn update(&self, entity: WithId<E>) -> sqlx::Result<WithId<E>>;
}

/// \[D\]elete CRUD operation
#[async_trait]
pub trait Delete<E> {
    /// Delete the object of type `E` corresponding to the provided `id`
    async fn delete(&self, id: i64) -> sqlx::Result<()>;

    /// Delete all objects of type E and return the number of deleted rows
    async fn delete_all(&self) -> sqlx::Result<u64>;
}

/// CRUD operations
#[async_trait]
pub trait Crud<E>: Create<E> + Read<E> + Update<E> + Delete<E> {}

impl<S, E> Crud<E> for S where S: Create<E> + Read<E> + Update<E> + Delete<E> {}