JsonExtensions extension

Defines extensions on string expressions to support the json1 api from Dart.

on

• Expression<String>

Methods

json() → Expression<String>

Reads this expression as a JSON structure and outputs the JSON in a minified format.

jsonArrayLength([String? path]) → Expression<int>

Assuming that this string is a json array, returns the length of this json array.

jsonb() → Expression<Uint8List>

Reads this expression as a JSON structure and outputs the JSON in a binary format internal to sqlite3.

jsonEach(DatabaseConnectionUser database, [String? path]) → JsonTableFunction

Calls the json_each table-valued function on this string, optionally using path as the root path.

jsonExtract<T extends Object>(String path) → Expression<T>

Assuming that this string is a json object or array, extracts a part of this structure identified by path.

jsonTree(DatabaseConnectionUser database, [String? path]) → JsonTableFunction

Calls the json_tree table-valued function on this string, optionally using path as the root path.