extensions/json1 library

Experimental bindings to the json1 sqlite extension.

Note that the json1 extension might not be available on all runtimes. When using this library, it is recommended to use a NativeDatabase with a dependency on sqlite3_flutter_libs.

Classes

JsonTableFunction

Calls json table-valued functions in drift.

Extensions

JsonbExtensions on Expression<Uint8List>

Defines extensions for the binary JSONB format introduced in sqlite3 version 3.45.

JsonExtensions on Expression<String>

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

Functions

jsonbGroupArray(Expression<Object> value, {OrderBy? orderBy, Expression<bool>? filter}) → Expression<Uint8List>

Returns a binary representation of a JSON array containing the result of evaluating value in each row of the current group.

jsonbGroupObject(Map<Expression<String>, Expression<Object>> values) → Expression<Uint8List>

Returns a binary representation of a JSON object consisting of the provided keys and values in the current group.

jsonGroupArray(Expression<Object> value, {OrderBy? orderBy, Expression<bool>? filter}) → Expression<String>

Returns a JSON array containing the result of evaluating value in each row of the current group.

jsonGroupObject(Map<Expression<String>, Expression<Object>> values) → Expression<String>

Returns a JSON object consisting of the keys and values from the provided values map.