#!/usr/bin/env bash
set -euo pipefail

BASE_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
PROJECT_ROOT="/Users/rating/workspace/neta-bi-bot"
RUN_DATE="${1:-$(date +%Y%m%d)}"
OUT_DIR="${BASE_DIR}/data/csv"

mkdir -p "${OUT_DIR}"

python3 "${PROJECT_ROOT}/scripts/bytehouse_run_sql_v2.py" \
  -f "${BASE_DIR}/sql/05_daily_trigger_priority_summary.sql" \
  -y \
  --format csv \
  -o "${OUT_DIR}/daily_trigger_priority_summary_${RUN_DATE}.csv"

python3 "${PROJECT_ROOT}/scripts/bytehouse_run_sql_v2.py" \
  -f "${BASE_DIR}/sql/04_daily_trigger_userlist.sql" \
  -y \
  --format csv \
  -o "${OUT_DIR}/daily_trigger_userlist_raw_${RUN_DATE}.csv"

python3 "${BASE_DIR}/script/enrich_trigger_userlist_with_mysql.py" \
  --input "${OUT_DIR}/daily_trigger_userlist_raw_${RUN_DATE}.csv" \
  --output "${OUT_DIR}/daily_trigger_userlist_${RUN_DATE}.csv"

echo "Generated files:"
echo "  ${OUT_DIR}/daily_trigger_priority_summary_${RUN_DATE}.csv"
echo "  ${OUT_DIR}/daily_trigger_userlist_raw_${RUN_DATE}.csv"
echo "  ${OUT_DIR}/daily_trigger_userlist_${RUN_DATE}.csv"