Rails query from three models using joins

Question

I have the following models in my Rails application:

class Test
    has_many :tests_profiles
    has_many :class_profiles

class TestsProfile
    belongs_to :class_profile
    belongs_to :test

class ClassProfile
    has_many :tests_profiles

I must query tests belonging to particular ClassProfile. My present helper function is like this:

def get_tests(class_profile)
        return Test.joins(:tests_profiles).where(tests_profiles: {class_profile_id: class_profile.id})

In my erb file, I am looping through the result like this:

<% tests = get_tests(class_profile) %>
    <% tests.each do |test| %>
        <th><%= test.name %></th>
    <% end %>

But the problem here is I am getting all the tests names and not the only ones associated with that particular ClassProfile. How can I correct it so that it functions that way I want it to?

'tests belonging to particular ClassProfile' - it sounds like all you need is class_profile.tests. — Marek Lipka
– Marek Lipka, Commented May 30, 2019 at 10:13
I don't understand your data model at all. You have Test associated many to one to ClassProfile? — Marek Lipka
– Marek Lipka, Commented May 30, 2019 at 10:34
You have a typo somewhere - has_many :tests_profiles but class TestProfile. Note difference between test and tests, it should be the same for both cases — Vasilisa
– Vasilisa, Commented May 31, 2019 at 6:25

Vasilisa · Accepted Answer · 2019-05-31 06:24:20Z

1

You can use has_many through here:

class Test
    has_many :tests_profiles
    has_many :class_profiles, through: :tests_profiles

class TestsProfile
    belongs_to :class_profile
    belongs_to :test

class ClassProfile
    has_many :tests_profiles
    has_many :tests, through: :tests_profiles

and use class_profile.tests.each do in the view

answered May 31, 2019 at 6:24

Vasilisa

4,6403 gold badges22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails query from three models using joins

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related