Peewee: Checking record exist

[kadnan]

I know about exception thrown in this regard, just want to know whether there's some count or exists() method to check whether some record returned or not?

[coleifer]

ffs man documentation

• http://docs.peewee-orm.com/en/latest/peewee/api.html#SelectQuery.exists
• http://docs.peewee-orm.com/en/latest/peewee/api.html#SelectQuery.count

[dsmurrell]

I was searching for the same thing (I don't usually RTFM right away either). Just to let you know that your links don't take you to the right place on the page as I assume the # is supposed to do.

[coleifer]

• http://docs.peewee-orm.com/en/latest/peewee/api.html#SelectBase.exists
• http://docs.peewee-orm.com/en/latest/peewee/api.html#SelectBase.count

tl/dr

query = User.select().where(User.username == 'reads-the-manual')
if query.exists():
    print('there are %s users who %s' (query.count(), 'read the manual'))