queue

What this skill does

# Article Queue

Manage the article queue stored in the SQLite database (`.article_writer/article_writer.db`).

## Data Access

All data is stored in the `articles` table of the SQLite database. Use the provided scripts for all operations:

```bash
# Queue summary
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts status

# List articles (with filters)
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list [filter]

# Show article details
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts show <id>

# Stats and operations
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --summary
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --get <id>
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --set-status <status> <id>
```

## Schema Reference

See [references/schema-reference.md](references/schema-reference.md) for fields.

## Key Fields

### Author Reference

Articles reference authors via `author_id`, `author_name`, and `author_languages` columns:

```json
{
  "author_id": "mwguerra",
  "author_name": "MW Guerra",
  "author_languages": ["pt_BR", "en_US"]
}
```

If author not specified, the default author (lowest `sort_order`) is used.

### Output Files (per language)
```json
{
  "output_folder": "content/articles/2025_01_15_rate-limiting/",
  "output_files": [
    {
      "language": "pt_BR",
      "path": "content/articles/2025_01_15_rate-limiting/rate-limiting.pt_BR.md",
      "translated_at": "2025-01-15T14:00:00Z"
    },
    {
      "language": "en_US",
      "path": "content/articles/2025_01_15_rate-limiting/rate-limiting.en_US.md",
      "translated_at": "2025-01-15T16:00:00Z"
    }
  ]
}
```

### Timestamps
- `created_at`: When task was added to queue
- `written_at`: When primary article was completed
- `published_at`: When article went live
- `updated_at`: Last modification

## Operations

### Status Summary
```bash
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts status
```

### Filter by Author
```bash
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list author:mwguerra
```

### Filter by Language
```bash
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list lang:en_US
```

### Update After Writing
```bash
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts update <id> status:draft
```

### Add Translation
Update the `output_files` JSON column with additional language entries.

## Status Flow

```
pending -> in_progress -> draft -> review -> published
               |
           archived
```

## Default Author

When adding tasks without author:
1. Query default author: `SELECT * FROM authors ORDER BY sort_order ASC LIMIT 1`
2. Store author_id, author_name, author_languages in article record

## Validation

Before processing:
- Verify author_id exists in authors table
- Validate languages are subset of author's languages
- Check all required fields present