Multi-Agent Collaboration for Team and Friends
TypeScript agent-automationagent-orchestrationagent-workflowai-agentsai-collaborationai-memoryai-workforceautonomous-agentsclaude-codeclaude-code-skillscodexcoding-agentmulti-agentmultiple-agentone-person-businessone-person-companyone-person-teamopencodesolopreneur
#!/bin/bash
# Bulk delete 'log' type rows from task_message table in batches of 50k
# Run from repo root: bash scripts/cleanup-log-messages.sh
cd "$(dirname "$0")/../src/web"
BATCH=50000
TOTAL_DELETED=0
while true; do
echo "Deleting batch of $BATCH rows..."
RESULT=$(npx wrangler d1 execute alook-app --remote --json --command "DELETE FROM task_message WHERE type = 'log' LIMIT $BATCH;" 2>&1)
if [ $? -ne 0 ]; then
echo "Wrangler command failed. Output:"
echo "$RESULT"
echo "Waiting 30s before retry..."
sleep 30
continue
fi
if echo "$RESULT" | grep -q '"error"'; then
echo "D1 error detected, waiting 30s before retry..."
echo "$RESULT"
sleep 30
continue
fi
CHANGES=$(echo "$RESULT" | grep -o '"changes":[[:space:]]*[0-9]*' | head -1 | grep -o '[0-9]*' || true)
if [ -z "$CHANGES" ]; then
echo "Could not parse changes from response:"
echo "$RESULT"
echo "Waiting 10s before retry..."
sleep 10
continue
fi
TOTAL_DELETED=$((TOTAL_DELETED + CHANGES))
echo "Deleted $CHANGES rows (total: $TOTAL_DELETED)"
if [ "$CHANGES" -lt "$BATCH" ]; then
echo "Done! Total deleted: $TOTAL_DELETED"
break
fi
sleep 5
done