influxdb gem sample

import.rb

require 'influxdb'
require 'time'

class Time
  def timezone(timezone = 'UTC')
    old = ENV['TZ']
    utc = self.dup.utc
    ENV['TZ'] = timezone
    output = utc.localtime
    ENV['TZ'] = old
    output
  end
end

database = 'electric_usage'
influxdb = InfluxDB::Client.new(database,
                                host: '192.168.x.x',
                                time_precision: 's')

File.open('2016_usage.csv', 'r') do |file|
  file.each_line do |line|
    p data = line.chomp.split(',')

    time = Time.parse(data[0].split('+')[0]).timezone('Asia/Tokyo').to_i
    value = data[1].to_f

    name = 'usage'
    write_data = { values: { value: value }, timestamp: time }

    influxdb.write_point('usage', write_data)
  end
end