cloudant query utility script

index.sh

#!/bin/bash

set -e

USERNAME=snowch
DBNAME=stackoverflow

SCRIPT=$(basename $0)

if [[ ! $1 =~ (create)|(list)|(delete)|(find)  ]]; then
  echo "Usage: ./$SCRIPT create|list|delete|find"
  exit 1
fi

if [[ ! -e ~/.netrc ]]; then
  echo "Could not find your ~/.netrc file containing your Cloudant login credentials.  For example:"
  echo ""
  echo "machine <<username>>.cloudant.com login <<username>> password <<password>>"
  exit 1
fi

if [[ $1 == 'find' ]]; 
then
  curl -n -X POST https://$USERNAME.cloudant.com/$DBNAME/_find -d '
  {
    "selector": {
        "subject": {"$eq": "SAMPLE TOPIC"}
    },
    "fields": ["_id", "_rev", "subject"],
    "sort": [{"subject": "asc"}],
    "limit": 10,
    "skip": 0
  }'
fi

if [[ $1 == 'create' ]]; 
then
  curl -n -X POST https://$USERNAME.cloudant.com/$DBNAME/_index -d '
  {
      "index": {
          "fields": ["subject"]
      },
      "name" : "subject",
      "type" : "json"
  }'
fi

if [[ $1 == 'list' ]]; 
then
  curl -n -s -X GET https://$USERNAME.cloudant.com/$DBNAME/_index | python -m json.tool
fi

if [[ $1 == 'delete' ]]; 
then
  if [[ -z $2 ]]; then
    echo "Usage: ./$SCRIPT delete design_doc/type/name"
    exit 1
  fi
  curl -n -s -X DELETE https://$USERNAME.cloudant.com/$DBNAME/_index/$2
fi