[{"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\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
IdDateTimeHigh P.Low P.cltmpevaptmpcmpI
{{msg.payload[$index].currentdate}} {{msg.payload[$index].currenttime}}{{msg.payload[$index].hp}}{{msg.payload[$index].lp}}{{msg.payload[$index].cltmp}}{{msg.payload[$index].evaptmp}}{{msg.payload[$index].cmpI}}
\n","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":1010,"y":220,"wires":[["b7f14525.ccccd8"]]},{"id":"acebd26d.40588","type":"inject","z":"17083b79.0b1df5","name":"SELECT Date,Time, hp, FROM hvac;","topic":"SELECT currentdate,currenttime, hp, FROM hvac;","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":210,"y":200,"wires":[["982494e.889a568"]]},{"id":"c9cd134d.8d662","type":"inject","z":"17083b79.0b1df5","name":"INJECT LOCAL TIME","topic":"INSERT INTO hvac ( DATE('now','localtime'));","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":440,"wires":[["acdbe77a.a77b28"]]},{"id":"acdbe77a.a77b28","type":"debug","z":"17083b79.0b1df5","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":530,"y":440,"wires":[]},{"id":"43f5a38e.29f69c","type":"sqlitedb","z":"","db":"C:\\Users\\amvel\\.node-red\\db\\hvac.db","mode":"RWC"},{"id":"fb5d670e.ab2458","type":"ui_group","z":"","name":"Default","tab":"7aeb5b98.bc1a04","disp":true,"width":"26","collapse":true},{"id":"7aeb5b98.bc1a04","type":"ui_tab","z":"","name":"Graphs","icon":"dashboard","order":5,"disabled":false,"hidden":false}]