Back to Details

fridge-tracker

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Fridge Tracker

冰箱追踪器

Persistent fridge and pantry inventory using SQLite.
使用SQLite实现的持久化冰箱与食品储藏室库存管理工具。

Setup

设置

bash
bash skills/fridge-tracker/scripts/init-db.sh
bash
bash skills/fridge-tracker/scripts/init-db.sh

Commands

命令

/fridge list
(default)

/fridge list
(默认命令)

bash
sqlite3 /data/workspace/pantry.db "SELECT item, quantity, updated_at FROM fridge ORDER BY item;"
Display as a bullet list. If empty: "Fridge is empty. Add items with 
/fridge add <item> <quantity>
"
bash
sqlite3 /data/workspace/pantry.db "SELECT item, quantity, updated_at FROM fridge ORDER BY item;"
以无序列表形式展示结果。如果库存为空，返回：“冰箱是空的。使用 
/fridge add <物品> <数量>
添加物品”

/fridge add <item> [quantity]

/fridge add <物品> [数量]

bash
sqlite3 /data/workspace/pantry.db "INSERT OR REPLACE INTO fridge (item,quantity,updated_at) VALUES (lower('<item>'), '<quantity>', datetime('now'));"
Reply: "Added [item] ([quantity]) to fridge."
bash
sqlite3 /data/workspace/pantry.db "INSERT OR REPLACE INTO fridge (item,quantity,updated_at) VALUES (lower('<item>'), '<quantity>', datetime('now'));"
返回：“已将 [物品]（[数量]）添加到冰箱。”

/fridge remove <item>

/fridge remove <物品>

bash
sqlite3 /data/workspace/pantry.db "DELETE FROM fridge WHERE item=lower('<item>');"
Reply: "Removed [item]." or "Item not found."
bash
sqlite3 /data/workspace/pantry.db "DELETE FROM fridge WHERE item=lower('<item>');"
返回：“已移除 [物品]。” 或 “未找到该物品。”

/fridge clear

/fridge clear

bash
sqlite3 /data/workspace/pantry.db "DELETE FROM fridge;"
Reply: "Fridge cleared."
bash
sqlite3 /data/workspace/pantry.db "DELETE FROM fridge;"
返回：“冰箱已清空。”

Notes

注意事项

  • Always lowercase item names when storing
  • Data is shared with meal-planner and shopping-agent skills
  • If sqlite3 unavailable, maintain inventory in session memory as fallback
  • 存储物品名称时始终统一转为小写
  • 数据会与 meal-planner 和 shopping-agent 技能共享
  • 如果 sqlite3 不可用，降级方案为在会话内存中维护库存数据