sqlite-hashes 0.10.8

Hashing functions for SQLite with aggregation support: MD5, SHA1, SHA256, SHA512, Blake3, FNV-1a, xxHash
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

#![allow(dead_code)]

#[macro_use]
#[path = "_utils.rs"]
mod utils;
use crate::utils::Conn;

#[ctor::ctor]
fn init() {
    let _ = env_logger::builder().is_test(true).try_init();
}

#[test]
fn simple() {
    let c = Conn::new();
    test_all!(c.select("(NULL)"), NULL);
    test_all!(c.select("(NULL, NULL, NULL)"), NULL);
    test_all!(c.select("(1)"), ERROR);
    test_all!(c.select("(0.42)"), ERROR);
    test_all!(c.select("()"), ERROR);
    test_all!(c.select("('')"), blob(""));
    test_all!(c.select("('a')"), blob("a"));
    test_all!(c.select("('123456789')"), blob("123456789"));
    test_all!(c.select("(x'')"), blob(""));
    test_all!(c.select("(x'00')"), blob("\0"));
    test_all!(
        c.select("(x'0123456789abcdef')"),
        bytes_as_blob(b"\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
    test_all!(
        c.select("('', 'a', '123456789', x'', x'00', x'0123456789abcdef')"),
        bytes_as_blob(b"a123456789\x00\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
    test_all!(
        c.select("(NULL, 'a', NULL, '123456789', x'', x'00', NULL, x'0123456789abcdef', NULL)"),
        bytes_as_blob(b"a123456789\x00\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
}

#[test]
#[cfg(feature = "hex")]
fn simple_hex() {
    let c = Conn::new();
    test_all!(c.select("_hex(NULL)"), EMPTY);
    test_all!(c.select("_hex(NULL, NULL, NULL)"), EMPTY);
    test_all!(c.select("_hex(1)"), ERROR);
    test_all!(c.select("_hex(0.42)"), ERROR);
    test_all!(c.select("_hex()"), ERROR);
    test_all!(c.select("_hex('')"), hex(""));
    test_all!(c.select("_hex('a')"), hex("a"));
    test_all!(c.select("_hex('123456789')"), hex("123456789"));
    test_all!(c.select("_hex(x'')"), hex(""));
    test_all!(c.select("_hex(x'00')"), hex("\0"));
    test_all!(
        c.select("_hex(x'0123456789abcdef')"),
        bytes_as_hex(b"\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
    test_all!(
        c.select("_hex('', 'a', '123456789', x'', x'00', x'0123456789abcdef')"),
        bytes_as_hex(b"a123456789\x00\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
    test_all!(
        c.select("_hex(NULL, 'a', NULL, '123456789', x'', x'00', NULL, x'0123456789abcdef', NULL)"),
        bytes_as_hex(b"a123456789\x00\x01\x23\x45\x67\x89\xab\xcd\xef")
    );
}