pub fn register_hash_functions(conn: &Connection) -> Result<()>Expand description
Register all hashing functions for the given SQLite connection.
This is a convenience function that calls all of the register_*_function functions.
Features must be enabled for the corresponding functions to be registered.
ยงExample
let db = Connection::open_in_memory()?;
register_hash_functions(&db)?;
let hash: String = db.query_row("SELECT md5_hex('hello')", [], |r| r.get(0))?;
assert_eq!(&hash, "5D41402ABC4B2A76B9719D911017C592");
let hash: String = db.query_row("SELECT sha1_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "AAF4C61DDCC5E8A2DABEDE0F3B482CD9AEA9434D");
let hash: String = db.query_row("SELECT sha224_hex('hello')", [], |r| r.get(0))?;
assert_eq!(&hash, "EA09AE9CC6768C50FCEE903ED054556E5BFC8347907F12598AA24193");
let hash: String = db.query_row("SELECT sha256_hex('hello')", [], |r| r.get(0))?;
assert_eq!(&hash, "2CF24DBA5FB0A30E26E83B2AC5B9E29E1B161E5C1FA7425E73043362938B9824");
let hash: String = db.query_row("SELECT sha384_hex('hello')", [], |r| r.get(0))?;
assert_eq!(&hash, "59E1748777448C69DE6B800D7A33BBFB9FF1B463E44354C3553BCDB9C666FA90125A3C79F90397BDF5F6A13DE828684F");
let hash: String = db.query_row("SELECT sha512_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "9B71D224BD62F3785D96D46AD3EA3D73319BFBC2890CAADAE2DFF72519673CA72323C3D99BA5C11D7C7ACC6E14B8C5DA0C4663475C2E5C3ADEF46F73BCDEC043");
let hash: String = db.query_row("SELECT blake3_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "EA8F163DB38682925E4491C5E58D4BB3506EF8C14EB78A86E908C5624A67200F");
let hash: String = db.query_row("SELECT fnv1a_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "A430D84680AABD0B");
let hash: String = db.query_row("SELECT xxh32_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "FB0077F9");
let hash: String = db.query_row("SELECT xxh64_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "26C7827D889F6DA3");
let hash: String = db.query_row("SELECT xxh3_64_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "9555E8555C62DCFD");
let hash: String = db.query_row("SELECT xxh3_128_hex('hello')", [], |r| r.get(0))?;
assert_eq!(hash, "B5E9C1AD071B3E7FC779CFAA5E523818");