cblite-cli-win

To Install

npm install -g cblite-cli-win

cblite Tool Documentation

cblite is a command-line tool for inspecting and querying LiteCore and Couchbase Lite databases (which are directories with a .cblite2 extension.)

It has the following sub-commands:

Command	Purpose
cblite cat	Display the body of one or more documents
cblite cp	Replicate, import or export a database
cblite file	Display information about the database
cblite help	Display help text
cblite ls	List the documents in the database
cblite put	Create or update a document
cblite query	Run queries, using the JSON Query Schema
cblite revs	List the revisions of a document
cblite rm	Delete a document
cblite select	Run queries, using N1QL syntax
cblite serve	Starts a (rudimentary) REST API listener

Interactive Mode

The tool has an interactive mode that you start by running cblite /path/to/database, i.e. with no subcommand. It will then prompt you for commands: each command is a command line without the initial cblite or the database-path parameter. Enter quit or press Ctrl-D to exit.

When starting interactive mode, you can put a few flags before the database path:

Flag	Effect
--create	Creates a new database if the path does not exist. Opens database in writeable mode.
--writeable	Opens the database in writeable mode, allowing use of the put and rm subcommands.

These flags were added after version 2.1.

Global Flags

These flags go immediately after cblite. No subcommand should be given.

Flag	Effect
--help	Prints help text, then exits
--version	Echoes the version of LiteCore, then exits

Sub-Commands

(You can run cblite --help to get a quick summary, or cblite help CMD for help on CMD.)

cat

Displays the JSON body of a document (or of documents whose IDs match a pattern.)

cblite cat [flags] databasepath DOCID [DOCID ...]

cat [flags] DOCID [DOCID ...]

(DOCID may contain shell-style wildcards *, ?)

Flag	Effect
--key KEY	Display only a single key/value (may be used multiple times)
--rev	Show the revision ID(s)
--raw	Raw JSON (not pretty-printed)
--json5	JSON5 syntax (no quotes around dict keys)

cp (aka export, import, push, pull)

Copies a database, imports or exports JSON, or replicates.

cblite cp [flags] source destination

source and destination can be database paths, replication URLs, or JSON file paths. One of them must be a database path ending in *.cblite2. The other can be any of the following:

• *.cblite2 ⟶ Copies local db file, and assigns new UUID to target *
• blip://* ⟶ Networked replication
• *.json ⟶ Imports/exports JSON file (one document per line)
• */ ⟶ Imports/exports directory of JSON files (one per doc)

* The --replicate flag can be used to force a local-to-local copy to use the replicator. If the command is invoked as push or pull, this flag is implicitly set.

cp [flags] destination

In interactive mode, the database path is already known, so it's used as the source, and cp takes only a destination argument. You can optionally call the command push or export. Or if you use the synonyms pull or import in interactive mode, the parameter you give is treated as the source, while the current database is the destination.

Flag	Effect
--bidi	Bidirectional (push+pull) replication
--careful	Abort on any error.
--continuous	Continuous replication (never stops!)
--existing or -x	Fail if destination doesn't already exist.
--jsonid property	JSON property to use for document ID**
--limit n	Stop after n documents. (Replicator ignores this)
--replicate	Forces use of replicator when copying local to local
--user name[:password]	Credentials for remote server. (If password is not given, the tool will prompt you to enter it.)
--verbose or -v	Log progress information. Repeat flag for more verbosity.

** --jsonid works as follows: When source is JSON, this is a property name/path whose value will be used as the document ID. (If omitted, documents are given UUIDs.) When destination is JSON, this is a property name that will be added to the JSON, whose value is the document's ID. (If this flag is omitted, the value defaults to _id.)

file

Shows information about the database, such as the number of documents and the latest sequence number.

cblite file databasepath

file databasepath

help

Displays a list of all commands, or details of a given command.

cblite help [subcommand]

help [subcommand]

ls

Lists the IDs of documents in the database.

cblite ls [flags] databasepath [PATTERN]

ls [flags] [PATTERN]

Flag	Effect
-l	Long format (one doc per line, with metadata)
--offset n	Skip first n docs
--limit n	Stop after n docs
--desc	Descending order
--seq	Order by sequence, not docID
--del	Include deleted documents
--conf	Include only conflicted documents
--body	Display document bodies
--pretty	Pretty-print document bodies (implies --body)
--json5	JSON5 syntax, i.e. unquoted dict keys (implies --body)

(PATTERN is an optional pattern for matching docIDs, with shell-style wildcards *, ?)

put

Creates or updates a document.

This command was added after version 2.1.

cblite put [flags] databasepath DOCID "JSON"

put [flags] DOCID "JSON"

Flag	Effect
--create	Only create a document; fails if the document exists.
--update	Only update an existing document; fails if the document does not exist.

The document body JSON must be a single argument; put quotes around it to ensure that and to avoid misinterpretation of special characters. JSON5 syntax is allowed.

NOTE: In the interactive mode, this command will fail unless cblite was invoked with the --writeable or --create flag.

query

Queries the database, using JSON syntax. (See also select, to query with N1QL.)

cblite query [flags] databasepath "query"

query [flags] query

Flag	Effect
--offset n	Skip first n rows
--limit n	Stop after n rows

The query must follow the JSON query schema. (JSON5 syntax is allowed.) It can be a dictionary {{ ... }) containing an entire query specification, or an array ([ ... ]) with just a WHERE clause. There are examples of each up above.

If you're running cblite query ... from a shell, you'll need to quote the JSON.

revs

Displays the revision history of a document.

cblite revs databasepath DOCID

revs DOCID

rm

This command was added after version 2.1.

Deletes a document.

cblite rm databasepath DOCID

rm DOCID

NOTE: In the interactive mode, this command will fail unless cblite was invoked with the --writeable or --create flag.

select

Queries the database using N1QL syntax.

cblite select [flags] databasepath "query"

select [flags] query

Flag	Effect
--offset n	Skip first n rows
--limit n	Stop after n rows

query is a N1QL SELECT query, minus the keyword SELECT since that's already been given as the command name. No FROM clause is needed since there's only one key-space (the database).

serve

Runs a mini HTTP server that responds to the Couchbase Lite REST API.

cblite serve [flags] databasepath

serve [flags]

Flag	Effect
--port n	Set TCP port number (default is 59840)
--readonly	Prevent REST calls from altering the database
--verbose or -v	Log requests. Repeat flag for more verbosity.

Note: Only a subset of the Couchbase Lite REST API is implemented so far! See [the documentation][REST-API].

Example

$  cblite file travel-sample.cblite2
Database:   travel-sample.cblite2/
Total size: 34MB
Documents:  31591, last sequence 31591

$  cblite ls -l --limit 10 travel-sample.cblite2
Document ID     Rev ID     Flags   Seq     Size
airline_10      1-d70614ae ---       1     0.1K
airline_10123   1-091f80f6 ---       2     0.1K
airline_10226   1-928c43f4 ---       3     0.1K
airline_10642   1-5cb6252c ---       4     0.1K
airline_10748   1-630b0443 ---       5     0.1K
airline_10765   1-e7999661 ---       6     0.1K
airline_109     1-bd546abb ---       7     0.1K
airline_112     1-ca955c69 ---       8     0.1K
airline_1191    1-28dbba6e ---       9     0.1K
airline_1203    1-045b6947 ---      10     0.1K
(Stopping after 10 docs)

$  cblite travel-sample.cblite2
(cblite) query --limit 10 ["=", [".type"], "airline"]
["_id": "airline_10"]
["_id": "airline_10123"]
["_id": "airline_10226"]
["_id": "airline_10642"]
["_id": "airline_10748"]
["_id": "airline_10765"]
["_id": "airline_109"]
["_id": "airline_112"]
["_id": "airline_1191"]
["_id": "airline_1203"]
(Limit was 10 rows)
(cblite) query --limit 10 '{WHAT: [[".name"]], WHERE:  ["=", [".type"], "airline"], ORDER_BY: [[".name"]]}'
["40-Mile Air"]
["AD Aviation"]
["ATA Airlines"]
["Access Air"]
["Aigle Azur"]
["Air Austral"]
["Air Caledonie International"]
["Air Caraïbes"]
["Air Cargo Carriers"]
["Air Cudlua"]
(Limit was 10 rows)
(cblite) ^D
$