Files
terminalShop/scripts/ops/list-paid.sh

7 lines
346 B
Bash
Executable File

#!/usr/bin/env bash
# List recent paid orders awaiting label purchase.
# Usage: scripts/ops/list-paid.sh
set -euo pipefail
ssh ubuntu-helsinki "sqlite3 -header -column /root/terminalShop/data/terminalshop.db \"SELECT id, status, total, shipping_name, shipping_city, shipping_country FROM orders WHERE status='paid' ORDER BY id DESC LIMIT 10;\""