The best way to control Claude Code, Codex and more from any computer or phone
| 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 | ) {} |