如何在lambda python函数中将json数组转换为json对象

Question

如何在 lambda python 函数中将 json 数组转换为 json 对象，下面是我的 lambda 代码：import sysimport loggingimport pymysqlimport jsonrds_host=".com"name="name"password="pass"db_name="DB"port = 3306def save_events(event):result = []conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=30)with conn.cursor() as cur:  cur.execute("select * from bodyPart")for row in cur:  result.append(list(row))print ("Data from RDS...")print (result)cur.close()bodyparts = json.dumps(result)def lambda_handler(event, context):  save_events(event)  return bodyparts以下是输出响应：[[1, \"Chest\", \"link"], [2, \"Shoulder\", null], [3, \"Arms\", null]]如何获得类似的回应 {id='1', name='chest', link='......', ....}

Answer 1

目前你的函数save_events没有提到传入的事件。但是你问的直接问题是用这样的代码解决的：

result = []

conn = pymysql.connect(rds_host,

        user=name,

        passwd=password,

        db=db_name,

        connect_timeout=30)

cursor = conn.cursor()

cursor.execute("SELECT * FROM bodyPart")

data = cursor.fetchall()

#data = [[1, "Chest", "link"], [2, "Shoulder", None], [3, "Arms", None]]

element = {}

for row in data:

    element["ident"], element["name"], element["link"] = row

    result.append(element)

print("Data from RDS...")

print json.dumps(result)

conn.close()

正如评论中提到的，您的行是字典而不是列表。