Skip to main content

params

Macro params 

Source
macro_rules! params {
    () => { ... };
    ($($param:expr),+ $(,)?) => { ... };
}
Expand description

Create a parameter list for SQL queries

This macro provides a convenient way to create parameter lists without manually wrapping each value in Value::from().

§Examples

use stoolap::{Database, params};

let db = Database::open("memory://")?;
db.execute("CREATE TABLE users (id INTEGER, name TEXT, age INTEGER)", ())?;

// Insert with params
db.execute(
    "INSERT INTO users VALUES ($1, $2, $3)",
    params![1, "Alice", 30]
)?;

// Query with params
let rows = db.query(
    "SELECT * FROM users WHERE age > $1",
    params![25]
)?;

// Mixed types work seamlessly
db.execute(
    "INSERT INTO users VALUES ($1, $2, $3)",
    params![2, String::from("Bob"), 25]
)?;