Dear all
I have two model, Event and EventDetail
class Event < ActiveRecord::Base set_table_name "ssc_event" set_primary_key "event_id" has_one :event_detail, :class_name => 'EventDetail', :foreign_key => 'event_id' end
class EventDetail < ActiveRecord::Base set_table_name 'ssc_event_detail' set_primary_key "event_id" belongs_to :event, :class_name => 'Event', :foreign_key => 'event_id' end
The schema in ssc_event.event_id is an identity column. The schema in ssc_event_detail.event_id is an integer column
I use the following ruby code to insert a new record, but I think it is not clever.
a = Event.new a.cluster_code = "KWC" a.hosp_code = "CMC" a.save b = EventDetail.new b.id = a.id.to_i b.detail = "This is detail"
Any one have a better solution? Please share.
Many thanks Valentino