database::commitTransaction
Commit and finalize an interactive transaction.
- transaction_idstringrequired
- committedbooleanrequired
database
v0.2.0Talk to PostgreSQL, MySQL, and SQLite from iii — query, execute, transactions, prepared statements, and change feeds.
Install
bash
iii trigger compose::add worker=database@0.2.0Run in your project with the iii engine running. Exact versions are immutable and digest-pinned.
Functions10
Function
database::beginTransaction
Open an interactive transaction; returns a handle to use with transactionQuery/transactionExecute/commitTransaction/rollbackTransaction.
- dbstringrequired
- isolationstring
- timeout_msinteger· uint64min 0
- transactionobjectrequired
JSON wire envelope returned by `beginTransaction`.
- expires_atstring· date-timerequired
- idstringrequired
database::execute
Run a write statement (INSERT/UPDATE/DELETE/DDL).
- dbstringrequired
- paramsunknown[]
- returningstring[]
- sqlstringrequired
- affected_rowsinteger· uint64requiredmin 0
- last_insert_idstring
- returned_rowsobject[]requiredEmpty object
database::transactionQuery
Run a read-only SQL query inside an interactive transaction.
- paramsunknown[]
- sqlstringrequired
- transaction_idstringrequired
- columnsobject[]required
- namestringrequired
- typestringrequired
- row_countinteger· uintrequiredmin 0
- rowsobject[]requiredEmpty object
database::query
Run a read-only SQL query and return the result rows.
- dbstringrequired
- paramsunknown[]
- sqlstringrequired
- timeout_msinteger· uint64min 0
- columnsobject[]required
- namestringrequired
- typestringrequired
- row_countinteger· uintrequiredmin 0
- rowsobject[]requiredEmpty object
database::rollbackTransaction
Rollback and finalize an interactive transaction.
- transaction_idstringrequired
- rolled_backbooleanrequired
database::prepareStatement
Prepare a parameterized statement once.
- dbstringrequired
- sqlstringrequired
- ttl_secondsinteger· uint64min 0
- handleobjectrequired
- expires_atstring· date-timerequired
- idstringrequired
database::transaction
Run a sequence of statements atomically.
- dbstringrequired
- isolationstring
- statementsobject[]required
- paramsunknown[]
- sqlstringrequired
- committedbooleanrequired
- errorunknown
- failed_indexinteger· uintmin 0
- resultsobject[]
- affected_rowsinteger· uint64requiredmin 0
- rowsunknown[][]required
database::transactionExecute
Run a write statement inside an interactive transaction. BEGIN/COMMIT/ROLLBACK are rejected; use commit/rollbackTransaction.
- paramsunknown[]
- returningstring[]
- sqlstringrequired
- transaction_idstringrequired
- affected_rowsinteger· uint64requiredmin 0
- last_insert_idstring
- returned_rowsobject[]requiredEmpty object
database::runStatement
Run a previously-prepared handle.
- handle_idstringrequired
- paramsunknown[]
- columnsobject[]required
- namestringrequired
- typestringrequired
- row_countinteger· uintrequiredmin 0
- rowsobject[]requiredEmpty object
Triggers1
database::row-change
Postgres logical replication. Stubbed in v1.0 pending tokio-postgres replication API.
valueunknown
valueunknown