I would like to ask how can merge data with Mongoid, when I inserting
new data
class Record
include Mongoid::Document
include Mongoid::Attributes::Dynamic
field :header1, :type => String
field :header2, :type => String
validates :header1, uniqueness:{scope: :header2}
end
Then I want to create a database from arrays of hashes
record1 = [{“header4” =>“value4”}, {“header3” =>“value3”},
{“header5”=>“value5”}, {“header1”=>“value1”}, {“header2”=>“value2”}]
record2 = [{“header4” =>“value4”}, {“header3” =>“value3”},
{“header5”=>“value5”}, {“header1”=>“value1”}, {“header2”=>“value2”}]
all_records= [record1, record2]
And I want to create new database record and if data with same keys
(header1+header2) already exist I want to merge this rows
all_records.each do record
record.each |do| i
Record.create!(i)
Record.where(:header1 => i[“header1”], :header2 => i[“header2”]
).update(i)
Record.index({ header1: 1, header2:1 }, { unique: true, drop_dups: true
})
end
end
But when I run this code I am getting error Mongoid::Errors::Validations
And looks like code record.index({ header1: 1, header:2 }, { unique:
true, drop_dups: true })
does not do anything, because I still getting duplicated records in
database.
What is wrong with this code? Thank you for the help!