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 { AuthSessionId, MessageId, ThreadId, ProviderInstanceId } 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,
asEventId,
asCheckpointRef,
projectionSnapshotLayer,
} from "./test-support/ProjectionSnapshotHarness.ts";
projectionSnapshotLayer("ProjectionSnapshotQuery", (it) => {
it.effect("hydrates read model from projection tables and computes snapshot sequence", () =>
Effect.gen(function* () {
const snapshotQuery = yield* ProjectionSnapshotQuery;
const sql = yield* SqlClient.SqlClient;
yield* sql`DELETE FROM projection_projects`;
yield* sql`DELETE FROM projection_state`;
yield* sql`DELETE FROM projection_thread_proposed_plans`;
yield* sql`DELETE FROM projection_turns`;
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"}',
'[{"id":"script-1","name":"Build","command":"bun run build","icon":"build","runOnWorktreeCreate":false}]',
'2026-02-24T00:00:00.000Z',
'2026-02-24T00: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,
linked_pull_request_json,
latest_turn_id,
latest_user_message_at,
pending_approval_count,
pending_user_input_count,
has_actionable_proposed_plan,
pinned_at,
pin_order_key,
created_at,
updated_at,
deleted_at
)
VALUES (
'thread-1',
'project-1',
'Thread 1',
'{"provider":"codex","model":"gpt-5-codex"}',
'full-access',
'default',
NULL,
NULL,
'{"projectId":"project-1","repository":"pingdotgg/t3code","number":42,"url":"https://github.com/pingdotgg/t3code/pull/42"}',
'turn-1',
'2026-02-24T00:00:04.000Z',
1,
0,
0,
'2026-02-24T00:00:01.000Z',
'gm',
'2026-02-24T00:00:02.000Z',
'2026-02-24T00:00:03.000Z',
NULL
)
`;
yield* sql`
INSERT INTO projection_thread_messages (
message_id,
thread_id,
turn_id,
role,
text,
author_person_id,
author_display_name,
is_streaming,
created_at,
updated_at
)
VALUES (
'message-1',
'thread-1',
'turn-1',
'assistant',
'hello from projection',
'person-1',
'Leo',
0,
'2026-02-24T00:00:04.000Z',
'2026-02-24T00:00:05.000Z'
)
`;
yield* sql`
INSERT INTO projection_thread_proposed_plans (
plan_id,
thread_id,
turn_id,
plan_markdown,
implemented_at,
implementation_thread_id,
created_at,
updated_at
)
VALUES (
'plan-1',
'thread-1',
'turn-1',
'# Ship it',
'2026-02-24T00:00:05.500Z',
'thread-2',
'2026-02-24T00:00:05.000Z',
'2026-02-24T00:00:05.500Z'
)
`;
yield* sql`
INSERT INTO projection_thread_activities (
activity_id,
thread_id,
turn_id,
tone,
kind,
summary,
payload_json,
created_at
)
VALUES (
'activity-1',
'thread-1',
'turn-1',
'info',
'runtime.note',
'provider started',
'{"stage":"start"}',
'2026-02-24T00:00:06.000Z'
)
`;
yield* sql`
INSERT INTO projection_thread_sessions (
thread_id,
status,
provider_name,
provider_session_id,
provider_thread_id,
runtime_mode,
active_turn_id,
last_error,
updated_at
)
VALUES (
'thread-1',
'running',
'codex',
'provider-session-1',
'provider-thread-1',
'approval-required',
'turn-1',
NULL,
'2026-02-24T00:00:07.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-1',
'turn-1',
'message-request-1',
'thread-1',
'plan-1',
'message-1',
'completed',
'2026-02-24T00:00:08.000Z',
'2026-02-24T00:00:08.000Z',
'2026-02-24T00:00:08.000Z',
1,
'checkpoint-1',
'ready',
'[{"path":"README.md","kind":"modified","additions":2,"deletions":1}]'
)
`;
let sequence = 5;
for (const projector of Object.values(ORCHESTRATION_PROJECTOR_NAMES)) {
yield* sql`
INSERT INTO projection_state (
projector,
last_applied_sequence,
updated_at
)
VALUES (
${projector},
${sequence},
'2026-02-24T00:00:09.000Z'
)
`;
sequence += 1;
}
const snapshot = yield* snapshotQuery.getSnapshot();
assert.equal(snapshot.snapshotSequence, 5);
assert.equal(snapshot.updatedAt, "2026-02-24T00:00:09.000Z");
assert.deepEqual(snapshot.projects, [
{
id: asProjectId("project-1"),
title: "Project 1",
workspaceRoot: "/tmp/project-1",
repositoryIdentity: null,
defaultModelSelection: {
instanceId: ProviderInstanceId.make("codex"),
model: "gpt-5-codex",
},
faviconPath: null,
scripts: [
{
id: "script-1",
name: "Build",
command: "bun run build",
icon: "build",
runOnWorktreeCreate: false,
},
],
defaultThreadEnvMode: null,
createdAt: "2026-02-24T00:00:00.000Z",
updatedAt: "2026-02-24T00:00:01.000Z",
deletedAt: null,
},
]);
assert.deepEqual(snapshot.threads, [
{
id: ThreadId.make("thread-1"),
projectId: asProjectId("project-1"),
botId: null,
groupId: null,
parentThreadId: null,
parentDelegationId: null,
respondingBotId: null,
title: "Thread 1",
modelSelection: {
instanceId: ProviderInstanceId.make("codex"),
model: "gpt-5-codex",
},
interactionMode: "default",
runtimeMode: "full-access",
branch: null,
worktreePath: null,
linkedPullRequest: {
projectId: asProjectId("project-1"),
repository: "pingdotgg/t3code",
number: 42,
url: "https://github.com/pingdotgg/t3code/pull/42",
},
latestTurn: {
turnId: asTurnId("turn-1"),
state: "completed",
requestedAt: "2026-02-24T00:00:08.000Z",
startedAt: "2026-02-24T00:00:08.000Z",
completedAt: "2026-02-24T00:00:08.000Z",
assistantMessageId: asMessageId("message-1"),
requestMessageId: asMessageId("message-request-1"),
respondingBotId: null,
sourceProposedPlan: {
threadId: ThreadId.make("thread-1"),
planId: "plan-1",
},
},
createdAt: "2026-02-24T00:00:02.000Z",
updatedAt: "2026-02-24T00:00:03.000Z",
archivedAt: null,
settledOverride: null,
settledAt: null,
unsettledAt: null,
snoozedUntil: null,
snoozedAt: null,
pinnedAt: "2026-02-24T00:00:01.000Z",
pinOrderKey: "gm",
titleRegeneration: null,
deletedAt: null,
messages: [
{
id: asMessageId("message-1"),
role: "assistant",
text: "hello from projection",
authorPersonId: AuthSessionId.make("person-1"),
authorDisplayName: "Leo",
turnId: asTurnId("turn-1"),
respondingBotId: null,
reactions: [],
streaming: false,
createdAt: "2026-02-24T00:00:04.000Z",
updatedAt: "2026-02-24T00:00:05.000Z",
},
],
proposedPlans: [
{
id: "plan-1",
turnId: asTurnId("turn-1"),
planMarkdown: "# Ship it",
implementedAt: "2026-02-24T00:00:05.500Z",
implementationThreadId: ThreadId.make("thread-2"),
createdAt: "2026-02-24T00:00:05.000Z",
updatedAt: "2026-02-24T00:00:05.500Z",
},
],
activities: [
{
id: asEventId("activity-1"),
tone: "info",
kind: "runtime.note",
summary: "provider started",
payload: { stage: "start" },
turnId: asTurnId("turn-1"),
createdAt: "2026-02-24T00:00:06.000Z",
},
],
checkpoints: [
{
turnId: asTurnId("turn-1"),
checkpointTurnCount: 1,
checkpointRef: asCheckpointRef("checkpoint-1"),
status: "ready",
files: [{ path: "README.md", kind: "modified", additions: 2, deletions: 1 }],
assistantMessageId: asMessageId("message-1"),
completedAt: "2026-02-24T00:00:08.000Z",
},
],
session: {
threadId: ThreadId.make("thread-1"),
status: "running",
providerName: "codex",
runtimeMode: "approval-required",
mcpServerIds: [],
activeTurnId: asTurnId("turn-1"),
lastError: null,
updatedAt: "2026-02-24T00:00:07.000Z",
},
},
]);
const shellSnapshot = yield* snapshotQuery.getShellSnapshot();
assert.equal(shellSnapshot.snapshotSequence, 5);
assert.deepEqual(shellSnapshot.projects, [
{
id: asProjectId("project-1"),
title: "Project 1",
workspaceRoot: "/tmp/project-1",
repositoryIdentity: null,
defaultModelSelection: {
instanceId: ProviderInstanceId.make("codex"),
model: "gpt-5-codex",
},
faviconPath: null,
scripts: [
{
id: "script-1",
name: "Build",
command: "bun run build",
icon: "build",
runOnWorktreeCreate: false,
},
],
defaultThreadEnvMode: null,
createdAt: "2026-02-24T00:00:00.000Z",
updatedAt: "2026-02-24T00:00:01.000Z",
},
]);
assert.deepEqual(shellSnapshot.threads, [
{
id: ThreadId.make("thread-1"),
projectId: asProjectId("project-1"),
botId: null,
groupId: null,
parentThreadId: null,
parentDelegationId: null,
respondingBotId: null,
title: "Thread 1",
modelSelection: {
instanceId: ProviderInstanceId.make("codex"),
model: "gpt-5-codex",
},
interactionMode: "default",
runtimeMode: "full-access",
branch: null,
worktreePath: null,
linkedPullRequest: {
projectId: asProjectId("project-1"),
repository: "pingdotgg/t3code",
number: 42,
url: "https://github.com/pingdotgg/t3code/pull/42",
},
latestTurn: {
turnId: asTurnId("turn-1"),
state: "completed",
requestedAt: "2026-02-24T00:00:08.000Z",
startedAt: "2026-02-24T00:00:08.000Z",
completedAt: "2026-02-24T00:00:08.000Z",
assistantMessageId: asMessageId("message-1"),
requestMessageId: asMessageId("message-request-1"),
respondingBotId: null,
sourceProposedPlan: {
threadId: ThreadId.make("thread-1"),
planId: "plan-1",
},
},
createdAt: "2026-02-24T00:00:02.000Z",
updatedAt: "2026-02-24T00:00:03.000Z",
archivedAt: null,
settledOverride: null,
settledAt: null,
unsettledAt: null,
snoozedUntil: null,
snoozedAt: null,
pinnedAt: "2026-02-24T00:00:01.000Z",
pinOrderKey: "gm",
titleRegeneration: null,
session: {
threadId: ThreadId.make("thread-1"),
status: "running",
providerName: "codex",
runtimeMode: "approval-required",
mcpServerIds: [],
activeTurnId: asTurnId("turn-1"),
lastError: null,
updatedAt: "2026-02-24T00:00:07.000Z",
},
latestUserMessageAt: "2026-02-24T00:00:04.000Z",
hasPendingApprovals: true,
hasPendingUserInput: false,
hasActionableProposedPlan: false,
backgroundLiveness: null,
planProgress: null,
},
]);
const threadDetail = yield* snapshotQuery.getThreadDetailById(ThreadId.make("thread-1"));
assert.equal(threadDetail._tag, "Some");
if (Predicate.isTagged(threadDetail, "Some")) {
assert.deepEqual(threadDetail.value, snapshot.threads[0]);
}
const turnStart = yield* snapshotQuery.getTurnStartMessage({
threadId: ThreadId.make("thread-1"),
messageId: MessageId.make("message-1"),
});
assert.equal(turnStart._tag, "Some");
if (Predicate.isTagged(turnStart, "Some")) {
assert.equal(turnStart.value.message.role, "assistant");
assert.equal(turnStart.value.message.text, "hello from projection");
assert.equal(turnStart.value.hasOtherUserMessages, false);
}
}),
);
it.effect("measures replay payload bytes without decoding event bodies", () =>
Effect.gen(function* () {
const snapshotQuery = yield* ProjectionSnapshotQuery;
const sql = yield* SqlClient.SqlClient;
yield* sql`DELETE FROM orchestration_events`;
const rows = yield* sql<{ readonly sequence: number }>`
INSERT INTO orchestration_events (
event_id, aggregate_kind, stream_id, stream_version, event_type, occurred_at,
command_id, causation_event_id, correlation_id, actor_kind, payload_json, metadata_json
)
VALUES
(
'replay-event-1', 'thread', 'thread-replay', 1, 'thread.activity-appended',
'2026-03-01T00:00:00.000Z', NULL, NULL, NULL, 'provider',
json_object('output', printf('%.*c', 1000, 'x')), '{}'
),
(
'replay-event-2', 'thread', 'thread-replay', 2, 'thread.activity-appended',
'2026-03-01T00:00:01.000Z', NULL, NULL, NULL, 'provider',
json_object('output', printf('%.*c', 2000, 'x')), '{}'
),
(
'replay-event-3', 'thread', 'thread-replay', 3, 'thread.activity-appended',
'2026-03-01T00:00:02.000Z', NULL, NULL, NULL, 'provider',
json_object('output', printf('%.*c', 3000, 'x')), '{}'
),
(
'replay-event-4', 'thread', 'thread-replay', 4, 'thread.activity-appended',
'2026-03-01T00:00:03.000Z', NULL, NULL, NULL, 'provider',
json_object('output', '😀'), '{}'
)
RETURNING sequence
`;
// Bytes, not code points: the 4-byte emoji row is {"output":"😀"}, 17 bytes.
// Shared-layer AUTOINCREMENT does not reset after DELETE, so bound the
// query to the inserted sequences rather than assuming 1..4.
const stats = yield* snapshotQuery.getEventReplayStats({
fromSequenceExclusive: rows[0]!.sequence,
toSequenceInclusive: rows[3]!.sequence,
});
assert.deepStrictEqual(stats, {
eventCount: 3,
payloadBytes: 5043,
});
}),
);
});