bend-kit-sqlite Releases (2): 0.1.0.1 0x1dd647736fb09289bc1eed9825ef1113 indexed https://jend.leeeet.dev/files.txt?path=bend-kit-sqlite@0.1.0.1 0.1.0.0 0x05a539098c68c3d7c7b9fe8f5a96a7f7 unindexed https://jend.leeeet.dev/files.txt?path=bend-kit-sqlite@0.1.0.0 Definitions (14): Sqlite.db.open (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=db.open) # Handles are opaque U32 IDs. Close each database after finalizing all its statements. # Every effect returns (SQLite error code, message) on failure. # BEND_LIBSQLITE selects a custom libsqlite3 path. def db.open(path: String) -> IO(Result<&1, &1, U32 & String, U32>): Sqlite.db.close (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=db.close) def db.close(db: U32) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.prepare (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.prepare) # Exactly one SQL statement is accepted; use bind operations for values. def stmt.prepare(db: U32, sql: String) -> IO(Result<&1, &1, U32 & String, U32>): Sqlite.stmt.finalize (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.finalize) def stmt.finalize(stmt: U32) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.bind.int (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.bind.int) # Bind positions start at 1. Integer values are unsigned 32-bit. def stmt.bind.int(stmt: U32, index: U32, value: U32) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.bind.text (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.bind.text) def stmt.bind.text(stmt: U32, index: U32, text: String) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.bind.null (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.bind.null) def stmt.bind.null(stmt: U32, index: U32) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.bind.blob (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.bind.blob) # Blob octets are packed four per U32, least-significant byte first. def stmt.bind.blob(stmt: U32, index: U32, len: U32, words: Array) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.step (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.step) # True means a row is available; False means no more rows. def stmt.step(stmt: U32) -> IO(Result<&1, &1, U32 & String, Bool>): Sqlite.stmt.reset (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.reset) def stmt.reset(stmt: U32) -> IO(Result<&1, &1, U32 & String, Unit>): Sqlite.stmt.column.kind (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.column.kind) # Column indexes start at 0. Read columns only after a True step. # SQLite kinds: 1 integer, 2 float, 3 text, 4 blob, 5 null. def stmt.column.kind(stmt: U32, index: U32) -> IO(Result<&1, &1, U32 & String, U32>): Sqlite.stmt.column.int (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.column.int) def stmt.column.int(stmt: U32, index: U32) -> IO(Result<&1, &1, U32 & String, U32>): Sqlite.stmt.column.text (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.column.text) def stmt.column.text(stmt: U32, index: U32) -> IO(Result<&1, &1, U32 & String, String>): Sqlite.stmt.column.blob (https://jend.leeeet.dev/definition.txt?path=bend-kit-sqlite@0.1.0.1/sqlite.bend&name=stmt.column.blob) def stmt.column.blob(stmt: U32, index: U32) -> IO(Result<&1, &1, U32 & String, U32 & Array>):