How to do active record associations with non-plural table names?

Question

I'm trying to get an active record association working for two tables that do not have a plural form but still can imply multiple ( Equipment and JobEquipment)

I keep getting the following error when I try and get the Equipment from a the JobEquipment object. The relationship is 1 to Many ( 1 piece of equipment can have Many Job Equipment instances)

job_equipment.equipment

NoMethodError: undefined method `fetch_value' for nil:NilClass

Currently my models look like this

class JobEquipment < ApplicationRecord
    self.table_name = "job_equipment"
    belongs_to :equipment, :class_name=>"Equipment"
    // I tried adding the :class_name=>model to indicate to active record that this would be the plural name as well but no luck.

end

class Equipment < ApplicationRecord
    self.table_name = 'equipment'
    has_many :job_equipment, :class_name => "JobEquipment" // I don't believe this has_many association is required but I was running out of ideas so I've added it just incase.
end

The JobEquipment table has the equipment_id.

What am I missing here? All my other associations work but the tables all have plural names. I've tried a few things to get this to work. I even tried to use Equipments and JobEquipments but Rails/Active record still threw an error.

I feel like there must be a way to do this as I think a table named equipment would be very common.

Any help would be much appreciated, strangely I couldn't find any resources indicating others having issues with associations on non-plural form tables

Table name won't matter. Just make sure your associations are written as normal. — Josh Brody, Jul 04 '18 at 22:54
Check if this can help: https://stackoverflow.com/a/8737003/5239030 — iGian, Jul 05 '18 at 05:24
@iGian Thanks, I tried adding the foreign_key but no luck. Still having the same issue. — SegFaultDev, Jul 05 '18 at 15:10
@JoshBrody do you see anything wrong with my current associations? — SegFaultDev, Jul 05 '18 at 15:11
@SegFaultDev `has_many :job_equipment` should be pluralized. — Josh Brody, Jul 05 '18 at 17:26
I managed to resolve this a few weeks ago. All the comments are correct, what seemed to be causing the issue was that I was using a reserved keyword as a column name in a migration. — SegFaultDev, Jul 27 '18 at 21:11

How to do active record associations with non-plural table names?

0 Answers0