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 { NonNegativeInt } from "@akeru/contracts";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";
import * as Option from "effect/Option";
import * as Schema from "effect/Schema";
import * as Struct from "effect/Struct";
import { toPersistenceDecodeError, toPersistenceSqlError } from "../Errors.ts";
import {
DeleteProjectionThreadActivitiesInput,
GetLatestProjectionThreadTaskActivityInput,
ListProjectionThreadActivitiesInput,
ListProjectionThreadUserInputLifecycleInput,
ProjectionThreadActivity,
ProjectionThreadActivityRepository,
type ProjectionThreadActivityRepositoryShape,
} from "../Services/ProjectionThreadActivities.ts";
const ProjectionThreadActivityDbRowSchema = ProjectionThreadActivity.mapFields(
Struct.assign({
payload: Schema.fromJsonString(Schema.Unknown),
sequence: Schema.NullOr(NonNegativeInt),
}),
);
function toProjectionThreadActivity(
row: Schema.Schema.Type<typeof ProjectionThreadActivityDbRowSchema>,
): ProjectionThreadActivity {
return {
activityId: row.activityId,
threadId: row.threadId,
turnId: row.turnId,
tone: row.tone,
kind: row.kind,
summary: row.summary,
payload: row.payload,
...(row.sequence !== null ? { sequence: row.sequence } : {}),
createdAt: row.createdAt,
};
}
function toPersistenceSqlOrDecodeError(sqlOperation: string, decodeOperation: string) {
return (cause: unknown) =>
Schema.isSchemaError(cause)
? toPersistenceDecodeError(decodeOperation)(cause)
: toPersistenceSqlError(sqlOperation)(cause);
}
// Match String.trim so blank saved titles cannot hide an earlier task name.
const taskTitleWhitespace =
"\u0009\u000a\u000b\u000c\u000d\u0020\u00a0\u1680\u2000\u2001\u2002\u2003\u2004\u2005\u2006\u2007\u2008\u2009\u200a\u2028\u2029\u202f\u205f\u3000\ufeff";
const makeProjectionThreadActivityRepository = Effect.gen(function* () {
const sql = yield* SqlClient.SqlClient;
const upsertProjectionThreadActivityRow = SqlSchema.void({
Request: ProjectionThreadActivity,
execute: (row) =>
sql`
INSERT INTO projection_thread_activities (
activity_id,
thread_id,
turn_id,
tone,
kind,
summary,
payload_json,
sequence,
created_at
)
VALUES (
${row.activityId},
${row.threadId},
${row.turnId},
${row.tone},
${row.kind},
${row.summary},
${JSON.stringify(row.payload)},
${row.sequence ?? null},
${row.createdAt}
)
ON CONFLICT (activity_id)
DO UPDATE SET
thread_id = excluded.thread_id,
turn_id = excluded.turn_id,
tone = excluded.tone,
kind = excluded.kind,
summary = excluded.summary,
payload_json = excluded.payload_json,
sequence = excluded.sequence,
created_at = excluded.created_at
`,
});
const listProjectionThreadActivityRows = SqlSchema.findAll({
Request: ListProjectionThreadActivitiesInput,
Result: ProjectionThreadActivityDbRowSchema,
execute: ({ threadId, activityKinds, limit }) =>
sql`
SELECT
activity_id AS "activityId",
thread_id AS "threadId",
turn_id AS "turnId",
tone,
kind,
summary,
payload_json AS "payload",
sequence,
created_at AS "createdAt"
FROM (
SELECT *
FROM projection_thread_activities
WHERE thread_id = ${threadId}
${activityKinds === undefined ? sql`` : sql`AND ${sql.in("kind", activityKinds)}`}
ORDER BY sequence DESC, created_at DESC, activity_id DESC
${limit === undefined ? sql`` : sql`LIMIT ${limit}`}
) AS recent_activities
ORDER BY
CASE WHEN sequence IS NULL THEN 0 ELSE 1 END ASC,
sequence ASC,
created_at ASC,
activity_id ASC
`,
});
const listUserInputLifecycleActivityRows = SqlSchema.findAll({
Request: ListProjectionThreadActivitiesInput,
Result: ProjectionThreadActivityDbRowSchema,
execute: ({ threadId }) =>
sql`
SELECT
activity_id AS "activityId",
thread_id AS "threadId",
turn_id AS "turnId",
tone,
kind,
summary,
payload_json AS "payload",
sequence,
created_at AS "createdAt"
FROM projection_thread_activities
WHERE thread_id = ${threadId}
AND kind IN (
'user-input.requested',
'user-input.resolved',
'provider.user-input.respond.failed'
)
ORDER BY
CASE WHEN sequence IS NULL THEN 0 ELSE 1 END ASC,
sequence ASC,
created_at ASC,
activity_id ASC
`,
});
const listUserInputLifecycleActivityRowsForTurn = SqlSchema.findAll({
Request: ListProjectionThreadUserInputLifecycleInput,
Result: ProjectionThreadActivityDbRowSchema,
execute: ({ threadId, turnId }) =>
sql`
SELECT
activity_id AS "activityId",
thread_id AS "threadId",
turn_id AS "turnId",
tone,
kind,
summary,
payload_json AS "payload",
sequence,
created_at AS "createdAt"
FROM projection_thread_activities
WHERE thread_id = ${threadId}
AND turn_id = ${turnId}
AND kind IN (
'user-input.requested',
'user-input.resolved',
'provider.user-input.respond.failed'
)
ORDER BY sequence ASC, created_at ASC, activity_id ASC
`,
});
const getLatestProjectionThreadTaskActivityRow = SqlSchema.findOneOption({
Request: GetLatestProjectionThreadTaskActivityInput,
Result: ProjectionThreadActivityDbRowSchema,
execute: ({ threadId, taskId }) =>
sql`
SELECT
activity_id AS "activityId",
thread_id AS "threadId",
turn_id AS "turnId",
tone,
kind,
summary,
payload_json AS "payload",
sequence,
created_at AS "createdAt"
FROM projection_thread_activities
WHERE thread_id = ${threadId}
AND kind IN ('task.started', 'task.progress')
AND json_extract(payload_json, '$.taskId') = ${taskId}
AND length(trim(
CASE
WHEN json_type(payload_json, '$.title') = 'text'
THEN json_extract(payload_json, '$.title')
WHEN kind = 'task.started' AND json_type(payload_json, '$.detail') = 'text'
THEN json_extract(payload_json, '$.detail')
ELSE ''
END,
${taskTitleWhitespace}
)) > 0
ORDER BY sequence DESC, created_at DESC, activity_id DESC
LIMIT 1
`,
});
const deleteProjectionThreadActivityRows = SqlSchema.void({
Request: DeleteProjectionThreadActivitiesInput,
execute: ({ threadId }) =>
sql`
DELETE FROM projection_thread_activities
WHERE thread_id = ${threadId}
`,
});
const upsert: ProjectionThreadActivityRepositoryShape["upsert"] = (row) =>
upsertProjectionThreadActivityRow(row).pipe(
Effect.mapError(
toPersistenceSqlOrDecodeError(
"ProjectionThreadActivityRepository.upsert:query",
"ProjectionThreadActivityRepository.upsert:encodeRequest",
),
),
);
const listByThreadId: ProjectionThreadActivityRepositoryShape["listByThreadId"] = (input) =>
listProjectionThreadActivityRows(input).pipe(
Effect.mapError(
toPersistenceSqlOrDecodeError(
"ProjectionThreadActivityRepository.listByThreadId:query",
"ProjectionThreadActivityRepository.listByThreadId:decodeRows",
),
),
Effect.map((rows) => rows.map(toProjectionThreadActivity)),
);
const listUserInputLifecycleByThreadId: ProjectionThreadActivityRepositoryShape["listUserInputLifecycleByThreadId"] =
(input) =>
listUserInputLifecycleActivityRows(input).pipe(
Effect.mapError(
toPersistenceSqlOrDecodeError(
"ProjectionThreadActivityRepository.listUserInputLifecycleByThreadId:query",
"ProjectionThreadActivityRepository.listUserInputLifecycleByThreadId:decodeRows",
),
),
Effect.map((rows) => rows.map(toProjectionThreadActivity)),
);
const listUserInputLifecycleByThreadAndTurn: ProjectionThreadActivityRepositoryShape["listUserInputLifecycleByThreadAndTurn"] =
(input) =>
listUserInputLifecycleActivityRowsForTurn(input).pipe(
Effect.mapError(
toPersistenceSqlOrDecodeError(
"ProjectionThreadActivityRepository.listUserInputLifecycleByThreadAndTurn:query",
"ProjectionThreadActivityRepository.listUserInputLifecycleByThreadAndTurn:decodeRows",
),
),
Effect.map((rows) => rows.map(toProjectionThreadActivity)),
);
const getLatestTaskActivity: ProjectionThreadActivityRepositoryShape["getLatestTaskActivity"] = (
input,
) =>
getLatestProjectionThreadTaskActivityRow(input).pipe(
Effect.mapError(
toPersistenceSqlOrDecodeError(
"ProjectionThreadActivityRepository.getLatestTaskActivity:query",
"ProjectionThreadActivityRepository.getLatestTaskActivity:decodeRow",
),
),
Effect.map(Option.map(toProjectionThreadActivity)),
);
const deleteByThreadId: ProjectionThreadActivityRepositoryShape["deleteByThreadId"] = (input) =>
deleteProjectionThreadActivityRows(input).pipe(
Effect.mapError(
toPersistenceSqlError("ProjectionThreadActivityRepository.deleteByThreadId:query"),
),
);
return {
upsert,
listByThreadId,
listUserInputLifecycleByThreadId,
listUserInputLifecycleByThreadAndTurn,
getLatestTaskActivity,
deleteByThreadId,
} satisfies ProjectionThreadActivityRepositoryShape;
});
export const ProjectionThreadActivityRepositoryLive = Layer.effect(
ProjectionThreadActivityRepository,
makeProjectionThreadActivityRepository,
);