I am trying to Querying Multiple Database table and display results in races index.html.erb
Schema is this
ActiveRecord::Schema.define(version: 2019_05_21_043953) do
create_table “days”, force: :cascade do |t|
t.date “day”
t.integer “season_id”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.index [“season_id”], name: “index_days_on_season_id”
end
create_table “races”, force: :cascade do |t|
t.boolean “display”
t.text “racename”
t.text “class”
t.integer “season_id”
t.integer “day_id”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.index [“day_id”], name: “index_races_on_day_id”
t.index [“season_id”], name: “index_races_on_season_id”
end
create_table “seasons”, force: :cascade do |t|
t.integer “year”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
end
end
A typical query in rails console --sandbox Querying all the races for that day
SELECT day,class,racename FROM RACES
INNER JOIN DAYS on days.id = races.day_id
INNER JOIN SEASONS on days.season_id = seasons.id
WHERE days.id = ‘46’
“2019-04-20” “Pee Wee” “Pee Wee Div 2”
“2019-04-20” “Pee Wee” “Pee Wee Div 1”
“2019-04-20” “Juniors” “Juniors Div 2 Shilo Tocher Cup”
“2019-04-20” “Juniors” “Juniors Div 1 Gavin Tavendale Cup”
“2019-04-20” “Solo” “Solo’s Robin McKinnon Plate”
“2019-04-20” “Side Cars” “Sidecars Tony Schafer Cup”
I have this as the race model
class Race < ApplicationRecord
belongs_to :season
belongs_to :day
class << self
def with_season(seasons)
joins(:seasons).where(seasons: {id: seasons})
end
def with_day(days)
joins(:days).where(days: {id: days})
end
def with_race(races)
joins(:races).where(races: {id: races})
end
end
end
I want to select the Season ,the day and the race
with something like this in races index.html.erb
<%= f.label :day_id , class: ‘control-label’ %>
<%= collection_select(:race, :day_id, Day.all, :id, :day, {}, {:multiple => false}) %>
So far I have this for races index.html.erb
<%= notice %>
Races
@races = Race.with_season(params[:season_id]).with_day(params[:day_id]).with_race(params[:_id])
<% @races.each do |race| %>
<% end %>
| Display | Racename | Class | Season | Day | |||
|---|---|---|---|---|---|---|---|
| <%= race.display %> | <%= race.racename %> | <%= race.class %> | <%= race.season %> | <%= race.day %> | <%= link_to 'Show', race %> | <%= link_to 'Edit', edit_race_path(race) %> | <%= link_to 'Destroy', race, method: :delete, data: { confirm: 'Are you sure?' } %> |
<%= link_to ‘New Race’, new_race_path %>
Any Questions or suggestions just post please
Cheers Dave
