sailfork / t3code-github / .repos/ alchemy-effect/ packages/ gcp/ src/ SQL/ ExecuteSqlHttp.ts

import * as sqladmin from "@distilled.cloud/gcp/sqladmin_v1";
import * as Output from "alchemy/Output";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";
import * as GCPBindings from "../GCPBindings.ts";
import { grantFor } from "../HttpBinding.ts";
import { ExecuteSql, type ExecuteSqlRequest } from "./ExecuteSql.ts";
import type { Instance } from "./Instance.ts";

/**
 * HTTP implementation of {@link ExecuteSql}.
 *
 * @layer
 * @provides GCP.SQL.ExecuteSql
 */
export const ExecuteSqlHttp = Layer.effect(
  ExecuteSql,
  Effect.gen(function* () {
    const bind = yield* GCPBindings.Bind;
    const execute = yield* GCPBindings.withCredentials(sqladmin.executeSqlInstances);
    return Effect.fn(function* (instance: Instance) {
      if (!globalThis.__ALCHEMY_RUNTIME__) {
        yield* bind`GCP.SQL.ExecuteSql(${instance})`({
          // Cloud SQL has no instance-level IAM policy; an IAM Condition
          // scopes the project grant to this instance.
          iam: [
            grantFor(
              { role: "roles/cloudsql.instanceUser", scopeByCondition: true },
              Output.interpolate`projects/${instance.project}/instances/${instance.instanceName}`,
            ),
          ],
        });
      }
      const instanceName = yield* instance.instanceName;
      const project = yield* instance.project;
      return Effect.fn(`GCP.SQL.ExecuteSql(${instance.LogicalId})`)(function* (
        request: ExecuteSqlRequest,
      ) {
        return yield* execute({
          ...request,
          instance: yield* instanceName,
          project: yield* project,
        });
      });
    });
  }),
);