welds 0.4.22

An async ORM for (postgres, mssql, mysql, sqlite)
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102

use super::*;
use crate::model_traits::Column;
use crate::model_traits::HasSchema;
use crate::model_traits::TableColumns;
use crate::model_traits::TableInfo;
use crate::query::clause::BasicOpt;

// Test Object that can be used to write SQL
// Testing with null/some/and unwrapped values
//

// model with option
#[allow(dead_code)]
struct Product2 {
    pub name: Option<String>,
}

impl TryFrom<Row> for Product2 {
    type Error = crate::WeldsError;
    fn try_from(_value: Row) -> std::result::Result<Self, Self::Error> {
        Ok(Product2 { name: None })
    }
}

pub struct Product2Schema {
    name: BasicOpt<String>,
}

impl Default for Product2Schema {
    fn default() -> Self {
        Self {
            name: BasicOpt::new("dbname", "name"),
        }
    }
}

impl TableInfo for Product2Schema {
    fn identifier() -> &'static [&'static str] {
        &["da_schemaname", "da_tablename"]
    }
}

impl TableColumns for Product2Schema {
    type ColumnStruct = Self;
    fn select_columns() -> Vec<Column> {
        vec![Column::new("dbname", "String", true)]
    }
    fn update_columns() -> Vec<Column> {
        vec![Column::new("dbname", "String", true)]
    }
    fn insert_columns() -> Vec<Column> {
        vec![Column::new("dbname", "String", true)]
    }
    fn primary_keys() -> Vec<Column> {
        vec![]
    }
}

impl HasSchema for Product2 {
    type Schema = Product2Schema;
}

// Tests

#[test]
fn should_exec_basicopt_with_where_with_value() {
    futures::executor::block_on(async move {
        let q = QueryBuilder::<Product2>::new().where_col(|c| c.name.equal("bla"));
        let client = welds_connections::noop::build(Syntax::Mssql);
        q.run(&client).await.unwrap();
        let ran_sql = client.last_sql().unwrap();
        let expected =
            "SELECT t1.\"dbname\" FROM da_schemaname.da_tablename t1 WHERE ( t1.\"dbname\" = @p1 )";
        assert_eq!(expected, &ran_sql);
    });
}

#[test]
fn should_exec_basicopt_with_where_with_none() {
    futures::executor::block_on(async move {
        let q = QueryBuilder::<Product2>::new().where_col(|c| c.name.equal(None));
        let client = welds_connections::noop::build(Syntax::Mssql);
        q.run(&client).await.unwrap();
        let ran_sql = client.last_sql().unwrap();
        let expected = "SELECT t1.\"dbname\" FROM da_schemaname.da_tablename t1 WHERE ( t1.\"dbname\" IS NULL )";
        assert_eq!(expected, &ran_sql);
    });
}

#[test]
fn should_exec_basicopt_with_where_with_some() {
    futures::executor::block_on(async move {
        let foo = Some("bar".to_string());
        let q = QueryBuilder::<Product2>::new().where_col(|c| c.name.equal(&foo));
        let client = welds_connections::noop::build(Syntax::Mssql);
        q.run(&client).await.unwrap();
        let ran_sql = client.last_sql().unwrap();
        let expected =
            "SELECT t1.\"dbname\" FROM da_schemaname.da_tablename t1 WHERE ( t1.\"dbname\" = @p1 )";
        assert_eq!(expected, &ran_sql);
    });
}