Skip to content

Latest commit

 

History

History
61 lines (42 loc) · 2.12 KB

rds-data.rst

File metadata and controls

61 lines (42 loc) · 2.12 KB
Raw

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:

    python

    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