SQLAlchemy SELECT id FROM Table_1 WHERE name='xyz'

Question

I can get the SELECT id from parts where name='Part1' as an SQL statement but what is the way to do that with SQLAlchemy?

I've tried;

db.session.query(Parts.id).filter(name=form.name.data)

But this returns an Object not the id

Answer 1

Use the below code.

parts = db.session.query(Parts).filter(Parts.name==Part1).first()

Then if you want the only id you can just access

parts.id