05.05.2021, 16:33
Hi,
I cant get this script to work:
tagname = 'log'
logtime = os.time() - 60 * 60
query = [[
SELECT ol.*, o.name, o.datatype
FROM objectlog ol
JOIN objects o ON ol.address=o.id
JOIN objecttags t ON o.id=t.object
WHERE t.tag=? AND logtime>=?
ORDER BY id DESC
]]
buffer = { 'date;name;value' }
items = db:getall(query, tagname, logtime)
for _, item in ipairs(items) do
id = tonumber(item.address) or 0
logdate = os.date('%Y-%m-%d', math.floor(item.logtime))
etype = item.eventtype
if (etype == 'write' or etype == 'response') and item.datatype then
value = grp.decodevalue(item.datahex, item.datatype)
if type(value) == 'number' then
value = tostring(value):gsub('%.', ',')
end
else
value = ''
end
buffer[ #buffer + 1 ] = string.format('%s;%s;%s',
logdate, item.name or '', tostring(value))
end
csv = table.concat(buffer, '\n')
I got nil.
I want to read meters convert to: buffer = { 'date;name;value' }
and send email once every sixth our.
Thanks for help.
I cant get this script to work:
tagname = 'log'
logtime = os.time() - 60 * 60
query = [[
SELECT ol.*, o.name, o.datatype
FROM objectlog ol
JOIN objects o ON ol.address=o.id
JOIN objecttags t ON o.id=t.object
WHERE t.tag=? AND logtime>=?
ORDER BY id DESC
]]
buffer = { 'date;name;value' }
items = db:getall(query, tagname, logtime)
for _, item in ipairs(items) do
id = tonumber(item.address) or 0
logdate = os.date('%Y-%m-%d', math.floor(item.logtime))
etype = item.eventtype
if (etype == 'write' or etype == 'response') and item.datatype then
value = grp.decodevalue(item.datahex, item.datatype)
if type(value) == 'number' then
value = tostring(value):gsub('%.', ',')
end
else
value = ''
end
buffer[ #buffer + 1 ] = string.format('%s;%s;%s',
logdate, item.name or '', tostring(value))
end
csv = table.concat(buffer, '\n')
I got nil.
I want to read meters convert to: buffer = { 'date;name;value' }
and send email once every sixth our.
Thanks for help.