welds 0.4.23

An async ORM for (postgres, mssql, mysql, sqlite)
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
51
52
53
54
55
56
57
58
59
60
61
62

use crate::Syntax;
use crate::state::DbState;

// Testing that the tail end of the SQL is correct
// Limits / skips / orders
use crate::WeldsModel;

#[derive(Debug, Default, WeldsModel)]
#[welds(table = "nums")]
#[welds_path(crate)] // needed only within the welds crate.
struct Product {
    #[welds(primary_key)]
    pub id: i32,
    pub a: i32,
    pub b: i32,
}

// Tests

#[test]
fn should_be_able_to_delete_simple_object() {
    futures::executor::block_on(async move {
        let obj = Product::default();
        let mut obj = DbState::db_loaded(obj);
        let client = welds_connections::noop::build(Syntax::Mysql);
        let _ = obj.delete(&client).await;
        let ran_sql = client.last_sql().unwrap();
        let expected = "DELETE FROM nums where id=?";
        assert_eq!(expected, &ran_sql);
    });
}

#[test]
fn should_be_able_to_write_delete_query() {
    futures::executor::block_on(async move {
        use crate::query::builder::QueryBuilder;
        let q = QueryBuilder::<Product>::new().where_col(|c| c.a.gt(1));
        let client = welds_connections::noop::build(Syntax::Mysql);
        let _ = q.delete(&client).await;
        let ran_sql = client.last_sql().unwrap();
        let expected = "DELETE FROM nums WHERE ( nums.a > ? )";
        assert_eq!(expected, &ran_sql);
    });
}

#[test]
fn should_be_able_to_write_delete_query_with_limit() {
    futures::executor::block_on(async move {
        use crate::query::builder::QueryBuilder;
        let q = QueryBuilder::<Product>::new()
            .where_col(|c| c.a.gt(1))
            .limit(10);
        let client = welds_connections::noop::build(Syntax::Mysql);
        let _ = q.delete(&client).await;
        let ran_sql = client.last_sql().unwrap();
        let expected = "DELETE FROM nums WHERE (  nums.id IN (SELECT t1.id FROM nums t1 WHERE ( t1.a > ? ) ORDER BY 1 LIMIT 0, 10)  )";
        assert_eq!(expected, &ran_sql);

        let args_count = client.args_count().unwrap();
        assert_eq!(args_count, 1);
    });
}