NAME

Paws::RDSData::BatchExecuteStatement - Arguments for method BatchExecuteStatement on Paws::RDSData

DESCRIPTION

This class represents the parameters used for calling the method BatchExecuteStatement on the AWS RDS DataService service. Use the attributes of this class as arguments to method BatchExecuteStatement.

You shouldn't make instances of this class. Each attribute should be used as a named argument in the call to BatchExecuteStatement.

SYNOPSIS

    my $rds-data = Paws->service('RDSData');
    my $BatchExecuteStatementResponse = $rds -data->BatchExecuteStatement(
      ResourceArn   => 'MyArn',
      SecretArn     => 'MyArn',
      Sql           => 'MySqlStatement',
      Database      => 'MyDbName',         # OPTIONAL
      ParameterSets => [
        [
          {
            Name     => 'MyParameterName',    # OPTIONAL
            TypeHint => 'JSON'
            ,    # values: JSON, UUID, TIMESTAMP, DATE, TIME, DECIMAL; OPTIONAL
            Value => {
              ArrayValue => {
                ArrayValues   => [ <ArrayValue>, ... ],    # OPTIONAL
                BooleanValues => [ 1,            ... ],    # OPTIONAL
                DoubleValues  => [ 1,            ... ],    # OPTIONAL
                LongValues    => [ 1,            ... ],    # OPTIONAL
                StringValues  => [ 'MyString',   ... ],    # OPTIONAL
              },    # OPTIONAL
              BlobValue    => 'BlobBlob',    # OPTIONAL
              BooleanValue => 1,
              DoubleValue  => 1,
              IsNull       => 1,
              LongValue    => 1,
              StringValue  => 'MyString',
            },    # OPTIONAL
          },
          ...
        ],
        ...
      ],    # OPTIONAL
      Schema        => 'MyDbName',    # OPTIONAL
      TransactionId => 'MyId',        # OPTIONAL
    );
    # Results:
    my $UpdateResults = $BatchExecuteStatementResponse->UpdateResults;
    # Returns a L<Paws::RDSData::BatchExecuteStatementResponse> object.

Values for attributes that are native types (Int, String, Float, etc) can passed as-is (scalar values). Values for complex Types (objects) can be passed as a HashRef. The keys and values of the hashref will be used to instance the underlying object. For the AWS API documentation, see <https://docs.aws.amazon.com/goto/WebAPI/rds-data/BatchExecuteStatement>

ATTRIBUTES

Database => Str

The name of the database.

ParameterSets => ArrayRef[ArrayRef[Paws::RDSData::SqlParameter]]

The parameter set for the batch operation.

The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:

Specify one or more empty parameter sets.
Use the "ExecuteStatement" operation instead of the "BatchExecuteStatement" operation.

Array parameters are not supported.

REQUIRED ResourceArn => Str

The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.

Schema => Str

The name of the database schema.

REQUIRED SecretArn => Str

The name or ARN of the secret that enables access to the DB cluster.

REQUIRED Sql => Str

The SQL statement to run.

TransactionId => Str

The identifier of a transaction that was started by using the "BeginTransaction" operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.

If the SQL statement is not part of a transaction, don't set this parameter.

BUGS and CONTRIBUTIONS

The source code is located here: <https://github.com/pplu/aws-sdk-perl>

Please report bugs to: <https://github.com/pplu/aws-sdk-perl/issues>