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