Transaction


#1

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.

Thanks,
Pradeep


#2

Pradeep M. 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.


Cheers,

  • Jacob A.