Advertisement
Guest User

Untitled

a guest
Nov 16th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. var newMSG = msg.payload;
  2.  
  3. timestamp = newMSG.rx.gwrx[0].time.split(' ');
  4. date = { payload: timestamp[0]};
  5. time = { payload: timestamp[1]};
  6. pulse_base64 = {payload: newMSG.rx.userdata.payload};
  7. device_no = {payload: newMSG.rx.moteeui};
  8. port = {payload: newMSG.rx.userdata.port};
  9. rssi = {payload: newMSG.rx.gwrx[0].rssi};
  10.  
  11. msg.topic = "INSERT INTO `electro_count` (`date`, `time`, `start_t`, `end_t`, `flow`, `pulse`, `device_no`, `rssi`, `port`) VALUES ("+date+","+time+","+"1"+","+"2"+","+"3"+","+pulse_base64+","+device_no+","+rssi+","+port+")";
  12. return msg ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement