liquid_feedback_frontend: ebb3c5fa158d model/issue.lua

liquid_feedback_frontend

view model/issue.lua @ 1225:ebb3c5fa158d

Removed exhaustive GROUP BY list in Issue:get_search_selector(...) due to PRIMARY KEY (PostgreSQL 9.1 feature)

author	jbe
date	Tue Dec 01 16:43:54 2015 +0100 (2015-12-01)
parents	701a5cf6b067
children	8288027edb54

line source

1 Issue = mondelefant.new_class()

2 Issue.table = 'issue'

4 local new_selector = Issue.new_selector

6 function Issue:new_selector()

7 local selector = new_selector(self)

8 selector:add_field("justify_interval(admission_time)::text", "admission_time_text")

9 selector:add_field("justify_interval(discussion_time)::text", "discussion_time_text")

10 selector:add_field("justify_interval(verification_time)::text", "verification_time_text")

11 selector:add_field("justify_interval(voting_time)::text", "voting_time_text")

12 selector:add_field("justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now())", "state_time_left")

13 selector:add_field("justify_interval(now() - issue.closed)", "closed_ago")

14 return selector

15 end

17 Issue:add_reference{

18 mode = 'm1',

19 to = "Area",

20 this_key = 'area_id',

21 that_key = 'id',

22 ref = 'area',

23 }

25 Issue:add_reference{

26 mode = 'm1',

27 to = "Policy",

28 this_key = 'policy_id',

29 that_key = 'id',

30 ref = 'policy',

31 }

33 Issue:add_reference{

34 mode = '1m',

35 to = "Initiative",

36 this_key = 'id',

37 that_key = 'issue_id',

38 ref = 'initiatives',

39 back_ref = 'issue',

40 default_order = 'initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id'

41 }

43 Issue:add_reference{

44 mode = '1m',

45 to = "Interest",

46 this_key = 'id',

47 that_key = 'issue_id',

48 ref = 'interests',

49 back_ref = 'issue',

50 default_order = '"id"'

51 }

53 Issue:add_reference{

54 mode = '1m',

55 to = "Supporter",

56 this_key = 'id',

57 that_key = 'issue_id',

58 ref = 'supporters',

59 back_ref = 'issue',

60 default_order = '"id"'

61 }

63 Issue:add_reference{

64 mode = '1m',

65 to = "DirectVoter",

66 this_key = 'id',

67 that_key = 'issue_id',

68 ref = 'direct_voters',

69 back_ref = 'issue',

70 default_order = '"member_id"'

71 }

73 Issue:add_reference{

74 mode = '1m',

75 to = "Vote",

76 this_key = 'id',

77 that_key = 'issue_id',

78 ref = 'votes',

79 back_ref = 'issue',

80 default_order = '"member_id", "initiative_id"'

81 }

83 Issue:add_reference{

84 mode = '1m',

85 to = "Delegation",

86 this_key = 'id',

87 that_key = 'issue_id',

88 ref = 'delegations',

89 back_ref = 'issue'

90 }

92 Issue:add_reference{

93 mode = 'mm',

94 to = "Member",

95 this_key = 'id',

96 that_key = 'id',

97 connected_by_table = 'interest',

98 connected_by_this_key = 'issue_id',

99 connected_by_that_key = 'member_id',

100 ref = 'members'

101 }

102

103 Issue:add_reference{

104 mode = 'mm',

105 to = "Member",

106 this_key = 'id',

107 that_key = 'id',

108 connected_by_table = 'direct_interest_snapshot',

109 connected_by_this_key = 'issue_id',

110 connected_by_that_key = 'member_id',

111 ref = 'interested_members_snapshot'

112 }

113

114 Issue:add_reference{

115 mode = 'mm',

116 to = "Member",

117 this_key = 'id',

118 that_key = 'id',

119 connected_by_table = 'direct_voter',

120 connected_by_this_key = 'issue_id',

121 connected_by_that_key = 'member_id',

122 ref = 'direct_voters'

123 }

124

125 Issue:add_reference{

126 mode = "11",

127 to = mondelefant.class_prototype,

128 this_key = "id",

129 that_key = "issue_id",

130 ref = "member_info",

131 back_ref = "issue",

132 selector_generator = function(list, options)

133 assert(options.member_id, "member_id mandatory for member_info")

134 local ids = { sep = ", " }

135 for i, object in ipairs(list) do

136 local id = object.id

137 if id ~= nil then

138 ids[#ids+1] = {"?", id}

139 end

140 end

141 local sub_selector = Issue:get_db_conn():new_selector()

142 if #ids == 0 then

143 return sub_selector:empty_list_mode()

144 end

145 sub_selector:from ( "issue" )

146 sub_selector:add_field ( "issue.id", "issue_id" )

147 sub_selector:add_field { '(delegation_info(?, null, null, issue.id, ?)).*', options.member_id, options.trustee_id }

148 sub_selector:add_where { 'issue.id IN ($)', ids }

149

150 local selector = Issue:get_db_conn():new_selector()

151 selector:add_from ( "issue" )

152 selector:join(sub_selector, "delegation_info", "delegation_info.issue_id = issue.id" )

153 selector:left_join ( "member", "first_trustee", "first_trustee.id = delegation_info.first_trustee_id" )

154 selector:left_join ( "member", "other_trustee", "other_trustee.id = delegation_info.other_trustee_id" )

155 selector:add_field ( "delegation_info.*" )

156 selector:add_field ( "first_trustee.name", "first_trustee_name" )

157 selector:add_field ( "other_trustee.name", "other_trustee_name" )

158 selector:left_join ( "direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", options.member_id })

159 selector:add_field ( "direct_voter.member_id NOTNULL", "direct_voted")

160 selector:left_join ( "non_voter", nil, { "non_voter.issue_id = issue.id AND non_voter.member_id = ?", options.member_id })

161 selector:add_field ( "non_voter.member_id NOTNULL", "non_voter" )

162 selector:left_join ( "direct_interest_snapshot", nil, { [[

163 direct_interest_snapshot.issue_id = issue.id AND

164 direct_interest_snapshot.event = issue.latest_snapshot_event AND

165 direct_interest_snapshot.member_id = ?

166 ]], options.member_id })

167 selector:add_field ( "direct_interest_snapshot.weight", "weight" )

168 return selector

169 end

170 }

171

172 function Issue.list:load_everything_for_member_id(member_id)

173 local areas = self:load("area")

174 areas:load("unit")

175 self:load("policy")

176 if member_id then

177 self:load("member_info", { member_id = member_id })

178 end

179 local initiatives = self:load("initiatives")

180 initiatives:load_everything_for_member_id(member_id)

181 end

182

183 function Issue.object:load_everything_for_member_id(member_id)

184 local areas = self:load("area")

185 areas:load("unit")

186 self:load("policy")

187 if member_id then

188 self:load("member_info", { member_id = member_id })

189 end

190 local initiatives = self:load("initiatives")

191 initiatives:load_everything_for_member_id(member_id)

192 end

193

194

195

196 function Issue:get_state_name_for_state(value)

197 local state_name_table = {

198 admission = _"Admission",

199 discussion = _"Discussion",

200 verification = _"Verification",

201 voting = _"Voting",

202 canceled_revoked_before_accepted = _"Revoked (during admission)",

203 canceled_issue_not_accepted = _"Failed 1st quorum",

204 canceled_after_revocation_during_discussion = _"Revoked (during discussion)",

205 canceled_after_revocation_during_verification = _"Revoked (during verification)",

206 canceled_by_admin = _"Canceled by administrative intervention",

207 calculation = _"Calculation",

208 canceled_no_initiative_admitted = _"All initiatives failed 2nd quorum",

209 finished_without_winner = _"Disapproved",

210 finished_with_winner = _"Finished with winner",

211 }

212 return state_name_table[value] or value or ''

213 end

214

215

216

217 function Issue:get_search_selector(search_string)

218 return self:new_selector()

219 :join('"initiative"', nil, '"initiative"."issue_id" = "issue"."id"')

220 :join('"draft"', nil, '"draft"."initiative_id" = "initiative"."id"')

221 :add_where{ '"initiative"."text_search_data" @@ "text_search_query"(?) OR "draft"."text_search_data" @@ "text_search_query"(?)', search_string, search_string }

222 :add_group_by('"issue"."id"')

223 end

224

225 function Issue:modify_selector_for_state(initiatives_selector, state)

226 if state == "new" then

227 initiatives_selector:add_where("issue.accepted ISNULL AND issue.closed ISNULL")

228 elseif state == "accepted" then

229 initiatives_selector:add_where("issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL")

230 elseif state == "frozen" then

231 initiatives_selector:add_where("issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL")

232 elseif state == "voting" then

233 initiatives_selector:add_where("issue.fully_frozen NOTNULL AND issue.closed ISNULL")