JSFiddle - React, Tailwind, and code Playground

by Gustavo Ramoscelli

HTML

<script>
payload = {"id":3003209,"sl":27,"anIn":{"ts":1562290847,"tsm":10,"an":[[0.04,0.02,0.05,0.02,0,0,0.03],[8.02,8.1,7.95,8.21,7.87,7.9,7.63],[4.62,4.64,4.66,4.68,4.63,4.64,4.64],[9.5,9.43,9.42,9.55,9.62,9.47,9.41]]}};
device_id = payload.id
sl = payload.sl
ts = payload.anIn.ts;
tsm = payload.anIn.tsm;
msgid = "sdfsdf.hgwec"; // 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+"');";
    });
});



document.write(JSON.stringify({payload:resp}));
</script>