paws.database (version 0.1.11)

rdsdataservice_execute_sql: Runs one or more SQL statements

Description

Runs one or more SQL statements.

This operation is deprecated. Use the batch_execute_statement or execute_statement operation.

Usage

rdsdataservice_execute_sql(awsSecretStoreArn, database,
  dbClusterOrInstanceArn, schema, sqlStatements)

Arguments

awsSecretStoreArn

[required] The Amazon Resource Name (ARN) of the secret that enables access to the DB cluster.

database

The name of the database.

dbClusterOrInstanceArn

[required] The ARN of the Aurora Serverless DB cluster.

schema

The name of the database schema.

sqlStatements

[required] One or more SQL statements to run on the DB cluster.

You can separate SQL statements from each other with a semicolon (;). Any valid SQL statement is permitted, including data definition, data manipulation, and commit statements.

Value

A list with the following syntax:

list(
  sqlStatementResults = list(
    list(
      numberOfRecordsUpdated = 123,
      resultFrame = list(
        records = list(
          list(
            values = list(
              list(
                arrayValues = list(
                  list()
                ),
                bigIntValue = 123,
                bitValue = TRUE|FALSE,
                blobValue = raw,
                doubleValue = 123.0,
                intValue = 123,
                isNull = TRUE|FALSE,
                realValue = 123.0,
                stringValue = "string",
                structValue = list(
                  attributes = list(
                    list()
                  )
                )
              )
            )
          )
        ),
        resultSetMetadata = list(
          columnCount = 123,
          columnMetadata = list(
            list(
              arrayBaseColumnType = 123,
              isAutoIncrement = TRUE|FALSE,
              isCaseSensitive = TRUE|FALSE,
              isCurrency = TRUE|FALSE,
              isSigned = TRUE|FALSE,
              label = "string",
              name = "string",
              nullable = 123,
              precision = 123,
              scale = 123,
              schemaName = "string",
              tableName = "string",
              type = 123,
              typeName = "string"
            )
          )
        )
      )
    )
  )
)

Request syntax

svc$execute_sql(
  awsSecretStoreArn = "string",
  database = "string",
  dbClusterOrInstanceArn = "string",
  schema = "string",
  sqlStatements = "string"
)