Use this crate to add various hash functions to SQLite, including MD5, SHA1, SHA256, and SHA512. All functions support text and blob values. Functions support any number of parameters which will be hashed in order. NULL values will be ignored. The functions return a blob with the hash value unless all parameters are NULL, in which case NULL is returned.
There are also aggregate functions that compute combined hash over a set of values, e.g. sha256_concat. These functions are useful for computing hash over a set of values, e.g. a column in a table. The aggregate functions also support multiple values, so you can compute a hash over a set of columns, e.g. sha256_concat(col1, col2, col3) over a whole set.
This crate uses rusqlite to add user-defined functions using static linking. Eventually it would be good to build dynamically loadable extension binaries usable from other languages (PRs welcome).
```rust use sqlitehashes::{registersha256_function, rusqlite::Connection};
fn main() { // Connect to SQLite DB and register needed hashing functions let db = Connection::openinmemory().unwrap(); registersha256function(&db).unwrap();
// Hash 'password' using SHA-256, and dump it as a HEX string let sql = "SELECT hex(sha256('password'))"; let hash: String = db.queryrowandthen(&sql, [], |r| r.get(0)).unwrap(); asserteq!(hash, "5E884898DA28047151D0E56F8DC6292773603D0D6AABBDD62A11EF721D1542D8");
// Hash 'pass' (as text) and 'word' (as blob) using SHA-256, and dump it as a HEX string // The result is the same as the above 'password' example. let sql = "SELECT hex(sha256(cast('pass' as text), cast('word' as blob)))"; let hash: String = db.queryrowandthen(&sql, [], |r| r.get(0)).unwrap(); asserteq!(hash, "5E884898DA28047151D0E56F8DC6292773603D0D6AABBDD62A11EF721D1542D8");
// Iterate over a set of values and hash them together. // Make sure the value order is consistent. // This example creates a sequence of ints from 0 to 9. let sql = " WITH RECURSIVE sequence(value) AS ( SELECT 0 UNION ALL SELECT value + 1 FROM sequence LIMIT 10 ) SELECT hex(sha256concat(cast(value as text))) FROM sequence ORDER BY value"; let hash: String = db.queryrowandthen(&sql, [], |r| r.get(0)).unwrap(); assert_eq!(hash, "84D89877F0D4041EFB6BF91A16F0248F2FD573E6AF05C19F96BEDB9F882F7882");
// The above sequence aggregation example is equivalent to this: let sql = "SELECT hex(sha256('0123456789'))"; let hash: String = db.queryrowandthen(&sql, [], |r| r.get(0)).unwrap(); asserteq!(hash, "84D89877F0D4041EFB6BF91A16F0248F2FD573E6AF05C19F96BEDB9F882F7882"); } ```
By default, this crate will compile with all hash functions. You can enable just the ones you need to reduce compile time.
toml
[dependencies]
sqlite-hashes = { version = "0.3", default-features = false, features = ["sha256"] }
make. Install it with cargo install just.just.just test.git push, it will run a few validations, including cargo fmt, cargo clippy, and cargo test. Use git push --no-verify to skip these checks.Licensed under either of
Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.