chain-builder 2.0.0

A typed, dialect-aware SQL query builder for Rust (PostgreSQL/MySQL/SQLite).
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

//! M9: feature-gated `uuid` / `chrono` bind types.
//!
//! Each module is gated by its feature so the default test build stays green and
//! byte-identical. Tests assert both that `IntoBind` produces the right `Value`
//! variant (no DB needed) and that the value flows through `to_sql` as a bind.

#[cfg(feature = "uuid")]
mod uuid_tests {
    use chain_builder::{IntoBind, Postgres, QueryBuilder, Value};

    #[test]
    fn uuid_into_bind_is_uuid_variant() {
        let id = uuid::Uuid::nil();
        assert_eq!(id.into_bind(), Value::Uuid(id));
    }

    #[test]
    fn uuid_binds() {
        let id = uuid::Uuid::nil();
        let (sql, binds) = QueryBuilder::<Postgres>::table("t")
            .select(["id"])
            .where_eq("id", id)
            .to_sql();
        assert_eq!(sql, r#"SELECT "id" FROM "t" WHERE "id" = $1"#);
        assert_eq!(binds, vec![Value::Uuid(id)]);
    }

    #[test]
    fn option_uuid_some_and_none() {
        let id = uuid::Uuid::nil();
        assert_eq!(Some(id).into_bind(), Value::Uuid(id));
        assert_eq!(Option::<uuid::Uuid>::None.into_bind(), Value::Null);
    }
}

#[cfg(feature = "chrono")]
mod chrono_tests {
    use chain_builder::{IntoBind, Postgres, QueryBuilder, Value};
    use chrono::{DateTime, NaiveDate, NaiveDateTime, NaiveTime, Utc};

    fn sample_dt_utc() -> DateTime<Utc> {
        DateTime::<Utc>::from_timestamp(1_700_000_000, 0).unwrap()
    }

    fn sample_naive_date() -> NaiveDate {
        NaiveDate::from_ymd_opt(2026, 6, 9).unwrap()
    }

    fn sample_naive_time() -> NaiveTime {
        NaiveTime::from_hms_opt(13, 30, 0).unwrap()
    }

    fn sample_naive_datetime() -> NaiveDateTime {
        NaiveDateTime::new(sample_naive_date(), sample_naive_time())
    }

    #[test]
    fn datetime_utc_into_bind() {
        let dt = sample_dt_utc();
        assert_eq!(dt.into_bind(), Value::DateTimeUtc(dt));
    }

    #[test]
    fn naive_datetime_into_bind() {
        let ndt = sample_naive_datetime();
        assert_eq!(ndt.into_bind(), Value::NaiveDateTime(ndt));
    }

    #[test]
    fn naive_date_into_bind() {
        let nd = sample_naive_date();
        assert_eq!(nd.into_bind(), Value::NaiveDate(nd));
    }

    #[test]
    fn naive_time_into_bind() {
        let nt = sample_naive_time();
        assert_eq!(nt.into_bind(), Value::NaiveTime(nt));
    }

    #[test]
    fn datetime_utc_binds() {
        let dt = sample_dt_utc();
        let (sql, binds) = QueryBuilder::<Postgres>::table("t")
            .select(["id"])
            .where_eq("created_at", dt)
            .to_sql();
        assert_eq!(sql, r#"SELECT "id" FROM "t" WHERE "created_at" = $1"#);
        assert_eq!(binds, vec![Value::DateTimeUtc(dt)]);
    }

    #[test]
    fn naive_date_binds() {
        let nd = sample_naive_date();
        let (sql, binds) = QueryBuilder::<Postgres>::table("t")
            .select(["id"])
            .where_eq("day", nd)
            .to_sql();
        assert_eq!(sql, r#"SELECT "id" FROM "t" WHERE "day" = $1"#);
        assert_eq!(binds, vec![Value::NaiveDate(nd)]);
    }

    #[test]
    fn option_chrono_none_becomes_null() {
        assert_eq!(Option::<DateTime<Utc>>::None.into_bind(), Value::Null);
        assert_eq!(Option::<NaiveDate>::None.into_bind(), Value::Null);
    }
}