do_upload.rake

if (local_gem_dir = File.join(File.dirname(__FILE__), '..', '..', 'gems')) && $BUNDLE.nil?
  $BUNDLE = true; Gem.clear_paths; Gem.path.unshift(local_gem_dir)
end
Merb.start_environment(:environment => ENV['MERB_ENV'] || 'production')

namespace :mostfit do
  desc "Create DB from excel sheet"
  task :upload, :directory, :filename, :erase do |task, args|

    # to run this rake task manually, invoke it as follows from the command line
    # uuid should correspond to a directory in merb-root/uploads
    # filename is the name of the escel file
    # the third argument decides whether you want to destroy old data or not UNTESTED
    # rake mostfit:upload["filename.xls","uuid","false"]

    require "log4r"
    #    include Log4r
    filename  = args[:filename]
    directory = args[:directory]

    file      = Upload.new(filename, directory)          
    #create logger
    log       = Log4r::Logger.new 'upload_log'
    pf        = Log4r::PatternFormatter.new(:pattern => "<b>[%l]</b> %m")
    file_log  = Log4r::FileOutputter.new('output_log', :filename => [Merb.root, "public", "logs", file.directory].join("/"), :truncate => false, :formatter => pf)
    log.add(file_log) 
    p file_log
    log.level = Log4r::INFO

    log.info("File has been uploaded to the server. Now processing it into a bunch of csv files")
    # puts `ruby #{Merb.root}/lib/tasks/excel.rb #{directory} #{filename}`
    log.info("CSV extraction complete. Processing files.")
    file.load_csv(log, args[:erase] == "true")
    log.info("CSV files are now loaded into the DB. Creating loan schedules. This may take a few minutes.")
   # Loan.all.each{|l| l.update_history}
    #these 3 rake task are meant to prepare db with the new-layout branch.
    Rake::Task['mostfit:db:prepare'].invoke
    Rake::Task['mostfit:conversion:update_loan_cache'].invoke
    Rake::Task['mostfit:data:create_history'].invoke
    log.info("<h2>Processing complete! Your MIS is now ready for use. Please take a note of all the errors reported here(if any) and rectify them.</h2>")            
  end
end