chain-builder 2.1.2

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

//! `Value::Decimal` binding (requires the `decimal` feature).
#![cfg(feature = "decimal")]

use std::str::FromStr;

use chain_builder::{IntoBind, Postgres, QueryBuilder, Value};
use rust_decimal::Decimal;

#[test]
fn decimal_into_bind() {
    let d = Decimal::from_str("19.99").unwrap();
    assert_eq!(d.into_bind(), Value::Decimal(d));
}

#[test]
fn decimal_binds_as_placeholder() {
    let price = Decimal::from_str("19.99").unwrap();
    let (sql, binds) = QueryBuilder::<Postgres>::table("products")
        .select(["id"])
        .where_eq("price", price)
        .to_sql();
    assert_eq!(sql, r#"SELECT "id" FROM "products" WHERE "price" = $1"#);
    assert_eq!(binds, vec![Value::Decimal(price)]);
}

#[test]
fn decimal_option_none_is_null() {
    assert_eq!(Option::<Decimal>::None.into_bind(), Value::Null);
}