flask sqlalchemy check if object exist in db [duplicate]

Question

I have a Flask application which uses Flask-SQLAlchemy to connect to a database.

I need to check if row with name='reza' exists...

I think I can use Any(), Exists().

Callam Delaney · Accepted Answer · 2021-06-21 16:16:54Z

9

user = User.query.filter_by(name='reza').count()
if count > 0:
    print 'user exists'

edited Jun 21, 2021 at 16:16

answered Jun 20, 2017 at 10:45

Callam Delaney

6583 silver badges15 bronze badges

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

2 Comments

Hamlett Over a year ago

count() is a super-inefficient way of checking the existence of an object. There is an exist() function in SQLAlchemy with this purpose. Check this answer: stackoverflow.com/a/16003360/1674908

Callam Delaney Over a year ago

@Hamlett You are correct, this is the best way to do it - I wasn't aware of this function at the time.

Collectives™ on Stack Overflow

flask sqlalchemy check if object exist in db [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related