From: Pen Ttt <myocean135@...>
Date: 2010-09-23T14:39:04+09:00
Subject: Re: how to get Mycompute.sum().mean=2.5?

a friend  help me solve it,

require 'rubygems'
require 'mysql'
class  Analyse
def self.get(from,to)
  object = Analyse.new
  open('/tmp/result','w') do  |wfile|
  dbh = Mysql.real_connect("localhost", "root", "******")
  dbh.query("use  stock;")
  result=dbh.query("select symbol,date,open,high,low,close  \
 from  `#{symbol}`    where (date > from and date< to) order by date
asc;")
  compute=[]
  result.each{|row|   wfile.puts row.join(";")}
  end
  return object
end

  def  self.mean
   amean=[]
   open('/tmp/result','r'){|rfile|
      line=rfile.readlines
      line.each{|item|
        amean<< item.chomp.split(";")[-1].to_f
       }}
     amean=amean.compact
     amean.inject(0){|s,n| s+n}/(amean.size.to_f)
   end
end
end
-- 
Posted via http://www.ruby-forum.com/.