Import and export CSV files with orc

orcsv

#!/usr/bin/env bash

import () {
  csvjson "${3:-/dev/stdin}" \
  | jq --raw-output '.[] | @sh "echo orc add-entry '"$1"' user \(.'"$2"') \(tostring)"' \
  | xargs -0 bash -c
}

export_ () {
  orc ls "$1" user | cut -f 4 | in2csv -f ndjson
}

usage () {
  cat <<EOF
usage:
  orcsv import <REGISTER> <KEYFIELD> <FILENAME>
  cat <FILENAME> | orcsv import <REGISTER> <KEYFIELD>
  orcsv export <REGISTER>

dependencies:
  orc:    https://github.com/register-dynamics/orc
  csvkit: https://csvkit.rtfd.org
  jq:     https://stedolan.github.io/jq/
EOF
}

case $1 in
  import) shift; import "$@";;
  export) shift; export_ "$@";;
  *) usage; exit 1;;
esac