Revision history [back]

To apply a filter using in_() in SQLAlchemy for JSON data, you can use the JSONB type provided by SQLAlchemy. This allows you to access the JSON data as a column in your SQL queries.

Here's an example of how to apply a filter for JSON data using in_():

from sqlalchemy import Column, Integer, String, JSON, create_engine, and_
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# create the engine and session
engine = create_engine('postgresql://user:password@host/dbname')
Session = sessionmaker(bind=engine)
session = Session()

# create the base class for declarative models
Base = declarative_base()

# define the model
class MyModel(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    data = Column(JSON)

# use in_() to apply a filter for JSON data
query = session.query(MyModel).filter(
    MyModel.data['key'].in_(['value1', 'value2'])
)

# execute the query and get the results
results = query.all()

In this example, we have a table called my_table with a column called data that contains JSON data. To apply a filter for the JSON data, we access the data column using the MyModel.data syntax and then use in_() to specify the values we want to filter for. The query.all() method is used to execute the query and get the results.