What's the equivalent of peewee's DoesNotExist in SQLAlchemy?

Question

I've been using peewee with SQLite for some time and now I'm switching to SQLAlchemy with Postgres and I can't find equivalent of DoesNotExist (see example)

try:
    return models.User.get(models.User.id == userid)
except models.DoesNotExist:
    return None

Do you know how to achieve the same with SQLAlchemy? I've checked stuff which I can import from sqlalchemy.ext but nothing seemed right.

Might be helpful: https://stackoverflow.com/questions/18110033/getting-first-row-from-sqlalchemy — Blender, Aug 14 '16 at 00:39

masnun · Accepted Answer · 2016-08-14T03:01:50.900

5

The closest could be this one: - http://docs.sqlalchemy.org/en/latest/orm/exceptions.html#sqlalchemy.orm.exc.NoResultFound

Code Sample:

from sqlalchemy.orm.exc import NoResultFound

try:
    user = session.query(User).one()
except NoResultFound, e:
    print "No users found"

edited Aug 14 '16 at 03:01

answered Aug 14 '16 at 00:32

masnun

11,635
4
39
50

or you can replace the whole `try` clause with the equivalent `session.query(User).one_or_none()` – donkopotamus Aug 24 '16 at 04:48

score -2 · Answer 2 · answered Aug 24 '16 at 03:31

-2

Peewee does work with Postgresql, you know. ;)

answered Aug 24 '16 at 03:31

coleifer

24,887
6
60
75

Yeah, I just wanted to use something more advanced than peewee – carambo Aug 26 '16 at 23:09
Peewees a hell of a lot better than django and people have built advanced things with django's orm. – coleifer Aug 28 '16 at 01:19

What's the equivalent of peewee's DoesNotExist in SQLAlchemy?

2 Answers2