Sometimes, we want to check if row exists in table with Python Flask-SQLAlchemy

In this article, we’ll look at how to check if row exists in table with Python Flask-SQLAlchemy.

How to check if row exists in table with Python Flask-SQLAlchemy?

To check if row exists in table with Python Flask-SQLAlchemy, we can make a query top the table.

For instance, we write

exists = db.session.query(User.id).filter_by(name='davidism').first() is not None

to call query to query the table by User.id.

And we call filter_by to add additional filters by the name field value.

Then we call first to return the first value.

Conclusion

To check if row exists in table with Python Flask-SQLAlchemy, we can make a query top the table.