Function test_diff_sqlite_output_e2e

tests/test_outputs.py:336–361

(fixtures, fuzzy_rule_match, tmp_path)

@pytest.mark.e2e
def test_diff_sqlite_output_e2e(fixtures, fuzzy_rule_match, tmp_path):
    pth1 = fixtures.path("diffs/1_a")
    pth2 = fixtures.path("diffs/1_b")
    db_path = tmp_path / "aura_test_diff_output.sqlite"

    try:
        _ = fixtures.get_cli_output(["diff", pth1, pth2, "-f", f"sqlite://{db_path}"])
    except FeatureDisabled as exc:
        pytest.mark.skipif(reason=exc.args[0])

    db = sqlite3.connect(db_path)
    db.row_factory = sqlite3.Row

    diffs = [dict(x) for x in db.execute("SELECT * FROM diffs").fetchall()]
    diff_ids = {x["id"]: x for x in diffs}

    detections = [dict(x) for x in db.execute("SELECT * FROM detections").fetchall()]

    for d in detections:
        if d["is_new"]:
            diff_ids[d["diff"]].setdefault("new_detections", []).append(d)
        else:
            diff_ids[d["diff"]].setdefault("removed_detections", []).append(d)

    for match in DIFF_MATCHES:
        assert any(fuzzy_rule_match(x, match) for x in diffs), (match, diffs)


@pytest.mark.skipif(jsonschema is None, reason="jsonschema module is not installed")