JsonbExtensions extension
Defines extensions for the binary JSONB
format introduced in sqlite3
version 3.45.
For details, see https://www.sqlite.org/json1.html#jsonb
- on
Methods
-
json(
) → Expression< String> -
Available on Expression<
Reads this binary JSONB structure and emits its textual representation as minified JSON.Uint8List> , provided by the JsonbExtensions extension -
jsonArrayLength(
[String? path]) → Expression< int> -
Available on Expression<
Assuming thatUint8List> , provided by the JsonbExtensions extensionthis
is an expression evaluating to a binary JSONB array, returns the length of the array. -
jsonEach(
DatabaseConnectionUser database, [String? path]) → JsonTableFunction -
Available on Expression<
Calls theUint8List> , provided by the JsonbExtensions extensionjson_each
table-valued function onthis
binary JSON buffer, optionally usingpath
as the root path. -
jsonExtract<
T extends Object> (String path) → Expression< T> -
Available on Expression<
Assuming thatUint8List> , provided by the JsonbExtensions extensionthis
is an expression evaluating to a binary JSONB object or array, extracts the part of the structure identified bypath
. -
jsonTree(
DatabaseConnectionUser database, [String? path]) → JsonTableFunction -
Available on Expression<
Calls theUint8List> , provided by the JsonbExtensions extensionjson_tree
table-valued function onthis
binary JSON buffer, optionally usingpath
as the root path.