cli-db

tools to interact with databases, esp. in the cloud

• Usage
• Commands

Usage

$ npm install -g cli-db
$ cli-db COMMAND
running command...
$ cli-db (-v|--version|version)
cli-db/0.4.3 darwin-x64 node-v12.16.2
$ cli-db --help [COMMAND]
USAGE
  $ cli-db COMMAND
...

Commands

• cli-db ffprobe INPUT_FILE
• cli-db help [COMMAND]
• cli-db http URL
• cli-db mongo

cli-db ffprobe INPUT_FILE

Media utils - ffprobe

USAGE
  $ cli-db ffprobe INPUT_FILE

ARGUMENTS
  INPUT_FILE  local path or URL to a file

OPTIONS
  -h, --help  show CLI help

DESCRIPTION
  Perform content tasks

  Requires the 'ffmpeg' package for your OS:
  - mac: brew install ffmpeg
  - debian/ubuntu: apt install ffmpeg

EXAMPLE

  AFILE=s3://YOUR-BUCKET/YOUR-FILE.mp4
  SECONDS=60
  cli-db ffprobe $(aws s3 presign $AFILE --expires-in $SECONDS --profile YOUR-AWS-PROFILE) | jq '.'

See code: src/commands/ffprobe.js

cli-db help [COMMAND]

display help for cli-db

USAGE
  $ cli-db help [COMMAND]

ARGUMENTS
  COMMAND  command to show help for

OPTIONS
  --all  see all commands in CLI

See code: @oclif/plugin-help

cli-db http URL

make http requests

USAGE
  $ cli-db http URL

ARGUMENTS
  URL  the complete url, i.e. fully qualified domain name

OPTIONS
  -H, --headers=headers                              JSON map of headers to use in the request
  -X, --method=method                                (required) [default: GET] http method to use: GET, POST, PUT,...
  -d, --data=data                                    the payload for write methods
  -i, --aws-access-key-id=aws-access-key-id          access key id for AWS signing
  -k, --aws-secret-access-key=aws-secret-access-key  secret key for AWS signing
  -p, --aws-profile=aws-profile                      profile name for AWS CLI and SDK
  -r, --aws-region=aws-region                        AWS region of service
  -s, --aws-service=aws-service                      [default: execute-api] AWS service, e.g. appsync
  -t, --aws-session-token=aws-session-token          session token for AWS signing

See code: src/commands/http.js

cli-db mongo

Interact with MongoDb

USAGE
  $ cli-db mongo

OPTIONS
  -b, --db=db                      (required) the mongo database name
  -c, --collection=collection      (required) the mongo collection name
  -d, --data=data                  the data for the query
  -f, --file=file                  the file path with content for the data
  -h, --help                       show CLI help
  -i, --input=input                the path to assign input for the data query
  -l, --awsProfile=awsProfile      aws profile containing secrets
  -m, --method=method              (required) the mongo method
  -o, --options=options            [default: {}] the json string for mongo query options
  -p, --projection=projection      [default: {}] the json projection string
  -q, --query=query                (required) the json query filter string
  -r, --awsRegion=awsRegion        aws region containing secrets
  -s, --awsSecretUrl=awsSecretUrl  aws secret containing mongo connection string
  -u, --url=url                    mongo connection string (URL)

DESCRIPTION
  Specify reads, writes, aggregations, with AWS integration to support secret connection strings

EXAMPLES

  UPSERT

     cli-db mongo \
      -u 'mongodb://localhost:27018' \
      -b 'test' \
      -c 'todo' \
      -m 'updateOne' \
      -q '{"id": "123"}' \
      -d '{"$set": {"id": "123", "title": "buy toothpaste"}}' \
      -o '{"upsert": true}'

  READ (connection from AWS Secrets Manager)

     cli-db mongo \
      -l 'your-aws-profile-name-here' \
      -s 'test-mongo-local' \
      -r 'us-west-2' \
      -b 'test' \
      -c 'todo' \
      -m 'findOne' \
      -q '{"id": "123"}'

See code: src/commands/mongo.js