FX - JSON @ File format @ MentDB Weak
JSON
json loadjson showjson load selectjson load by refjson iobjectjson countjson selectjson is objectjson is arrayjson existjson docjson fieldsjson iarrayjson iarrayjson uarrayjson uobjectjson darrayjson dobjectjson sortjson unloadjson unload_all
json load <key> <jsonString>
Description
To load a JSON string
To load a JSON string
Parameters
key: The key - string - required
jsonString: The JSON string - string - required
key: The key - string - required
jsonString: The JSON string - string - required
admin
json load "keyId" "{}";
mentdb
1
json show
Description
To show all JSON objects saved in the session
To show all JSON objects saved in the session
admin
json show;
mentdb
["keyId","newKeyId"]
json load select <key> <jsonString> <jPath>
Description
To load a JSON string and select an element
To load a JSON string and select an element
Parameters
key: The key - string - required
jsonString: The JSON string - string - required
jPath: The JSON path - string - required
key: The key - string - required
jsonString: The JSON string - string - required
jPath: The JSON path - string - required
admin
json load select "keyId" "{\"a\": 5.0, \"b\": {\"c\": 7.0}}" /a;
mentdb
5.0
json load by ref <fromKey> <jPath> <new KeyId>
Description
To load a JSON string by reference from another JSON object
To load a JSON string by reference from another JSON object
Parameters
fromKey: The key - string - required
jPath: The JSON path - string - required
new KeyId: The JSON string - string - required
fromKey: The key - string - required
jPath: The JSON path - string - required
new KeyId: The JSON string - string - required
admin
json load by ref "keyId" /b "newKeyId";
mentdb
{ "c": 7.0 }
admin
json uobject "newKeyId" / c 8 NUM; json select "newKeyId" /c;
mentdb
8.0
admin
json doc "keyId";
mentdb
{ "a": 5.0, "b": { "c": 8.0 } }
json iobject <key> <jPath> <fieldname> <value> <type>
Description
To insert an element into an object in a node
To insert an element into an object in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
admin
json iobject "keyId" / a 5 NUM;
mentdb
1
admin
json iobject "keyId" / tab "[]" ARRAY;
mentdb
1
json count <key> <jPath>
Description
To count the elements in a node
To count the elements in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
key: The key - string - required
jPath: The JSON path - string - required
admin
json count "keyId" /
mentdb
3
json select <key> <jPath>
Description
To select an element in a node
To select an element in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
key: The key - string - required
jPath: The JSON path - string - required
admin
json select "keyId" /a
mentdb
5.0
json is object <key> <jPath>
Description
To check if an element is an object in a node
To check if an element is an object in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
key: The key - string - required
jPath: The JSON path - string - required
admin
json is object "keyId" /
mentdb
1
json is array <key> <jPath>
Description
To check if an element is an array in a node
To check if an element is an array in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
key: The key - string - required
jPath: The JSON path - string - required
admin
json is array "keyId" /tab
mentdb
1
json exist <key>
Description
To check if a key is loaded
To check if a key is loaded
Parameters
key: The key - string - required
key: The key - string - required
admin
json exist "keyId"
mentdb
1
json doc <key>
Description
To get a JSON document
To get a JSON document
Parameters
key: The key - string - required
key: The key - string - required
admin
json doc "keyId"
mentdb
{ "a": 5.0, "b": { "c": 8.0 }, "tab": [] }
json fields <key> <jPath>
Description
To get all the fields of an object in a node
To get all the fields of an object in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
key: The key - string - required
jPath: The JSON path - string - required
admin
json fields "keyId" /
mentdb
[ "a", "b", "tab" ]
json iarray <key> <jPath> <value> <type>
Description
To insert an element into an array in a node
To insert an element into an array in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
key: The key - string - required
jPath: The JSON path - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
admin
json iarray "keyId" /tab test STR;
mentdb
1
admin
json iarray "keyId" /tab test2 STR
mentdb
1
admin
json doc "keyId"
mentdb
{ "a": 5.0, "b": { "c": 8.0 }, "tab": [ "test", "test2" ] }
json iarray <key> <jPath> <index> <value> <type>
Description
To insert an element into an array in a node
To insert an element into an array in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
index: The index position - number - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
key: The key - string - required
jPath: The JSON path - string - required
index: The index position - number - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
admin
json iarray "keyId" /tab 0 test STR;
mentdb
1
admin
json iarray "keyId" /tab test2 STR
mentdb
1
admin
json doc "keyId"
mentdb
{ "a": 5.0, "b": { "c": 8.0 }, "tab": [ "test", "test", "test2", "test2" ] }
json uarray <key> <jPath> <index> <value> <type>
Description
To update an element in an array in a node
To update an element in an array in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
index: The index - integer - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
key: The key - string - required
jPath: The JSON path - string - required
index: The index - integer - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
admin
json uarray "keyId" /tab 1 test2 STR;
mentdb
1
admin
json doc "keyId"
mentdb
{ "a": 5.0, "b": { "c": 8.0 }, "tab": [ "test", "test2", "test2", "test2" ] }
json uobject <key> <jPath> <fieldname> <value> <type>
Description
To update an element in an object in a node
To update an element in an object in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
value: The value - string - required
type: The type (NUM|INT|STR|BOOL|BOOL2|ARRAY|OBJ) - string - required
admin
json uobject "keyId" / a 8 NUM;
mentdb
1
admin
json doc "keyId"
mentdb
{ "a": 8.0, "b": { "c": 8.0 }, "tab": [ "test", "test2", "test2", "test2" ] }
json darray <key> <jPath> <index>
Description
To delete an element from an array in a node
To delete an element from an array in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
index: The index - integer - required
key: The key - string - required
jPath: The JSON path - string - required
index: The index - integer - required
admin
json darray "keyId" /tab 0;
mentdb
1
admin
json doc "keyId"
mentdb
{ "a": 8.0, "b": { "c": 8.0 }, "tab": [ "test2", "test2", "test2" ] }
json dobject <key> <jPath> <fieldname>
Description
To delete an element from an object in a node
To delete an element from an object in a node
Parameters
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
key: The key - string - required
jPath: The JSON path - string - required
fieldname: The field name - string - required
admin
json dobject "keyId" / a;
mentdb
1
admin
json doc "keyId"
mentdb
{ "b": { "c": 8.0 }, "tab": [ "test2", "test2", "test2" ] }
json sort <key> <jPath> <field> <order>
Description
To sort an array in a node, by a field of its objects (or by the elements if the field is empty). Numbers are compared as numbers, the other values as strings (case insensitive), null values are at the end
To sort an array in a node, by a field of its objects (or by the elements if the field is empty). Numbers are compared as numbers, the other values as strings (case insensitive), null values are at the end
Parameters
key: The key - string - required
jPath: The JSON path of the array - string - required
field: The field name (empty to sort the elements themselves) - string - required
order: ASC or DESC - string - required
key: The key - string - required
jPath: The JSON path of the array - string - required
field: The field name (empty to sort the elements themselves) - string - required
order: ASC or DESC - string - required
admin
json load "sortId" "[{\"nb\":\"10\"},{\"nb\":\"2\"},{\"nb\":\"9\"}]"; json sort "sortId" / nb ASC;
mentdb
1
admin
json doc "sortId"
mentdb
[ { "nb": "2" }, { "nb": "9" }, { "nb": "10" } ]
json unload <key>
Description
To unload a JSON document
To unload a JSON document
Parameters
key: The key - string - required
key: The key - string - required
admin
json unload "keyId";
mentdb
1
json unload_all
Description
To unload all JSON documents
To unload all JSON documents
admin
json unload_all;
mentdb
1