search climbs by gym

climb.rb

class Climb < ApplicationRecord
  include PgSearch

  belongs_to :user
  belongs_to :route 
  has_many :comments
end

gym.rb

class Gym < ApplicationRecord
  include PgSearch

  has_many :routes
  has_many :memberships
  has_many :users, :through => :memberships
 end

route.rb

class Route < ApplicationRecord
  include PgSearch
  
  belongs_to :gym
  belongs_to :user
  has_many :climbs
  has_many :comments
end

task.txt

Task: find which climbs are set at a particular gym

example:
@gym = gym.find(name: "stronghold")
@routes = Climb.where(gym_id: @gym.id)

has_many :climbs, :through => :routes
has_one :gym, :through => :routes

^ STILL doesnt do quite what i want. allows me to do @gym.climbs but not Climb.where(gym_id: @gym.id)

@climbs.joins(:route).where(gym_id: @gym.id)
I know something like this ^ should maybe work as well.

What's wrong with @gym.climbs ?

absolutely nothing....ive got to stop doing 10 hours in front of a screen. (just picked this back up after yesterday)
I think it felt alien to be doing the lookup on gyms instead of climbs, this was part of a search function im finishing.

sorry for wasting your time.

side note, im really enjoying postgres. got this up n running:

#pg search scope for route identifier
pg_search_scope(
:search_identifier,
:against => %i(identifier),
:using => {
:tsearch => {:prefix => true},
:trigram => {:threshold => 0.1}
}
)