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

#![feature(inherent_associated_types)]
#![allow(incomplete_features)]

use criterion::{
	criterion_group,
	criterion_main,
	Criterion,
};
use sqlx::FromRow;
use sqlxo::blocks::{
	BuildableFilter,
	BuildableJoin,
};
use sqlxo::{
	Buildable,
	JoinKind,
	QueryBuilder,
};
use sqlxo::{
	JoinValue,
	Query,
};
use uuid::Uuid;

#[derive(Debug, Clone, FromRow, Query)]
pub struct Material {
	#[sqlxo(primary_key)]
	pub id: Uuid,
}

#[derive(Debug, Clone, FromRow, Query)]
pub struct Item {
	#[sqlxo(primary_key)]
	pub id:          Uuid,
	#[sqlxo(foreign_key(to = "material.id"))]
	pub material_id: Option<Uuid>,

	#[sqlxo(belongs_to)]
	#[sqlx(skip)]
	pub material: JoinValue<Material>,
}

fn bench_read_builder(c: &mut Criterion) {
	let mut group = c.benchmark_group("read_builder");

	group.bench_function("baseline", |b| {
		b.iter(|| {
			let plan = QueryBuilder::<Item>::read().build();
			criterion::black_box(plan.sql(sqlxo::blocks::SelectType::Star));
		});
	});

	group.bench_function("join_and_where", |b| {
		b.iter(|| {
			let plan = QueryBuilder::<Item>::read()
				.join(ItemJoin::ItemToMaterialByMaterialId, JoinKind::Left)
				.r#where(sqlxo::blocks::Expression::Leaf(
					ItemQuery::MaterialIdIsNotNull,
				))
				.build();
			criterion::black_box(plan.sql(sqlxo::blocks::SelectType::Star));
		});
	});

	group.finish();
}

criterion_group!(benches, bench_read_builder);
criterion_main!(benches);