Query Objects

Problem

A class has one or multiple complex SQL/ActiveRecord queries or scopes.

Solution

Extract those complex SQL/ActiveRecord queries or scopes to query objects located under src/api/app/queries. Those query objects are plain old Ruby objects (PORO), so they are easy to test and they can be reused if needed.

Details

Links:

• https://www.martinfowler.com/eaaCatalog/queryObject.html
• https://mkdev.me/en/posts/how-to-use-query-objects-to-refactor-rails-sql-queries
• https://github.com/infinum/rails-handbook/blob/master/Design%20Patterns/Query%20Objects.md