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
63
64
65
66
67
68
69
70

use crate::Syntax;
use crate::WeldsModel;

#[derive(Debug, Default, WeldsModel)]
#[welds(table = "products")]
#[welds_path(crate)] // needed only within the welds crate.
#[welds(HasMany(orders, Order, "product_id"))]
struct Product {
    #[welds(primary_key)]
    pub id: i32,
    pub name: String,
}

#[derive(Debug, Default, WeldsModel)]
#[welds(table = "orders")]
#[welds_path(crate)] // needed only within the welds crate.
#[welds(BelongsTo(product, Product, "product_id"))]
struct Order {
    #[welds(primary_key)]
    pub id: i32,
    pub product_id: i32,
    pub price: i32,
}

#[test]
fn should_be_able_to_select_as() {
    futures::executor::block_on(async move {
        let q = Product::all().select_as(|x| x.id, "apples");
        let sql = q.to_sql(Syntax::Postgres);
        assert_eq!(sql, "SELECT t1.\"id\" AS \"apples\" FROM products t1");
    });
}

#[test]
fn should_be_able_to_select_distinct() {
    futures::executor::block_on(async move {
        let q = Product::all().select(|x| x.name).distinct();
        let sql = q.to_sql(Syntax::Postgres);
        assert_eq!(sql, "SELECT DISTINCT t1.\"name\" FROM products t1");
    });
}

#[test]
fn should_be_able_to_select_both_sets_of_ids() {
    futures::executor::block_on(async move {
        let q = Product::all()
            .select_as(|x| x.id, "pid")
            .join(|x| x.orders, Order::all().select_as(|o| o.id, "oid"));
        let sql = q.to_sql(Syntax::Postgres);
        assert_eq!(
            sql,
            "SELECT t1.\"id\" AS \"pid\", t2.\"id\" AS \"oid\" FROM products t1 JOIN orders t2 ON t1.\"id\" = t2.\"product_id\""
        );
    });
}

#[test]
fn should_be_able_to_select_join_with_order_by() {
    futures::executor::block_on(async move {
        let q = Product::all()
            .select(|x| x.id)
            .join(|x| x.orders, Order::all().select_as(|o| o.price, "price"))
            .order_by_asc(|x| x.id);
        let sql = q.to_sql(Syntax::Postgres);
        assert_eq!(
            sql,
            "SELECT t1.\"id\", t2.\"price\" FROM products t1 JOIN orders t2 ON t1.\"id\" = t2.\"product_id\" ORDER BY t1.\"id\" ASC"
        );
    });
}