Files
fecoandClaude Opus 5.5 ce3d3804a7 Paid detailed analyses with per-kind units; example analysis page
- Credits become analysis units (migration 0006): a natal analysis uses
  one 'natal' unit, a synastry analysis one 'synastry' unit. No monthly
  free credits, no model tiers: ANALYSIS_MODEL (default Opus 5.5) writes
  every paid analysis. Admins grant units per kind; the worker refunds
  the right unit on failure.
- Chart page: the detailed analysis card (offer with units left and a
  confirmation, progress while writing, the finished six sections).
- Public /pelda page: a full Opus analysis of a made-up chart, with the
  free summary and a login call to action.
- The worker sends the JSON schema with properties in 'required' order.
  serde_json sorted them, so the title came after ~9000 tokens of text
  and Opus sometimes left it empty (3 failed attempts in a live test);
  with the order fixed the same analysis succeeded at the first try.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_012vLHzh5qUhFtmJhzkcTbXL
2026-11-16 17:39:15 +00:00

15 lines
769 B
SQL

-- Paid analyses are counted per kind instead of generic credits: a
-- detailed natal analysis uses one 'natal' unit, a synastry analysis one
-- 'synastry' unit. Units are bought in packages (or granted by an admin).
-- The free monthly credits are gone: the free part is the short summary.
DELETE FROM credit_ledger WHERE reason = 'monthly_grant';
ALTER TABLE credit_ledger ADD COLUMN unit text NOT NULL DEFAULT 'natal' CHECK (unit IN ('natal', 'synastry'));
ALTER TABLE credit_ledger ALTER COLUMN unit DROP DEFAULT;
DROP INDEX credit_ledger_user_idx;
CREATE INDEX credit_ledger_user_idx ON credit_ledger (user_id, unit, created_at DESC);
COMMENT ON COLUMN analyses.credits_charged IS 'Units of the analysis kind spent on it (0 or 1; 0 for summaries and copies)';