bsw/jbe@0: db:query("BEGIN")
bsw/jbe@0: 
bsw/jbe@0: local suggestion = Suggestion:new()
bsw/jbe@0: 
bsw/jbe@0: suggestion.author_id = app.session.member.id
bsw/jbe@0: param.update(suggestion, "name", "description", "initiative_id")
bsw/jbe@0: suggestion:save()
bsw/jbe@0: 
bsw/jbe@0: local opinion = Opinion:new()
bsw/jbe@0: 
bsw/jbe@0: opinion.suggestion_id = suggestion.id
bsw/jbe@0: opinion.member_id     = app.session.member.id
bsw/jbe@0: opinion.degree        = param.get("degree", atom.integer)
bsw/jbe@0: opinion.fulfilled     = false
bsw/jbe@0: 
bsw/jbe@0: opinion:save()
bsw/jbe@0: 
bsw/jbe@0: db:query("COMMIT")
bsw/jbe@0: 
bsw/jbe@0: slot.put_into("notice", _"Your suggestion has been added")