I need some directions to use the json extension for sqlite in scriptcase!
Specs in https://www.sqlite.org/json1.html
After some PHP recompilation tasks it is possible for me to use the json1 functions in PHP with scriptcase.
One show stopper is i can not use the syntax for using it in scriptcase.
Here an example sql:
SELECT DISTINCT json_extract(big.json,’$.id’) FROM big, json_tree(big.json, ‘$.partlist’) WHERE json_tree.key=‘uuid’ AND json_tree.value=‘6fa5181e-5721-11e5-a04e-57f3d7b32808’; my problem is 'json_tree(…) is not accepted as table name.
The json_tree and json_each gives bach an virtual table like this:
CREATE TABLE json_tree( key ANY, – key for current element relative to its parent value ANY, – value for the current element type TEXT, – ‘object’,‘array’,‘string’,‘integer’, etc. atom ANY, – value for primitive types, null for array & object id INTEGER – integer ID for this element parent INTEGER, – integer ID for the parent of this element fullkey TEXT, – full path describing the current element path TEXT, – path to the container of the current row json JSON HIDDEN, – 1st input parameter: the raw JSON root TEXT HIDDEN – 2nd input parameter: the PATH at which to start ); The only way i found for now to show such constructs in an Grid is via an View from the the Sqlite Database. Is there an way to enhance the sql parser for sqlite? regards
bigwasp