Python Lambda函数成功，但未更新任何行

Question

我有一个AWS lamda函数来更新我的RDS

def lambda_handler(event, context):

    connection = psycopg2.connect(user="****", password=****,
                                  host=****, port="****",
                                  database="****")
    
    cursor = connection.cursor()
    postgres_put_query = "UPDATE restaurant SET (item, price) = ('{0}','{1}') WHERE id = '{2}'".format(event['item'], event['price'], event['id'])
    cursor.execute(postgres_put_query)
    print(cursor.rowcount)

print语句按预期打印1，但是当我查看数据库中的数据时，没有进行任何更新

Answer 1

您需要调用connection.commit()以反映数据库中的更改

def lambda_handler(event, context):

    connection = psycopg2.connect(user="****", password=****,
                                  host=****, port="****",
                                  database="****")
    
    cursor = connection.cursor()
    postgres_put_query = "UPDATE restaurant SET (item, price) = ('{0}','{1}') WHERE id = '{2}'".format(event['item'], event['price'], event['id'])
    cursor.execute(postgres_put_query)
    print(cursor.rowcount)
    connection.commit()