Module statement 

Prepared statement support

Examples

use radixdb_api::Database;

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

// Prepare a statement for repeated execution
let insert = db.prepare("INSERT INTO users VALUES ($1, $2)")?;

// Execute multiple times efficiently
for (id, name) in [(1, "Alice"), (2, "Bob"), (3, "Charlie")] {
    insert.execute((id, name))?;
}

// Prepare a query
let select = db.prepare("SELECT name FROM users WHERE id = $1")?;
for id in 1..=3 {
    for row in select.query((id,))? {
        println!("{}", row?.get::<String>(0)?);
    }
}

Structs

Statement

A prepared SQL statement