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

main
ts 58 lines 1.83 KB
Raw
1 import * as GCP from "@alchemy.run/gcp";
2 import * as Effect from "effect/Effect";
3 import { serveProbes } from "../../bindingHost.ts";
4
5 export const ITEMS_DDL = "CREATE TABLE Items (\n Id STRING(36) NOT NULL,\n) PRIMARY KEY(Id)";
6
7 export const Db = GCP.Spanner.Instance("Db", {
8 config: "regional-us-central1",
9 processingUnits: 100,
10 });
11
12 /** Database `GetDdl` reads (roles/spanner.databaseReader). */
13 export const Schema = Effect.gen(function* () {
14 const instance = yield* Db;
15 return yield* GCP.Spanner.Database("Schema", {
16 instance: instance.name,
17 extraStatements: [ITEMS_DDL],
18 });
19 });
20
21 /** Database `ExecuteSql` queries (roles/spanner.databaseUser). */
22 export const App = Effect.gen(function* () {
23 const instance = yield* Db;
24 return yield* GCP.Spanner.Database("App", {
25 instance: instance.name,
26 extraStatements: [ITEMS_DDL],
27 });
28 });
29
30 /**
31 * Effect-native Cloud Run service exercising every Spanner binding as its
32 * own runtime service account. Deployed from {@link ../Bindings.test.ts}.
33 */
34 export default class SpannerBindingsHost extends GCP.Function<SpannerBindingsHost>()(
35 "SpannerBindingsHost",
36 { main: import.meta.url, invokerIamDisabled: true },
37 Effect.gen(function* () {
38 const getInstance = yield* GCP.Spanner.GetInstance(Db);
39 const getDdl = yield* GCP.Spanner.GetDdl(Schema);
40 const executeSql = yield* GCP.Spanner.ExecuteSql(App);
41
42 return {
43 fetch: serveProbes({
44 getInstance: getInstance(),
45 getDdl: getDdl(),
46 executeSql: executeSql({
47 sql: "SELECT COUNT(*) AS n FROM Items WHERE Id != @id",
48 params: { id: "none" },
49 paramTypes: { id: { code: "STRING" } },
50 }),
51 }),
52 };
53 }).pipe(
54 Effect.provide(GCP.Spanner.GetInstanceHttp),
55 Effect.provide(GCP.Spanner.GetDdlHttp),
56 Effect.provide(GCP.Spanner.ExecuteSqlHttp),
57 ),
58 ) {}