Forum Domoticz en français

Code : Tout sélectionner

commandArray = {}
function SaveTable(matable,sortie)
    Path="/home/pi/domoticz/"
    dbPath="/home/pi/domoticz/domoticz.db"
    if sortie == nil then sortie = 'sortie.txt' end
    sql='sqlite3 -header -csv '..dbPath..' "select * from '..matable..';" > '..Path..sortie
    os.capture(sql)
    os.execute("chown pi "..Path..sortie)
end

if time.hour==5 and time.min==1 then
    -- retourne le jour sur 2 car ex: "29"
    jour = os.date("%d")
    SaveTable('EventMaster', 'scripts/lua/logs/Event_'..jour..'.txt')
end

return commandArray

Code : Tout sélectionner

#!/bin/bash
#
# dump all dzVents to separate files
#
# change to reflect your situation / requirements
#
# from: https://www.domoticz.com/forum/viewtopic.php?f=31&t=28627&p=218924&hilit=save+file+lua#p218924

domoticzDir='/home/pi/PROD_domoticz/'
scriptDir='/home/pi/mydomoticz/myscripts/dzVents/'

# no changes required below this line
#
#mkdir -p $scriptDir
sudo cp $domoticzDir/domoticz.db /tmp/tmp.db 

sudo sqlite3 /tmp/tmp.db "select ID, name,status from eventMaster WHERE interpreter = 'dzVents'" | while read line;
do
	#echo "line:" $line
	ID=$(echo $line | awk -F'|' '{ print $1 }')
	#echo "ID " $ID

	NAME=$(echo $line | awk -F'|' '{ print $2 }')
	#echo "NAME " $NAME

	STATUS=$(echo $line | awk -F'|' '{ print $3 }')
	#echo "STATUS" $STATUS


	if [[ $STATUS == 0 ]] ; then # script inactive
	        scriptDirName=$scriptDir$NAME'.inactive.lua'
        else
        	scriptDirName=$scriptDir$NAME'.lua'
        fi

	sudo sqlite3 /tmp/tmp.db "select XMLSTatement from eventMaster WHERE interpreter = 'dzVents' and ID = $ID" > $scriptDirName
	echo "export " $NAME " to " $scriptDirName 
done
sudo rm /tmp/tmp.db

Code : Tout sélectionner

interpreter = 'dzVents' 

Code : Tout sélectionner

-rw-r--r-- 1 pi pi  9163 Dec 18  2020 AlerteMoustiques.lua
-rw-r--r-- 1 pi pi 10014 Jul 15 00:05 AlerteMoustiques_V1R0.lua
-rw-r--r-- 1 pi pi  1893 Jul 15 00:05 Aqua_Icones.inactive.lua
-rw-r--r-- 1 pi pi  2393 Jul 15 00:05 AquaMeters.lua
-rw-r--r-- 1 pi pi  4093 Jul 11 00:05 aquaOnOff.lua
-rw-r--r-- 1 pi pi  4205 Jul 15 00:05 AquaOnOff.lua
-rw-r--r-- 1 pi pi  2577 Jul 15 00:05 AquaOnOffPump.lua
-rw-r--r-- 1 pi pi  4480 Jul 15 00:05 AquaVolume.lua
-rw-r--r-- 1 pi pi  1530 Jul 15 00:05 aTestDimTo0.inactive.lua
-rw-r--r-- 1 pi pi 11537 Sep 20  2020 Auto_off.inactive.lua
-rw-r--r-- 1 pi pi 50834 Dec 11  2020 AutoOff_Notif.inactive.lua

Code : Tout sélectionner

# export dzvents scripts
5 0  * * * /home/pi/mydomoticz/myscripts/export_dzVent.sh 2>&1 | /usr/bin/logger                                           -t DZBACKUP

Code : Tout sélectionner

commandArray = {}

function mysplit (inputstr, sep)
    if sep == nil then sep = "%s" end
    local t={}
    for str in string.gmatch(inputstr, "([^"..sep.."]+)") do
        table.insert(t, str)
    end
    return t
end

function os.capture(cmd)
  local f = assert(io.popen(cmd, 'r'))
  local s = assert(f:read('*a'))
  f:close()
  return s
end

function SaveTable(dbPath, matable, sortie)
    local sql1='sqlite3 '..dbPath..' "select ID, name,status from '..matable..';"'
    local result = os.capture(sql1)
    local lignes = mysplit(result, '\n\r')
    for i=1,#lignes,1 do
        splited = mysplit(lignes[i], '|')
        id = splited[1]
        name = splited[2]
        status = splited[3]
        if status == '0' then
            scriptDirName = sortie .. name ..'.inactive.lua'
        else
            scriptDirName = sortie .. name ..'.active.lua'
        end
        sql2 = 'sqlite3 ' .. dbPath .. ' "select XMLSTatement from '..matable..' WHERE ID = ' .. id .. '" > "' .. scriptDirName .. '"'
        os.execute(sql2)
        os.execute('chown pi "'..scriptDirName .. '"')
    end
    print("Les scripts LUA ont été sauvé")
end

Timer = os.date('%H:%M')
if Timer == '05:01' then
    -- retourne le jour de l'année ex: "365"
    jour = os.date("%j")
    SaveTable('/home/pi/domoticz/domoticz.db', 'EventMaster', '/home/pi/domoticz/scripts/lua/logs/'..jour..'_')
end

return commandArray