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.

If you have questions or comments related to the Data API, send email to Rds-data-api-feedback@amazon.com (mailto:Rds-data-api-feedback@amazon.com).

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>

CommitTransaction

ResourceArn => Str

SecretArn => Str

TransactionId => Str

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 or 1,000 records. If the call returns more than 1 MB of response data or over 1,000 records, 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

SEE ALSO

This service class forms part of Paws

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

cpanm Paws::SDK::Config

perl -MCPAN -e shell
install Paws::SDK::Config