RDSDataService

Table of Contents

• RDSDataService
  • Client
  • Paginators

Client

class RDSDataService.Client

A low-level client representing AWS RDS DataService:

import boto3

client = boto3.client('rds-data')

These are the available methods:

• can_paginate()
• execute_sql()
• generate_presigned_url()
• get_paginator()
• get_waiter()

can_paginate(operation_name)

Check if an operation can be paginated.

Parameters

operation_name (string) -- The operation name. This is the same name as the method name on the client. For example, if the method name is create_foo, and you'd normally invoke the operation as client.create_foo(**kwargs), if the create_foo operation can be paginated, you can use the call client.get_paginator("create_foo").

Returns

True if the operation can be paginated, False otherwise.

execute_sql(**kwargs)

Executes any SQL statement on the target database synchronously

See also: AWS API Documentation

Request Syntax

response = client.execute_sql(
    awsSecretStoreArn='string',
    database='string',
    dbClusterOrInstanceArn='string',
    schema='string',
    sqlStatements='string'
)

Parameters

• awsSecretStoreArn (string) -- [REQUIRED] ARN of the db credentials in AWS Secret Store or the friendly secret name
• database (string) -- Target DB name
• dbClusterOrInstanceArn (string) -- [REQUIRED] ARN of the target db cluster or instance
• schema (string) -- Target Schema name
• sqlStatements (string) -- [REQUIRED] SQL statement(s) to be executed. Statements can be chained by using semicolons

Return type

dict

Returns

Response Syntax

{
    'sqlStatementResults': [
        {
            'numberOfRecordsUpdated': 123,
            'resultFrame': {
                'records': [
                    {
                        'values': [
                            {
                                'arrayValues': [
                                    {'... recursive ...'},
                                ],
                                'bigIntValue': 123,
                                'bitValue': True|False,
                                'blobValue': b'bytes',
                                'doubleValue': 123.0,
                                'intValue': 123,
                                'isNull': True|False,
                                'realValue': ...,
                                'stringValue': 'string',
                                'structValue': {
                                    'attributes': [
                                        {'... recursive ...'},
                                    ]
                                }
                            },
                        ]
                    },
                ],
                'resultSetMetadata': {
                    'columnCount': 123,
                    'columnMetadata': [
                        {
                            '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'
                        },
                    ]
                }
            }
        },
    ]
}

Response Structure

• (dict) -- Execute SQL response
  • sqlStatementResults (list) -- Results returned by executing the sql statement(s)
    • (dict) -- SQL statement execution result
      • numberOfRecordsUpdated (integer) -- Number of rows updated.
      • resultFrame (dict) -- ResultFrame returned by executing the sql statement
        • records (list) -- ResultSet Metadata.
          • (dict) -- Row or Record
            • values (list) -- Record
              • (dict) -- Column value
                • arrayValues (list) -- Arbitrarily nested arrays
                  • (dict) -- Column value
                • bigIntValue (integer) -- Long value
                • bitValue (boolean) -- Bit value
                • blobValue (bytes) -- Blob value
                • doubleValue (float) -- Double value
                • intValue (integer) -- Integer value
                • isNull (boolean) -- Is column null
                • realValue (float) -- Float value
                • stringValue (string) -- String value
                • structValue (dict) -- Struct or UDT
                  • attributes (list) -- Struct or UDT
                    • (dict) -- Column value
        • resultSetMetadata (dict) -- ResultSet Metadata.
          • columnCount (integer) -- Number of columns
          • columnMetadata (list) -- List of columns and their types
            • (dict) -- Column Metadata
              • arrayBaseColumnType (integer) -- Homogenous array base SQL type from java.sql.Types.
              • isAutoIncrement (boolean) -- Whether the designated column is automatically numbered
              • isCaseSensitive (boolean) -- Whether values in the designated column's case matters
              • isCurrency (boolean) -- Whether values in the designated column is a cash value
              • isSigned (boolean) -- Whether values in the designated column are signed numbers
              • label (string) -- Usually specified by the SQL AS. If not specified, return column name.
              • name (string) -- Name of the column.
              • nullable (integer) -- Indicates the nullability of values in the designated column. One of columnNoNulls (0), columnNullable (1), columnNullableUnknown (2)
              • precision (integer) -- Get the designated column's specified column size.For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. 0 is returned for data types where the column size is not applicable.
              • scale (integer) -- Designated column's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.
              • schemaName (string) -- Designated column's table's schema
              • tableName (string) -- Designated column's table name
              • type (integer) -- SQL type from java.sql.Types.
              • typeName (string) -- Database-specific type name.

generate_presigned_url(ClientMethod, Params=None, ExpiresIn=3600, HttpMethod=None)

Generate a presigned url given a client, its method, and arguments

Parameters

• ClientMethod (string) -- The client method to presign for
• Params (dict) -- The parameters normally passed to ClientMethod.
• ExpiresIn (int) -- The number of seconds the presigned url is valid for. By default it expires in an hour (3600 seconds)
• HttpMethod (string) -- The http method to use on the generated url. By default, the http method is whatever is used in the method's model.

Returns

The presigned url

get_paginator(operation_name)

Create a paginator for an operation.

Parameters

operation_name (string) -- The operation name. This is the same name as the method name on the client. For example, if the method name is create_foo, and you'd normally invoke the operation as client.create_foo(**kwargs), if the create_foo operation can be paginated, you can use the call client.get_paginator("create_foo").

Raises OperationNotPageableError

Raised if the operation is not pageable. You can use the client.can_paginate method to check if an operation is pageable.

Return type

L{botocore.paginate.Paginator}

Returns

A paginator object.

get_waiter(waiter_name)

Returns an object that can wait for some condition.

Parameters

waiter_name (str) -- The name of the waiter to get. See the waiters section of the service docs for a list of available waiters.

Returns

The specified waiter object.

Return type

botocore.waiter.Waiter

Paginators

The available paginators are: