Plugin adding a jq() SQL function to sqlite-utils
Project description
sqlite-utils-jq
Plugin adding a jq()
SQL function to sqlite-utils.
Installation
Install this plugin in the same environment as sqlite-utils
:
sqlite-utils install sqlite-utils-jq
Usage
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"
Development
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlite-utils-jq-0.1.tar.gz
(2.2 kB
view hashes)
Built Distribution
Close
Hashes for sqlite_utils_jq-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ef5d6da1061ee132aa3a0aa0dc52b3eb5e040bcc6fe1e795f83d5e243e88f77d |
|
MD5 | 67890eec4c511be5703c15ad80888322 |
|
BLAKE2b-256 | 00b44b3947806270007377955e4c884401bdcbf2e43e1681c720079a97dd1299 |