blog_example_p1.2.ex

defmodule ProductVehicle do
  def vehicles_that_fit_product(query \\ ProductVehicle, product_id) do
    query
    |> join(:inner,
            [products_vehicles],
            product in assoc(products_vehicles, :product))
    |> join(:inner,
            [products_vehicles],
            vehicle in assoc(products_vehicles, :vehicle))
    |> join(:inner,
            [_, _, vehicle],
            vehicle in assoc(vehicle, :vehicle_model))
    |> join(:inner,
            [_, _, _, vehicle_model],
            vehicle in assoc(vehicle_model, :vehicle_make))
  end
end