I have a table that’s currently only a primary key. Basically:
create_table “entites”, :force => true do |t|
end
class Entity < ActiveRecord::Base
has_many :entity_members
end
create_table “entity_membership”, :force => true do |t|
t.column “person_id”, :integer, :null => false
t.column “role”, :string, :null => false
t.column “entity_id”, :integer, :null => false
end
class EntityMembershp < ActiveRecord::Base
belongs_to :entity_member
belongs_to :person
end
The entity id is needed to link the aggregation to various other
models, but there’s no other information that can or should be
associated with it.
However I can’t seem to get the Entity class to create/save as it
doesn’t seem to auto-assign the id. From the console I’ve tried:
a = Entity.new
=> #<Entity:0x250fac0 @new_record=true, @attributes={}>a.save
ActiveRecord::StatementInvalid: PGError: ERROR: syntax error at or
near “)” at character 22
: INSERT INTO entities () VALUES()
[long error backtrace snipped]a = Entity.create
ActiveRecord::StatementInvalid: PGError: ERROR: syntax error at or
near “)” at character 22
: INSERT INTO entities () VALUES()
Is there anyway I can make this work? Is there anything cleaner than
adding a dummy column?
Eric