sqlite3-csv.sh: dump an table from sqlite db as csv

sqlite3-csv.sh

#!/bin/bash
# sqlite3-csv: dump an table from sqlite db as csv

summary="$0: dump an sqlite db as csv"
usageline="   usage: $0 thisdb [thistable]"
usage="${summary}\n\n${usageline}\n\n"

if [ -z "$1" ]; then
  printf "$usage"
  exit;
elif [ ! -f "$1" ]; then
  echo "$1 isn't a file..."
  printf "$usage"
  exit;
else
  thisdb="$1"
fi

if [ -z "$2" ]; then
  thistable='*'
else
  thistable="$2"
fi

if [ "$thistable" == '*' ]; then
  echo "Tables: "
  sqlite3 places.sqlite .tables
  exit;
else
  sqlite3 -header -csv "$thisdb" "select * from $thistable;"
  exit
fi