1 files changed, 146 insertions, 0 deletions
diff --git a/static/netbsd/man3/sqlite3_blob_open.3 b/static/netbsd/man3/sqlite3_blob_open.3
new file mode 100644
index 00000000..5feb3a18
--- /dev/null
+++ b/static/netbsd/man3/sqlite3_blob_open.3
@@ -0,0 +1,146 @@
+.Dd January 24, 2024
+.Dt SQLITE3_BLOB_OPEN 3
+.Os
+.Sh NAME
+.Nm sqlite3_blob_open
+.Nd open a BLOB for incremental I/O
+.Sh SYNOPSIS
+.In sqlite3.h
+.Ft int
+.Fo sqlite3_blob_open
+.Fa "sqlite3*"
+.Fa "const char *zDb"
+.Fa "const char *zTable"
+.Fa "const char *zColumn"
+.Fa "sqlite3_int64 iRow"
+.Fa "int flags"
+.Fa "sqlite3_blob **ppBlob"
+.Fc
+.Sh DESCRIPTION
+This interfaces opens a handle to the BLOB located in row iRow,
+column zColumn, table zTable in database zDb; in other words, the same
+BLOB that would be selected by:
+.Bd -literal
+SELECT zColumn FROM zDb.zTable WHERE rowid = iRow;
+.Ed
+.Pp
+Parameter zDb is not the filename that contains the database, but rather
+the symbolic name of the database.
+For attached databases, this is the name that appears after the AS
+keyword in the ATTACH statement.
+For the main database file, the database name is "main".
+For TEMP tables, the database name is "temp".
+.Pp
+If the flags parameter is non-zero, then the BLOB is opened for read
+and write access.
+If the flags parameter is zero, the BLOB is opened for read-only access.
+.Pp
+On success, SQLITE_OK is returned and the new BLOB handle
+is stored in *ppBlob.
+Otherwise an error code is returned and, unless the error
+code is SQLITE_MISUSE, *ppBlob is set to NULL.
+This means that, provided the API is not misused, it is always safe
+to call
+.Fn sqlite3_blob_close
+on *ppBlob after this function it returns.
+.Pp
+This function fails with SQLITE_ERROR if any of the following are true:
+.Bl -bullet
+.It
+Database zDb does not exist,
+.It
+Table zTable does not exist within database zDb,
+.It
+Table zTable is a WITHOUT ROWID table,
+.It
+Column zColumn does not exist,
+.It
+Row iRow is not present in the table,
+.It
+The specified column of row iRow contains a value that is not a TEXT
+or BLOB value,
+.It
+Column zColumn is part of an index, PRIMARY KEY or UNIQUE constraint
+and the blob is being opened for read/write access,
+.It
+Foreign key constraints are enabled, column
+zColumn is part of a child key definition and the blob is
+being opened for read/write access.
+.El
+.Pp
+Unless it returns SQLITE_MISUSE, this function sets the database connection
+error code and message accessible via
+.Fn sqlite3_errcode
+and
+.Fn sqlite3_errmsg
+and related functions.
+.Pp
+A BLOB referenced by sqlite3_blob_open() may be read using the
+.Fn sqlite3_blob_read
+interface and modified by using
+.Fn sqlite3_blob_write .
+The BLOB handle can be moved to a different row of the same
+table using the
+.Fn sqlite3_blob_reopen
+interface.
+However, the column, table, or database of a BLOB handle
+cannot be changed after the BLOB handle is opened.
+.Pp
+If the row that a BLOB handle points to is modified by an UPDATE,
+DELETE, or by ON CONFLICT side-effects then the BLOB
+handle is marked as "expired".
+This is true if any column of the row is changed, even a column other
+than the one the BLOB handle is open on.
+Calls to
+.Fn sqlite3_blob_read
+and
+.Fn sqlite3_blob_write
+for an expired BLOB handle fail with a return code of SQLITE_ABORT.
+Changes written into a BLOB prior to the BLOB expiring are not rolled
+back by the expiration of the BLOB.
+Such changes will eventually commit if the transaction continues to
+completion.
+.Pp
+Use the
+.Fn sqlite3_blob_bytes
+interface to determine the size of the opened blob.
+The size of a blob may not be changed by this interface.
+Use the UPDATE SQL command to change the size of a blob.
+.Pp
+The
+.Fn sqlite3_bind_zeroblob
+and
+.Fn sqlite3_result_zeroblob
+interfaces and the built-in zeroblob SQL function may be used
+to create a zero-filled blob to read or write using the incremental-blob
+interface.
+.Pp
+To avoid a resource leak, every open BLOB handle should
+eventually be released by a call to
+.Fn sqlite3_blob_close .
+.Sh IMPLEMENTATION NOTES
+These declarations were extracted from the
+interface documentation at line 7683.
+.Bd -literal
+SQLITE_API int sqlite3_blob_open(
+  sqlite3*,
+  const char *zDb,
+  const char *zTable,
+  const char *zColumn,
+  sqlite3_int64 iRow,
+  int flags,
+  sqlite3_blob **ppBlob
+);
+.Ed
+.Sh SEE ALSO
+.Xr sqlite3 3 ,
+.Xr sqlite3_bind_blob 3 ,
+.Xr sqlite3_blob 3 ,
+.Xr sqlite3_blob_bytes 3 ,
+.Xr sqlite3_blob_close 3 ,
+.Xr sqlite3_blob_read 3 ,
+.Xr sqlite3_blob_reopen 3 ,
+.Xr sqlite3_blob_write 3 ,
+.Xr sqlite3_errcode 3 ,
+.Xr sqlite3_result_blob 3 ,
+.Xr SQLITE_OK 3