Qualityfolio: Test Management as Code & Traceability Mesh

---
doc-classify:
  - select: heading[depth="1"]
    role: project
  - select: heading[depth="2"]
    role: suite
  - select: heading[depth="3"]
    role: case
  - select: heading[depth="4"]
    role: evidence
---

# Infusion Dose Calculator (SaMD)

@id samd-dose-calculator

Software system testing for an IEC 62304 Class B software item.

## Dose Alert Verification

@id dose-alert-suite

Verifies the over-limit dose alert against its software requirement.

### Verify an over-limit dose entry raises a blocking alert

@id TC-MED-001

```yaml META
  requirementID: REQ-SAMD-010
  Priority: High
  Tags: [IEC 62304, Software System Testing]
  Scenario Type: Unhappy Path
```

**Steps**

- [x] Enter a dose above the configured maximum for the selected drug.
- [x] Attempt to confirm the order.

**Expected Results**

- [x] A blocking alert names the limit that was exceeded.
- [x] The order cannot be confirmed until the dose is corrected.

#### Evidence

@id TC-MED-001

```yaml META
  cycle: 1.2
  cycle-date: 04-11-2026
  assignee: QA engineer
  status: passed
```

**Attachment**

- [Results JSON](./evidence/TC-MED-001/1.2/result.auto.json)
- [Run MD](./evidence/TC-MED-001/1.2/run.auto.md)

# Parse test-artifacts/, ingest evidence/, apply qualityfolio-json-etl.sql
spry rb run qualityfolio.md

# Inspect what was captured
surveilr shell -d resource-surveillance.sqlite.db --output table \
  --cmd "SELECT nature, COUNT(*) AS files FROM uniform_resource GROUP BY nature;"

spry sp spc --fs dev-src.auto --destroy-first --conf sqlpage/sqlpage.json --md qualityfolio.md

# Bind to localhost; the dashboard is then at http://localhost:9227/
surveilr web-ui -d ./resource-surveillance.sqlite.db --port 9227 --host localhost

-- Synthetic illustration: a requirement traceability matrix from the RSSD.
-- uniform_resource is surveilr's table (it already exists in a real RSSD).
-- test_case and requirement stand in for the links Qualityfolio's ETL reads
-- from each test case's YAML META block (requirementID).
CREATE TABLE IF NOT EXISTS uniform_resource (uri TEXT, nature TEXT, content TEXT);
CREATE TABLE IF NOT EXISTS requirement (requirement_id TEXT PRIMARY KEY, title TEXT);
CREATE TABLE IF NOT EXISTS test_case (
  test_case_id   TEXT PRIMARY KEY,
  requirement_id TEXT NOT NULL REFERENCES requirement (requirement_id)
);

WITH evidence AS (
  -- .../evidence/TC-MED-001/1.1/result.auto.json -> TC-MED-001/1.1/result.auto.json
  SELECT uri,
         substr(uri, instr(uri, '/evidence/') + 10) AS rel,
         json_extract(content, '$.status') AS status
  FROM uniform_resource
  WHERE uri LIKE '%/evidence/%/result.auto.json' AND json_valid(content)
), runs AS (
  SELECT substr(rel, 1, instr(rel, '/') - 1) AS test_case_id,
         substr(rel, instr(rel, '/') + 1,
                instr(substr(rel, instr(rel, '/') + 1), '/') - 1) AS cycle,
         status, uri
  FROM evidence
)
SELECT r.requirement_id,
       COALESCE(t.test_case_id, 'NOT COVERED') AS test_case_id,
       COALESCE(x.cycle, '-')                  AS cycle,
       COALESCE(x.status, 'no evidence')       AS status,
       x.uri                                   AS evidence_path
FROM requirement r
LEFT JOIN test_case t ON t.requirement_id = r.requirement_id
LEFT JOIN runs x      ON x.test_case_id   = t.test_case_id
ORDER BY r.requirement_id, t.test_case_id, x.cycle;