Jakub Troszok
Reputation: 103733
Where should I put SQL queries in Rails?
What is the best practice where should I put SQL queries in Rails?
Should I create the methods in models for example: find_all_public_items where I'm using the find methods with all the conditions, and then using them in controllers. Like that I have all the queries in one place but I miss the flexibility that every query should be exactly suited for the need.
Should I just use the find/find_by_sql in controllers - like this I'm not creating thousands of methods but i'm loosing control on how the controllers are sucking data from database.
Upvotes: 5
Views: 1249
Answers (2)
John Topley
Reputation: 115342
You should put them in your models. You might want to investigate named scopes too.
Upvotes: 7
Related Questions
- Rails activerecord where to sql
- SQL where to query in Rails
- ruby on rails should i query to db from controller
- Is it a good practice to directly write SQL query in rails?
- Newbie: Rails' way to query database in my case
- standard sql queries in rails
- Ruby on Rails3 and MySQL query best practices
- Where do I put my database query tests in rails?
- Queries or methods in Rails?
- What is your convention for specifying complex SQL queries in Rails?