Plugin adding a jq() SQL function to sqlite-utils
Plugin adding a jq()
SQL function to sqlite-utils.
Install this plugin in the same environment as sqlite-utils
:
sqlite-utils install sqlite-utils-jq
This plugin adds a jq()
function for executing jq programs against JSON values.
sqlite-utils memory "select jq(:doc, :expr) as result" \
-p doc '{"foo": "bar"}' \
-p expr '.foo' \
--table
Output:
result
--------
"bar"
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd sqlite-utils-jq
python3 -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest