liquid_feedback_frontend
annotate model/direct_voter.lua @ 140:21ddb78dd09d
add missing group by for Issue search selector
fixes bug #262
fixes bug #262
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Wed Oct 06 14:14:23 2010 +0200 (2010-10-06) |
| parents | afd9f769c7ae |
| children | ea3d3757ddc3 |
| rev | line source |
|---|---|
| bsw/jbe@0 | 1 DirectVoter = mondelefant.new_class() |
| bsw/jbe@5 | 2 DirectVoter.table = 'direct_voter' |
| bsw/jbe@5 | 3 DirectVoter.primary_key = { "issue_id", "member_id" } |
| bsw/jbe@0 | 4 |
| bsw/jbe@0 | 5 DirectVoter:add_reference{ |
| bsw/jbe@0 | 6 mode = 'm1', |
| bsw/jbe@0 | 7 to = "Issue", |
| bsw/jbe@0 | 8 this_key = 'issue_id', |
| bsw/jbe@0 | 9 that_key = 'id', |
| bsw/jbe@0 | 10 ref = 'issue', |
| bsw/jbe@0 | 11 } |
| bsw/jbe@0 | 12 |
| bsw/jbe@0 | 13 DirectVoter:add_reference{ |
| bsw/jbe@0 | 14 mode = 'm1', |
| bsw/jbe@0 | 15 to = "Member", |
| bsw/jbe@0 | 16 this_key = 'member_id', |
| bsw/jbe@0 | 17 that_key = 'id', |
| bsw/jbe@0 | 18 ref = 'member', |
| bsw/jbe@0 | 19 } |
| bsw/jbe@5 | 20 |
| bsw/jbe@5 | 21 function DirectVoter:by_pk(issue_id, member_id) |
| bsw/jbe@5 | 22 return self:new_selector() |
| bsw/jbe@5 | 23 :add_where{ "issue_id = ? AND member_id = ?", issue_id, member_id } |
| bsw/jbe@5 | 24 :optional_object_mode() |
| bsw/jbe@5 | 25 :exec() |
| bsw/jbe@5 | 26 end |