Hi,

I have the following "generate_report" method being called from a rake task, which gets a hash as an input, that contains the reported hours spent by each user on a task and outputs the data as a .csv report.

  desc "Task reporting"
  task :report, [:inp_dt] => [:environment] do |t, args|

    h = select_data(args.inp_dt) /* not shown here */
    generate_report(h)

  end


def generate_report(h)

  out_dir = File.dirname(__FILE__) + '/../../output'
  myfile = "#{out_dir}" + "/monthly_#{Date.today.strftime("%m%d%Y")}.csv"
  writer = CSV.open(myfile, 'w')

  h.each do |h,v|
    v.each do |key,val|
      writer << val
    end
  end
  writer.close

end

where h =

{:BILL=>{:PROJA=>["CYR", "00876", "2", 24], :PROJB=>["EPR", "00876", "2", 16]}, :JANE=>{:PROJA=>["TRB", "049576", "2", 16]}}

I would like to set/update a 'processed' flag for each reported transaction and only commit the update when the file is written correctly or rollback the updates when the task fails. How can I accomplish this.

thanks, ash