Module: Unidom::Common::DataHelper

Defined in:
lib/unidom/common/data_helper.rb

Instance Method Summary collapse

Instance Method Details

#each_csv_row(file_name, &block) ⇒ Object

以 CSV 的格式加载 file_name 对应的文件，利用闭包遍历每一行。如： Unidom::Common::DataHelper.each_csv_row ‘/var/file.csv’ do |line|

puts line.inspect

end



13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/unidom/common/data_helper.rb', line 13

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

#parse_time(date_text, default = Time.now) ⇒ Object

根据日期文本 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



34
35
36
37
38
 
# File 'lib/unidom/common/data_helper.rb', line 34

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