How to pass from model to controller Ruby on Rails

Question

I am unsure how to call a model method from a controller

In Event controller query is ran in

 class StaticPagesController < ApplicationController
    def self.all_published()
       events = 'SELECT  user_id FROM events'
       where("dotw = DAYNAME(curdate())")
    end
  end

Page_controller

  def index
    @published_posts = Event.all_published.paginate()
  end

View

  <% if @published_posts.any? %>
     <ol class="microposts">
       <%= render partial: 'shared/feed_item', collection: @published_posts %>
    </ol>
    <%= will_paginate @published_posts %>
 <% end %>

Pierre-Louis Gottfrois · Accepted Answer · 2013-08-27 05:55:00Z

1

Rails follow the "fat model, skinny controller" convention. This means that you should put your business logic, such as queries, inside your models.

In your case, the all_published method should go in your Event model such as:

class Event
  def self.all_published
    where('your sql query here')
  end
end

Then call with:

Event.all_published

Rails controllers should only be responsible of rendering / redirecting and settings views variables.

answered Aug 27, 2013 at 5:55

Pierre-Louis Gottfrois

17.6k9 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass from model to controller Ruby on Rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related