kali 0.1.0

A query builder and orm-ish crate built on 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
47
48
49
50

use kali::{column::ColumnExpr, entity::Entity};
use sqlx::SqlitePool;

#[kali::entity("users")]
#[derive(Debug, sqlx::FromRow)]
struct User {
    id: i64,
    username: String,
}

#[kali::entity("user_profiles")]
#[derive(Debug, sqlx::FromRow)]
struct UserProfile {
    #[primary_key]
    user_id: i64,
    bio: String,
}

#[sqlx::test(migrations = "tests/migrations", fixtures("users"))]
async fn fetch_user_by_id(pool: SqlitePool) -> anyhow::Result<()> {
    let user = User::fetch_one(&pool, 1).await?;

    assert_eq!(user.id, 1);
    assert_eq!(user.username, "holden");

    Ok(())
}

#[sqlx::test(migrations = "tests/migrations", fixtures("users"))]
async fn query_user_by_id(pool: SqlitePool) -> anyhow::Result<()> {
    let user: User = User::query()
        .filter(User::Id.eq(1))
        .fetch_one(&pool)
        .await?;

    assert_eq!(user.id, 1);
    assert_eq!(user.username, "holden");

    Ok(())
}

#[sqlx::test(migrations = "tests/migrations", fixtures("users", "profiles"))]
async fn fetch_non_standard_pk(pool: SqlitePool) -> anyhow::Result<()> {
    let user_profile = UserProfile::fetch_one(&pool, 1).await?;

    assert_eq!(user_profile.user_id, 1);
    assert_eq!(user_profile.bio, "can't park there bud");

    Ok(())
}