"""Tests for the OpenCode learn scanner.""" from __future__ import annotations import json import os import sqlite3 from pathlib import Path import pytest import headroom.learn.plugins.opencode as opencode_module from headroom.learn.models import ErrorCategory from headroom.learn.plugins.opencode import OpenCodePlugin from headroom.learn.registry import get_registry, reset_registry from headroom.learn.writer import CodexWriter def _create_opencode_db( db_path: Path, project_path: Path, *, project_id: str = "project-1", project_name: str = "Headroom", session_id: str = "session-1", tool_command: str = "pytest", ) -> None: conn = sqlite3.connect(db_path) try: conn.executescript( """ CREATE TABLE project ( id TEXT PRIMARY KEY, name TEXT, worktree TEXT ); CREATE TABLE session ( id TEXT PRIMARY KEY, project_id TEXT, time_created INTEGER ); CREATE TABLE message ( id TEXT PRIMARY KEY, session_id TEXT ); CREATE TABLE part ( id TEXT PRIMARY KEY, message_id TEXT, data TEXT, time_created INTEGER ); """ ) conn.execute( "INSERT INTO project (id, name, worktree) VALUES (?, ?, ?)", (project_id, project_name, str(project_path)), ) conn.execute( "INSERT INTO session (id, project_id, time_created) VALUES (?, ?, ?)", (session_id, project_id, 1_700_000_000_000), ) conn.execute( "INSERT INTO message (id, session_id) VALUES (?, ?)", ("message-1", session_id), ) conn.execute( "INSERT INTO part (id, message_id, data, time_created) VALUES (?, ?, ?, ?)", ( "part-1", "message-1", json.dumps( { "type": "tool", "tool": "bash", "callID": "call-1", "state": { "status": "error", "input": {"command": tool_command}, "output": "Error: command failed with exit code 1", }, } ), 1_700_000_000_001, ), ) conn.commit() finally: conn.close() def _patch_default_paths(monkeypatch: pytest.MonkeyPatch, db_dir: Path) -> tuple[Path, Path]: canonical_db = db_dir / "opencode.db" local_db = db_dir / "opencode-local.db" monkeypatch.setattr(opencode_module, "_OPENCODE_DIR", db_dir, raising=False) monkeypatch.setattr(opencode_module, "_OPENCODE_DB", canonical_db, raising=False) return canonical_db, local_db def _set_mtime(path: Path, *, seconds: int) -> None: os.utime(path, ns=(seconds * 1_000_000_000, seconds * 1_000_000_000)) def _write_agents_file(project_path: Path) -> None: project_path.mkdir() (project_path / "AGENTS.md").write_text("# Existing context\n", encoding="utf-8") def test_opencode_plugin_explicit_path_discovers_projects_and_scans_tool_failures( tmp_path: Path, ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_path = tmp_path / "opencode.db" _create_opencode_db(db_path, project_path) plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Headroom" assert projects[0].project_path == project_path assert projects[0].context_file == project_path / "AGENTS.md" sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 assert sessions[0].session_id == "session-1" assert sessions[0].timestamp is not None tool_call = sessions[0].tool_calls[0] assert tool_call.name == "Bash" assert tool_call.tool_call_id == "call-1" assert tool_call.input_data == {"command": "pytest"} assert tool_call.is_error is True assert tool_call.error_category == ErrorCategory.RUNTIME_ERROR def test_opencode_plugin_newer_local_database_wins_by_default( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, local_db = _patch_default_paths(monkeypatch, db_dir) _create_opencode_db( canonical_db, project_path, project_name="Canonical", tool_command="canonical-command", ) _create_opencode_db( local_db, project_path, project_name="Local", tool_command="local-command", ) _set_mtime(canonical_db, seconds=1) _set_mtime(local_db, seconds=2) plugin = OpenCodePlugin() assert plugin.detect() is True projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Local" sessions = plugin.scan_project(projects[0]) assert sessions[0].tool_calls[0].input_data == {"command": "local-command"} def test_opencode_plugin_canonical_only_default_path( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, _ = _patch_default_paths(monkeypatch, db_dir) _create_opencode_db( canonical_db, project_path, project_name="Canonical", tool_command="canonical-command", ) plugin = OpenCodePlugin() assert plugin.detect() is True projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Canonical" assert plugin._db_path == canonical_db def test_opencode_plugin_local_only_default_path( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() _, local_db = _patch_default_paths(monkeypatch, db_dir) _create_opencode_db( local_db, project_path, project_name="Local", tool_command="local-command", ) plugin = OpenCodePlugin() assert plugin.detect() is True projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Local" assert plugin._db_path == local_db def test_opencode_plugin_equal_mtime_prefers_canonical( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, local_db = _patch_default_paths(monkeypatch, db_dir) _create_opencode_db( canonical_db, project_path, project_name="Canonical", tool_command="canonical-command", ) _create_opencode_db( local_db, project_path, project_name="Local", tool_command="local-command", ) _set_mtime(canonical_db, seconds=1) _set_mtime(local_db, seconds=1) plugin = OpenCodePlugin() assert plugin._db_path == canonical_db projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Canonical" def test_opencode_plugin_env_override_wins(tmp_path: Path, monkeypatch: pytest.MonkeyPatch) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, local_db = _patch_default_paths(monkeypatch, db_dir) override_db = db_dir / "override.db" _create_opencode_db( canonical_db, project_path, project_name="Canonical", tool_command="canonical-command", ) _create_opencode_db( local_db, project_path, project_name="Local", tool_command="local-command", ) _create_opencode_db( override_db, project_path, project_name="Override", tool_command="override-command", ) _set_mtime(canonical_db, seconds=1) _set_mtime(local_db, seconds=2) monkeypatch.setenv(opencode_module._OPENCODE_DB_ENV, str(override_db)) plugin = OpenCodePlugin() assert plugin._db_path == override_db projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "Override" def test_opencode_plugin_missing_override_stays_missing( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: project_path = tmp_path / "repo" _write_agents_file(project_path) db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, local_db = _patch_default_paths(monkeypatch, db_dir) missing_db = db_dir / "override-missing.db" _create_opencode_db(canonical_db, project_path, project_name="Canonical") _create_opencode_db(local_db, project_path, project_name="Local") _set_mtime(canonical_db, seconds=1) _set_mtime(local_db, seconds=2) monkeypatch.setenv(opencode_module._OPENCODE_DB_ENV, str(missing_db)) plugin = OpenCodePlugin() assert plugin._db_path == missing_db assert plugin.detect() is False assert plugin.discover_projects() == [] def test_opencode_plugin_no_default_database_detects_missing( tmp_path: Path, monkeypatch: pytest.MonkeyPatch ) -> None: db_dir = tmp_path / "opencode" db_dir.mkdir() canonical_db, _ = _patch_default_paths(monkeypatch, db_dir) plugin = OpenCodePlugin() assert plugin._db_path == canonical_db assert plugin.detect() is False assert plugin.discover_projects() == [] def test_opencode_plugin_uses_agents_writer(tmp_path: Path) -> None: plugin = OpenCodePlugin(db_path=tmp_path / "missing.db") assert plugin.detect() is False assert isinstance(plugin.create_writer(), CodexWriter) def test_opencode_plugin_is_discovered_by_registry() -> None: reset_registry() try: assert "opencode" in get_registry() finally: reset_registry() def _create_opencode_db_v2( db_path: Path, project_path: Path, *, project_id: str = "project-v2", project_name: str | None = None, session_id: str = "session-v2", worktree: str | None = None, ) -> None: """Build a minimal opencode v2 database (session_v2 + session_message). Mirrors the schema shipped by current opencode releases: each ``session_message`` row holds JSON ``data`` with a ``content`` list, and tool entries carry ``name``/``id`` plus a ``state`` dict with ``status``/``input``/``content`` (or ``error`` on failure). """ conn = sqlite3.connect(db_path) try: conn.executescript( """ CREATE TABLE project ( id TEXT PRIMARY KEY, worktree TEXT NOT NULL, name TEXT ); CREATE TABLE session_v2 ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, time_created INTEGER NOT NULL ); CREATE TABLE session_message ( id TEXT PRIMARY KEY, session_id TEXT NOT NULL, type TEXT NOT NULL, seq INTEGER NOT NULL, time_created INTEGER NOT NULL, time_updated INTEGER NOT NULL, data TEXT NOT NULL ); """ ) # NOTE: compact separators mirror production storage (no spaces), which # the scanner's LIKE prefilter matches. def _dump(obj: object) -> str: return json.dumps(obj, separators=(",", ":")) conn.execute( "INSERT INTO project (id, worktree, name) VALUES (?, ?, ?)", (project_id, worktree if worktree is not None else str(project_path), project_name), ) conn.execute( "INSERT INTO session_v2 (id, project_id, time_created) VALUES (?, ?, ?)", (session_id, project_id, 1_700_000_000_000), ) conn.execute( "INSERT INTO session_message (id, session_id, type, seq, time_created, time_updated, data)" " VALUES (?, ?, ?, ?, ?, ?, ?)", ( "message-v2-1", session_id, "assistant", 5, 1_700_000_000_001, 1_700_000_000_002, _dump( { "content": [ { "type": "tool", "id": "call-v2-1", "name": "read", "state": { "status": "completed", "input": {"path": "/repo/main.py"}, "content": [{"type": "text", "text": "print('hi')\n"}], "metadata": {"truncated": False}, }, }, { "type": "tool", "id": "call-v2-2", "name": "bash", "state": { "status": "error", "input": {"command": "pytest"}, "error": { "type": "tool.execution", "message": "Error: command failed with exit code 1", }, }, }, ] } ), ), ) conn.commit() finally: conn.close() def test_opencode_plugin_v2_schema_discovers_projects_and_scans_tool_calls( tmp_path: Path, ) -> None: project_path = tmp_path / "repo-v2" _write_agents_file(project_path) db_path = tmp_path / "opencode-v2.db" _create_opencode_db_v2(db_path, project_path, project_name="V2Project") plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "V2Project" assert projects[0].project_path == project_path sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 assert sessions[0].session_id == "session-v2" assert len(sessions[0].tool_calls) == 2 ok_call, err_call = sessions[0].tool_calls assert ok_call.name == "read" assert ok_call.is_error is False assert "print('hi')" in ok_call.output assert err_call.name == "Bash" assert err_call.tool_call_id == "call-v2-2" assert err_call.is_error is True assert err_call.error_category == ErrorCategory.RUNTIME_ERROR def test_opencode_plugin_v2_forward_slash_windows_worktree_scans_calls( tmp_path: Path, ) -> None: # opencode stores Windows worktrees with forward slashes, while # str(Path(worktree)) renders them with backslashes on Windows. Scanning # must match both spellings instead of silently returning zero sessions. db_path = tmp_path / "opencode-v2-windows.db" _create_opencode_db_v2( db_path, Path("C:/Users/runner/project"), project_name="WindowsProject", worktree="C:/Users/runner/project", ) plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 # Simulate discovery on Windows: Path() renders the stored worktree with # native separators (and may normalize the drive-letter case). projects[0].project_path = Path(r"c:\users\runner\project") sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 assert [call.tool_call_id for call in sessions[0].tool_calls] == [ "call-v2-1", "call-v2-2", ] assert sessions[0].tool_calls[1].is_error is True def test_opencode_plugin_v2_null_project_name_falls_back_to_worktree( tmp_path: Path, ) -> None: # Current opencode releases leave project.name NULL; discovery must fall # back to the worktree basename instead of crashing or emitting an empty name. project_path = tmp_path / "fallback-repo" project_path.mkdir() db_path = tmp_path / "opencode-v2-null.db" _create_opencode_db_v2(db_path, project_path, project_name=None) plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "fallback-repo" assert projects[0].context_file is None sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 def test_opencode_plugin_v2_missing_name_column_still_discovers( tmp_path: Path, ) -> None: # Very old databases lack project.name entirely; discovery must use the # missing-column fallback instead of raising OperationalError. project_path = tmp_path / "nocol-repo" project_path.mkdir() db_path = tmp_path / "opencode-v2-nocol.db" conn = sqlite3.connect(db_path) try: conn.executescript( """ CREATE TABLE project (id TEXT PRIMARY KEY, worktree TEXT NOT NULL); CREATE TABLE session_v2 ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, time_created INTEGER NOT NULL ); """ ) conn.execute( "INSERT INTO project (id, worktree) VALUES (?, ?)", ("project-nocol", str(project_path)), ) conn.execute( "INSERT INTO session_v2 (id, project_id, time_created) VALUES (?, ?, ?)", ("session-nocol", "project-nocol", 1_700_000_000_000), ) conn.commit() finally: conn.close() plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 assert projects[0].name == "nocol-repo" def test_opencode_plugin_v2_failure_keeps_error_message_alongside_content( tmp_path: Path, ) -> None: # A failed tool carrying both progress output and error details must keep # the error text so classification sees the failure, not just the output. project_path = tmp_path / "repo-v2-mixed" project_path.mkdir() db_path = tmp_path / "opencode-v2-mixed.db" conn = sqlite3.connect(db_path) try: conn.executescript( """ CREATE TABLE project (id TEXT PRIMARY KEY, worktree TEXT NOT NULL, name TEXT); CREATE TABLE session_v2 ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, time_created INTEGER NOT NULL ); CREATE TABLE session_message ( id TEXT PRIMARY KEY, session_id TEXT NOT NULL, type TEXT NOT NULL, seq INTEGER NOT NULL, time_created INTEGER NOT NULL, time_updated INTEGER NOT NULL, data TEXT NOT NULL ); """ ) conn.execute( "INSERT INTO project (id, worktree, name) VALUES (?, ?, ?)", ("project-mixed", str(project_path), "Mixed"), ) conn.execute( "INSERT INTO session_v2 (id, project_id, time_created) VALUES (?, ?, ?)", ("session-mixed", "project-mixed", 1_700_000_000_000), ) conn.execute( "INSERT INTO session_message (id, session_id, type, seq, time_created, time_updated, data)" " VALUES (?, ?, ?, ?, ?, ?, ?)", ( "message-mixed-1", "session-mixed", "assistant", 5, 1_700_000_000_001, 1_700_000_000_002, json.dumps( { "content": [ { "type": "tool", "id": "call-mixed-1", "name": "bash", "state": { "status": "error", "input": {"command": "pytest"}, "content": [{"type": "text", "text": "starting tests"}], "error": { "type": "tool.execution", "message": "ENOENT: missing fixture", }, }, } ] }, separators=(",", ":"), ), ), ) conn.commit() finally: conn.close() plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 call = sessions[0].tool_calls[0] assert call.is_error is True assert "starting tests" in call.output assert "ENOENT: missing fixture" in call.output assert call.error_category == ErrorCategory.FILE_NOT_FOUND def test_opencode_plugin_v2_skips_non_dict_message_data( tmp_path: Path, ) -> None: # Stored "null"/"[]" payloads parse to non-dicts; they must be skipped, # not abort the session scan. project_path = tmp_path / "repo-v2-nulldata" project_path.mkdir() db_path = tmp_path / "opencode-v2-nulldata.db" _create_opencode_db_v2(db_path, project_path, project_name="NullData") conn = sqlite3.connect(db_path) try: for msg_id, payload in (("junk-1", "null"), ("junk-2", "[]")): conn.execute( "INSERT INTO session_message (id, session_id, type, seq, time_created, time_updated, data)" " VALUES (?, ?, ?, ?, ?, ?, ?)", ( msg_id, "session-v2", "assistant", 1, 1_700_000_000_000, 1_700_000_000_000, payload, ), ) conn.commit() finally: conn.close() plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 assert len(sessions[0].tool_calls) == 2 def test_opencode_plugin_mixed_schema_falls_back_to_legacy_tables( tmp_path: Path, ) -> None: # A partially migrated database can hold a v2 session whose tool calls # still live in the legacy part/message tables; the scanner must fall # back instead of reporting the session empty. project_path = tmp_path / "repo-mixed-schema" project_path.mkdir() db_path = tmp_path / "opencode-mixed-schema.db" conn = sqlite3.connect(db_path) try: conn.executescript( """ CREATE TABLE project (id TEXT PRIMARY KEY, worktree TEXT NOT NULL, name TEXT); CREATE TABLE session_v2 ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, time_created INTEGER NOT NULL ); CREATE TABLE session_message ( id TEXT PRIMARY KEY, session_id TEXT NOT NULL, type TEXT NOT NULL, seq INTEGER NOT NULL, time_created INTEGER NOT NULL, time_updated INTEGER NOT NULL, data TEXT NOT NULL ); CREATE TABLE message (id TEXT PRIMARY KEY, session_id TEXT); CREATE TABLE part ( id TEXT PRIMARY KEY, message_id TEXT, data TEXT, time_created INTEGER ); """ ) conn.execute( "INSERT INTO project (id, worktree, name) VALUES (?, ?, ?)", ("project-ms", str(project_path), "MixedSchema"), ) conn.execute( "INSERT INTO session_v2 (id, project_id, time_created) VALUES (?, ?, ?)", ("session-ms", "project-ms", 1_700_000_000_000), ) conn.execute( "INSERT INTO message (id, session_id) VALUES (?, ?)", ("message-ms-1", "session-ms"), ) conn.execute( "INSERT INTO part (id, message_id, data, time_created) VALUES (?, ?, ?, ?)", ( "part-ms-1", "message-ms-1", json.dumps( { "type": "tool", "tool": "bash", "callID": "call-ms-1", "state": { "status": "error", "input": {"command": "pytest"}, "output": "Error: command failed with exit code 1", }, } ), 1_700_000_000_001, ), ) conn.commit() finally: conn.close() plugin = OpenCodePlugin(db_path=db_path) projects = plugin.discover_projects() assert len(projects) == 1 sessions = plugin.scan_project(projects[0]) assert len(sessions) == 1 assert sessions[0].tool_calls[0].tool_call_id == "call-ms-1" assert sessions[0].tool_calls[0].is_error is True