The best way to control Claude Code, Codex and more from any computer or phone
| 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); |