Looking for an up to date example to query mysql

[UtiliseIT]

Hi,

My use case is to query a MySQL database as part of a (AWS) Lambda function that returns results in json format via an api. Queries may be selects, selects with variables, or firing sp's.

My current situation is I have a working example that I think is quite old. In addition im note sure that the output is in the correct json format. An example from the api is

Output:
[[""], ["Adelaide"], ["Alexandria"], ["Alice Springs"]]

My current code is

def handler(event, context):
    try:
        conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=20)
    except:
        logger.error("ERROR: Unexpected error: Could not connect to MySql instance.")
    """
    This function fetches content from mysql RDS instance
    """
    rows = []
    with conn.cursor() as cursor:

        sql = "SELECT * FROM tablea"
        cursor.execute(sql)
        for row in cursor:
            rows.append(row)
            print(row)

    return {
    'statusCode':200,
    'headers': {'Access-Control-Allow-Origin': '*'},
    'body':  json.dumps(rows)
    }

The folders in my project are (im not even sure how to update)

.idea
_pycache_
pip
pip-9.0.1.dist-info
pkg_resources
pymysql
PyMySQL-0.7.11.dist-info
setuptools
setuptools-36.6.0.dist-info
wheel
wheel-0.30.0.dist.info

With Lambda there is the ability to run Python 3.7

Thanks for any assistance, greatly appreciated.