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

main
ts 55 lines 1.84 KB
Raw
1 import * as Drizzle from "@alchemy.run/drizzle/MySQL";
2 import * as Railway from "@alchemy.run/railway";
3 import * as Effect from "effect/Effect";
4 import { HttpServerRequest } from "effect/http/HttpServerRequest";
5 import * as HttpServerResponse from "effect/http/HttpServerResponse";
6 import { Partition, Site } from "./suite-env.ts";
7
8 export const MYSQL_API_PORT = 3000;
9
10 export { Site };
11
12 export const Db = Railway.MySQL("Db", {
13 project: Site,
14 environment: Partition,
15 });
16
17 /**
18 * HTTP Service that binds MySQL via {@link Railway.ConnectMySQL}
19 * and answers SELECT 1. Never returns the connection string.
20 */
21 export default class MySQLApi extends Railway.Service<MySQLApi>()(
22 "MySQLApi",
23 {
24 project: Site,
25 environment: Partition,
26 main: import.meta.url,
27 port: MYSQL_API_PORT,
28 // Match Alchemy's installed version; multiple lockfile entries make an
29 // unversioned external ambiguous when bundling this fixture.
30 build: { install: { mysql2: "3.24.2" } },
31 },
32 Effect.gen(function* () {
33 const conn = yield* Railway.ConnectMySQL(Db);
34 const db = yield* Drizzle.MySQL(conn.connectionString);
35
36 return {
37 fetch: Effect.gen(function* () {
38 const request = yield* HttpServerRequest;
39 const path = new URL(request.url, "http://service").pathname;
40 if (path === "/ping") {
41 return yield* HttpServerResponse.json({ ok: true });
42 }
43 const rows = yield* db.execute("select 1 as ok", "objects");
44 if (path === "/health" || path === "/") {
45 return yield* HttpServerResponse.json({ rows });
46 }
47 return yield* HttpServerResponse.json({ rows }, { status: 404 });
48 }).pipe(
49 Effect.catch((error) =>
50 HttpServerResponse.json({ ok: false, error: String(error) }, { status: 500 }),
51 ),
52 ),
53 };
54 }).pipe(Effect.provide(Railway.ConnectMySQLHttp)),
55 ) {}