How to do query with `WHERE value IN list` in the Python Peewee ORM?

python orm flask peewee
kramer65 picture kramer65 · Aug 7, 2014 · Viewed 8.1k times · Source

I'm using the (awesome) Python Peewee ORM for my Flask project, but I now got stuck trying to do a query with a where value in ['a', 'b', 'c']. I tried doing it as follows:

MyModel.select().where(MyModel.sell_currency in ['BTC', 'LTC'])

But unfortunately it returns all records in the DB. Any ideas how I could do this?

Answer

ambi picture ambi · Aug 7, 2014

The docs has the answer: x << y will perform x IN y, where y is a list or query. So the final query will look like:

MyModel.select().where(MyModel.sell_currency << ['BTC', 'LTC'])

Related questions

flask-sqlalchemy or sqlalchemy

I am new in both flask and sqlalchemy, I just start working on a flask app, and I am using sqlalchemy for now. I was wondering if there is any significant benefit I can get from using flask-sqlalchemy vs sqlalchemy. …

Read More
SQLAlchemy ordering by count on a many to many relationship

This is a simplified example of my current models (I'm using the Flask SQLAlchemy extension): like = db.Table( 'like', db.Column('uid', db.Integer, db.ForeignKey('users.id')), db.Column('pid', db.Integer, db.ForeignKey('posts.id')) ) class User(db.…

Read More
Efficiently updating database using SQLAlchemy ORM

I'm starting a new application and looking at using an ORM -- in particular, SQLAlchemy. Say I've got a column 'foo' in my database and I want to increment it. In straight sqlite, this is easy: db = sqlite3.connect('mydata.…

Read More