[{"id":"aec0e875.4d2c58","type":"inject","z":"17083b79.0b1df5","name":"CREATE","topic":"CREATE TABLE hvac ( id INTEGER PRIMARY KEY AUTOINCREMENT,currentdate DATE, currenttime TIME, hp NUMERIC, lp NUMERIC, cltmp NUMERIC,evaptmp NUMERIC,cmpI NUMERIC, device TEXT)","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":120,"wires":[["982494e.889a568"]]},{"id":"7e4386df.5fc288","type":"inject","z":"17083b79.0b1df5","name":"SELECT","topic":"SELECT * FROM hvac","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":260,"wires":[["982494e.889a568"]]},{"id":"52dcbf27.939b9","type":"inject","z":"17083b79.0b1df5","name":"DELETE","topic":"DELETE from hvac","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":320,"wires":[["982494e.889a568"]]},{"id":"fd97afa2.13685","type":"inject","z":"17083b79.0b1df5","name":"DropTable","topic":"DROP TABLE HVAC","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":380,"wires":[["982494e.889a568"]]},{"id":"982494e.889a568","type":"sqlite","z":"17083b79.0b1df5","mydb":"43f5a38e.29f69c","sqlquery":"msg.topic","sql":"","name":"Sqlite","x":810,"y":160,"wires":[["dfb0a257.6accc","80829407.e4a1c8"]]},{"id":"dfb0a257.6accc","type":"debug","z":"17083b79.0b1df5","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":990,"y":160,"wires":[]},{"id":"3e6e3c12.522f54","type":"inject","z":"17083b79.0b1df5","name":"INSERT INTO hvac (id,currentdate,currenttime,hp,lp,device) values);","topic":"INSERT INTO hvac (currentdate,currenttime,hp,lp,device) values(date('now'),time('now'),777,250, \"Meson2\");","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":300,"y":160,"wires":[["982494e.889a568"]]},{"id":"b7f14525.ccccd8","type":"debug","z":"17083b79.0b1df5","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1030,"y":300,"wires":[]},{"id":"80829407.e4a1c8","type":"ui_template","z":"17083b79.0b1df5","group":"fb5d670e.ab2458","name":"Data Table","order":3,"width":"0","height":"0","format":"\n
Id | \nDate | \nTime | \nHigh P. | \nLow P. | \ncltmp | \nevaptmp | \ncmpI | \n \n \n
---|---|---|---|---|---|---|---|
{{msg.payload[$index].currentdate}} | \n{{msg.payload[$index].currenttime}} | \n{{msg.payload[$index].hp}} | \n{{msg.payload[$index].lp}} | \n{{msg.payload[$index].cltmp}} | \n{{msg.payload[$index].evaptmp}} | \n{{msg.payload[$index].cmpI}} | \n \n