def test_before_filter (self): project_1 = Project.cached("1") project_2 = Project.cached("2") resource_1 = Resource.cached("1") resource_2 = Resource.cached("2") user_1 = User.cached("1") user_2 = User.cached("2") start = datetime(2000, 1, 1) end = start + timedelta(weeks=1) allocation_1 = Allocation(project_1, resource_1, 10, start, end) allocation_2 = Allocation(project_1, resource_1, 20, start, end) allocation_3 = Allocation(project_2, resource_1, 30, start, end) allocation_4 = Allocation(project_2, resource_2, 35, start, end) charge_1 = Charge(allocation_1, 10) charge_2 = Charge(allocation_2, 15) charge_3 = Charge(allocation_2, 5) charge_4 = Charge(allocation_4, 9) charge_5 = Charge(allocation_4, 8) Refund(charge_1, 4) Refund(charge_2, 3) Refund(charge_2, 5) Refund(charge_5, 8) Hold(allocation_4, 9) hold_2 = Hold(allocation_4, 8) hold_2.active = False charge_1.job = Job("1.1") charge_2.job = Job("1.2") charge_3.job = Job("1.3") charge_4.job = Job("2.1") charge_5.job = Job("2.2") charge_1.job.user = user_1 charge_2.job.user = user_2 charge_3.job.user = user_1 charge_4.job.user = user_1 charge_5.job.user = user_2 charge_1.datetime = datetime(2000, 1, 2) charge_2.datetime = datetime(2000, 1, 3) charge_3.datetime = datetime(2000, 1, 4) charge_4.datetime = datetime(2000, 1, 5) charge_5.datetime = datetime(2000, 1, 6) charge_1.job.start = datetime(2000, 1, 1) charge_2.job.start = datetime(2000, 1, 2) charge_3.job.start = datetime(2000, 1, 3) charge_4.job.start = datetime(2000, 1, 4) charge_5.job.start = datetime(2000, 1, 5) allocations = [allocation_1, allocation_2, allocation_3, allocation_4] Session.add_all(allocations) Session.flush() assert_equal( list(allocation_summary(allocations, before=datetime(2000, 1, 4))), [(allocation_1, 1, 6, 4), (allocation_2, 2, 7, 8), (allocation_3, 0, 0, 30), (allocation_4, 0, 0, 17)])