check if query exists using peewee

python peewee
calthoff picture calthoff · Jul 30, 2015 · Viewed 13.7k times · Source

I am using the Peewee library in Python and I want to check if a query exists. I do not want to create a record if it doesn't exist, so I don't want to use get_or_create. There must be a better solution than to use try/except with get but I don't see anything. Please let me know if there is a better way. Thanks.

Answer

coleifer picture coleifer · Jul 30, 2015

You can use .exists():

query = User.select().where(User.username == 'charlie')
if query.exists():
    # A user named "charlie" exists.
    cool()

http://docs.peewee-orm.com/en/latest/peewee/api.html?highlight=exists#SelectBase.exists

Related questions

Peewee model to JSON

I'm creating an API using peewee as the ORM and I need the ability to convert a peewee model object into a JSON object to send to the user. Does anyone know of a good way to do this?

Read More
Accessing remote MySQL database with peewee

I'm trying to connect to a MySQL database on Amazon's RDS using peewee and I can't get it to work. I'm new to databases so I'm probably doing something stupid, but this is what I'm trying: import peewee as pw …

Read More
Python Peewee execute_sql() example

I am using the Peewee module as the ORM for my project. I read the entire documentation, there is no clear example on how to process the result from db.execute_sql(). I traced the code, only can find db.…

Read More