ruby 导出xml

今天有个任务，要求写个ruby文件，将数据导入到xml文件

由于以前也经常做这样的导出，不过那个一般只涉及到单个数据表(而且是直接导入到excel中)，比较简单，所以就直接用ruby 连接到数据库了

ENV['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.AL32UTF8' require "rubygems" gem "activerecord" require "active_record" $KCODE = 'u' require 'jcode' require 'iconv' require 'win32ole' convert = Iconv.new('UTF-8//IGNORE', 'GB2312//IGNORE') excel = WIN32OLE.new("excel.application") excel.visible=true ActiveRecord::Base.establish_connection( :adapter => "oracle", :username => "user", :password => "pwd", :database => "dbname", :encoding=> "utf8" ) workbook = excel.Workbooks.open("D://stat.xls") @sheet = workbook.Worksheets(1) class Project < ActiveRecord::Base end projects = Project.find(:all) row = 1 projects.each do |project| col = 1 project.attributes.each |key,value| @sheet.cells(row,col) = value col += 1 end row += 1 end

 

于是这次也按着老思路来走了，也想用 require "rexml/document"，然后直接生成xml文件，

ENV['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.AL32UTF8' require "rubygems" gem "activerecord" require "active_record" $KCODE = 'u' require 'jcode' require 'iconv' require 'rexml/document' convert = Iconv.new('UTF-8//IGNORE', 'GB2312//IGNORE') doc = REXML::Document.new ActiveRecord::Base.establish_connection( :adapter => "oracle", :username => "user", :password => "pwd", :database => "dbname", :encoding=> "utf8" ) class Project < ActiveRecord::Base end doc = REXML::Document.new pro = doc.add_element('projects') projects = Project.find(:all) projects.each do |pro| pro = doc.add_element('project',{'id'=>pro.id}) project_name = pro.add_element('project_name') project_name.add_text(pro.project_name) ... end .... doc.write()

这个理论上是可以实现的，但由于这次导出到数据涉及到多个模块，而且会要调用到模块中的很多方法

最后虽然弄了一个多小时，但最后还是由于模块太复杂，而不能实现

 

最后终于，用到了很牛的方法：require "net/http"

利用该方法，可以直接链接到网页，将网页生成的数据直接写到xml文件中就可以了，总共所花时间不到10分钟：）

require "net/http" class Time def last_day_of_month mdays = [nil, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31] mdays[2] = 29 if Date.leap?(self.year) last_day = mdays[self.month] Time.mktime(self.year, self.month, last_day) end def first_day_of_month Time.mktime(self.year,self.month,1) end def next_month return Time.mktime(self.year+1,1,self.day) if self.month + 1 > 12 return Time.mktime(self.year,self.month+1,self.day) end end start_date = Time.local(2008,11,1) puts 'start' while start_date < Time.now date1_t = start_date.first_day_of_month.strftime("%Y-%m-%d") date2_t = start_date.last_day_of_month.strftime("%Y-%m-%d") date1 = [date1_t,"00:00:01"].join('+'); date2 = [date2_t,"23:59:59"].join('+') file_name = ["d://",date1_t,'~',date2_t,'.xml'].join file = File.open(file_name,'w') file.puts Net::HTTP.get(URI.parse("http://127.0.0.1:3003/controller/index?api=project_list&date1=#{date1}&date2=#{date2}&user=user&pwd=pwd")) file.close start_date = start_date.next_month end puts 'ok'