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

main
ts 62 lines 1.92 KB
Raw
1 import * as AWS from "@alchemy.run/aws";
2 import * as SQL from "@alchemy.run/sql/Postgres";
3 import type { RuntimeContext } from "alchemy/RuntimeContext";
4 import * as Context from "effect/Context";
5 import * as Data from "effect/Data";
6 import * as Effect from "effect/Effect";
7 import * as Layer from "effect/Layer";
8 import { Network } from "./Network.ts";
9
10 export class SqlError extends Data.TaggedError("SqlError")<{
11 readonly message: string;
12 readonly cause?: unknown;
13 }> {}
14
15 export class Database extends Context.Service<
16 Database,
17 {
18 query<Row extends Record<string, unknown> = Record<string, unknown>>(
19 statement: string,
20 values?: ReadonlyArray<unknown>,
21 ): Effect.Effect<ReadonlyArray<Row>, SqlError, RuntimeContext>;
22 }
23 >()("Sql") {}
24
25 export const DatabaseAurora = Layer.effect(
26 Database,
27 Effect.gen(function* () {
28 const { vpc, databaseSecurityGroup } = yield* Network;
29 const database = yield* AWS.RDS.Aurora("Database", {
30 subnetIds: vpc.privateSubnetIds,
31 securityGroupIds: [databaseSecurityGroup.groupId],
32 });
33
34 const connect = yield* AWS.RDS.Connect(database.cluster, {
35 secret: database.secret,
36 subnetIds: vpc.privateSubnetIds,
37 securityGroupIds: [databaseSecurityGroup.groupId],
38 });
39
40 // `Connect` resolves credentials per invocation; the pool opens on the
41 // first query and closes when the invocation settles.
42 const sql = yield* SQL.Postgres({
43 url: connect.pipe(Effect.map((connection) => connection.url)),
44 });
45
46 return Database.of({
47 query: <Row extends Record<string, unknown>>(
48 statement: string,
49 values: ReadonlyArray<unknown> = [],
50 ) =>
51 sql.unsafe<Row>(statement, values).pipe(
52 Effect.mapError(
53 (cause) =>
54 new SqlError({
55 message: `Failed to execute SQL statement: ${statement}`,
56 cause,
57 }),
58 ),
59 ),
60 });
61 }),
62 );