How to get all objects with a date that fall in a specific month SQLAlchemy

python, sqlalchemy

Solution

This should find all the events in June, 2012.

import datetime
import calendar

year = 2012
month = 6

num_days = calendar.monthrange(year, month)[1]
start_date = datetime.date(year, month, 1)
end_date = datetime.date(year, month, num_days)

results = session.query(Event).filter(
    and_(Event.date >= start_date, Event.date <= end_date)).all()

Problem

I have a simple SQLAlchemy model: ``` class Event(Base): """ The SQLAlchemy declarative model class for a Event object. """ __tablename__ = 'events' id = Column(Integer, primary_key=True) date = Column(DateTime) title = Column(Text) ``` How do I filter a SQLAlchemy query so that only events in a specific month are returned?

Original source