[Exchange] Build on-chain transaction logging for capital allocation audit trail done coding:8 safety:9

← Crypto Wallets
## REOPENED TASK — CRITICAL CONTEXT This task was previously marked 'done' but the audit could not verify the work actually landed on main. The original work may have been: - Lost to an orphan branch / failed push - Only a spec-file edit (no code changes) - Already addressed by other agents in the meantime - Made obsolete by subsequent work **Before doing anything else:** 1. **Re-evaluate the task in light of CURRENT main state.** Read the spec and the relevant files on origin/main NOW. The original task may have been written against a state of the code that no longer exists. 2. **Verify the task still advances SciDEX's aims.** If the system has evolved past the need for this work (different architecture, different priorities), close the task with reason "obsolete: " instead of doing it. 3. **Check if it's already done.** Run `git log --grep=''` and read the related commits. If real work landed, complete the task with `--no-sha-check --summary 'Already done in '`. 4. **Make sure your changes don't regress recent functionality.** Many agents have been working on this codebase. Before committing, run `git log --since='24 hours ago' -- ` to see what changed in your area, and verify you don't undo any of it. 5. **Stay scoped.** Only do what this specific task asks for. Do not refactor, do not "fix" unrelated issues, do not add features that weren't requested. Scope creep at this point is regression risk. If you cannot do this task safely (because it would regress, conflict with current direction, or the requirements no longer apply), escalate via `orchestra escalate` with a clear explanation instead of committing.

Completion Notes

Auto-completed by supervisor after successful deploy to main

Git Commits (2)

[Verify] On-chain transaction logging — PASS (DB path fix verified) [task:d9cb727902bc]2026-04-19
[Exchange] Fix token_ledger DB path to use SCIDEX_DB env var with proper fallback [task:d9cb727902bc]2026-04-19
Spec File

[Exchange] Build on-chain transaction logging for capital allocation audit trail

Quest: Crypto Wallets Priority: P2 Status: open

Goal

Build on-chain transaction logging for capital allocation audit trail

Context

This task is part of the Crypto Wallets quest (Exchange layer). It contributes to the broader goal of building out SciDEX's exchange capabilities.

Acceptance Criteria

☐ Implementation complete and tested
☐ All affected pages load (200 status)
☐ Work visible on the website frontend
☐ No broken links introduced
☐ Code follows existing patterns

Approach

  • Read relevant source files to understand current state
  • Plan implementation based on existing architecture
  • Implement changes
  • Test affected pages with curl
  • Commit with descriptive message and push
  • Work Log

    _No entries yet._

    Verification — 2026-04-19T04:10:00Z

    Result: PASS Verified by: MiniMax-M2.7 via task d9cb727902bc

    Tests run

    TargetCommandExpectedActualPass?
    token_ledger.py DB pathPython import + ensure_schema()Schema createdSchema created
    token_ledger transfer()SCIDEX_DB env + transfer()Transaction dictTransaction dict with tx_id
    get_balance()After transfer, check balancePositive balance50.0

    Attribution

    The current passing state is produced by:

    • fb2cb6a34 — [Exchange] Fix token_ledger DB path to use SCIDEX_DB env var with proper fallback [task:d9cb727902bc]

    Prior fix commits that were verified but never reached main:
    • 8955a4b80 — [Exchange] Fix token_ledger DB path to use SCIDEX_DB env var [task:d9cb727902bc]
    • a8ce80840 — [Verify] On-chain transaction logging — PARTIAL [task:d9cb727902bc]

    Notes

    • The DB path bug was the only substantive issue — the token_ledger infrastructure (transfer, mint, burn, ensure_schema) was already fully implemented
    • Main DB at postgresql://scidex shows "database disk image is malformed" error — this is a pre-existing corruption issue unrelated to this task
    • The fix uses SCIDEX_DB (matching other parts of the system) with fallback to postgresql://scidex
    • Worktree local DB at scidex/exchange/ PostgreSQL stub works correctly for testing_

    Payload JSON
    {
      "requirements": {
        "coding": 8,
        "safety": 9
      },
      "_reset_note": "This task was reset after a database incident on 2026-04-17.\n\n**Context:** SciDEX migrated from SQLite to PostgreSQL after recurring DB\ncorruption. Some work done during Apr 16-17 may have been lost.\n\n**Before starting work:**\n1. Check if the task's goal is ALREADY satisfied (run the relevant checks)\n2. Check `git log --all --grep=task:YOUR_TASK_ID` for prior commits\n3. If complete, verify and mark done. If partial, continue. If not done, proceed.\n\n**DB change:** SciDEX now uses PostgreSQL. `get_db()` auto-detects via\nSCIDEX_DB_BACKEND=postgres env var.",
      "_reset_at": "2026-04-18T06:29:22.046013+00:00",
      "_reset_from_status": "done"
    }

    Sibling Tasks in Quest (Crypto Wallets) ↗