sailfork / t3code-github / .repos/ alchemy-effect/ examples/ cloudflare-planetscale-mysql-drizzle/ src/ Api.ts

import * as Cloudflare from "@alchemy.run/cloudflare";
import * as Drizzle from "@alchemy.run/drizzle/MySQL";
import { eq } from "drizzle-orm";
import { Layer } from "effect";
import * as Effect from "effect/Effect";
import * as HttpServerRequest from "effect/http/HttpServerRequest";
import * as HttpServerResponse from "effect/http/HttpServerResponse";
import { Hyperdrive } from "./Db.ts";
import { relations, Users } from "./schema.ts";

export default class Api extends Cloudflare.Worker<Api>()(
  "Api",
  {
    main: import.meta.url,
    compatibility: {
      date: "2026-08-31",
    },
  },
  Effect.gen(function* () {
    const conn = yield* Cloudflare.Hyperdrive.Connect(Hyperdrive);
    const db = yield* Drizzle.MySQL(conn.connectionString, {
      relations,
    });

    return {
      fetch: Effect.gen(function* () {
        const request = yield* HttpServerRequest.HttpServerRequest;
        switch (request.method) {
          case "GET": {
            if (request.url === "/") {
              const users = yield* db.select().from(Users);
              return yield* HttpServerResponse.json({ users });
            }
            const id = Number(request.url.split("/").pop());
            if (Number.isNaN(id)) {
              return yield* HttpServerResponse.json({ error: "Invalid user ID" }, { status: 400 });
            }
            const user = yield* db.query.Users.findFirst({
              where: { id },
              with: { posts: true },
            });
            return yield* HttpServerResponse.json({ user });
          }
          case "POST": {
            // MySQL has no RETURNING — $returningId reports the generated
            // primary key, and the row is read back with a SELECT.
            const [created] = yield* db
              .insert(Users)
              .values({
                name: crypto.randomUUID(),
                email: crypto.randomUUID(),
              })
              .$returningId();
            const user = yield* db.select().from(Users).where(eq(Users.id, created!.id));
            return yield* HttpServerResponse.json({ user });
          }
          case "DELETE": {
            const id = Number(request.url.split("/").pop());
            if (Number.isNaN(id)) {
              return yield* HttpServerResponse.json({ error: "Invalid user ID" }, { status: 400 });
            }
            const [user] = yield* db.select().from(Users).where(eq(Users.id, id));
            yield* db.delete(Users).where(eq(Users.id, id));
            return yield* HttpServerResponse.json({ user });
          }
          default: {
            return yield* HttpServerResponse.json({ error: "Method not allowed" }, { status: 405 });
          }
        }
      }).pipe(
        Effect.catch((cause: any) => {
          const peel = (e: any): any => (e?.cause ? peel(e.cause) : e);
          const root = peel(cause);
          return HttpServerResponse.json(
            {
              ok: false,
              error: String(cause),
              rootError: root?.message ?? String(root),
              rootCode: root?.code,
            },
            { status: 500 },
          );
        }),
      ),
    };
  }).pipe(Effect.provide(Layer.mergeAll(Cloudflare.Hyperdrive.ConnectBinding))),
) {}