llmage/scripts/fix_m3_pricing.sql
Hermes Agent 0d2b39ddd7 feat: add recover_usages button to accounting failed page
- Add recover_usages.dspy: reads ioinfo files, extracts usage from
  last output, writes back to llmusage.usages field
- Add toolbar button in llmusage_accounting_failed/index.ui
- Register new path in load_path.py RBAC config
- Force-add dspy (parent dir in .gitignore for CRUD auto-gen)
2026-06-15 17:01:29 +08:00

27 lines
764 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- ============================================================
-- 修复 MiniMax-M3 定价重复条目
-- 问题步骤11b的CONCAT重复执行导致M3条目重复
-- 解决删除没有prompt_tokens filter的旧M3条目前3条
-- ============================================================
UPDATE `pricing_program_timing`
SET `pricing_data` = REPLACE(`pricing_data`,
'- price_factors: prompt_tokens
unit_prices: 2.1
unit: 百万
filters:
- model: MiniMax-M3
- price_factors: completion_tokens
unit_prices: 8.4
unit: 百万
filters:
- model: MiniMax-M3
- price_factors: cached_tokens
unit_prices: 0.42
unit: 百万
filters:
- model: MiniMax-M3
', '')
WHERE `ppid` = '5jmzupARABxkDFwUraFiQ' AND `enabled_date` = '2026-04-12';