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=trueActiveRecord::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 endprojects = Project.find(:all)row = 1projects.each do |project| col = 1 project.attributes.each |key,value| @sheet.cells(row,col) = value col += 1 end row += 1end

 

于是这次也按着老思路来走了，也想用 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.newActiveRecord::Base.establish_connection(:adapter => "oracle",:username => "user",:password => "pwd",:database => "dbname",:encoding=> "utf8")class Project < ActiveRecord::Baseenddoc = REXML::Document.newpro = 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) endendstart_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_monthendputs 'ok'