bsw@1248: NewsletterToSend = mondelefant.new_class()
bsw@1248: NewsletterToSend.table = 'newsletter_to_send'
bsw@1248: 
bsw@1248: NewsletterToSend:add_reference{
bsw@1248:   mode          = 'm1',
bsw@1248:   to            = "Newsletter",
bsw@1248:   this_key      = 'newsletter_id',
bsw@1248:   that_key      = 'id',
bsw@1248:   ref           = 'newsletter',
bsw@1248: }
bsw@1248: 
bsw@1248: NewsletterToSend:add_reference{
bsw@1248:   mode          = 'm1',
bsw@1248:   to            = "Member",
bsw@1248:   this_key      = 'recipient_id',
bsw@1248:   that_key      = 'id',
bsw@1248:   ref           = 'member',
bsw@1248: }
bsw@1248: 
bsw@1248: function NewsletterToSend:get_next()
bsw@1248:   return NewsletterToSend:new_selector()
bsw@1248:     :set_distinct("newsletter_id")
bsw@1248:     :add_order_by("newsletter_id")
bsw@1248:     :limit(1)
bsw@1248:     :optional_object_mode()
bsw@1248:     :exec()
bsw@1248: end
bsw@1248: 
bsw@1248: function NewsletterToSend:by_newsletter_id(id)
bsw@1248:   return NewsletterToSend:new_selector()
bsw@1248:     :add_where{ "newsletter_id = ?", id }
bsw@1248:     :optional_object_mode()
bsw@1248:     :exec()
bsw@1248: end