jongos JSON in-memory-db query engine
Download

jongos Ranking & Summary

jongos Tags

query JSON query engine

jongos Description

jongos is a tool to run and load file JSON automaticly: python jongos.py < file_name.json >.Load JSON file> db.load("file_name.json")Refresh current loaded JSON file> db.refresh()Save current in-memory db into current loaded JSON file> db.save()Save query results as JSON file> db.capture("save_to_file_name.json")extra: execute after any db.find() / db.group() / db.count() commandInsert new record> db.insert(json_item)Delete record> db.remove(query)Find a row> db.find(query)extra: add "$return": in query will return field1 and field2 onlyCount a row that match query> db.count(query)Group a row with a key:> db.group(query)add "$key": "title" in query will using field title as your grouping keyQueryJSON structure examples:Match Exact, Except, Like and LikeAndFilter all item with Mrs title : query = {"$title": "Mrs"}Filter all item with title except Ms : query = {"$title": {"$ne":"Ms"}}Filter all item like 'five' in email : query = {"email": {"$like":"five"}}Filter all item like 'five' or 'four' in email : query = {"email": {"$likes":}}Filter all item like 'five' and 'four' in email : query = {"email": {"$likesAnd":}}Greater and Lower thanFilter all math score greater than 60 : query = {"score.math": {"$gt":60}}Filter all math score lower than 60 : query = {"score.math": {"$lt":60}}Filter all math score greater than equal 60 : query = {"score.math": {"$gte":60}}Filter all math score lower than equal 60 : query = {"score.math": {"$lte":60}}Include and No IncludeFilter all math score in 60 and 70: query = {"score.math": {"$in":}}Filter all math score not in 60 and 70 : query = {"score.math": {"$nin":}}Product's homepage

jongos Related Software