What do you want to do?
├── add all posts from URL → harvest mode
├── add posts from author name → author mode (lookup URL first)
├── discover similar blogs → suggest mode (analyze library)
├── check what we have → inventory mode
└── unclear → ask which blog URL

# discover posts using agent-browser
agent-browser open https://example.com/blog
agent-browser snapshot -i -c
agent-browser get text "a[href*='/posts/']"  # extract post links

# check existing articles
sqlite3 ~/.epub/library.db "SELECT title FROM library_items WHERE author = 'Author Name'"

# batch convert
for url in $(cat ~/.abbie/feeds/harvested/urls.txt); do
  reader url "$url" --author "Author Name"
done

# Or use the built-in batch command
reader blog harvest --file ~/.abbie/feeds/harvested/urls.txt --author "Author Name"

# verify
sqlite3 ~/.epub/library.db "SELECT COUNT(*) FROM library_items WHERE author = 'Author Name'"

# get existing authors
sqlite3 ~/.epub/library.db "SELECT DISTINCT author FROM library_items ORDER BY author"

# analyze for mentions
for epub in ~/.epub/library/*.epub; do
  unzip -p "$epub" | grep -o 'https://[^"]*' | grep blog
done | sort | uniq -c | sort -rn | head -20

# authors with < 10 posts (incomplete archives)
sqlite3 ~/.epub/library.db "
  SELECT author, COUNT(*) as count
  FROM library_items
  WHERE source IN ('feed', 'backfill', 'url')
  GROUP BY author
  HAVING count < 10
  ORDER BY count DESC
"

# authors missing from known blogs
comm -13 \
  <(sqlite3 ~/.epub/library.db "SELECT DISTINCT author FROM library_items WHERE source IN ('feed', 'backfill')" | sort) \
  <(jq -r '.[].author' ~/.claude/skills/blog-add/assets/supported-blogs.json | sort)

# oldest post dates (check for updates)
sqlite3 ~/.epub/library.db "
  SELECT author, MAX(created_at) as latest
  FROM library_items
  WHERE source IN ('feed', 'backfill')
  GROUP BY author
  ORDER BY latest ASC
  LIMIT 20
"

# sequential (safe)
cat urls.txt | while read url; do
  node ~/.epub/bin/run.js url "$url" --author "Author"
done

# parallel (faster, 4 workers)
cat urls.txt | xargs -P 4 -I {} node ~/.epub/bin/run.js url "{}" --author "Author"

# with retry and logging
mkdir -p ~/.abbie/feeds/harvested
cat urls.txt | while read url; do
  if ! node ~/.epub/bin/run.js url "$url" --author "Author" 2>&1 | tee -a ~/.abbie/feeds/harvested/conversion.log; then
    echo "$url" >> ~/.abbie/feeds/harvested/failed.txt
  fi
  sleep 1  # rate limiting
done

# open blog archive
agent-browser open https://blog.example.com/archive

# wait for load
agent-browser wait --load networkidle

# get snapshot
agent-browser snapshot -i -c

# extract links
mkdir -p ~/.abbie/feeds/harvested
agent-browser eval "
  Array.from(document.querySelectorAll('a[href*=\"/posts/\"]'))
    .map(a => a.href)
    .join('\\n')
" > ~/.abbie/feeds/harvested/urls.txt

# click "load more" until exhausted
while agent-browser is visible ".load-more"; do
  agent-browser click ".load-more"
  agent-browser wait 2000
done

# extract all loaded links
agent-browser eval "Array.from(document.querySelectorAll('article a')).map(a => a.href).join('\\n')"

# scroll to bottom repeatedly
for i in {1..20}; do
  agent-browser scroll down 1000
  agent-browser wait 1000
done

# extract all visible posts
agent-browser snapshot -i -c

# verify epub created
test -f ~/.epub/library/*.epub && echo "✓ epub exists"

# verify in database
sqlite3 ~/.epub/library.db "SELECT title FROM library_items WHERE id = '$ID'"

# verify author set
sqlite3 ~/.epub/library.db "SELECT author FROM library_items WHERE id = '$ID'" | grep -q "Author Name"

# expected vs actual count
EXPECTED=$(wc -l < urls.txt)
ACTUAL=$(sqlite3 ~/.epub/library.db "SELECT COUNT(*) FROM library_items WHERE author = 'Author' AND source IN ('url', 'backfill')")
echo "Expected: $EXPECTED, Actual: $ACTUAL"

# check for failures
test -f ~/.abbie/feeds/harvested/failed.txt && echo "⚠ $(wc -l < ~/.abbie/feeds/harvested/failed.txt) failures"