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

Question

如何在 lambda python 函数中将 json 数组转换为 json 对象，下面是我的 lambda 代码：

import sys

import logging

import pymysql

import json

rds_host=".com"

name="name"

password="pass"

db_name="DB"

port = 3306

def 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()正如评论中提到的，您的行是字典而不是列表。