Domoticz

Code: Select all

return {
        active = true,
        on = {
            devices = {'test'}
        },
        data = {
            switchevents = { initial = {} }
        },
    execute = function(dz, item, info)


    local testdata  ='{"veld1": "waarde 1","veld2": "waarde 2"}'

    function deepdump( tbl )
            local checklist = {}
            
            local function innerdump( tbl, indent )
                checklist[ tostring(tbl) ] = true
                for k,v in pairs(tbl) do
                        print (indent .. tostring(k) .. " ===> value: ".. tostring(v)  )
                    if (type(v) == "table" and not checklist[ tostring(v) ]) then 
                        innerdump(v,indent .. tostring(k) .. ".") 
                    end
                end
            end
            checklist[ tostring(tbl) ] = true
            innerdump( tbl, "Key: " )
    end

    -- how to add "veld3": "waarde 3" to testdata
    testdata.add("veld3": "waarde 3")

    local myTable   = dz.utils.fromJSON(testdata) 
    deepdump(myTable) -- use this function call to see the structure of your table

end
}

Code: Select all

return {
        active = true,
        on = { devices = {'test', 'myTrigger'}},

    execute = function(dz, item)

    local testJSON  ='{"key1": "value 1","key2": "value 2"}'
    local testTable =   { 
                            ["key3"] = "value 3",
                            ["key4"] = "value 4",
                        }

    local myTable   = dz.utils.fromJSON(testJSON) 

    -- merge tables
    for k,v in pairs(testTable) do myTable[k] = v end

    local varName   = "key 8"
    local varName2  = { ["key 9"] = "value 9" }

    myTable.key5 = "value 5" -- method 1. Only allowed for string keys without spaces in name
    myTable["key 6"] = "value 6" -- method 2 (necessary when something else as a string without spaces)
    myTable[7] = "value 7" -- method 3 numeric key
    myTable[varName] = "value 8" -- method 4 using content of a variable as key
    myTable[9] = varName2 -- method 5 add a sub-table
    
    dz.utils.dumpTable(myTable) 
end
}

Code: Select all

local function getTablePairsCount(t)
   local tableCounter = 0
   for k,v in pairs(t) do
       tableCounter = tableCounter + 1
   end
   return tableCounter
end

local function tableValuesToString(t,sep)
   local myString = '' 
   local sep = sep or ',' -- default separator = ,
   for k, v in pairs(t) do
        if type(v) == 'string' then
            myString = myString .. v .. sep 
        end
   end
   if myString ~= '' then  return myString:gsub("[" .. sep .. "]*$",'') end -- return concatenated string after removing last separator
end


local rTable = {} 
local record1 = '{"ident": "aaaa", "var1": "1", "var2": "1"}'
local record2 = '{"ident": "zzzz", "var1": "2", "var2": "1"}'
local record3 = '{"ident": "bbbbb", "var1": "1", "var2": "7"}'

rTable[1] =  record1

rTable[#rTable + 1] =  record2
rTable[#rTable + 1] =  record3

print ('there are ' .. getTablePairsCount(rTable) .. '  records in the table') -- works on all tables
print ('there are ' .. #rTable .. '  records in the table') -- gives only a valid answer on pure array like tables
print ('[' .. table.concat(rTable,',') .. ']') -- table concat only concatenates the values within the pure array part of the table (with key 1,2,3,..)

rTable[0] = '{"ident": "00000", "var0"=": "0", "var00": "00"}' 
rTable['negen'] =  '{"ident": "999999", "var9"=": "9", "var99": "99"}' 

print ('there are now ' .. getTablePairsCount(rTable) .. '  records in the table')
print ('there are now more then '  .. #rTable .. '  records in the table') -- #rTable does not give the count of all records now only the ones in the pure Array

print('\n\n')

print ('Values from pure array part of the table ==>>  [' .. table.concat(rTable,',') .. ']')  -- this does not print all the table values
print ('Values from complete table ==>> [' .. tableValuesToString(rTable,',') .. ']')