class MS::Tcsv_file_writer
Public Class Methods
write(db,file_name,opts)
click to toggle source
# File lib/ms/tr_file_writer.rb, line 51 def self.write(db,file_name,opts) prog = Progress.new("Writing csv:") spectra = db.execute "SELECT * FROM spectra AS S JOIN peptides AS P ON S.pep_id=P.Id" total = spectra.size #write file = File.open("#{file_name}_truth.csv","w") file.puts "simulator_options=#{opts.inspect}" file.puts "rt,mz,int,centroid_id,merge_id,peptide_id,protien_id,seq,charge,abu" count = 0 num = 0 step = total/100 spectra.each do |cent| file.puts "#{cent[2]},#{cent[3]},#{cent[4]},#{cent[0]},#{cent[5]},#{cent[1]},#{cent[18]},#{cent[7]},#{cent[9]},#{cent[14]}" end file.close prog.finish! end