Skip to main content

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

Project description

aurora_response_parser

THIS PACKAGE IS NOW PART OF the appsync-tools package Use it instead

https://github.com/QuiNovas/appsync-tools

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.

Methods

parseResults(records) -> list Arguments: records – The records from the API query (execute_statement()[“records”])

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for aurora-prettyparser, version 1.0.4
Filename, size File type Python version Upload date Hashes
Filename, size aurora_prettyparser-1.0.4-py2.py3-none-any.whl (6.6 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size aurora-prettyparser-1.0.4.tar.gz (6.2 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page