rds-data
Implemented features for this service
[ ] batch_execute_statement
[ ] begin_transaction
[ ] commit_transaction
[ ] execute_sql
[X] execute_statement
There is no validation yet on any of the input parameters.
SQL statements are not executed by Moto, so this call will always return 0 records by default.
You can use a dedicated API to override this, by configuring a queue of expected results.
A request to execute_statement will take the first result from that queue, and assign it to the provided SQL-query. Subsequent requests using the same SQL-query will return the same result. Other requests using a different SQL-query will take the next result from the queue, or return an empty result if the queue is empty.
Configure this queue by making an HTTP request to /moto-api/static/rds-data/statement-results. An example invocation looks like this:
expected_results = { "account_id": "123456789012", # This is the default - can be omitted "region": "us-east-1", # This is the default - can be omitted "results": [ { "records": [...], "columnMetadata": [...], "numberOfRecordsUpdated": 42, "generatedFields": [...], "formattedRecords": "some json" }, # other results as required ], } resp = requests.post( "http://motoapi.amazonaws.com/moto-api/static/rds-data/statement-results", json=expected_results, ) assert resp.status_code == 201 rdsdata = boto3.client("rds-data", region_name="us-east-1") resp = rdsdata.execute_statement(resourceArn="not applicable", secretArn="not applicable", sql="SELECT some FROM thing")
[ ] rollback_transaction