Enterprise Rails

Refactor Steps

1. Locate complicated ActiveRecord queries that are repeated throughout your application. They don’t have to be identical; “similar” is a high-enough bar.

2. Write a single SQL query that returns a superset of the data from the queries in the previous step.

3. Create a database view based on that query. Be sure to choose a name that abides by ActiveRecord naming conventions. Create a view with:

   create view viewname as query;

4. Create a model based on the view. Remember to carry over any associations from the base tables but omit destroy dependencies.

5. Within associated model classes, add associations for the new view-backed model. Again, omit destroy dependencies.

6. Replace the complicated ActiveRecord queries from the first step with more concise queries against the new view-backed model.

7. Run your tests.