How to find of user exists in mysql table using peewee ORM?

Question

I have this table in mysql,

import peewee

class User(peewee.Model):

    username = peewee.Charfield(max_length=60)
    email = peewee.Charfield(max_length=300)

    def __repr__(self):
        return "<User: {}>".format(self.username)

when I try the below code for an existing user:

User.get(email="zhaochang@qq.com")

it returns <User: zhaochang>

but for a random email/user that dose not exists User.get(email="some_random@email.com") it throws error:

UserDoesNotExist: Instance matching query does not exist:

SQL: SELECT 't1'.'id', 't1'.'email', 't1'.'username' FROM 'user' AS t1 WHERE ('t1'.'email' = %s) PARAMS: [u'some_random@email.com']

I was expecting for User.get method to return None.

score 1 · Accepted Answer · answered Oct 23 '18 at 07:04

1

Why would you expect the method to return None when the documentation clearly states that

If no model is returned, a DoesNotExist is raised.

Source: http://docs.peewee-orm.com/en/latest/peewee/api.html#Model.get

answered Oct 23 '18 at 07:04

BoboDarph

2,751
1
10
15

i read that in documentation and used how it is showin in example. thanks – Chang Zhao Oct 23 '18 at 08:53

How to find of user exists in mysql table using peewee ORM?

1 Answers1