1// Code generated by smithy-go-codegen DO NOT EDIT. 2 3package rdsdata 4 5import ( 6 "context" 7 awsmiddleware "github.com/aws/aws-sdk-go-v2/aws/middleware" 8 "github.com/aws/aws-sdk-go-v2/aws/signer/v4" 9 "github.com/aws/aws-sdk-go-v2/service/rdsdata/types" 10 "github.com/aws/smithy-go/middleware" 11 smithyhttp "github.com/aws/smithy-go/transport/http" 12) 13 14// Runs a batch SQL statement over an array of data. You can run bulk update and 15// insert operations for multiple records using a DML statement with different 16// parameter sets. Bulk operations can provide a significant performance 17// improvement over individual insert and update operations. If a call isn't part 18// of a transaction because it doesn't include the transactionID parameter, changes 19// that result from the call are committed automatically. 20func (c *Client) BatchExecuteStatement(ctx context.Context, params *BatchExecuteStatementInput, optFns ...func(*Options)) (*BatchExecuteStatementOutput, error) { 21 if params == nil { 22 params = &BatchExecuteStatementInput{} 23 } 24 25 result, metadata, err := c.invokeOperation(ctx, "BatchExecuteStatement", params, optFns, addOperationBatchExecuteStatementMiddlewares) 26 if err != nil { 27 return nil, err 28 } 29 30 out := result.(*BatchExecuteStatementOutput) 31 out.ResultMetadata = metadata 32 return out, nil 33} 34 35// The request parameters represent the input of a SQL statement over an array of 36// data. 37type BatchExecuteStatementInput struct { 38 39 // The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster. 40 // 41 // This member is required. 42 ResourceArn *string 43 44 // The name or ARN of the secret that enables access to the DB cluster. 45 // 46 // This member is required. 47 SecretArn *string 48 49 // The SQL statement to run. 50 // 51 // This member is required. 52 Sql *string 53 54 // The name of the database. 55 Database *string 56 57 // The parameter set for the batch operation. The SQL statement is executed as many 58 // times as the number of parameter sets provided. To execute a SQL statement with 59 // no parameters, use one of the following options: 60 // 61 // * Specify one or more empty 62 // parameter sets. 63 // 64 // * Use the ExecuteStatement operation instead of the 65 // BatchExecuteStatement operation. 66 // 67 // Array parameters are not supported. 68 ParameterSets [][]types.SqlParameter 69 70 // The name of the database schema. 71 Schema *string 72 73 // The identifier of a transaction that was started by using the BeginTransaction 74 // operation. Specify the transaction ID of the transaction that you want to 75 // include the SQL statement in. If the SQL statement is not part of a transaction, 76 // don't set this parameter. 77 TransactionId *string 78} 79 80// The response elements represent the output of a SQL statement over an array of 81// data. 82type BatchExecuteStatementOutput struct { 83 84 // The execution results of each batch entry. 85 UpdateResults []types.UpdateResult 86 87 // Metadata pertaining to the operation's result. 88 ResultMetadata middleware.Metadata 89} 90 91func addOperationBatchExecuteStatementMiddlewares(stack *middleware.Stack, options Options) (err error) { 92 err = stack.Serialize.Add(&awsRestjson1_serializeOpBatchExecuteStatement{}, middleware.After) 93 if err != nil { 94 return err 95 } 96 err = stack.Deserialize.Add(&awsRestjson1_deserializeOpBatchExecuteStatement{}, middleware.After) 97 if err != nil { 98 return err 99 } 100 if err = addSetLoggerMiddleware(stack, options); err != nil { 101 return err 102 } 103 if err = awsmiddleware.AddClientRequestIDMiddleware(stack); err != nil { 104 return err 105 } 106 if err = smithyhttp.AddComputeContentLengthMiddleware(stack); err != nil { 107 return err 108 } 109 if err = addResolveEndpointMiddleware(stack, options); err != nil { 110 return err 111 } 112 if err = v4.AddComputePayloadSHA256Middleware(stack); err != nil { 113 return err 114 } 115 if err = addRetryMiddlewares(stack, options); err != nil { 116 return err 117 } 118 if err = addHTTPSignerV4Middleware(stack, options); err != nil { 119 return err 120 } 121 if err = awsmiddleware.AddRawResponseToMetadata(stack); err != nil { 122 return err 123 } 124 if err = awsmiddleware.AddRecordResponseTiming(stack); err != nil { 125 return err 126 } 127 if err = addClientUserAgent(stack); err != nil { 128 return err 129 } 130 if err = smithyhttp.AddErrorCloseResponseBodyMiddleware(stack); err != nil { 131 return err 132 } 133 if err = smithyhttp.AddCloseResponseBodyMiddleware(stack); err != nil { 134 return err 135 } 136 if err = addOpBatchExecuteStatementValidationMiddleware(stack); err != nil { 137 return err 138 } 139 if err = stack.Initialize.Add(newServiceMetadataMiddleware_opBatchExecuteStatement(options.Region), middleware.Before); err != nil { 140 return err 141 } 142 if err = addRequestIDRetrieverMiddleware(stack); err != nil { 143 return err 144 } 145 if err = addResponseErrorMiddleware(stack); err != nil { 146 return err 147 } 148 if err = addRequestResponseLogging(stack, options); err != nil { 149 return err 150 } 151 return nil 152} 153 154func newServiceMetadataMiddleware_opBatchExecuteStatement(region string) *awsmiddleware.RegisterServiceMetadata { 155 return &awsmiddleware.RegisterServiceMetadata{ 156 Region: region, 157 ServiceID: ServiceID, 158 SigningName: "rds-data", 159 OperationName: "BatchExecuteStatement", 160 } 161} 162