a query

gistfile1.txt

records =\
        (session.query(LaborItem)
         .join(ServiceUnit, ServiceUnit.id == LaborItem.punch_unit_id)
         .filter(LaborItem.date <= days[-1])
         .filter(LaborItem.date >= days[0])
         .filter(*unit_filters(LaborItem.punch_unit_id))
         .filter(ServiceUnit.is_active_sql(days[-1]))# is this what we want for long date ranges?
         .options(sa.orm.joinedload('pay_type'))
         .options(sa.orm.joinedload('pay_type.versions'))
         .options(sa.orm.joinedload('punch_job'))
         .options(sa.orm.joinedload('punch_benefit_calculation_rule'))
         ).all()