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

main
ts 78 lines 2.78 KB
Raw
1 import * as Cloudflare from "@alchemy.run/cloudflare";
2 import * as SQL from "@alchemy.run/cloudflare/D1/SQL";
3 import * as Effect from "effect/Effect";
4 import * as HttpServerRequest from "effect/http/HttpServerRequest";
5 import * as HttpServerResponse from "effect/http/HttpServerResponse";
6 import { Database } from "./database.ts";
7
8 export interface User {
9 readonly id: number;
10 readonly email: string;
11 readonly name: string;
12 readonly created_at: number;
13 }
14
15 /**
16 * A Worker querying D1 through `@effect/sql-d1` — tagged-template SQL over
17 * the native binding. Interpolated values are parameterized, every query is
18 * an Effect, and failures surface as typed `SqlError`s.
19 */
20 export default class Api extends Cloudflare.Worker<Api>()(
21 "Api",
22 {
23 main: import.meta.url,
24 },
25 Effect.gen(function* () {
26 const d1 = yield* Cloudflare.D1.QueryDatabase(Database);
27 const sql = yield* SQL.D1(d1);
28
29 return {
30 fetch: Effect.gen(function* () {
31 const request = yield* HttpServerRequest.HttpServerRequest;
32 switch (request.method) {
33 case "GET": {
34 if (request.url === "/") {
35 const users = yield* sql<User>`
36 SELECT * FROM users ORDER BY id
37 `;
38 return yield* HttpServerResponse.json({ users });
39 }
40 const id = Number(request.url.split("/").pop());
41 if (Number.isNaN(id)) {
42 return yield* HttpServerResponse.json({ error: "Invalid user ID" }, { status: 400 });
43 }
44 const [user] = yield* sql<User>`
45 SELECT * FROM users WHERE id = ${id}
46 `;
47 return yield* HttpServerResponse.json({ user: user ?? null });
48 }
49 case "POST": {
50 const [user] = yield* sql<User>`
51 INSERT INTO users (name, email)
52 VALUES (${crypto.randomUUID()}, ${crypto.randomUUID()})
53 RETURNING *
54 `;
55 return yield* HttpServerResponse.json({ user });
56 }
57 case "DELETE": {
58 const id = Number(request.url.split("/").pop());
59 if (Number.isNaN(id)) {
60 return yield* HttpServerResponse.json({ error: "Invalid user ID" }, { status: 400 });
61 }
62 const [user] = yield* sql<User>`
63 DELETE FROM users WHERE id = ${id} RETURNING *
64 `;
65 return yield* HttpServerResponse.json({ user: user ?? null });
66 }
67 default: {
68 return yield* HttpServerResponse.json({ error: "Method not allowed" }, { status: 405 });
69 }
70 }
71 }).pipe(
72 Effect.catchCause((cause) =>
73 HttpServerResponse.json({ error: String(cause) }, { status: 500 }),
74 ),
75 ),
76 };
77 }).pipe(Effect.provide(Cloudflare.D1.QueryDatabaseBinding)),
78 ) {}