Sha256: 69c5aa1b48f81c4e882a13259d38a48132f018424c20c0d2b437c5fc7bb2f931
Contents?: true
Size: 1.28 KB
Versions: 8
Compression:
Stored size: 1.28 KB
Contents
require 'csv'
module Unidom
module Common
module DataHelper
##
# 以 CSV 的格式加载 file_name 对应的文件，利用闭包遍历每一行。如：
# Unidom::Common::DataHelper.each_csv_row '/var/file.csv' do |line|
# puts line.inspect
# end
def each_csv_row(file_name, &block)
started_at = Time.now
puts "Importing from CSV file: #{file_name}."
if file_name.blank?
puts "#{file_name} doesn't exist."
abort 1
end
CSV.foreach file_name, { encoding: 'UTF-8', headers: :first_row }, &block
puts "#{Time.now-started_at} seconds was spent to handle the given CSV."
end
##
# 根据日期文本 date_text 解析出时间，如果日期文本为空，则返回指定的时间或当前时间。如：
# Unidom::Common::DataHelper.parse_time '2000-01-01' # 2000-01-01 00:00:00
# Unidom::Common::DataHelper.parse_time '' # Time.now
# Unidom::Common::DataHelper.parse_time nil, Time.now-1.minute # Time.now-1.minute
def parse_time(date_text, default = Time.now)
return default if date_text.blank?
date = Date.parse date_text
Time.utc date.year, date.month, date.day
end
end
end
end
Version data entries
8 entries across 8 versions & 1 rubygems