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 SqlClient from "effect/unstable/sql/SqlClient";
import * as SqlSchema from "effect/unstable/sql/SqlSchema";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";
import * as Schema from "effect/Schema";
import * as Struct from "effect/Struct";
import { McpServerId } from "@akeru/contracts";
import { toPersistenceSqlError } from "../Errors.ts";
import {
ProjectionThreadSession,
ProjectionThreadSessionRepository,
type ProjectionThreadSessionRepositoryShape,
DeleteProjectionThreadSessionInput,
GetProjectionThreadSessionInput,
} from "../Services/ProjectionThreadSessions.ts";
const ProjectionThreadSessionDbRow = ProjectionThreadSession.mapFields(
Struct.assign({
mcpServerIds: Schema.fromJsonString(Schema.Array(McpServerId)),
}),
);
const makeProjectionThreadSessionRepository = Effect.gen(function* () {
const sql = yield* SqlClient.SqlClient;
const upsertProjectionThreadSessionRow = SqlSchema.void({
Request: ProjectionThreadSession,
execute: (row) =>
sql`
INSERT INTO projection_thread_sessions (
thread_id,
status,
provider_name,
provider_instance_id,
runtime_mode,
mcp_server_ids_json,
active_turn_id,
last_error,
updated_at
)
VALUES (
${row.threadId},
${row.status},
${row.providerName},
${row.providerInstanceId},
${row.runtimeMode},
${JSON.stringify(row.mcpServerIds)},
${row.activeTurnId},
${row.lastError},
${row.updatedAt}
)
ON CONFLICT (thread_id)
DO UPDATE SET
status = excluded.status,
provider_name = excluded.provider_name,
provider_instance_id = excluded.provider_instance_id,
runtime_mode = excluded.runtime_mode,
mcp_server_ids_json = excluded.mcp_server_ids_json,
active_turn_id = excluded.active_turn_id,
last_error = excluded.last_error,
updated_at = excluded.updated_at
`,
});
const getProjectionThreadSessionRow = SqlSchema.findOneOption({
Request: GetProjectionThreadSessionInput,
Result: ProjectionThreadSessionDbRow,
execute: ({ threadId }) =>
sql`
SELECT
thread_id AS "threadId",
status,
provider_name AS "providerName",
provider_instance_id AS "providerInstanceId",
runtime_mode AS "runtimeMode",
mcp_server_ids_json AS "mcpServerIds",
active_turn_id AS "activeTurnId",
last_error AS "lastError",
updated_at AS "updatedAt"
FROM projection_thread_sessions
WHERE thread_id = ${threadId}
`,
});
const deleteProjectionThreadSessionRow = SqlSchema.void({
Request: DeleteProjectionThreadSessionInput,
execute: ({ threadId }) =>
sql`
DELETE FROM projection_thread_sessions
WHERE thread_id = ${threadId}
`,
});
const upsert: ProjectionThreadSessionRepositoryShape["upsert"] = (row) =>
upsertProjectionThreadSessionRow(row).pipe(
Effect.mapError(toPersistenceSqlError("ProjectionThreadSessionRepository.upsert:query")),
);
const getByThreadId: ProjectionThreadSessionRepositoryShape["getByThreadId"] = (input) =>
getProjectionThreadSessionRow(input).pipe(
Effect.mapError(
toPersistenceSqlError("ProjectionThreadSessionRepository.getByThreadId:query"),
),
);
const deleteByThreadId: ProjectionThreadSessionRepositoryShape["deleteByThreadId"] = (input) =>
deleteProjectionThreadSessionRow(input).pipe(
Effect.mapError(
toPersistenceSqlError("ProjectionThreadSessionRepository.deleteByThreadId:query"),
),
);
return {
upsert,
getByThreadId,
deleteByThreadId,
} satisfies ProjectionThreadSessionRepositoryShape;
});
export const ProjectionThreadSessionRepositoryLive = Layer.effect(
ProjectionThreadSessionRepository,
makeProjectionThreadSessionRepository,
);