free.sh

#!/bin/sh

# Params
# 1: the UTC hour 0--23 at which the free electricity starts.

planDir="/home/rwb/Luxopus/plans"
f=$(ls "$planDir" | tail -1)

if [ -z "$1" ]; then
	echo "Parameter is required."
	exit 1
fi

d1=$( date -u -d "$1" )
if [ $? -ne 0 ];  then
  echo "Parameter must be a date."
  exit 1
fi

dj=$( date -u -d "$1" +%Y-%m-%dT%H:00:00Z )
djj=$( date -u -d "$1 +1 hour" +%Y-%m-%dT%H:00:00Z )
 
echo "Setting buy price to zero at UTC $d1 in plan ${f}."
echo "dj is $dj"
echo "djj is $djj"

# Find the last entry where .Start is before d and slap it about.
p=$( cat ${planDir}/${f} | jq --arg dj "$dj" '[ .Plans[] | select ( .Start | fromdateiso8601 < $dj ) ] | last ' )

if [ -z "$p" ]; then
	echo "No plan found."
	exit 1
fi

#pNew=$( echo "$p" | jq  --arg dj "$dj" ' .Start |= $dj | .Buy |= 0 | .Action.ChargeFromGrid |= 100 | .Action.DischargeToGrid |= 100 | .New |= "NEW" ' )
pNew=$( echo "$p" | jq  --arg dj "$dj" ' .Start |= $dj | .Buy |= 0 ' )
pAfter=$( echo "$p" | jq --arg djj "$djj" ' .Start |= $djj ' )

r=$( cat ${planDir}/${f} | jq --argjson pNew "$pNew" --argjson pAfter "$pAfter" ' [ .Plans[], $pNew, $pAfter ] | sort_by( .Start | fromdateiso8601 ) | { Plans: . } ' )

#echo "$r" 

#echo "--- EXIT ---"
#exit 1

# Replace file.
echo "$r" > "${planDir}/${f}.tmp"
mv "${planDir}/${f}.tmp" "${planDir}/$f"

# Update influx in case a new plan is generated which supersedes this one.
token="Hb9Hv6jvOe6RqPVZKTPArOouN5DBZ46nmRonNuTio94edn70Ayqgg5TWxKtTKuceQhnL5UKQqhgdWB4uwEwuKA=="

djns=$( date -u -d "$dj" +"%s *1000000000" | bc )

influx write --org mini31 --bucket solar --token $token "prices,fuel=electricity,type=buy,tariff=E-1R-FLUX-IMPORT-23-02-14-E prices=0.0 $djns"

pSell=$( echo "$p" | jq -r '.Sell' )
influx write --org mini31 --bucket solar --token $token "prices,fuel=electricity,type=sell,tariff=E-1R-FLUX-IMPORT-23-02-14-E prices=$pSell $djns"

djjns=$( date -u -d "$djj" +"%s *1000000000" | bc )

pBuy=$(  echo "$pAfter" | jq -r '.Buy' )
influx write --org mini31 --bucket solar --token $token "prices,fuel=electricity,type=buy,tariff=E-1R-FLUX-IMPORT-23-02-14-E prices=$pBuy $djjns"

influx write --org mini31 --bucket solar --token $token "prices,fuel=electricity,type=sell,tariff=E-1R-FLUX-IMPORT-23-02-14-E prices=$pSell $djjns"