AWS.RDSData (aws-elixir v0.8.0) View Source

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 in the Amazon Aurora User Guide.

Link to this section Summary

Functions

Runs a batch SQL statement over an array of data.

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

Runs one or more SQL statements.

Runs a SQL statement against a database.

Performs a rollback of a transaction.

Link to this section Functions

Link to this function

batch_execute_statement(client, input, options \\ [])

View Source

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.

Link to this function

begin_transaction(client, input, options \\ [])

View Source

Starts a SQL transaction.

A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours. 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. DDL statements inside a transaction cause an implicit commit. We recommend that you run each DDL statement in a separateExecuteStatementcall withcontinueAfterTimeoutenabled.

Link to this function

commit_transaction(client, input, options \\ [])

View Source

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

Link to this function

execute_sql(client, input, options \\ [])

View Source

Runs one or more SQL statements.

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

Link to this function

execute_statement(client, input, options \\ [])

View Source

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.

Link to this function

rollback_transaction(client, input, options \\ [])

View Source

Performs a rollback of a transaction.

Rolling back a transaction cancels its changes.