Example usage

def test_rdsdata_behaviour:

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(
    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