sqlb 0.4.0

Simple, expressive, and progressive SQL Builder for Rust.
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
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
103
104
105
106
107
108
109
110
111
112
113
114
115
116

use anyhow::Result;
use sqlb::HasFields;
use sqlb_macros::Fields;

#[test]
pub fn test_macro_field_names() -> Result<()> {
	// -- Setup & Fixtures
	#[allow(unused)]
	#[derive(Debug, Fields)]
	struct Todo {
		id: i64,

		#[field(name = "description")]
		desc: Option<String>,
		name: String,

		#[field(skip)]
		something_else: String,
	}
	let fx_desc = "desc 01";

	// -- Exec
	let field_names = Todo::field_names();

	// -- Check
	assert_eq!(field_names, &["id", "description", "name"]);

	// -- Exec & Check
	let todo = Todo {
		id: 123,
		desc: Some(fx_desc.to_string()),
		name: "name 01".to_string(),
		something_else: "something 01".to_string(),
	};
	let fields = todo.all_fields();
	assert_eq!("description", &fields[1].name);
	let val = format!("{:?}", &fields[1].value);
	assert_eq!(r#"Some("desc 01")"#, val);

	Ok(())
}

#[test]
pub fn test_macro_all_fields() -> Result<()> {
	// -- Setup & Fixtures
	#[allow(unused)]
	#[derive(Debug, Fields)]
	struct Todo {
		id: i64,

		#[field(name = "description")]
		desc: Option<String>,
		name: String,

		#[field(skip)]
		something_else: String,
	}
	let fx_desc = "desc 01";

	// -- Exec
	let todo = Todo {
		id: 123,
		desc: Some(fx_desc.to_string()),
		name: "name 01".to_string(),
		something_else: "something 01".to_string(),
	};
	let fields = todo.all_fields();

	// -- Check
	assert_eq!("description", &fields[1].name);
	let val = format!("{:?}", &fields[1].value);
	assert_eq!(r#"Some("desc 01")"#, val);

	Ok(())
}

// Note: Just a compile check.
#[allow(unused)]
#[test]
pub fn test_custom_type_and_enum() -> Result<()> {
	use sqlb::bindable;

	#[derive(sqlb::Fields, Default, Clone)]
	pub struct SubscriptionPatch {
		pub client_id: Option<i32>,
		pub my_val: Option<MyEnum>,
	}

	#[derive(sqlx::Type, Debug, Clone)]
	#[sqlx(type_name = "my_enum")] // must be defined in pg as a enum type.
	pub enum MyEnum {
		One,
		Two,
		TooBig,
	}
	sqlb::bindable!(MyEnum);

	#[derive(Debug, Clone, Copy, sqlx::Type)]
	#[sqlx(transparent)]
	pub struct OffsetDateTime(pub time::OffsetDateTime);
	pub struct ClientName(String);

	Ok(())
}

// Note: Just a compile check.
#[test]
pub fn test_bindable_generic() -> Result<()> {
	#[derive(Debug, Clone, sqlx::Type)]
	#[sqlx(transparent)]
	pub struct ClientRef<T>(T);

	sqlb::bindable!(ClientRef<String>);

	Ok(())
}