The library documents itself · Tables & data
stzDatabase
16 own methods · 0 forms written with extensions, listed under their method
the source: base/data/stzDatabase.ring(opens in a new tab) · All classes · The area reference: Tables & data
Under each method, its extensions (Q CS XT Z ZZ IB W U): bold and ticked, it exists; struck, it does not. The extensions and what they mean
No method of this class is run on this page: the class reaches files, the network, processes, the clock, chance or sound, and an example run here would only be an example of its effects. Each method carries the explanation the library gives of itself.
Method
Explanation, as the source carries it
init
(no comment in the source: the name reads as a sentence) initno extension
Path
(no comment in the source: the name reads as a sentence) pathno extension
IsOpen
(no comment in the source: the name reads as a sentence) is openno extension
Why
(no comment in the source: the name reads as a sentence) whyno extension
Exec
run a DDL/DML statement; returns rows-changed, or raises on errorno extension
Rows
query rows: [ [ col, col, ... ], ... ] (cells text-coerced). Empty result -> []. Raises on a malformed query, AND on a query that fails partway through its rows -- it never returns the rows read so far as if they were the answer. Rows come back as Haro lists straight from the engine: a tab or a newline inside a value is data. (They used to travel as one TAB/NEWLINE-joined string split here, which cut such a value into extra cells and extra rows.)no extension
Value
a single scalar (first cell of the first row), "" when emptyno extension
ExecWith
A string binds as TEXT (exact bytes), an integral number as INTEGER, any other number as REAL. One statement per call. run a statement with bound values; returns rows changed, raises on errorno extension
RowsWith
rows with bound values, every cell as text (NULL -> "")no extension
TypedRowsWith
rows with bound values, INTEGER and REAL cells as Haro numbersno extension
ValueWith
bound statementsno extension
Begin
Begin() takes the write lock at once (BEGIN IMMEDIATE), so a busy database refuses here, where the whole unit can be retried.no extension
Commit
transactionsno extension
Rollback
transactionsno extension
LastInsertId
transactionsno extension
Close
transactionsno extension