Python Lambda function succeeds but no rows appear updated

Question

I have an AWS lamda function making an update to my 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)

The print statement prints 1 as expected however when I look at the data in my database no updates were made.

user13966865 · Accepted Answer · 2021-04-20 03:04:49Z

1

you need to call connection.commit() to reflect the change in database

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()

edited Apr 20, 2021 at 3:04

answered Apr 20, 2021 at 2:58

user13966865

4685 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user11631308 Over a year ago

I get the following error: "errorMessage": "'psycopg2.extensions.cursor' object has no attribute 'commit'"

Collectives™ on Stack Overflow

Python Lambda function succeeds but no rows appear updated

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related