NAME

Paws::RDSData - Perl Interface to AWS AWS RDS DataService

SYNOPSIS

  use Paws;
  my $obj = Paws->service('RDSData');
  my $res = $obj->Method(
    Arg1 => $val1,
    Arg2 => [ 'V1', 'V2' ],
    # if Arg3 is an object, the HashRef will be used as arguments to the constructor
    # of the arguments type
    Arg3 => { Att1 => 'Val1' },
    # if Arg4 is an array of objects, the HashRefs will be passed as arguments to
    # the constructor of the arguments type
    Arg4 => [ { Att1 => 'Val1'  }, { Att1 => 'Val2' } ],
  );

DESCRIPTION

Amazon RDS Data Service

Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora Serverless DB cluster. To run these statements, you work with the Data Service API.

For more information about the Data Service API, see Using the Data API for Aurora Serverless (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html) in the Amazon Aurora User Guide.

For the AWS API documentation, see <https://docs.aws.amazon.com/goto/WebAPI/rds-data-2018-08-01>

METHODS

BatchExecuteStatement

ResourceArn => Str
SecretArn => Str
Sql => Str
[Database => Str]
[ParameterSets => ArrayRef[ArrayRef[Paws::RDSData::SqlParameter]]]
[Schema => Str]
[TransactionId => Str]

Each argument is described in detail in: Paws::RDSData::BatchExecuteStatement

Returns: a Paws::RDSData::BatchExecuteStatementResponse instance

Runs a batch SQL statement over an array of data.

You can run bulk update and insert operations for multiple records using a DML statement with different parameter sets. Bulk operations can provide a significant performance improvement over individual insert and update operations.

If a call isn't part of a transaction because it doesn't include the "transactionID" parameter, changes that result from the call are committed automatically.

BeginTransaction

ResourceArn => Str
SecretArn => Str
[Database => Str]
[Schema => Str]

Each argument is described in detail in: Paws::RDSData::BeginTransaction

Returns: a Paws::RDSData::BeginTransactionResponse instance

Starts a SQL transaction.

 <important> <p>A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours.</p> <p>A transaction times out if no calls use its transaction ID in three minutes. If a transaction times out before it's committed, it's rolled back automatically.</p> <p>DDL statements inside a transaction cause an implicit commit. We recommend that you run each DDL statement in a separate <code>ExecuteStatement</code> call with <code>continueAfterTimeout</code> enabled.</p> </important>

Each argument is described in detail in: Paws::RDSData::CommitTransaction

Returns: a Paws::RDSData::CommitTransactionResponse instance

Ends a SQL transaction started with the "BeginTransaction" operation and commits the changes.

ExecuteSql

AwsSecretStoreArn => Str
DbClusterOrInstanceArn => Str
SqlStatements => Str
[Database => Str]
[Schema => Str]

Each argument is described in detail in: Paws::RDSData::ExecuteSql

Returns: a Paws::RDSData::ExecuteSqlResponse instance

Runs one or more SQL statements.

This operation is deprecated. Use the "BatchExecuteStatement" or "ExecuteStatement" operation.

ExecuteStatement

ResourceArn => Str
SecretArn => Str
Sql => Str
[ContinueAfterTimeout => Bool]
[Database => Str]
[IncludeResultMetadata => Bool]
[Parameters => ArrayRef[Paws::RDSData::SqlParameter]]
[ResultSetOptions => Paws::RDSData::ResultSetOptions]
[Schema => Str]
[TransactionId => Str]

Each argument is described in detail in: Paws::RDSData::ExecuteStatement

Returns: a Paws::RDSData::ExecuteStatementResponse instance

Runs a SQL statement against a database.

If a call isn't part of a transaction because it doesn't include the "transactionID" parameter, changes that result from the call are committed automatically.

The response size limit is 1 MB. If the call returns more than 1 MB of response data, the call is terminated.

RollbackTransaction

ResourceArn => Str
SecretArn => Str
TransactionId => Str

Each argument is described in detail in: Paws::RDSData::RollbackTransaction

Returns: a Paws::RDSData::RollbackTransactionResponse instance

Performs a rollback of a transaction. Rolling back a transaction cancels its changes.

PAGINATORS

Paginator methods are helpers that repetively call methods that return partial results

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>