sqlxo 0.9.1

sqlxo: small SQL query builder + derives for filterable ORM-ish patterns
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

use sqlxo::{
	and,
	blocks::{
		Expression,
		SortOrder,
	},
	one,
	or,
	order_by,
};

use crate::helpers::{
	ItemColumn,
	ItemQuery,
	ItemSort,
};

#[test]
fn expression_macros() {
	let plain_query = Expression::Or(vec![
		Expression::And(vec![
			Expression::Leaf(ItemQuery::NameLike("%SternLampe%".into())),
			Expression::Leaf(ItemQuery::DescriptionNeq("Hohlweg".into())),
		]),
		Expression::Leaf(ItemQuery::PriceGt(1800f32)),
	]);

	let long_macro_query = or![
		and![
			Expression::Leaf(ItemQuery::NameLike("%SternLampe%".into())),
			Expression::Leaf(ItemQuery::DescriptionNeq("Hohlweg".into())),
		],
		Expression::Leaf(ItemQuery::PriceGt(1800f32)),
	];

	let short_macro_query = or![
		and![
			ItemQuery::NameLike("%SternLampe%".into()),
			ItemQuery::DescriptionNeq("Hohlweg".into()),
		],
		ItemQuery::PriceGt(1800f32),
	];

	assert_eq!(plain_query, long_macro_query);
	assert_eq!(long_macro_query, short_macro_query);
}

#[test]
#[allow(unused_parens)]
fn one_macro_builds_single_expression() {
	let plain_query = Expression::Leaf(ItemQuery::NameEq("a".into()));
	let macro_query: Expression<ItemQuery> =
		one! {(ItemQuery::NameEq("a".into()))};

	assert_eq!(plain_query, macro_query);
}

#[test]
fn sort_macros() {
	let plain_sort =
		SortOrder(vec![ItemSort::ByAmountAsc, ItemSort::ByNameDesc]);
	let short_macro_sort =
		order_by![ItemSort::ByAmountAsc, ItemSort::ByNameDesc];

	assert_eq!(plain_sort, short_macro_sort);
}

#[test]
fn take_macro_emits_selection_list_for_blocks() {
	let plain_take = &["id", "name"];
	let macro_take = sqlxo::take!(ItemColumn::Id, ItemColumn::Name);

	let macro_cols: Vec<_> = macro_take
		.clone()
		.expect_columns()
		.columns()
		.iter()
		.map(|col| col.column)
		.collect();

	assert_eq!(plain_take, macro_cols.as_slice());
}