Database

table table:<{row}> → string

Create table TABLE.

Top level only: this function will fail if used in module code.

keyset string → object:*

Get metadata for KEYSET.

Top level only: this function will fail if used in module code.

module string → object:*

Get metadata for MODULE. Returns an object with 'name', 'hash', 'blessed', 'code', and 'keyset' fields.

Top level only: this function will fail if used in module code.

table table:<{row}> → object:*

Get metadata for TABLE. Returns an object with 'name', 'hash', 'blessed', 'code', and 'keyset' fields.

Top level only: this function will fail if used in module code.

table table:<{row}> qry a:string b:object:<{row}> -> bool consumer a:string b:object:<{row}> -> <b> → [<b>]

Select rows from TABLE using QRY as a predicate with both key and value, and then accumulate results of the query in CONSUMER. Output is sorted by the ordering of keys.

table table:<{row}> key string object object:<{row}> → string

Write entry in TABLE for KEY of OBJECT column data, failing if data already exists for KEY.

table table:<{row}> key string txid integer → [object:*]

Return updates to TABLE for a KEY in transactions at or after TXID, in a list of objects indexed by txid.

table table:<{row}> → [string]

Return all keys in TABLE.

table table:<{row}> key string → object:<{row}>

table table:<{row}> key string columns [string] → object:<{row}>

Read row from TABLE for KEY, returning database record object, or just COLUMNS if specified.

table table:<{row}> where row:object:<{row}> -> bool → [object:<{row}>]

table table:<{row}> columns [string] where row:object:<{row}> -> bool → [object:<{row}>]

Select full rows or COLUMNS from table by applying WHERE to each row to get a boolean determining inclusion.

table table:<{row}> txid integer → [integer]

Return all txid values greater than or equal to TXID in TABLE.

table table:<{row}> txid integer → [object:*]

Return all updates to TABLE performed in transaction TXID.

table table:<{row}> key string object object:~<{row}> → string

Write entry in TABLE for KEY of OBJECT column data, failing if data does not exist for KEY.

table table:<{row}> key string defaults object:~<{row}> bindings binding:~<{row}> → <a>

Special form to read row from TABLE for KEY and bind columns per BINDINGS over subsequent body statements. If row not found, read columns from DEFAULTS, an object with matching key names.

table table:<{row}> key string bindings binding:<{row}> → <a>

Special form to read row from TABLE for KEY and bind columns per BINDINGS over subsequent body statements.

table table:<{row}> key string object object:<{row}> → string

Write entry in TABLE for KEY of OBJECT column data.