jsonb-cli

command line interface for manipulating jsonb-db

Installation

npm install jsonb-cli -g

Usage

Navigate to project folder and provide the followings commands

Available commands

| command | description | example | |:--------| :----------| :-------| | jsonb | lunch jsonb-cli| > jsonb| | help | print jsonb-cli usage help |> jsonb help | version | print jsonb-cli version |> jsonb version | connect --db=databasename | connect jsonb-cli to db |> jsonb connect --db=logs | db | list functions for connected db instance |jsonb>db | collections() | list avalaibale collections in connected db instance |jsonb>db.collections()| | createCollection("collectionName") | create collection |jsonb>db.createCollection("customers")| | updateCollection("oldCollectionName","newCollectionName") | rename collection |jsonb>db.updateCollection("customers","sample")| | dropCollection("collectionName") | delete collection |jsonb>db.dropCollection("sample")| | collection() | list avalable functions for each collections |jsonb>db.collection()| | find(criteria) | Find items in collection ,when criteria not provided all items are retrieved |jsonb>db.collection("sample").find({"country":"TZ"})| | skip(rows) | Skip rows for a given output |jsonb>db.collection("sample").find({"country":"TZ"}).skip(1)| | take(rows) | limit number of output rows |jsonb>db.collection("sample").find({"country":"TZ"}).take(1)| | count() | count total number of rows |jsonb>db.collection("sample").find({"country":"TZ"}).count()| | query | Format output to readable json |jsonb>db.collection("sample").find({"country":"TZ"}).query| | pretty() | Format output to nice look json format |jsonb>db.collection("sample").find({"country":"TZ"}).pretty()| | table() | Display results in table |jsonb>db.collection("sample").find({"country":"TZ"}).table()| | insert(value) | Insert one item(object) into a collection |jsonb>db.collection("sample").insert({"country":"UK"})| | insertMany(values) | Insert many items into a collection |jsonb>db.collection("sample").insertMany([{"country":"UK"},{"country":"KE"},{"country":"UG"}])| | update(criteria,value) | Update one items in a collection,where by criteria is searching object and value is the new item to be updated |jsonb>db.collection("sample").update({"country":"UK"},{"country":"TZ"})| | remove(criterai) | delete item from a collection |jsonb>db.collection("sample").remove({"country":"UK"})|