@devries-cameron20 / t3code Mirror · read-only
Fork 0

The best way to control Claude Code, Codex and more from any computer or phone

Mirrored from https://github.com/Camo67/t3code.git

Synced Nov 21, 04:45 UTC

main
ts 102 lines 3.72 KB
Raw
1 import * as Context from "effect/Context";
2 import * as Effect from "effect/Effect";
3 import * as Layer from "effect/Layer";
4 import * as Schema from "effect/Schema";
5 import * as SqlClient from "effect/sql/SqlClient";
6 import * as SqlSchema from "effect/sql/SqlSchema";
7 import { IssueTrackerKind, IssueTrackerProjectBinding, ProjectId } from "@t3tools/contracts";
8
9 import {
10 PersistenceDecodeError,
11 PersistenceSqlError,
12 type IssueTrackerBindingsRepositoryError,
13 } from "./Errors.ts";
14
15 const BindingRow = Schema.Struct({
16 projectId: ProjectId,
17 tracker: IssueTrackerKind,
18 scope: Schema.String,
19 });
20
21 /**
22 * Which standalone issue tracker scope each project reads beside its git host's own issues. A
23 * project is bound to one scope at most, and only while it has a row.
24 */
25 export class IssueTrackerBindingsRepository extends Context.Service<
26 IssueTrackerBindingsRepository,
27 {
28 readonly list: Effect.Effect<
29 ReadonlyMap<ProjectId, IssueTrackerProjectBinding>,
30 IssueTrackerBindingsRepositoryError
31 >;
32 /** Null unbinds. */
33 readonly set: (input: {
34 readonly projectId: ProjectId;
35 readonly binding: IssueTrackerProjectBinding | null;
36 /** When the binding was saved, as an ISO instant. */
37 readonly updatedAt: string;
38 }) => Effect.Effect<void, IssueTrackerBindingsRepositoryError>;
39 /** Unbinds every project that pointed at the tracker, when its credential is removed. */
40 readonly removeTracker: (
41 tracker: IssueTrackerKind,
42 ) => Effect.Effect<void, IssueTrackerBindingsRepositoryError>;
43 }
44 >()("t3/persistence/IssueTrackerBindings/IssueTrackerBindingsRepository") {}
45
46 function toSqlOrDecodeError(sqlOperation: string, decodeOperation: string) {
47 return (cause: unknown): IssueTrackerBindingsRepositoryError =>
48 Schema.isSchemaError(cause)
49 ? PersistenceDecodeError.fromSchemaError(decodeOperation, cause)
50 : new PersistenceSqlError({ operation: sqlOperation, cause });
51 }
52
53 const make = Effect.gen(function* () {
54 const sql = yield* SqlClient.SqlClient;
55
56 const listRows = SqlSchema.findAll({
57 Request: Schema.Void,
58 Result: BindingRow,
59 execute: () =>
60 sql`
61 SELECT project_id AS "projectId", tracker AS "tracker", scope AS "scope"
62 FROM issue_tracker_bindings
63 `,
64 });
65
66 return IssueTrackerBindingsRepository.of({
67 list: listRows(undefined).pipe(
68 Effect.map(
69 (rows) =>
70 new Map(
71 rows.map((row) => [row.projectId, { tracker: row.tracker, scope: row.scope }] as const),
72 ),
73 ),
74 Effect.mapError(toSqlOrDecodeError("listIssueTrackerBindings", "IssueTrackerBinding")),
75 ),
76 set: Effect.fn("IssueTrackerBindingsRepository.set")(
77 function* (input) {
78 yield* input.binding === null
79 ? sql`DELETE FROM issue_tracker_bindings WHERE project_id = ${input.projectId}`
80 : sql`
81 INSERT INTO issue_tracker_bindings (project_id, tracker, scope, updated_at)
82 VALUES (${input.projectId}, ${input.binding.tracker}, ${input.binding.scope}, ${input.updatedAt})
83 ON CONFLICT (project_id)
84 DO UPDATE SET tracker = excluded.tracker, scope = excluded.scope, updated_at = excluded.updated_at
85 `;
86 },
87 Effect.mapError(
88 (cause) => new PersistenceSqlError({ operation: "setIssueTrackerBinding", cause }),
89 ),
90 ),
91 removeTracker: Effect.fn("IssueTrackerBindingsRepository.removeTracker")(
92 function* (tracker) {
93 yield* sql`DELETE FROM issue_tracker_bindings WHERE tracker = ${tracker}`;
94 },
95 Effect.mapError(
96 (cause) => new PersistenceSqlError({ operation: "removeIssueTrackerBindings", cause }),
97 ),
98 ),
99 });
100 });
101
102 export const layer = Layer.effect(IssueTrackerBindingsRepository, make);