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.
In this exercise, you'll continue to query the same database schema from before, but using more complex concepts like subqueries.
To start, you'll want to clone and run the setup script for the repo
git clone [email protected]:thoughtbot-upcase-exercises/querying-has_many-associations.git
cd querying-has_many-associations
bin/setup
After cloning and running bin/setup, you'll see a list of pending tests. Follow the instructions in the pending test messages and implement methods on the Person model to get all the tests passing.
You can run rake to re-run the tests at any time.
After cloning and running bin/setup:
- Review
db/schema.rbto get a sense of the database schema you'll be querying. - Take a look at the classes in
app/modelsto get familiar with the models and associations you'll be working with. - Edit
spec/models/person_spec.rband remove thependingline from the first spec. - Edit
app/models/person.rband implementorder_by_location_nameto get the spec passing. - Repeat this process for the remaining pending specs in
person_spec.rb.
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!
Watch the trail video on querying has_many associations and check out the documentation for joins, distinct, and from.
Check out the featured solution branch to see the approach we recommend for this exercise.
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.
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.
querying-has_many-associations is Copyright © 2015-2018 thoughtbot, inc. It is free software, and may be redistributed under the terms specified in the LICENSE file.
This exercise is maintained and funded by thoughtbot, inc.
The names and logos for Upcase and thoughtbot are registered trademarks of thoughtbot, inc.