Fronius API Bash Script Logging to MariaDB

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;