1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/model/opinion.lua	Wed Nov 18 12:00:00 2009 +0100
     1.3 @@ -0,0 +1,35 @@
     1.4 +Opinion = mondelefant.new_class()
     1.5 +Opinion.table = 'opinion'
     1.6 +Opinion.primary_key = { "member_id", "suggestion_id" } 
     1.7 +
     1.8 +Opinion:add_reference{
     1.9 +  mode          = 'm1',
    1.10 +  to            = "Initiative",
    1.11 +  this_key      = 'initiative_id',
    1.12 +  that_key      = 'id',
    1.13 +  ref           = 'initiative',
    1.14 +}
    1.15 +
    1.16 +Opinion:add_reference{
    1.17 +  mode          = 'm1',
    1.18 +  to            = "Suggestion",
    1.19 +  this_key      = 'suggestion_id',
    1.20 +  that_key      = 'id',
    1.21 +  ref           = 'suggestion',
    1.22 +}
    1.23 +
    1.24 +Opinion:add_reference{
    1.25 +  mode          = 'm1',
    1.26 +  to            = "Member",
    1.27 +  this_key      = 'member_id',
    1.28 +  that_key      = 'id',
    1.29 +  ref           = 'member',
    1.30 +}
    1.31 +
    1.32 +function Opinion:by_pk(member_id, suggestion_id)
    1.33 +  return self:new_selector()
    1.34 +    :add_where{ "member_id = ?",     member_id }
    1.35 +    :add_where{ "suggestion_id = ?", suggestion_id }
    1.36 +    :optional_object_mode()
    1.37 +    :exec()
    1.38 +end