1 Initiator = mondelefant.new_class()

2 Initiator.table = 'initiator'

3 Initiator.primary_key = { "initiative_id", "member_id" }

4

5 Initiator:add_reference{

6 mode = 'm1',

7 to = "Initiative",

8 this_key = 'initiative_id',

9 that_key = 'id',

10 ref = 'initiative',

11 }

12

13 Initiator:add_reference{

14 mode = 'm1',

15 to = "Member",

16 this_key = 'member_id',

17 that_key = 'id',

18 ref = 'member',

19 }

20

21 function Initiator:by_pk(initiative_id, member_id)

22 return self:new_selector()

23 :add_where{ "initiative_id = ?", initiative_id }

24 :add_where{ "member_id = ?", member_id }

25 :optional_object_mode()

26 :exec()

27 end

28

29 function Initiator:selector_for_invites(member_id)

30 return Initiative:new_selector()

31 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")

32 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", member_id })

33 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")

34 end