Holzleitner---Backend--aktuell-/tool/reset_test_tour.sh

#!/usr/bin/env bash
#
# Setzt die Smoke-Test-Touren der Accounts 1001/1002 auf einen sauberen
# Zustand für den App-Smoke-Test:
#
#   * tour_date  → heute  (sonst filtert /me/tours/today sie weg)
#   * deliveries → state='active', state_reason=NULL, assigned_car_id=NULL
#   * delivery_items → scan_status='in_progress', scanned_quantity=0,
#                      held_reason=NULL, scan_last_updated_at=NOW()
#
# Verwendet den laufenden Postgres-Container aus docker-compose.yml. Falls
# der Container anders heißt, kann der Name per CONTAINER überschrieben
# werden:
#
#   CONTAINER=hl-postgres ./tool/reset_test_tour.sh
#
# Idempotent — kann beliebig oft ausgeführt werden.

set -euo pipefail

CONTAINER="${CONTAINER:-holzleitner-postgres}"
DB_USER="${DB_USER:-holzleitner}"
DB_NAME="${DB_NAME:-holzleitner}"
ACCOUNTS="${ACCOUNTS:-1001,1002}"

if ! docker inspect "$CONTAINER" >/dev/null 2>&1; then
  echo "✗ Container '$CONTAINER' läuft nicht. Starte docker compose up -d." >&2
  exit 1
fi

echo "→ Reset Smoke-Test-Touren für Accounts ($ACCOUNTS) …"

docker exec -i "$CONTAINER" psql -U "$DB_USER" -d "$DB_NAME" -v ON_ERROR_STOP=1 -q <<SQL
-- Tour-Datum auf heute schieben (alle Touren der Test-Accounts).
UPDATE tours
   SET tour_date = CURRENT_DATE,
       synced_at = NOW()
 WHERE account_id IN ($ACCOUNTS);

-- Lieferungen wieder aktiv, ohne Reason, keinem Auto zugeordnet.
UPDATE deliveries
   SET state           = 'active',
       state_reason    = NULL,
       assigned_car_id = NULL
 WHERE tour_id IN (SELECT id FROM tours WHERE account_id IN ($ACCOUNTS));

-- Items in „nichts gescannt"-Ausgangszustand zurück.
UPDATE delivery_items
   SET scan_status          = 'in_progress',
       scanned_quantity     = 0,
       held_reason          = NULL,
       scan_last_updated_at = NOW()
 WHERE delivery_id IN (
   SELECT d.id FROM deliveries d
     JOIN tours t ON t.id = d.tour_id
    WHERE t.account_id IN ($ACCOUNTS)
 );

\\echo
\\echo --- TOUREN ---
SELECT account_id, tour_date, id FROM tours
 WHERE account_id IN ($ACCOUNTS)
 ORDER BY account_id, tour_date;

\\echo
\\echo --- LIEFERUNGEN ---
SELECT t.account_id, d.erp_belegnummer, d.state, d.sort_order, d.assigned_car_id
  FROM deliveries d
  JOIN tours t ON t.id = d.tour_id
 WHERE t.account_id IN ($ACCOUNTS)
 ORDER BY t.account_id, d.sort_order;

\\echo
\\echo --- ITEMS ---
SELECT t.account_id, d.erp_belegnummer, di.belegzeilen_nr,
       a.name AS article, di.required_quantity, di.scan_status, di.scanned_quantity
  FROM delivery_items di
  JOIN deliveries d ON d.id = di.delivery_id
  JOIN tours t      ON t.id = d.tour_id
  JOIN articles a   ON a.id = di.article_id
 WHERE t.account_id IN ($ACCOUNTS)
 ORDER BY t.account_id, d.sort_order, di.belegzeilen_nr;
SQL

echo "✓ Reset abgeschlossen."