english-learn-cards

使用 SQLite + SRS 进行基于抽认卡的英语词汇学习。与 OpenClaw 代理提示配对时，可与任何聊天平台配合使用。

# English Learn Cards (SQLite + SRS)

A portable vocabulary flashcard workflow for OpenClaw.

- Stores cards in SQLite
- Supports SRS reviews (0–3 grading, SM-2–like)
- Uses a deterministic helper CLI (`scripts/words.py`) to avoid flaky formatting

## Platform notes

This skill is **platform-agnostic** (Slack/Discord/WhatsApp/Telegram/etc.).
Your channel-specific agent prompt should decide:
- message formatting (bullets/headers)
- quiz flow UX
- how user answers are parsed

A ready-to-copy prompt template lives in:
- `skill/prompt-examples/AGENT_PROMPT_TEMPLATE.md`

## Storage

- SQLite DB path is controlled via env var:
  - `ENGLISH_LEARN_CARDS_DB` (default: `~/clawd/memory/english-learn-cards.db`)

## Helper CLI (required)

Use the helper for all DB operations:

```bash
python skill/scripts/words.py init
python skill/scripts/words.py migrate
python skill/scripts/words.py add "implement" ...
python skill/scripts/words.py render "implement" --fill-audio
python skill/scripts/words.py due
python skill/scripts/words.py grade <card_id> <0-3>
```

## Safety / publishing

Do not commit:
- your SQLite DB
- secrets / tokens
- one-off migration/enrichment scripts

Keep local-only scripts outside the repo (see `.gitignore`).

---

## 中文说明

# English Learn Cards (SQLite + SRS)

适用于 OpenClaw 的可移植词汇抽认卡工作流。

- 将卡片存储在 SQLite 中
- 支持 SRS 复习（0–3 评分，类似 SM-2）
- 使用确定性的辅助 CLI（`scripts/words.py`）以避免不稳定的格式问题

## 平台说明

此技能**与平台无关**（Slack/Discord/WhatsApp/Telegram 等）。
你的特定频道代理提示应决定：
- 消息格式（项目符号/标题）
- 测验流程的 UX
- 如何解析用户的答案

可直接复制的提示模板位于：
- `skill/prompt-examples/AGENT_PROMPT_TEMPLATE.md`

## 存储

- SQLite 数据库路径通过环境变量控制：
  - `ENGLISH_LEARN_CARDS_DB`（默认：`~/clawd/memory/english-learn-cards.db`）

## 辅助 CLI（必需）

对所有数据库操作使用该辅助工具：

```bash
python skill/scripts/words.py init
python skill/scripts/words.py migrate
python skill/scripts/words.py add "implement" ...
python skill/scripts/words.py render "implement" --fill-audio
python skill/scripts/words.py due
python skill/scripts/words.py grade <card_id> <0-3>
```

## 安全 / 发布

请勿提交：
- 你的 SQLite 数据库
- 密钥 / 令牌
- 一次性的迁移/丰富脚本

将仅限本地的脚本保留在仓库之外（参见 `.gitignore`）。