macro_rules! named_params {
() => { ... };
($($name:ident : $value:expr),+ $(,)?) => { ... };
}Expand description
Create named parameters for SQL queries
This macro provides a convenient way to create named parameter bindings
for use with the :name syntax in SQL queries.
§Examples
ⓘ
use stoolap::{Database, named_params};
let db = Database::open("memory://")?;
db.execute("CREATE TABLE users (id INTEGER, name TEXT, active BOOLEAN)", ())?;
// Insert with named params
db.execute_named(
"INSERT INTO users VALUES (:id, :name, :active)",
named_params!{ id: 1, name: "Alice", active: true }
)?;
// Query with named params
let rows = db.query_named(
"SELECT * FROM users WHERE name = :name",
named_params!{ name: "Alice" }
)?;