PRS price to Influxdb

crontab.sh

* * * * * /home/steve/power/price | /home/steve/power/write

price.rb

#!/usr/bin/env ruby
require "net/http"
require "uri"
require "csv"

poc = "CHANGEME"

url = "https://electricityinfo.co.nz/download/prices?search_form[run_types][]=A&search_form[market_types][]=E&search_form[nodes][]=#{poc}&search_form[tp_roll_back]=50&search_form[tp_roll_fwd]=50"

uri = URI(url)

res = Net::HTTP.get(uri)

CSV.parse(res, headers: true) do |row|
  date = Date.strptime(row["Trading Date"], "%d/%m/%Y")
  tp = row["Period"].to_i
  time = date.to_time + (tp * 1800)
  price = row["Price"].to_f / 10

  puts "price,gxp=%s,type=%s price=%s %s000000000\n" % [row["GIP/GXP"], "PRS", price.to_s, time.to_i]
end

write.sh

#!/bin/sh

HOST="localhost"
PORT="8086"
DATABASE="CHANGEME"
USERNAME="CHANGEME"
PASSWORD="CHANGEME"

curl -i -XPOST "http://$HOST:$PORT/write?db=$DATABASE&u=$USERNAME&p=$PASSWORD" --data-binary "@-"