transaction

Pradeep Maddi wrote:

Hi all,

I have a scenario where i will uploading data from excel to database. My
condition for uploading is:

If any of the record has an error all the records should be rolled back.

Plz give me suggestions how to implement if we have a loop.

Let's say you have a ExcelData class which is a subclass of ActiveRecord:

ExcelData.transaction do
   theExcelRecords.each do |currentRecord|
     ExcelData.create!( currentRecord )
   end
end

In this case if any of the currentRecord's are unable to be saved the whole transaction will be rolled back.

I hope this was the information you were looking for.