Parses Aurora responses into a list dictionaries with column names as keys
Project description
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)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for aurora-prettyparser-1.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | feb6453c3dfbf6c6a577538ac64bf26e7da07f66e3b5794d9c90f9889035f6f2 |
|
MD5 | 2f742516969a1083fda94845c07b7041 |
|
BLAKE2b-256 | 363abf9fd9622db4194427228a03151cc06e66efacb7c4f68e40b5d301652c9c |
Hashes for aurora_prettyparser-1.0.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bc56d49c4d55f58420458d4c8cf4d470535f5229eb0aae7961e986422fc8f2b3 |
|
MD5 | 5d70196ad94426cbabbafab5b8b601e4 |
|
BLAKE2b-256 | 8c9586117236cdc0894aa29be8846458d44900255254760d8462809935e575bc |