Update column values query in SQLAlchemy

python Share on :

You can update column values of a row in SQLAlchemy by using the .update() method and assigning new values to its model properties.

session.query(
    UserModel
).filter(
    UserModel.id == 20
).update({
    UserModel.username: 'john_deo',
    UserModel.email: '[email protected]',
    UserModel.city: 'New York'
})

session.commit()

In the code snippet, we are updating the User's email, username, the city which has id 20.

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Get highest id or value record from a column SqlAlchemy Query
Update dictionary values in python
Column and data types in Sqlalchemy
Column name as alias name SQLAlchemy
Add column to existing table with default value SQLAlchemy
Count Rows group by column name SqlAlchemy
update data from table

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer