import * as rdsdata from "@distilled.cloud/aws/rds-data";
import * as Binding from "alchemy/Binding";
import type { RuntimeContext } from "alchemy/RuntimeContext";
import * as Effect from "effect/Effect";
import type { DBCluster } from "../RDS/DBCluster.ts";
import type { Secret } from "../SecretsManager/Secret.ts";
export interface ExecuteSqlOptions {
secret: Secret;
database?: string;
schema?: string;
}
export interface ExecuteSqlRequest extends Omit<
rdsdata.ExecuteSqlRequest,
"dbClusterOrInstanceArn" | "awsSecretStoreArn" | "database" | "schema"
> {}
/**
* Runtime binding for the deprecated `rds-data:ExecuteSql` API (Aurora
* Serverless v1 era). Prefer `AWS.RDSData.ExecuteStatement`, which supports
* named parameters and transactions.
*
* Bind it to a Data-API-enabled `DBCluster` and its credentials secret;
* provide the implementation with `Effect.provide(AWS.RDSData.ExecuteSqlHttp)`.
* ### Legacy SQL Execution
* **Example:** Run Raw SQL Statements
* ```typescript
* // init
* const executeSql = yield* AWS.RDSData.ExecuteSql(db.cluster, {
* secret: db.secret,
* database: "app",
* });
*
* // runtime — statements are passed as a single string, no parameters
* const result = yield* executeSql({ sqlStatements: "SELECT 1" });
* ```
*
* @binding
*/
export interface ExecuteSql extends Binding.Service<
ExecuteSql,
"AWS.RDSData.ExecuteSql",
(
cluster: DBCluster,
options: ExecuteSqlOptions,
) => Effect.Effect<
(
request: ExecuteSqlRequest,
) => Effect.Effect<rdsdata.ExecuteSqlResponse, rdsdata.ExecuteSqlError, RuntimeContext>
>
> {}
export const ExecuteSql = Binding.Service<ExecuteSql>("AWS.RDSData.ExecuteSql");