cratestack-rusqlite 0.4.13

On-device SQLite backend for the CrateStack ORM. Sync API, bundled SQLite, no tokio, intended for mobile/embedded use via FFI.
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

//! SELECT / ORDER BY rendering tests.

#![cfg(test)]

use cratestack_sql::{FieldRef, FilterExpr, OrderClause, SortDirection, SqlValue, SqliteDialect};

use super::select::{render_select, render_select_by_pk};
use super::tests_fixtures::{fixture_descriptor, soft_delete_descriptor};

#[test]
fn select_uses_question_placeholders_for_limit_and_offset() {
    let dialect = SqliteDialect;
    let descriptor = fixture_descriptor();
    let (sql, binds) = render_select(&dialect, &descriptor, &[], &[], Some(10), Some(5));
    assert!(sql.contains("LIMIT ?1"));
    assert!(sql.contains("OFFSET ?2"));
    assert_eq!(binds, vec![SqlValue::Int(10), SqlValue::Int(5)]);
}

#[test]
fn select_with_filter_emits_where_and_binds_value() {
    let dialect = SqliteDialect;
    let descriptor = fixture_descriptor();
    let id_ref = FieldRef::<(), i64>::new("id");
    let (sql, binds) = render_select(
        &dialect,
        &descriptor,
        &[FilterExpr::from(id_ref.eq(42i64))],
        &[],
        None,
        None,
    );
    assert!(sql.contains("WHERE id = ?1"), "got: {sql}");
    assert_eq!(binds, vec![SqlValue::Int(42)]);
}

#[test]
fn select_with_soft_delete_filters_out_deleted_rows() {
    let dialect = SqliteDialect;
    let descriptor = soft_delete_descriptor();
    let (sql, _) = render_select(&dialect, &descriptor, &[], &[], None, None);
    assert!(sql.contains("WHERE deleted_at IS NULL"), "got: {sql}");
}

#[test]
fn select_by_pk_binds_id_and_filters_soft_deletes() {
    let dialect = SqliteDialect;
    let descriptor = soft_delete_descriptor();
    let (sql, binds) = render_select_by_pk(&dialect, &descriptor, SqlValue::Int(7));
    assert!(sql.contains("WHERE id = ?1"));
    assert!(sql.contains("AND deleted_at IS NULL"));
    assert_eq!(binds, vec![SqlValue::Int(7)]);
}

#[test]
fn order_by_appends_nulls_last() {
    let dialect = SqliteDialect;
    let descriptor = fixture_descriptor();
    let (sql, _) = render_select(
        &dialect,
        &descriptor,
        &[],
        &[OrderClause::column("title", SortDirection::Asc)],
        None,
        None,
    );
    assert!(sql.contains("ORDER BY title ASC NULLS LAST"), "got: {sql}");
}

#[test]
fn order_by_nulls_first_flips_null_placement() {
    let dialect = SqliteDialect;
    let descriptor = fixture_descriptor();
    let clause = OrderClause::column("title", SortDirection::Asc).nulls_first();
    let (sql, _) = render_select(&dialect, &descriptor, &[], &[clause], None, None);
    assert!(sql.contains("ORDER BY title ASC NULLS FIRST"), "got: {sql}");
}