Date Iteration

SQL Example:

macOS

DB_NAME="journal"
TABLE_NAME="otel_logs"
START_DATE="2025-01-01"
END_DATE="2025-01-10"

current=$START_DATE
while [[ "$current" < "$END_DATE" || "$current" == "$END_DATE" ]]; do
  echo "ALTER TABLE ${DB_NAME}.${TABLE_NAME} DROP PARTITION '$current';"
  current=$(date -j -v +1d -f "%Y-%m-%d" "$current" "+%Y-%m-%d") # BSD date
done

Linux

DB_NAME="journal"
TABLE_NAME="otel_logs"
START_DATE="2025-01-01"
END_DATE="2025-01-10"

current=$(date -I -d "$START_DATE")
while [[ "$current" < "$END_DATE" || "$current" == "$END_DATE" ]]; do
  echo "ALTER TABLE ${DB_NAME}.${TABLE_NAME} DROP PARTITION '$current';"
  current=$(date -I -d "$current + 1 day") # GNU date
done