Domoticz

Code: Select all

[influxdb]
name = InfluxDB Repository - RHEL $releasever
baseurl = https://repos.influxdata.com/rhel/$releasever/$basearch/stable
enabled = 1
gpgcheck = 1
gpgkey = https://repos.influxdata.com/influxdb.key

Code: Select all

[grafana]
name=grafana
baseurl=https://packages.grafana.com/oss/rpm
repo_gpgcheck=1
enabled=1
gpgcheck=1
gpgkey=https://packages.grafana.com/gpg.key
sslverify=1
sslcacert=/etc/pki/tls/certs/ca-bundle.crt

Code: Select all

commandArray = {}

year 	= tonumber(os.date("%Y"));
month 	= os.date("%m");
day 	= os.date("%d");
hour 	= os.date("%H");
min 	= os.date("%M");
sec     = os.date("%S");
weekday = tonumber(os.date("%w"));
time    = os.date("%X");
datetime = year.."-"..month.."-"..day.." "..time;
--print(datetime);

for deviceName,deviceValue in pairs(devicechanged) do
    if (deviceName=='Woda licznik') then
        --print ("deviceName: "..deviceName);
        --print ("deviceValue: "..deviceValue);
        --print ("deviceName: "..deviceName..", deviceValue: "..deviceValue);
        print (deviceName..": "..deviceValue);
        local command = "python3 /home/pi/domoticz-scripts/ToMySQL.py Counter ".."'"..deviceName.."'".." "..deviceValue.." ".."'"..datetime.."'";
        --print(command)
        os.execute(command);
    elseif (deviceName=='TempArdGtw') then
        --print(type(deviceValue));
        --print(type(uservariables["ArdGtwTemp"]));
        if ( tostring(uservariables["ArdGtwTemp"]) ~= tostring(deviceValue) ) then
            --print(uservariables["ArdGtwTemp"]);
            --print(deviceValue);
            commandArray['Variable:ArdGtwTemp'] = deviceValue;
            --print("Temperatura zmieniła się");
            --print ("deviceName: "..deviceName..", deviceValue: "..deviceValue);
            print (deviceName..": "..deviceValue);
            local command = "python3 /home/pi/domoticz-scripts/ToMySQL.py Temperatury ".."'"..deviceName.."'".." "..deviceValue.." ".."'"..datetime.."'";
            print(command)
            os.execute(command);
        else
            --print("Temperature the same");
        end    
    end
end

return commandArray

Code: Select all

import pymysql.cursors
import sys
# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='somepassword',
                             db='mydb',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

print('Number of arguments:', len(sys.argv), 'arguments.')
print('Argument List:', str(sys.argv))

#Name = "WodaLicznik"
#value = 170008

try:
    with connection.cursor() as cursor:
        # Create a new record
        sql = "INSERT INTO `" + sys.argv[1] + "` (`Name`, `Value`, `Datetime`) VALUES (%s, %s, %s)"
        print(sql)
        #cursor.execute(sql, (Name, value))
        val = sys.argv[2] + str(sys.argv[3]) + str(sys.argv[4])
        cursor.execute(sql, (sys.argv[2], sys.argv[3], sys.argv[4]))

    connection.commit()

finally:
    connection.close()