Question

我已经用书面方法将数据从CSV中输入到DB。这对我来说,是一小小 ,远离南斯拉夫:

  def self.from_csv(data)
    c = Company.new
    FasterCSV.parse(data) do |row|
      c.name = row[0]
      c.street = row[1]
      c.street_number = row[2]
      c.apartament_number = row[3]

      c.city = row[4]
      c.post_code = row[5]
      c.post_office_city = row[6]

      c.nip = row[7]
      c.regon = row[8]
      c.vatin = row[9]
    end
  end

如何使其更加性化,或者在装上数据方面已经有什么平衡?

Answer 1

http://www.chris.com/ascii/index.php?art=people/naked%20ladies”

#          ___
#   _  _.-"_< }
#    ""--"" 7(
#          /())
#         / )/
#        ^ ( 
#          / /
#         /. 
#        //
# ______/L___ sexii
def self.from_csv(data)
  #...
end

但是,我对你的法典所看到的唯一问题是,你不能轻易地重新安排属性,因为你必须人工更新所有指数。我更喜欢用一个阵列的名词清单,并使用一些鲁比拉动态方法:

def self.from_csv(data)
  company = new
  row = CSV.parse_line(data)
  [:name, :street, :street_number, :apartament_number,
   :city, :post_code, :post_office_city,
   :nip, :regon, :vatin].each_with_index do |name, i|
    company.send(:"#{name}=", row[i])
  end
  company
end

还指出,您最终必须退回一个经过分析的公司案例,否则,在打上时,你将获得一些随机价值。

Answer 2

c = Company.new
cols = ["name", "street", "street_number", "apartament_number", "city", "post_code", "post_office_city", "nip", "regon", "vatic"]

FasterCSV.parse(data) do |row|
  cols.each_index { |i| c.send("#{cols[i]}=", row[i]) }
end

Answer 3

我写了这一轻重包装,装上了CSV文档:

https://github.com/stackpilot/loady

它使用1.9瓦卢,并使用标准卢布的CSV图书馆(前称“快车”)。

你这样做:

Loady.csv "/your/file.csv" do |row|
  Company.create row.to_attributes [:name, :street, :street_number, ...]
end

友情链接