aws_rds_data
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.Summary
Functions
-
batch_execute_statement(Client, Input)
Runs a batch SQL statement over an array of data.
- batch_execute_statement(Client, Input0, Options0)
-
begin_transaction(Client, Input)
Starts a SQL transaction.
- begin_transaction(Client, Input0, Options0)
-
commit_transaction(Client, Input)
Ends a SQL transaction started with the
BeginTransaction
operation and commits the changes. - commit_transaction(Client, Input0, Options0)
-
execute_sql(Client, Input)
Runs one or more SQL statements.
- execute_sql(Client, Input0, Options0)
-
execute_statement(Client, Input)
Runs a SQL statement against a database.
- execute_statement(Client, Input0, Options0)
-
rollback_transaction(Client, Input)
Performs a rollback of a transaction.
- rollback_transaction(Client, Input0, Options0)
Functions
batch_execute_statement(Client, Input)
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 thetransactionID
parameter, changes that result from the call are committed
automatically.
batch_execute_statement(Client, Input0, Options0)
begin_transaction(Client, Input)
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 separate ExecuteStatement
call with
continueAfterTimeout
enabled.
begin_transaction(Client, Input0, Options0)
commit_transaction(Client, Input)
Ends a SQL transaction started with the BeginTransaction
operation
and commits the changes.
commit_transaction(Client, Input0, Options0)
execute_sql(Client, Input)
Runs one or more SQL statements.
This operation is deprecated. Use theBatchExecuteStatement
or
ExecuteStatement
operation.
execute_sql(Client, Input0, Options0)
execute_statement(Client, Input)
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.
execute_statement(Client, Input0, Options0)
rollback_transaction(Client, Input)
Performs a rollback of a transaction.
Rolling back a transaction cancels its changes.