named_params

Macro named_params 

Source
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" }
)?;