遗留数据处理

gem install magic_multi_connections

require 'rubygems'
require_gem 'activerecord'
require_gem 'magic_multi_connections'

ActiveRecord::Base.establish_connection(:adapter=>'sqlserver',:host=>'localhost',:database=>'hbpcvs',:username=>'sa')

class Member < ActiveRecord::Base
self.table_name = "t_rm_vip_info"
self.primary_key = "card_flowno"
end

class MemberScore < ActiveRecord::Base
self.table_name="t_memtotalscore"
self.primary_key="membercode"
end

scores = {}
MemberScore.find(:all).each{|ms| scores[ms.membercode]=ms.remainderscore}

print "Fetch member's amount:",members.size,"\n"

class UserInfo < ActiveRecord::Base
establish_connection(:adapter=>'mysql',:host=>'localhost',:database=>'romh',:username=>'root')
end

Member.find(:all).each do |m|
u = UserInfo.new
m.attribute_names.each{|ar| u.send("#{ar}=",m.send("#{ar}"))if u.attribute_present?(ar)}
u.card_no = m.id
#其他的属性
#...
#额外另一张表用户的积分
u.socres=scores[m.id].nil? ? 0:scores[m.id]
u.save!
end