Open-source Grok Bot alternative for named AI teammates. Local-first desktop, web, and mobile clients with per-bot tools, instructions, and memory. Independent fork of T3 Code.
import * as Predicate from "effect/Predicate";
import { projectionSnapshotLayer } from "./test-support/ProjectionSnapshotHarness.ts";
import { ThreadId } from "@akeru/contracts";
import { assert } from "@effect/vitest";
import * as Effect from "effect/Effect";
import * as SqlClient from "effect/unstable/sql/SqlClient";
import { ORCHESTRATION_PROJECTOR_NAMES } from "./ProjectionPipeline.ts";
import { ProjectionSnapshotQuery } from "../Services/ProjectionSnapshotQuery.ts";
import { asProjectId, asTurnId, asMessageId } from "./test-support/ProjectionSnapshotHarness.ts";
projectionSnapshotLayer("ProjectionSnapshotQuery", (it) => {
it.effect(
"reads targeted project, thread, and count queries without hydrating the full snapshot",
() =>
Effect.gen(function* () {
const snapshotQuery = yield* ProjectionSnapshotQuery;
const sql = yield* SqlClient.SqlClient;
yield* sql`DELETE FROM projection_projects`;
yield* sql`DELETE FROM projection_threads`;
yield* sql`DELETE FROM projection_turns`;
yield* sql`DELETE FROM orchestration_events`;
yield* sql`
INSERT INTO orchestration_events (
event_id,
aggregate_kind,
stream_id,
stream_version,
event_type,
occurred_at,
actor_kind,
payload_json,
metadata_json
)
VALUES
(
'event-project-deleted-created',
'project',
'project-deleted',
1,
'project.created',
'2026-02-28T00:00:00.000Z',
'user',
'{"projectId":"project-deleted","workspaceRoot":"/tmp/workspace"}',
'{}'
),
(
'event-project-deleted-moved',
'project',
'project-deleted',
2,
'project.meta-updated',
'2026-02-28T00:00:01.000Z',
'user',
'{"projectId":"project-deleted","workspaceRoot":"/tmp/moved"}',
'{}'
),
(
'event-project-active-created',
'project',
'project-active',
1,
'project.created',
'2026-03-01T00:00:00.000Z',
'user',
'{"projectId":"project-active","workspaceRoot":"/tmp/workspace"}',
'{}'
)
`;
yield* sql`
INSERT INTO projection_projects (
project_id,
title,
workspace_root,
default_model_selection_json,
scripts_json,
created_at,
updated_at,
deleted_at
)
VALUES
(
'project-active',
'Active Project',
'/tmp/workspace',
'{"provider":"codex","model":"gpt-5-codex"}',
'[]',
'2026-03-01T00:00:00.000Z',
'2026-03-01T00:00:01.000Z',
NULL
),
(
'project-deleted',
'Deleted Project',
'/tmp/moved',
NULL,
'[]',
'2026-02-28T00:00:00.000Z',
'2026-02-28T00:00:01.000Z',
'2026-02-28T00:00:02.000Z'
)
`;
yield* sql`
INSERT INTO projection_threads (
thread_id,
project_id,
title,
model_selection_json,
runtime_mode,
interaction_mode,
branch,
worktree_path,
latest_turn_id,
created_at,
updated_at,
archived_at,
deleted_at
)
VALUES
(
'thread-first',
'project-active',
'First Thread',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
NULL,
'2026-03-01T00:00:05.000Z',
'2026-03-01T00:00:06.000Z',
NULL,
NULL
),
(
'thread-second',
'project-active',
'Second Thread',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
NULL,
'2026-03-01T00:00:07.000Z',
'2026-03-01T00:00:08.000Z',
NULL,
NULL
),
(
'thread-deleted',
'project-active',
'Deleted Thread',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
NULL,
'2026-03-01T00:00:09.000Z',
'2026-03-01T00:00:10.000Z',
NULL,
'2026-03-01T00:00:11.000Z'
)
`;
const counts = yield* snapshotQuery.getCounts();
assert.deepEqual(counts, {
projectCount: 2,
threadCount: 3,
});
const project = yield* snapshotQuery.getActiveProjectByWorkspaceRoot("/tmp/workspace");
assert.equal(project._tag, "Some");
if (Predicate.isTagged(project, "Some")) {
assert.equal(project.value.id, asProjectId("project-active"));
}
const originalProjectId =
yield* snapshotQuery.getOriginalProjectIdByWorkspaceRoot("/tmp/workspace");
assert.equal(originalProjectId._tag, "Some");
if (Predicate.isTagged(originalProjectId, "Some")) {
assert.equal(originalProjectId.value, asProjectId("project-deleted"));
}
const missingProject = yield* snapshotQuery.getActiveProjectByWorkspaceRoot("/tmp/missing");
assert.equal(missingProject._tag, "None");
const missingOriginalProjectId =
yield* snapshotQuery.getOriginalProjectIdByWorkspaceRoot("/tmp/missing");
assert.equal(missingOriginalProjectId._tag, "None");
const firstThreadId = yield* snapshotQuery.getFirstActiveThreadIdByProjectId(
asProjectId("project-active"),
);
assert.equal(firstThreadId._tag, "Some");
if (Predicate.isTagged(firstThreadId, "Some")) {
assert.equal(firstThreadId.value, ThreadId.make("thread-first"));
}
}),
);
it.effect("uses projection_threads.latest_turn_id for bulk command and shell snapshots", () =>
Effect.gen(function* () {
const snapshotQuery = yield* ProjectionSnapshotQuery;
const sql = yield* SqlClient.SqlClient;
yield* sql`DELETE FROM projection_projects`;
yield* sql`DELETE FROM projection_threads`;
yield* sql`DELETE FROM projection_turns`;
yield* sql`DELETE FROM projection_state`;
yield* sql`
INSERT INTO projection_projects (
project_id,
title,
workspace_root,
default_model_selection_json,
scripts_json,
created_at,
updated_at,
deleted_at
)
VALUES (
'project-1',
'Project 1',
'/tmp/project-1',
'{"provider":"codex","model":"gpt-5-codex"}',
'[]',
'2026-04-03T00:00:00.000Z',
'2026-04-03T00:00:01.000Z',
NULL
)
`;
yield* sql`
INSERT INTO projection_threads (
thread_id,
project_id,
title,
model_selection_json,
runtime_mode,
interaction_mode,
branch,
worktree_path,
latest_turn_id,
latest_user_message_at,
pending_approval_count,
pending_user_input_count,
has_actionable_proposed_plan,
created_at,
updated_at,
archived_at,
deleted_at
)
VALUES (
'thread-1',
'project-1',
'Thread 1',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
'turn-running',
'2026-04-03T00:00:04.000Z',
0,
0,
0,
'2026-04-03T00:00:02.000Z',
'2026-04-03T00:00:03.000Z',
NULL,
NULL
)
`;
yield* sql`
INSERT INTO projection_turns (
thread_id,
turn_id,
pending_message_id,
source_proposed_plan_thread_id,
source_proposed_plan_id,
assistant_message_id,
state,
requested_at,
started_at,
completed_at,
checkpoint_turn_count,
checkpoint_ref,
checkpoint_status,
checkpoint_files_json
)
VALUES
(
'thread-1',
'turn-running',
'message-user-2',
NULL,
NULL,
NULL,
'running',
'2026-04-03T00:00:30.000Z',
'2026-04-03T00:00:30.000Z',
NULL,
NULL,
NULL,
NULL,
'[]'
),
(
'thread-1',
'turn-completed',
'message-user-1',
NULL,
NULL,
'message-assistant-1',
'completed',
'2026-04-03T00:00:05.000Z',
'2026-04-03T00:00:06.000Z',
'2026-04-03T00:00:20.000Z',
NULL,
NULL,
NULL,
'[]'
)
`;
yield* sql`
INSERT INTO projection_state (projector, last_applied_sequence, updated_at)
VALUES
(${ORCHESTRATION_PROJECTOR_NAMES.projects}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.mcpServers}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.threads}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.threadMessages}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.threadProposedPlans}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.threadActivities}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.threadSessions}, 3, '2026-04-03T00:00:40.000Z'),
(${ORCHESTRATION_PROJECTOR_NAMES.checkpoints}, 3, '2026-04-03T00:00:40.000Z')
`;
const commandReadModel = yield* snapshotQuery.getCommandReadModel();
assert.equal(commandReadModel.threads[0]?.latestTurn?.turnId, asTurnId("turn-running"));
assert.equal(commandReadModel.threads[0]?.latestTurn?.state, "running");
assert.equal(
commandReadModel.threads[0]?.latestTurn?.requestMessageId,
asMessageId("message-user-2"),
);
const shellSnapshot = yield* snapshotQuery.getShellSnapshot();
assert.equal(shellSnapshot.threads[0]?.latestTurn?.turnId, asTurnId("turn-running"));
assert.equal(shellSnapshot.threads[0]?.latestTurn?.state, "running");
assert.equal(
shellSnapshot.threads[0]?.latestTurn?.requestMessageId,
asMessageId("message-user-2"),
);
const fullSnapshot = yield* snapshotQuery.getSnapshot();
assert.equal(fullSnapshot.threads[0]?.latestTurn?.turnId, asTurnId("turn-running"));
assert.equal(fullSnapshot.threads[0]?.latestTurn?.state, "running");
assert.equal(
fullSnapshot.threads[0]?.latestTurn?.requestMessageId,
asMessageId("message-user-2"),
);
}),
);
it.effect("keeps deleted project and thread tombstones in the command read model", () =>
Effect.gen(function* () {
const snapshotQuery = yield* ProjectionSnapshotQuery;
const sql = yield* SqlClient.SqlClient;
yield* sql`DELETE FROM projection_projects`;
yield* sql`DELETE FROM projection_threads`;
yield* sql`DELETE FROM projection_turns`;
yield* sql`DELETE FROM projection_state`;
yield* sql`
INSERT INTO projection_projects (
project_id,
title,
workspace_root,
default_model_selection_json,
scripts_json,
created_at,
updated_at,
deleted_at
)
VALUES (
'project-deleted',
'Deleted Project',
'/tmp/deleted-project',
'{"provider":"codex","model":"gpt-5-codex"}',
'[]',
'2026-04-05T00:00:00.000Z',
'2026-04-05T00:00:01.000Z',
'2026-04-05T00:00:02.000Z'
)
`;
yield* sql`
INSERT INTO projection_threads (
thread_id,
project_id,
title,
model_selection_json,
runtime_mode,
interaction_mode,
branch,
worktree_path,
latest_turn_id,
latest_user_message_at,
pending_approval_count,
pending_user_input_count,
has_actionable_proposed_plan,
created_at,
updated_at,
archived_at,
deleted_at
)
VALUES (
'thread-deleted',
'project-deleted',
'Deleted Thread',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
'turn-deleted',
NULL,
0,
0,
0,
'2026-04-05T00:00:03.000Z',
'2026-04-05T00:00:04.000Z',
NULL,
'2026-04-05T00:00:05.000Z'
)
`;
yield* sql`
INSERT INTO projection_turns (
thread_id,
turn_id,
pending_message_id,
source_proposed_plan_thread_id,
source_proposed_plan_id,
assistant_message_id,
state,
requested_at,
started_at,
completed_at,
checkpoint_turn_count,
checkpoint_ref,
checkpoint_status,
checkpoint_files_json
)
VALUES (
'thread-deleted',
'turn-deleted',
'message-deleted-user',
NULL,
NULL,
'message-deleted-assistant',
'completed',
'2026-04-05T00:00:04.100Z',
'2026-04-05T00:00:04.200Z',
'2026-04-05T00:00:04.300Z',
NULL,
NULL,
NULL,
'[]'
)
`;
const commandReadModel = yield* snapshotQuery.getCommandReadModel();
assert.equal(commandReadModel.projects[0]?.id, asProjectId("project-deleted"));
assert.equal(commandReadModel.projects[0]?.deletedAt, "2026-04-05T00:00:02.000Z");
assert.equal(commandReadModel.threads[0]?.id, ThreadId.make("thread-deleted"));
assert.equal(commandReadModel.threads[0]?.deletedAt, "2026-04-05T00:00:05.000Z");
assert.equal(commandReadModel.threads[0]?.latestTurn?.turnId, asTurnId("turn-deleted"));
assert.equal(commandReadModel.threads[0]?.latestTurn?.state, "completed");
const fullSnapshot = yield* snapshotQuery.getSnapshot();
assert.equal(fullSnapshot.threads[0]?.id, ThreadId.make("thread-deleted"));
assert.equal(fullSnapshot.threads[0]?.latestTurn?.turnId, asTurnId("turn-deleted"));
assert.equal(fullSnapshot.threads[0]?.latestTurn?.state, "completed");
const shellSnapshot = yield* snapshotQuery.getShellSnapshot();
assert.equal(shellSnapshot.projects.length, 0);
assert.equal(shellSnapshot.threads.length, 0);
}),
);
});