Module db

Module db 

Source
Expand description

Database access for plugins.

Provides type-safe database querying and mutation.

§Example

use orbis_plugin_api::sdk::db;

// Query with parameters
let users = db::query::<User>(
    "SELECT * FROM users WHERE active = ? LIMIT ?",
    &[&true, &10]
)?;

// Execute a mutation
let rows_affected = db::execute(
    "UPDATE users SET last_login = ? WHERE id = ?",
    &[&now, &user_id]
)?;

Structs§

DbRow
A row from a database query result
Transaction
Transaction builder for multiple operations

Enums§

DbValue
A value that can be used as a database parameter

Traits§

ToDbParams
Trait for types that can be converted to database parameters

Functions§

execute
Execute a database mutation (non-WASM stub)
insert_returning_id
Insert a row and return the last insert ID (non-WASM stub)
query
Execute a database query (non-WASM stub)
query_one
Query for a single row
query_one_required
Query for a single required row
query_raw
Execute a query and return raw rows (non-WASM stub)
query_scalar
Query for a single scalar value
transaction
Start building a transaction