@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, 06:00 UTC

main
ts 87 lines 3.19 KB
Raw
1 import * as Cloudflare from "@alchemy.run/cloudflare";
2 import * as Drizzle from "@alchemy.run/drizzle/MySQL";
3 import { eq } from "drizzle-orm";
4 import { Layer } from "effect";
5 import * as Effect from "effect/Effect";
6 import * as HttpServerRequest from "effect/http/HttpServerRequest";
7 import * as HttpServerResponse from "effect/http/HttpServerResponse";
8 import { Hyperdrive } from "./Db.ts";
9 import { relations, Users } from "./schema.ts";
10
11 export default class Api extends Cloudflare.Worker<Api>()(
12 "Api",
13 {
14 main: import.meta.url,
15 compatibility: {
16 date: "2026-08-31",
17 },
18 },
19 Effect.gen(function* () {
20 const conn = yield* Cloudflare.Hyperdrive.Connect(Hyperdrive);
21 const db = yield* Drizzle.MySQL(conn.connectionString, {
22 relations,
23 });
24
25 return {
26 fetch: Effect.gen(function* () {
27 const request = yield* HttpServerRequest.HttpServerRequest;
28 switch (request.method) {
29 case "GET": {
30 if (request.url === "/") {
31 const users = yield* db.select().from(Users);
32 return yield* HttpServerResponse.json({ users });
33 }
34 const id = Number(request.url.split("/").pop());
35 if (Number.isNaN(id)) {
36 return yield* HttpServerResponse.json({ error: "Invalid user ID" }, { status: 400 });
37 }
38 const user = yield* db.query.Users.findFirst({
39 where: { id },
40 with: { posts: true },
41 });
42 return yield* HttpServerResponse.json({ user });
43 }
44 case "POST": {
45 // MySQL has no RETURNING — $returningId reports the generated
46 // primary key, and the row is read back with a SELECT.
47 const [created] = yield* db
48 .insert(Users)
49 .values({
50 name: crypto.randomUUID(),
51 email: crypto.randomUUID(),
52 })
53 .$returningId();
54 const user = yield* db.select().from(Users).where(eq(Users.id, created!.id));
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* db.select().from(Users).where(eq(Users.id, id));
63 yield* db.delete(Users).where(eq(Users.id, id));
64 return yield* HttpServerResponse.json({ user });
65 }
66 default: {
67 return yield* HttpServerResponse.json({ error: "Method not allowed" }, { status: 405 });
68 }
69 }
70 }).pipe(
71 Effect.catch((cause: any) => {
72 const peel = (e: any): any => (e?.cause ? peel(e.cause) : e);
73 const root = peel(cause);
74 return HttpServerResponse.json(
75 {
76 ok: false,
77 error: String(cause),
78 rootError: root?.message ?? String(root),
79 rootCode: root?.code,
80 },
81 { status: 500 },
82 );
83 }),
84 ),
85 };
86 }).pipe(Effect.provide(Layer.mergeAll(Cloudflare.Hyperdrive.ConnectBinding))),
87 ) {}