Update single value from column on PostgreSQL DB using sqlalchemy

Question

I have a "batch" table on my postgresql DB, and I would like to change a single value within column "id", replacing 70 with 15:

from sqlalchemy import create_engine

# Connection with DB
engine = create_engine('postgresql://xxx')

engine.connect()

# Update the value
...

you can use the SQL statement: UPDATE batch SET id=15 WHERE id=70. How to connect to PostgreSQL from sqlalchemy is answered here: stackoverflow.com/questions/9353822/… — Luuk
– Luuk, Commented Sep 19, 2021 at 9:42
Could you please complete the above code to fully answer? Thank you — Alessandro Ceccarelli
– Alessandro Ceccarelli, Commented Sep 19, 2021 at 9:47
Could you please take a try and do that yourself? (SO is not a code writing service) — Luuk
– Luuk, Commented Sep 19, 2021 at 9:50
Which edit ? and please mark your own answer as the 'accepted answer'. (If that solved your question. If not, then that answer should not have been posted as answer, but as an edit to your question. — Luuk
– Luuk, Commented Sep 19, 2021 at 12:11

Alessandro Ceccarelli · Accepted Answer · 2021-09-19 10:11:33Z

0

# Connection with DB
engine = create_engine('postgresql://xxx')
engine.connect()

# Update the value

sql = f"""
    UPDATE batch
    SET id=15 
    WHERE id=70
"""

with engine.begin() as conn:     # TRANSACTION
    conn.execute(sql)

answered Sep 19, 2021 at 10:11

Alessandro Ceccarelli

1,9755 gold badges28 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Update single value from column on PostgreSQL DB using sqlalchemy

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related