dbquery.sh

#!/bin/bash
# Run an ad-hoc SQL query against the configured database.
#
#   ./dbquery.sh "select * from users"     # inline query
#   ./dbquery.sh -f query.sql              # query from a file
#   cat query.sql | ./dbquery.sh           # query from stdin
#   echo "select 1" | ./dbquery.sh         # query from stdin
#
# Works across all backends (local client, docker, docker compose). Output is
# a pretty table on a terminal and tab-separated when piped.
set -euo pipefail

DIR="$( cd -P "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
. "$DIR/_init.sh"

usage() {
    cat >&2 <<'EOF'
Usage:
  dbquery.sh "SELECT * FROM users"     run an inline query
  dbquery.sh -f query.sql              run a query from a file
  cat query.sql | dbquery.sh           run a query from stdin
EOF
    exit 2
}

sql=""
case "${1:-}" in
    -h|--help)
        usage
        ;;
    -f|--file)
        file="${2:-}"
        [ -n "$file" ] || { echo "missing file after $1" >&2; exit 2; }
        [ -f "$file" ] || { echo "$file doesn't exist" >&2; exit 3; }
        sql="$(cat "$file")"
        ;;
    "")
        # No args: read SQL from stdin (must be piped, not an interactive TTY).
        [ -t 0 ] && usage
        sql="$(cat)"
        ;;
    *)
        sql="$*"
        ;;
esac

# Pretty box table on a terminal, machine-friendly TSV when redirected/piped.
fmt=""
[ -t 1 ] && fmt=" --table"

printf '%s\n' "$sql" | db_exec notty "${MYSQL_CMD}${fmt} ${DBNAME}"