pekrau / jsondocdb

A Python Sqlite3 database for JSON documents. Simple indexing using JsonLogic.

jsondocdb

A Python Sqlite3 database for JSON documents. Simple indexing using JsonLogic.

The JsonLogic class was adapted from https://github.com/nadirizr/json-logic-py

Documentation will eventually be included here.

jsondocdb's Issues

Rename search to has_key

find

JSON path and value

lookup with value None

CLI find

Fix test_cli

Range_docs

Return dict of docs, iuids as key.

Dump

CLI: Indexes and/or documents.

Undump

CLI

• Flag for updating, or skipping documents with same iuid.
• Flag for adding indexes.

CSV export

Return data structure appropriate for csv write.

Require schema?

Allow readonly

Add indexes using JsonLogic

Write README

Example code, class and methods documentation.

Use code for exceptions.

Allow index function

• Callable as argument in create_index.
• Since cannot be recorded in db, needs to be set each time db is opened.

Change range

To return generator of iuids

Test utf8

Can handle json with swedish chars?

Rename index 'value' to 'key'?

Get_type

For iuid

Fix cli

Proper transaction class

allow subclassing

Find_docs

Return dict of docs, iuids as keys.

Follow Sqlite3 file conventions

Rename database class

Volume exercise

Possible to do ops in mem, then backup?

Context to switch to mem, then record back to file. How make safe?

Fix test_module

range values

instead of keys

Search using JSON path without index

Complete type annotation

Add selective indexes using JsonLogic

CLI range

Split out CLI?

Redesign find and range

Return iuid and doc

Add limit and offset to find and range

Test suite using pytest

Return id from iteration, find and range

Rewind. Cleaner.

search with value None

missing_key

Does not have a key JSON Path

Change iuid to id

More understandable terminology.

Allow attachments BLOBs for docs

lookup value

instead of key

JSON Schema for checking docs when adding

Should update of the schema doc trigger check of existing docs? What to do if fail?

Put_many

Within a transaction. Faster?

Get rid of doctype

Use sqlite3 register_adapter etc

Register_,converter: JSON from/to dict.

Change find

To return generator of iuids.

Tests

Rework using JsonLogic, not JsonPath

Safe backup

Tests of CLI

Add range method

CLI

Use click

• yasondb dbpath --create
• yasondb dbpath statistics
• yasondb dbpath export [--doctype default] [-o outputfile]
• yasondb dbpath show iuid [-o outputfile]
• yasondb dbpath find indexname key [-o outputfile]
• yasondb dbpath range indexname lowkey highkey [-o outputfile]