Fronius API Bash Script Logging to MariaDB: Difference between revisions
From KlavoWiki
Jump to navigationJump to search
m (David moved page Fronius API Bash Script to Fronius API Bash Script Logging to MariaDB without leaving a redirect) |
|||
Line 4: | Line 4: | ||
<pre> | <pre> | ||
#/bin/bash | #!/bin/bash | ||
Line 26: | Line 26: | ||
timeloop=$(date '+%H%M') | timeloop=$(date '+%H%M') | ||
has_param() { | |||
local term="$1" | |||
shift | |||
for arg; do | |||
if [[ $arg == "$term" ]]; then | |||
return 0 | |||
fi | |||
done | |||
return 1 | |||
} | |||
display_output () { | display_output () { | ||
Line 32: | Line 42: | ||
printf "${White}Date\t\t\tWatts\tVolts\tAMPs\tToday\tGross Total\tYear Total${NC}\n" | printf "${White}Date\t\t\tWatts\tVolts\tAMPs\tToday\tGross Total\tYear Total${NC}\n" | ||
fi | fi | ||
ETOTAL=$(cut -d. -f1 <<< "$ETOTAL") #Remove decimals from display output | |||
YTOTAL=$(cut -d. -f1 <<< "$YTOTAL") | |||
echo -e $strDateTime '\t'$PAC '\t'$VAC '\t'$IAC '\t'$ETODAY '\t'$ETOTAL'\t\t'$YTOTAL | echo -e $strDateTime '\t'$PAC '\t'$VAC '\t'$IAC '\t'$ETODAY '\t'$ETOTAL'\t\t'$YTOTAL | ||
Line 37: | Line 51: | ||
if [ $count -eq $rows ]; then | if [ $count -eq $rows ]; then | ||
count=0 | count=0 | ||
printf "\n\n" | |||
fi | fi | ||
Line 54: | Line 67: | ||
} | } | ||
main () { | |||
while [ $timeloop -lt 1930 ]; do | while [ $timeloop -lt 1930 ]; do | ||
Line 68: | Line 83: | ||
echo Exiting. | echo Exiting. | ||
echo | echo | ||
rm -f /run/solar-5kw.pid | |||
exit | exit | ||
fi | fi | ||
Line 81: | Line 98: | ||
if [ $PAC -lt 7 ] && [ $timeloop -gt 1600 ]; then | if [ $PAC -lt 7 ] && [ $timeloop -gt 1600 ]; then | ||
echo Time to exit | echo Time to exit | ||
rm -f /var/run/solar-5kw.pid | |||
exit 0 | exit 0 | ||
fi | fi | ||
if [ $ | if [ $VAC != 'null' ]; then | ||
write_sql | write_sql | ||
if [ "$Display" == "True" ] && [ $VAC != 'null' ]; then | |||
display_output | |||
fi | |||
fi | fi | ||
sleep 19 | sleep 19 | ||
done | done | ||
} | |||
#Begin | |||
if has_param '-v' "$@"; then | |||
Display=True | |||
fi | |||
if [ ! -f /var/run/solar-5kw.pid ]; then | |||
echo $$ > /var/run/solar-5kw.pid | |||
main | |||
elif pgrep -F /var/run/solar-5kw.pid; then | |||
printf "Process already running. Terminating....\n\n" | |||
else | |||
echo $$ > /var/run/solar-5kw.pid | |||
main | |||
fi | |||
#End | |||
</pre> | </pre> | ||
Latest revision as of 06:40, 23 April 2021
I have created a BASH script to save inverter data and history. I am running a Raspberry Pi and a local MariaDB server.
BASH Script
#!/bin/bash Red='\033[0;31m' Green='\033[0;32m' BrownO='\033[0;33m' Blue='\033[0;34m' Magenta='\033[0;35m' Cyan='\033[0;36m' White='\033[1;37m' NC='\033[0m' rows=20 #Lines to Display count=1 #Predefine rows db_Name=solar #Database Name db_Table=5kw #Table Name db_Server=localhost #Server Address, IP or FQDN timeloop=$(date '+%H%M') has_param() { local term="$1" shift for arg; do if [[ $arg == "$term" ]]; then return 0 fi done return 1 } display_output () { if [ $count -eq 1 ]; then printf "${White}Date\t\t\tWatts\tVolts\tAMPs\tToday\tGross Total\tYear Total${NC}\n" fi ETOTAL=$(cut -d. -f1 <<< "$ETOTAL") #Remove decimals from display output YTOTAL=$(cut -d. -f1 <<< "$YTOTAL") echo -e $strDateTime '\t'$PAC '\t'$VAC '\t'$IAC '\t'$ETODAY '\t'$ETOTAL'\t\t'$YTOTAL if [ $count -eq $rows ]; then count=0 printf "\n\n" fi ((count++)) } write_sql () { /usr/bin/mysql -D "$db_Name" -e "insert into $db_Table (date, etotal, etoday, ytotal, pac, vac, iac, fac) values ('$strDateTime', '$ETOTAL', '$ETODAY', '$YTOTAL', '$PAC', '$VAC', '$IAC', '$FAC');" } main () { while [ $timeloop -lt 1930 ]; do strDateTime=$(date '+%Y-%m-%d %H:%M:%S') timeloop=$(date '+%H%M') strVal=$(/usr/bin/curl -sG http://10.13.13.246/solar_api/v1/GetInverterRealtimeData.cgi?'Scope=Device&DataCollection=CommonInverterData&DeviceId=1') result=$? if [ $result -ne 0 ]; then echo echo Unable to access URL of inverter. echo Exiting. echo rm -f /run/solar-5kw.pid exit fi ETODAY=$(/usr/bin/jq '.Body.Data.DAY_ENERGY.Value' <<< $strVal) ETOTAL=$(/usr/bin/jq '.Body.Data.TOTAL_ENERGY.Value' <<< $strVal) YTOTAL=$(/usr/bin/jq '.Body.Data.YEAR_ENERGY.Value' <<< $strVal) PAC=$(/usr/bin/jq '.Body.Data.PAC.Value' <<< $strVal) VAC=$(/usr/bin/jq '.Body.Data.UAC.Value' <<< $strVal) IAC=$(/usr/bin/jq '.Body.Data.IAC.Value' <<< $strVal) FAC=$(/usr/bin/jq '.Body.Data.FAC.Value' <<< $strVal) if [ $PAC -lt 7 ] && [ $timeloop -gt 1600 ]; then echo Time to exit rm -f /var/run/solar-5kw.pid exit 0 fi if [ $VAC != 'null' ]; then write_sql if [ "$Display" == "True" ] && [ $VAC != 'null' ]; then display_output fi fi sleep 19 done } #Begin if has_param '-v' "$@"; then Display=True fi if [ ! -f /var/run/solar-5kw.pid ]; then echo $$ > /var/run/solar-5kw.pid main elif pgrep -F /var/run/solar-5kw.pid; then printf "Process already running. Terminating....\n\n" else echo $$ > /var/run/solar-5kw.pid main fi #End
SQL Database
mysql
create database solar
CREATE TABLE `5kw` ( `DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ETODAY` int(5) NOT NULL DEFAULT 0.00, `PAC` int(4) NOT NULL DEFAULT 0, `IAC` float(4,2) DEFAULT NULL, `VAC` float(4,1) DEFAULT NULL, `FAC` float(4,2) DEFAULT NULL, `YTOTAL` int(9) DEFAULT NULL, `ETOTAL` float(10) DEFAULT NULL, PRIMARY KEY (`DATE`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;