JSFiddle - React, Tailwind, and code Playground

by Gustavo Ramoscelli

HTML

<script defer>
function getdata() {


payload = {"id":3003209,"sl":27,"anIn":{"ts":1562371199,"tsm":10,"an":[[0.02,0.03,0.02,0.03,0.02,0.02],[7.95,8.11,7.98,8.13,8.13,8.17],[4.65,4.65,4.65,4.65,4.66,4.66],[9.61,9.58,9.64,9.58,9.61,9.58]]}};
device_id = payload.id;
sl = payload.sl;
ts = payload.anIn.ts;
tsm = payload.anIn.tsm;
msgid = 'ccc1f5e8.702838'; //msg._msgid;
resp = "";

///generar consultas analogicas
payload.anIn.an.forEach(function (set, sensor)  {
    set.forEach( function (val, index) {
        resp += "INSERT INTO public.analogicos (device_id,sl,ts,sensor,value,json_id)  values ('"+device_id+"',"+sl+","+(ts+tsm*index)+","+sensor+","+val+",'"+msgid+"');";
    });
});

return {payload:resp};
}


document.write(JSON.stringify(getdata().payload));
</script>