Advanced ActiveRecord Querying / Custom Joins

Hey there! We're thoughtbot, a design and development consultancy that brings your digital product ideas to life. We also love to share what we learn.

This coding exercise comes from Upcase, the online learning platform we run. It's part of the Advanced ActiveRecord Querying course and is just one small sample of all the great material available on Upcase, so be sure to visit and check out the rest.

Exercise Intro

In this exercise, you'll write custom joins to write queries that ActiveRecord can't infer on its own.

Instructions

To start, you'll want to clone and run the setup script for the repo

git clone git@github.com:thoughtbot-upcase-exercises/custom-joins.git
cd custom-joins
bin/setup

After cloning and running bin/setup:

Edit db/schema.rb to get a sense of the database schema you'll be querying.
Take a look at the classes in app/models to get familiar with the models and associations you'll be working with.
Edit spec/models/person_spec.rb and remove the pending line from the spec.
Edit app/models/person.rb and implement without_remote_manager to get the spec passing.
Edit spec/models/person_spec.rb and remove the other pending line.
Edit app/models/person.rb again and rewrite with_employees and with_local_coworkers to make the spec pass.

You can run rake to re-run the tests at any time.

Once all the tests are passing (and there are no pending specs), you're all set!

Tips and Tricks

Watch the trail video on using custom joins and check out the documentation for joins.

Featured Solution

Check out the featured solution branch to see the approach we recommend for this exercise.

Forum Discussion

If you find yourself stuck, be sure to check out the associated Upcase Forum discussion for this exercise to see what other folks have said.

Next Steps

When you've finished the exercise, head on back to the Advanced ActiveRecord Querying course to find the next exercise, or explore any of the other great content on Upcase.

License

Credits

This exercise is maintained and funded by thoughtbot, inc.

The names and logos for Upcase and thoughtbot are registered trademarks of thoughtbot, inc.

s-espinosa/custom-joins