How to update a record in database based on a variable in Python?

Question

How can I update a record in a database based on a variable?

I have a variable named run_time_start that is previously sent to the database.

But then, at some point, I want to update 2 columns in the same record, with the values of the variables end_date and total_time

is there any way I can do something like this?

engine.execute("UPDATE control_general_log SET (end_date, total_time) VALUES (?, ?)", run_time_end, total_elapsed_time, "WHERE chain_script = ?", run_time_start)

Tomer Mantzuri · Accepted Answer · 2022-05-04 12:15:30Z

1

try this:

engine.execute("UPDATE control_general_log SET end_date=?, total_time=? WHERE chain_script = ?", (run_time_end, total_elapsed_time, run_time_start,)

conn.commit()  # conn is your connection variable

answered May 4, 2022 at 12:15

Tomer Mantzuri

264 bronze badges

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

3 Comments

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Catarina Ribeiro Over a year ago

It didn't raise any error but it also didn't write to the db

Tomer Mantzuri Over a year ago

make sure u use commit(), i dont know how u call to your connection object ( the one u use to generete the "engine" cursor)

Collectives™ on Stack Overflow

How to update a record in database based on a variable in Python?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related