我正在try 从RDS MySQL实例中提取数据,并使用Put_Record boto3API加载到Kinesis数据流中.使用pymysql
的连接工作正常,我可以打印表格,但我不能将数据写入Kinesis数据流.我得到了这个错误"Object of type datetime is not JSON serializable"
.
def lambda_handler(event, context):
connection = pymysql.connect(
host = endpoint,
user = username,
password = passwrd,
database = database_name)
cursor = connection.cursor()
cursor.execute('SELECT * FROM table LIMIT 10')
rows = cursor.fetchall()
for row in rows:
print("{0} {1} {2}".format(row[0], row[1], row[2]))
kinesis = boto3.client('kinesis')
response = kinesis.put_record(
StreamName="test",
Data=json.dumps(rows),
PartitionKey="1"
)
connection.commit()
lambda_handler(None,None)
我试着打印这张表,它起作用了.唯一的问题是将记录放入Kinesis数据流.