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))1 maintainer
Release files for aurora-prettyparser 1.0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| aurora-prettyparser-1.0.1.tar.gz | 6.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| aurora_prettyparser-1.0.1-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 12.7 kB
Release files / aurora-prettyparser-1.0.1.tar.gz
| Download URL | aurora-prettyparser-1.0.1.tar.gz |
|---|---|
| Size | 6.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e83fc1f47d4fc43e9d8e6fc250d38892c513a0360be505bda602c72d6fc48295
|
|
BLAKE2b-256 checksum How to use checksums |
0706f8af98b85cf74fc4ae613733866b26f1fb4a02248ceb81a557ff3cfb62cd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/46.1.3 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.7.6
|
Release files / aurora_prettyparser-1.0.1-py2.py3-none-any.whl
| Download URL | aurora_prettyparser-1.0.1-py2.py3-none-any.whl |
|---|---|
| Size | 6.6 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
041c7d07f6f5dba97ae7255685fc95d67a49d1a43522121e2e5952d306034fec
|
|
BLAKE2b-256 checksum How to use checksums |
9aa67b8b3d0d90c84c9186bbea5b5047f81004306bcd1317515ded0b99ae94c0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/46.1.3 requests-toolbelt/0.9.1 tqdm/4.45.0 CPython/3.7.6
|
