aurora-prettyparser 1.0.0

Parses Aurora responses into a list dictionaries with column names as keys

Parses aurora serverless API responses into a more usable format. Results are returned as a list of dictionaries with the column names being the key. Nulls (returned by Aurora as isNull) are returned as None types. Any value that can be parsed as json is cast from a string to a list/dictionary. Responses are returned formated as:

[
  {"columnOneName": "value", "columnTwoName": "value"},
  {"columnOneName": "value", "columnTwoName": "value"}
]

Where each item in the top level array is a separate row.

Usage

parseResults(records)

### Args: ## records The records from the API query (execute_statement()[“records”])

## metadata The column metadata from API query (execute_statement()[“columnMetadata”])

Example

from auroraPrettyParser import parseResults

response = client.execute_statement(
    secretArn=environ["PG_SECRET"],
    database=environ["DB_NAME"],
    parameters=parameters,
    resourceArn=environ["DB_ARN"],
    includeResultMetadata=True,
    sql=sql
)

print(parseResults(response)