Node-red 與 TimeStamp 兩個有用node節點 : Simpletime node 與 node-red-contrib-simpletime node

Node-red 與 TimeStamp 兩個有用node節點。
Simpletime node 與  node-red-contrib-simpletime node

[{"id":"d8223513.8f6f18","type":"moment","z":"c1aa8d01.bc4c4","name":"hhmm","topic":"","input":"","inputType":"msg","inTz":"Asia/Seoul","adjAmount":0,"adjType":"days","adjDir":"add","format":"hhmm","locale":"ko_KR","output":"","outputType":"msg","outTz":"Asia/Seoul","x":370,"y":200,"wires":[["237a8a56.8109d6"]]},{"id":"d18af990.330fe8","type":"inject","z":"c1aa8d01.bc4c4","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":200,"y":200,"wires":[["d8223513.8f6f18","2b52e478.26e47c","9f4b6401.b92dd8"]]},{"id":"237a8a56.8109d6","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":630,"y":200,"wires":[]},{"id":"12df9e8.bab8a62","type":"comment","z":"c1aa8d01.bc4c4","name":"Moment","info":"","x":180,"y":160,"wires":[]},{"id":"87e1f5f1.ea1038","type":"inject","z":"c1aa8d01.bc4c4","name":"","topic":"","payload":"Shot","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":190,"y":380,"wires":[["7e74cab8.c8db74"]]},{"id":"a44e04bc.124028","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":630,"y":240,"wires":[]},{"id":"b4b5f32e.7f714","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":630,"y":280,"wires":[]},{"id":"2b52e478.26e47c","type":"moment","z":"c1aa8d01.bc4c4","name":"MMDD","topic":"","input":"","inputType":"msg","inTz":"Asia/Seoul","adjAmount":0,"adjType":"days","adjDir":"add","format":"MMDD","locale":"ko_KR","output":"","outputType":"msg","outTz":"Asia/Seoul","x":380,"y":240,"wires":[["a44e04bc.124028"]]},{"id":"9f4b6401.b92dd8","type":"moment","z":"c1aa8d01.bc4c4","name":"YYYY-MM-DD hh:mm:ss","topic":"","input":"","inputType":"msg","inTz":"Asia/Seoul","adjAmount":0,"adjType":"days","adjDir":"add","format":"YYYY-MM-DD hh:mm:ss","locale":"ko_KR","output":"","outputType":"msg","outTz":"Asia/Seoul","x":430,"y":280,"wires":[["b4b5f32e.7f714"]]},{"id":"f583c683.3eb5e8","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":570,"y":380,"wires":[]},{"id":"b81079a5.f9cc78","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"myepoch","x":580,"y":420,"wires":[]},{"id":"4eb6d406.fbe4ac","type":"debug","z":"c1aa8d01.bc4c4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"myrawdate","x":580,"y":460,"wires":[]},{"id":"7c145715.e8ef88","type":"comment","z":"c1aa8d01.bc4c4","name":"Simpletime","info":"","x":180,"y":340,"wires":[]},{"id":"d91ccbd7.a38648","type":"comment","z":"c1aa8d01.bc4c4","name":"Timestamp node","info":"","x":160,"y":120,"wires":[]},{"id":"7e74cab8.c8db74","type":"simpletime","z":"c1aa8d01.bc4c4","name":"","x":370,"y":380,"wires":[["f583c683.3eb5e8","b81079a5.f9cc78","4eb6d406.fbe4ac"]]}]

​NodeRed flow 範例 紅色儀表板node 音頻輸出 node 使用TTS功能

​NodeRed flow 範例 紅色儀表板node 音頻輸出 node 使用TTS功能

[{"id":"908b9843.e202c8","type":"comment","z":"16233033.a69fe","name":"TTS - Text to Speech Example","info":"","x":190,"y":80,"wires":[]},{"id":"17dfc21.6aca03e","type":"ui_audio","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","voice":"en-US","always":"","x":530,"y":100,"wires":[]},{"id":"8e015640.60f3e8","type":"ui_text_input","z":"16233033.a69fe","name":"","label":"","group":"30f2cf2f.c3a3b","order":9,"width":0,"height":0,"passthru":true,"mode":"text","delay":"0","topic":"","x":330,"y":140,"wires":[["17dfc21.6aca03e","aaee344f.bc1528","1800ed4d.f60f93"]]},{"id":"33437979.4be676","type":"inject","z":"16233033.a69fe","name":"","topic":"Hello","payload":"Hello","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":140,"wires":[["8e015640.60f3e8"]]},{"id":"be1e8a06.fbd948","type":"ui_text","z":"16233033.a69fe","group":"30f2cf2f.c3a3b","order":2,"width":0,"height":0,"name":"","label":"","format":"{{msg.payload}}","layout":"row-center","x":680,"y":140,"wires":[]},{"id":"aaee344f.bc1528","type":"delay","z":"16233033.a69fe","name":"","pauseType":"delay","timeout":"50","timeoutUnits":"milliseconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":320,"y":200,"wires":[["14698e02.1e0aa2"]]},{"id":"14698e02.1e0aa2","type":"function","z":"16233033.a69fe","name":"Check Text","func":"text=msg.payload;\nif(text !== \"\"){\n    msg.payload = \"\";\n    return msg;\n}","outputs":1,"noerr":0,"x":480,"y":200,"wires":[["8e015640.60f3e8"]]},{"id":"1800ed4d.f60f93","type":"function","z":"16233033.a69fe","name":"Check Text","func":"text=msg.payload;\nif(text !== \"\"){\n    msg.payload = text;\n    return msg;\n}","outputs":1,"noerr":0,"x":540,"y":140,"wires":[["be1e8a06.fbd948"]]},{"id":"99fd952b.8fe308","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":3,"width":"6","height":"1","passthru":true,"label":"Hello.","color":"","bgcolor":"","icon":"","payload":"Hello.","payloadType":"str","topic":"","x":320,"y":260,"wires":[["5cbeddbb.2b0b24"]]},{"id":"5cbeddbb.2b0b24","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":260,"wires":[]},{"id":"4702ed05.3c8b54","type":"link in","z":"16233033.a69fe","name":"","links":["5cbeddbb.2b0b24","2bea61ab.4cb7ce","b5f1cd27.707a6","23857211.7b145e","7353c977.fb1fb8","d51111c2.4ae4e"],"x":165,"y":200,"wires":[["8e015640.60f3e8"]]},{"id":"5bbbde80.b40c","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":260,"wires":[["99fd952b.8fe308"]]},{"id":"a56d9174.03ebe","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":4,"width":"6","height":"1","passthru":true,"label":"Good bye.","color":"","bgcolor":"","icon":"","payload":"Good bye.","payloadType":"str","topic":"","x":340,"y":300,"wires":[["2bea61ab.4cb7ce"]]},{"id":"2bea61ab.4cb7ce","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":300,"wires":[]},{"id":"9129223f.cc023","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":300,"wires":[["a56d9174.03ebe"]]},{"id":"b74bca1b.5a5dc8","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":5,"width":"6","height":"1","passthru":true,"label":"Thank you.","color":"","bgcolor":"","icon":"","payload":"Thank you.","payloadType":"str","topic":"","x":340,"y":340,"wires":[["b5f1cd27.707a6"]]},{"id":"b5f1cd27.707a6","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":340,"wires":[]},{"id":"15e44e2f.a6ac72","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":340,"wires":[["b74bca1b.5a5dc8"]]},{"id":"3e2e653d.393e0a","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":6,"width":"6","height":"1","passthru":true,"label":"I don't know.","color":"","bgcolor":"","icon":"","payload":"I don't know.","payloadType":"str","topic":"","x":340,"y":380,"wires":[["23857211.7b145e"]]},{"id":"23857211.7b145e","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":380,"wires":[]},{"id":"9db4b100.a19d3","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":380,"wires":[["3e2e653d.393e0a"]]},{"id":"555025d7.6e23cc","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":7,"width":"3","height":"1","passthru":true,"label":"Yes.","color":"","bgcolor":"","icon":"","payload":"Yes.","payloadType":"str","topic":"","x":320,"y":420,"wires":[["7353c977.fb1fb8"]]},{"id":"7353c977.fb1fb8","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":420,"wires":[]},{"id":"e04c698c.bedff8","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":420,"wires":[["555025d7.6e23cc"]]},{"id":"d452988e.c690e8","type":"ui_button","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","order":8,"width":"3","height":"1","passthru":true,"label":"No.","color":"","bgcolor":"","icon":"","payload":"No.","payloadType":"str","topic":"","x":320,"y":460,"wires":[["d51111c2.4ae4e"]]},{"id":"d51111c2.4ae4e","type":"link out","z":"16233033.a69fe","name":"text out","links":["4702ed05.3c8b54"],"x":485,"y":460,"wires":[]},{"id":"16836915.fe6757","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":460,"wires":[["d452988e.c690e8"]]},{"id":"588fb8f7.4ec6f8","type":"comment","z":"16233033.a69fe","name":"TTS - Text to Speech Example","info":"","x":210,"y":540,"wires":[]},{"id":"113b95a3.5ee51a","type":"ui_audio","z":"16233033.a69fe","name":"","group":"30f2cf2f.c3a3b","voice":"zh-TW","always":"","x":550,"y":560,"wires":[]},{"id":"5d2a299.c7837d8","type":"ui_text_input","z":"16233033.a69fe","name":"","label":"","group":"2bb21280.f543ae","order":9,"width":0,"height":0,"passthru":true,"mode":"text","delay":"0","topic":"","x":350,"y":600,"wires":[["113b95a3.5ee51a","9e694927.4cc2c8","2e8c4260.49b89e"]]},{"id":"d4eb4180.300e5","type":"inject","z":"16233033.a69fe","name":"","topic":"Hello","payload":"謝謝.","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":600,"wires":[["5d2a299.c7837d8"]]},{"id":"d9f79811.c22fa8","type":"ui_text","z":"16233033.a69fe","group":"2bb21280.f543ae","order":2,"width":0,"height":0,"name":"","label":"","format":"{{msg.payload}}","layout":"row-left","x":700,"y":600,"wires":[]},{"id":"9e694927.4cc2c8","type":"delay","z":"16233033.a69fe","name":"","pauseType":"delay","timeout":"50","timeoutUnits":"milliseconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":340,"y":660,"wires":[["9f5929b1.f05da8"]]},{"id":"9f5929b1.f05da8","type":"function","z":"16233033.a69fe","name":"Check Text","func":"text=msg.payload;\nif(text !== \"\"){\n    msg.payload = \"\";\n    return msg;\n}","outputs":1,"noerr":0,"x":500,"y":660,"wires":[["5d2a299.c7837d8"]]},{"id":"2e8c4260.49b89e","type":"function","z":"16233033.a69fe","name":"Check Text","func":"text=msg.payload;\nif(text !== \"\"){\n    msg.payload = text;\n    return msg;\n}","outputs":1,"noerr":0,"x":560,"y":600,"wires":[["d9f79811.c22fa8"]]},{"id":"669801af.33cd4","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":3,"width":"6","height":"1","passthru":true,"label":"Hello.","color":"","bgcolor":"","icon":"","payload":" 你好.","payloadType":"str","topic":"","x":340,"y":720,"wires":[["866acf9d.76e62"]]},{"id":"866acf9d.76e62","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":720,"wires":[]},{"id":"17d4a7ef.345e58","type":"link in","z":"16233033.a69fe","name":"","links":["866acf9d.76e62","92075af4.3ac378","dafc0811.066ec8","e7931a4e.b87df8","2d402571.5f5e8a","c6875067.3ce01"],"x":185,"y":660,"wires":[["5d2a299.c7837d8"]]},{"id":"4cc12fbb.b15cf","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":720,"wires":[["669801af.33cd4"]]},{"id":"a72065f8.c45ff8","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":4,"width":"6","height":"1","passthru":true,"label":"Good bye.","color":"","bgcolor":"","icon":"","payload":"再見.","payloadType":"str","topic":"","x":360,"y":760,"wires":[["92075af4.3ac378"]]},{"id":"92075af4.3ac378","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":760,"wires":[]},{"id":"7c534493.6c6f0c","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":760,"wires":[["a72065f8.c45ff8"]]},{"id":"aedf9081.69141","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":5,"width":"6","height":"1","passthru":true,"label":"Thank you.","color":"","bgcolor":"","icon":"","payload":"感謝您.","payloadType":"str","topic":"","x":360,"y":800,"wires":[["dafc0811.066ec8"]]},{"id":"dafc0811.066ec8","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":800,"wires":[]},{"id":"208b82aa.2fb4ae","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":800,"wires":[["aedf9081.69141"]]},{"id":"e048f034.9dc68","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":6,"width":"6","height":"1","passthru":true,"label":"I don't know.","color":"","bgcolor":"","icon":"","payload":"我不知道.","payloadType":"str","topic":"","x":360,"y":840,"wires":[["e7931a4e.b87df8"]]},{"id":"e7931a4e.b87df8","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":840,"wires":[]},{"id":"3796ae61.62f8e2","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":840,"wires":[["e048f034.9dc68"]]},{"id":"a2908ee5.8814f","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":7,"width":"3","height":"1","passthru":true,"label":"Yes.","color":"","bgcolor":"","icon":"","payload":"是的.","payloadType":"str","topic":"","x":340,"y":880,"wires":[["2d402571.5f5e8a"]]},{"id":"2d402571.5f5e8a","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":880,"wires":[]},{"id":"fec228e2.26c6f8","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":880,"wires":[["a2908ee5.8814f"]]},{"id":"bc4b1b1.81e6fe8","type":"ui_button","z":"16233033.a69fe","name":"","group":"2bb21280.f543ae","order":8,"width":"3","height":"1","passthru":true,"label":"No.","color":"","bgcolor":"","icon":"","payload":"不.","payloadType":"str","topic":"","x":340,"y":920,"wires":[["c6875067.3ce01"]]},{"id":"c6875067.3ce01","type":"link out","z":"16233033.a69fe","name":"text out","links":["17d4a7ef.345e58"],"x":505,"y":920,"wires":[]},{"id":"a1145ad9.0ea6d8","type":"inject","z":"16233033.a69fe","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":920,"wires":[["bc4b1b1.81e6fe8"]]},{"id":"30f2cf2f.c3a3b","type":"ui_group","z":"","name":"TTS - Text to Speech","tab":"81c048e6.13f398","order":1,"disp":true,"width":"6","collapse":false},{"id":"2bb21280.f543ae","type":"ui_group","z":"","name":"TTS - Text to Speech 2","tab":"81c048e6.13f398","order":2,"disp":true,"width":"6","collapse":false},{"id":"81c048e6.13f398","type":"ui_tab","z":"","name":"TTS","icon":"dashboard","order":2}]

使用nodered Dashboad圖表節點繪製隨機值的圖形 實現生成的隨機值以供Web API使用

使用nodered Dashboad圖表節點繪製隨機值的圖形
實現生成的隨機值以供Web API使用

[{"id":"fc080395.c9026","type":"inject","z":"89b5e167.6b055","name":"2s","topic":"","payload":"","payloadType":"date","repeat":"2","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":100,"wires":[["f9937848.c26178","8609b435.7c3808"]]},{"id":"f9937848.c26178","type":"function","z":"89b5e167.6b055","name":"random1","func":"ran = parseInt(Math.random() * 10);\nmsg.topic = \"Random1\";\nmsg.payload = ran;\nreturn msg;","outputs":1,"noerr":0,"x":320,"y":100,"wires":[["651ba2c1.9c9c2c"]]},{"id":"651ba2c1.9c9c2c","type":"ui_chart","z":"89b5e167.6b055","name":"","group":"172c72a3.c05a7d","order":0,"width":"6","height":"5","label":"20s(10 points)","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"20","removeOlderPoints":"","removeOlderUnit":"1","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"x":540,"y":100,"wires":[["d2e5e919.d5cec8","87c2df48.37139"],[]]},{"id":"8609b435.7c3808","type":"function","z":"89b5e167.6b055","name":"random2","func":"ran = parseInt(Math.random() * 10);\nmsg.topic = \"Random2\";\nmsg.payload = ran;\nreturn msg;","outputs":1,"noerr":0,"x":320,"y":140,"wires":[["651ba2c1.9c9c2c","bb63789f.53c338"]]},{"id":"1f543df9.6d6102","type":"inject","z":"89b5e167.6b055","name":"Flush","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":180,"wires":[["4165a1b1.2f64"]]},{"id":"4165a1b1.2f64","type":"function","z":"89b5e167.6b055","name":"Flush","func":"msg.payload = [];\nreturn msg;","outputs":1,"noerr":0,"x":310,"y":180,"wires":[["651ba2c1.9c9c2c"]]},{"id":"d2e5e919.d5cec8","type":"function","z":"89b5e167.6b055","name":"Save","func":"flow.set(\"chartarray\",msg.payload);","outputs":1,"noerr":0,"x":710,"y":100,"wires":[[]]},{"id":"461195ab.dd184c","type":"inject","z":"89b5e167.6b055","name":"Reload","topic":"","payload":"","payloadType":"date","repeat":"3600","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":220,"wires":[["d795bc86.eb7ef"]]},{"id":"d795bc86.eb7ef","type":"function","z":"89b5e167.6b055","name":"Reload","func":"msg.payload = flow.get(\"chartarray\");\nreturn msg;","outputs":1,"noerr":0,"x":320,"y":220,"wires":[["651ba2c1.9c9c2c"]]},{"id":"a68ffe6e.70af6","type":"comment","z":"89b5e167.6b055","name":"Dashboard Chart Node","info":"","x":190,"y":40,"wires":[]},{"id":"cd7a8378.f477e","type":"http in","z":"89b5e167.6b055","name":"","url":"/random","method":"get","upload":false,"swaggerDoc":"","x":150,"y":380,"wires":[["4a7a68bf.ff1e08"]]},{"id":"963bc9fc.06c678","type":"http response","z":"89b5e167.6b055","name":"","statusCode":"","headers":{},"x":730,"y":380,"wires":[]},{"id":"83e567b1.c41bf8","type":"comment","z":"89b5e167.6b055","name":"Random http://127.0.0.1:1880/random","info":"","x":210,"y":340,"wires":[]},{"id":"4a7a68bf.ff1e08","type":"function","z":"89b5e167.6b055","name":"http in","func":"rnum=parseInt(msg.req.query.rnum);\ncount=parseInt(msg.req.query.count);\n\nif (rnum <= 2 && count <= 10) {\n    msg.rnum = rnum;\n    msg.count = count;\n    msg.payload=\"OK\";\n    return msg; \n}else{\n    msg.payload=\"Error!\";\n    return msg;    \n}  ","outputs":1,"noerr":0,"x":310,"y":380,"wires":[["882cde83.df3dc","fb76b907.6ad8a8"]]},{"id":"882cde83.df3dc","type":"function","z":"89b5e167.6b055","name":"Ok","func":"pay=msg.payload;\nif (pay == \"OK\"){\n    return msg;\n}","outputs":1,"noerr":0,"x":450,"y":380,"wires":[["ac3178dd.232e58"]]},{"id":"ac3178dd.232e58","type":"function","z":"89b5e167.6b055","name":"Output","func":"var temp=[];\nvar tempmsg = flow.get(\"chartarray\");\nrnum=msg.rnum;\ncount=msg.count;\n\ntemp = \"[\";\nfor(var i = 0; i < rnum; i++){\n    temp = temp + \"[\";    \n    for(var j = 0; j < count; j++){\n        var j2=9-j;\n        temp = temp + '{ \"time\" : \"';\n        temp = temp + tempmsg[0].data[i][j2].x;\n        temp = temp + '\" , \"val\" : \"';\n        temp = temp + tempmsg[0].data[i][j2].y;\n        temp = temp + '\" }';\n        if (j < count-1){ temp = temp + \",\";}\n        }\n    temp = temp + \"]\";\n    if (i < rnum-1){ temp = temp + \",\";}\n}\ntemp = temp + \"]\";\n\nmsg.payload = temp;\nreturn msg;","outputs":1,"noerr":0,"x":590,"y":380,"wires":[["963bc9fc.06c678"]]},{"id":"87c2df48.37139","type":"debug","z":"89b5e167.6b055","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":730,"y":140,"wires":[]},{"id":"ff077da9.ea985","type":"http response","z":"89b5e167.6b055","name":"","statusCode":"","headers":{},"x":730,"y":440,"wires":[]},{"id":"fb76b907.6ad8a8","type":"function","z":"89b5e167.6b055","name":"Error","func":"pay=msg.payload;\nif (pay == \"Error!\"){\n    return msg;\n}","outputs":1,"noerr":0,"x":450,"y":440,"wires":[["f93d53fa.9fed5"]]},{"id":"f93d53fa.9fed5","type":"template","z":"89b5e167.6b055","name":"web","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"<html>\n    <head></head>\n    <body>\n        <h1>{{payload}}</h1>\n    </body>\n</html>","output":"str","x":590,"y":440,"wires":[["ff077da9.ea985"]]},{"id":"75730aee.fc4f04","type":"inject","z":"89b5e167.6b055","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":520,"wires":[["577880db.b6353"]]},{"id":"4f8d4188.37301","type":"debug","z":"89b5e167.6b055","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":570,"y":520,"wires":[]},{"id":"577880db.b6353","type":"http request","z":"89b5e167.6b055","name":"exchange","method":"GET","ret":"obj","url":"http://earthquake.kr/exchange/","tls":"","x":350,"y":520,"wires":[["4f8d4188.37301"]]},{"id":"c16e19b3.763ae8","type":"inject","z":"89b5e167.6b055","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":580,"wires":[["9e0b566b.77b098"]]},{"id":"6aefc7fa.873b88","type":"debug","z":"89b5e167.6b055","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":570,"y":580,"wires":[]},{"id":"9e0b566b.77b098","type":"http request","z":"89b5e167.6b055","name":"random","method":"GET","ret":"obj","url":"http://localhost:1880/random?rnum=2&count=5","tls":"","x":350,"y":580,"wires":[["6aefc7fa.873b88"]]},{"id":"bb63789f.53c338","type":"ui_template","z":"89b5e167.6b055","group":"172c72a3.c05a7d","name":"","order":0,"width":0,"height":0,"format":"<div layout=\"row\" layout-align=\"space-between\">\n<p>The random 1 number is</p>\n<p ng-style=\"{color: (msg.payload || 0) % 2 === 0 ? 'green' : 'red'}\">\n  {{(msg.payload || 0) % 2 === 0 ? 'even' : 'odd'}}\n</p>\n</div>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":540,"y":160,"wires":[[]]},{"id":"172c72a3.c05a7d","type":"ui_group","name":"Group 1","tab":"21c6ef7f.9ca0f","order":1,"disp":true,"width":6},{"id":"21c6ef7f.9ca0f","type":"ui_tab","name":"Tab 3","icon":"dashboard","order":1}]

使用nodered SQLite（存儲在數據庫中）

使用nodered SQLite（存儲在數據庫中）
複製和使用時，必須在編輯窗口中創建數據庫。
單擊創建數據庫->插入（多次單擊）->選擇
您可以看到保存為儀表板模板節點的值。

[{"id":"9d6d4a84.d1aff8","type":"comment","z":"8484646.833e198","name":"sqlite.org","info":"https://fred.sensetecnic.com/\nhttp://noderedguide.com/tutorial-sqlite-and-node-red/\nhttps://www.sqlite.org/lang.html\nhttps://www.sqlite.org/datatype3.html#expraff\n\nCREATE TABLE RANDOMNUM( TIMESTAMP INT PRIMARY KEY NOT NULL, VALUE INT NOT NULL, BOOL INT NOT NULL)\n\n//INSERT\nvar randomNum = Math.round(Math.random()*100);\nvar largeBool = (randomNum > 50)?1:0;\nvar newMsg = {\n \"topic\": \"INSERT INTO RANDOMNUM VALUES ( \" + msg.payload + \", \" + randomNum + \", \" + largeBool + \")\"\n}\nreturn newMsg;\n\nDELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-30 seconds')*1000\nDELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-24 hours')*1000\nDELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-7 days')*1000\n\nSELECT COUNT(*) FROM RANDOMNUM\n\nUPDATE RANDOMNUM SET BOOL = 1 WHERE VALUE > 80 AND BOOL = 0\n\nSELECT * FROM RANDOMNUM ORDER BY TIMESTAMP DESC LIMIT 100;\n<table style=\"width:100%\">\n  <tr>\n    <th>Index</th> \n    <th>Timestamp</th>\n    <th>Value</th> \n    <th>Bool</th>\n  </tr>\n  <tr ng-repeat=\"x in msg.payload | limitTo:20\">\n    <td>{{$index}}</td>\n    <td>{{msg.payload[$index].TIMESTAMP}}</td>\n    <td>{{msg.payload[$index].VALUE}}</td> \n    <td>{{msg.payload[$index].BOOL}}</td>\n  </tr>\n</table>\n\n","x":100,"y":80,"wires":[]},{"id":"f2e4a07e.d74cd","type":"inject","z":"8484646.833e198","name":"CREATE DB","topic":"CREATE TABLE RANDOMNUM( TIMESTAMP INT PRIMARY KEY NOT NULL, VALUE INT NOT NULL, BOOL INT NOT NULL)","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":140,"wires":[["aec9239d.cc376"]]},{"id":"bbe65fa9.231ef","type":"debug","z":"8484646.833e198","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":140,"wires":[]},{"id":"340954fa.e315ac","type":"inject","z":"8484646.833e198","name":"INSERT","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":200,"wires":[["d268106.8674cf"]]},{"id":"d268106.8674cf","type":"function","z":"8484646.833e198","name":"INSERT","func":"var randomNum = Math.round(Math.random()*100);\nvar largeBool = (randomNum > 50)?1:0;\nvar newMsg = {\n \"topic\": \"INSERT INTO RANDOMNUM VALUES ( \" + msg.payload + \", \" + randomNum + \", \" + largeBool + \")\"\n}\nreturn newMsg;","outputs":1,"noerr":0,"x":300,"y":200,"wires":[["3d041ff8.99772"]]},{"id":"eee4c1af.a72cc","type":"debug","z":"8484646.833e198","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":200,"wires":[]},{"id":"e1493005.34b9b","type":"inject","z":"8484646.833e198","name":"DELETE 30s","topic":"DELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-30 seconds')*1000","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":260,"wires":[["34a62b4f.a21764"]]},{"id":"70414900.693c28","type":"inject","z":"8484646.833e198","name":"DELETE 24h","topic":"DELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-24 hours')*1000","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":300,"wires":[["34a62b4f.a21764"]]},{"id":"9054be03.28c8","type":"inject","z":"8484646.833e198","name":"DELETE 7d","topic":"DELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-7 days')*1000","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":340,"wires":[["34a62b4f.a21764"]]},{"id":"72e6d526.73c10c","type":"debug","z":"8484646.833e198","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":260,"wires":[]},{"id":"17e945eb.9ed5ca","type":"inject","z":"8484646.833e198","name":"UPDATE","topic":"UPDATE RANDOMNUM SET BOOL = 1 WHERE VALUE > 20 AND BOOL = 0","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":400,"wires":[["9d5e0f2a.5b208"]]},{"id":"8d7215d1.6dfd18","type":"debug","z":"8484646.833e198","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":400,"wires":[]},{"id":"f4ca62dc.ae34b","type":"inject","z":"8484646.833e198","name":"COUNT","topic":"SELECT COUNT(*) FROM RANDOMNUM","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":130,"y":440,"wires":[["9d5e0f2a.5b208"]]},{"id":"29558e2e.545582","type":"inject","z":"8484646.833e198","name":"SELECT","topic":"SELECT * FROM RANDOMNUM ORDER BY TIMESTAMP DESC LIMIT 100;","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":500,"wires":[["4dc03fc9.22dea"]]},{"id":"852f16e.709a3e8","type":"ui_template","z":"8484646.833e198","group":"8fb8647f.605e88","name":"","order":0,"width":"6","height":"7","format":"<table style=\"width:100%\">\n  <tr>\n    <th>Index</th> \n    <th>Timestamp</th>\n    <th>Value</th> \n    <th>Bool</th>\n  </tr>\n  <tr ng-repeat=\"x in msg.payload | limitTo:20\">\n    <td>{{$index}}</td>\n    <td>{{msg.payload[$index].TIMESTAMP}}</td>\n    <td>{{msg.payload[$index].VALUE}}</td> \n    <td>{{msg.payload[$index].BOOL}}</td>\n  </tr>\n</table>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":600,"y":500,"wires":[[]]},{"id":"68266292.d9f43c","type":"debug","z":"8484646.833e198","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":590,"y":540,"wires":[]},{"id":"aec9239d.cc376","type":"sqlite","z":"8484646.833e198","mydb":"8fb63f39.b200c","sqlquery":"msg.topic","sql":"","name":"db_003","x":440,"y":140,"wires":[["bbe65fa9.231ef"]]},{"id":"3d041ff8.99772","type":"sqlite","z":"8484646.833e198","mydb":"8fb63f39.b200c","sqlquery":"msg.topic","sql":"","name":"db_003","x":440,"y":200,"wires":[["eee4c1af.a72cc"]]},{"id":"34a62b4f.a21764","type":"sqlite","z":"8484646.833e198","mydb":"8fb63f39.b200c","sqlquery":"msg.topic","sql":"","name":"db_003","x":440,"y":260,"wires":[["72e6d526.73c10c"]]},{"id":"9d5e0f2a.5b208","type":"sqlite","z":"8484646.833e198","mydb":"8fb63f39.b200c","sqlquery":"msg.topic","sql":"","name":"db_003","x":440,"y":400,"wires":[["8d7215d1.6dfd18"]]},{"id":"4dc03fc9.22dea","type":"sqlite","z":"8484646.833e198","mydb":"8fb63f39.b200c","sqlquery":"msg.topic","sql":"","name":"db_003","x":440,"y":500,"wires":[["852f16e.709a3e8","68266292.d9f43c"]]},{"id":"8fb8647f.605e88","type":"ui_group","name":"Group 1","tab":"50ec94a2.74b2ec","order":1,"disp":true,"width":6},{"id":"8fb63f39.b200c","type":"sqlitedb","z":"","db":"db_003.db","mode":"RWC"},{"id":"50ec94a2.74b2ec","type":"ui_tab","z":"","name":"Main Tab","icon":"dashboard","order":1}]

Node-RED 一定時間後輸出到payload

一定時間後輸出到payload。

源自於  https://cafe.naver.com/nodered

[{"id":"ca69abf0.22ce88","type":"trigger","z":"ad5297e5.94bf08","op1":"","op2":"1","op1type":"nul","op2type":"num","duration":"1","extend":false,"units":"s","reset":"0","bytopic":"all","name":"","x":340,"y":320,"wires":[["8853a0f2.c91cd"]]},{"id":"a218d017.29eeb","type":"inject","z":"ad5297e5.94bf08","name":"","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":156.99995613098145,"y":265.9999580383301,"wires":[["8853a0f2.c91cd"]]},{"id":"5363b076.d29b8","type":"inject","z":"ad5297e5.94bf08","name":"","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":154.99995613098145,"y":316.9999580383301,"wires":[["8853a0f2.c91cd"]]},{"id":"8853a0f2.c91cd","type":"function","z":"ad5297e5.94bf08","name":"after 5","func":"var input = msg.payload;\nvar count = context.get('count')||0;\nvar msg1 ={};\ncount = count + input;\ncontext.set('count',count);\n\nif(input == '0') {\n    context.set('count',0);\n    msg.payload = 0;\n    msg1.payload = 0;\n    return [msg,msg1];\n}else{\n    if(count > '5') {       // after 5 second\n        msg.payload = 1;\n        msg1.payload = 1;\n        return [msg,msg1];\n    }else{\n        msg.payload = 1;\n        return msg;\n    }\n}\n\n\n","outputs":2,"noerr":0,"x":332,"y":266,"wires":[["ca69abf0.22ce88"],["52818114.1176d"]]},{"id":"52818114.1176d","type":"debug","z":"ad5297e5.94bf08","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":514.0000629425049,"y":270.00000858306885,"wires":[]},{"id":"18425f86.07e3d","type":"comment","z":"ad5297e5.94bf08","name":"after 5","info":"","x":130.99995613098145,"y":78.99991703033447,"wires":[]},{"id":"e5c4635e.296cf","type":"delay","z":"ad5297e5.94bf08","name":"","pauseType":"delay","timeout":"5","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":459.0796146392822,"y":140.11798191070557,"wires":[["ae91587.0fd5ea8"]]},{"id":"2c204da4.1ffeb2","type":"function","z":"ad5297e5.94bf08","name":"after 5","func":"var msg1={};\n\nif(msg.payload == '0'){\n    msg.reset = true;       //delay reset\n    msg1.payload = 0;\n    return [msg,msg1];    \n}else{\n    return msg;\n}","outputs":2,"noerr":0,"x":311.07295417785645,"y":180.3089702129364,"wires":[["e5c4635e.296cf"],["ae91587.0fd5ea8"]]},{"id":"ae91587.0fd5ea8","type":"debug","z":"ad5297e5.94bf08","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":621.0728778839111,"y":186.60067653656006,"wires":[]},{"id":"b6072921.e6bd98","type":"inject","z":"ad5297e5.94bf08","name":"","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":155.01729774475098,"y":141.01033687591553,"wires":[["2c204da4.1ffeb2"]]},{"id":"6e58575.10e98a8","type":"inject","z":"ad5297e5.94bf08","name":"","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":154.01729011535645,"y":180.01033210754395,"wires":[["2c204da4.1ffeb2"]]}]

使用flow.get和flow.set 將輸入輸出為數組的功能節點。

將輸入輸出為數組的功能節點。
使用flow.get和flow.set可以輕鬆應用其他流程。
在樹莓派中最好使用Pin輸入作為Pin輸出。 ^^

[{"id":"b173b2ed.d86b7","type":"inject","z":"58e45d0e.8e40d4","name":"0","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":96,"wires":[["b109d02f.4e774"]]},{"id":"8d9d37f5.8e4c78","type":"inject","z":"58e45d0e.8e40d4","name":"1","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":171.94094848632812,"y":134.0451464653015,"wires":[["b109d02f.4e774"]]},{"id":"d71cb5d8.0d4078","type":"inject","z":"58e45d0e.8e40d4","name":"0","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170.94098663330078,"y":179.04515552520752,"wires":[["ad353cda.ffc03"]]},{"id":"716af658.654708","type":"inject","z":"58e45d0e.8e40d4","name":"1","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":171.94097518920898,"y":217.0451521873474,"wires":[["ad353cda.ffc03"]]},{"id":"b109d02f.4e774","type":"function","z":"58e45d0e.8e40d4","name":"Pin1","func":"flow.set(\"pin1\",msg.payload);\nreturn msg;","outputs":1,"noerr":0,"x":315.99308586120605,"y":96.34375953674316,"wires":[["87374f36.90249"]]},{"id":"ad353cda.ffc03","type":"function","z":"58e45d0e.8e40d4","name":"Pin2","func":"flow.set(\"pin2\",msg.payload);\nreturn msg;","outputs":1,"noerr":0,"x":312.94100189208984,"y":177.04515552520752,"wires":[["87374f36.90249"]]},{"id":"87374f36.90249","type":"function","z":"58e45d0e.8e40d4","name":"Pin3","func":"\npin1=flow.get(\"pin1\")||0;\npin2=flow.get(\"pin2\")||0;\nif(pin1==1 && pin2==1){\n    pin3=1;\n}else{\n    pin3=0\n}\nflow.set(\"pin3\",pin3);\nmsg.payload=[pin1,pin2,pin3];\nreturn msg;","outputs":1,"noerr":0,"x":470.0035171508789,"y":95.34029626846313,"wires":[["936cab73.4a2ec8"]]},{"id":"936cab73.4a2ec8","type":"debug","z":"58e45d0e.8e40d4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":634.0034942626953,"y":93.63542127609253,"wires":[]},{"id":"1dac8814.d12028","type":"inject","z":"58e45d0e.8e40d4","name":"0","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":168.9408950805664,"y":328.04511165618896,"wires":[["4517be22.d6f65"]]},{"id":"31cd1f7e.e929d","type":"inject","z":"58e45d0e.8e40d4","name":"1","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170.88184356689453,"y":366.0902581214905,"wires":[["4517be22.d6f65"]]},{"id":"c8e52bc9.407008","type":"inject","z":"58e45d0e.8e40d4","name":"0","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":169.8818817138672,"y":411.0902671813965,"wires":[["7d34e94a.41d198"]]},{"id":"9cfcb8cc.0ce4f8","type":"inject","z":"58e45d0e.8e40d4","name":"1","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170.8818702697754,"y":449.0902638435364,"wires":[["7d34e94a.41d198"]]},{"id":"4517be22.d6f65","type":"function","z":"58e45d0e.8e40d4","name":"Pin1","func":"flow.set(\"pin1\",msg.payload);\nreturn msg;","outputs":1,"noerr":0,"x":314.93398094177246,"y":328.38887119293213,"wires":[["90bfcb51.a84098"]]},{"id":"7d34e94a.41d198","type":"function","z":"58e45d0e.8e40d4","name":"Pin2","func":"flow.set(\"pin2\",msg.payload);\nreturn msg;","outputs":1,"noerr":0,"x":311.88189697265625,"y":409.0902671813965,"wires":[["90bfcb51.a84098"]]},{"id":"90bfcb51.a84098","type":"function","z":"58e45d0e.8e40d4","name":"Pin3","func":"\npin1=flow.get(\"pin1\")||0;\npin2=flow.get(\"pin2\")||0;\nif(pin1==1 && pin2==1){\n    pin3=1;\n}else{\n    pin3=0\n}\nflow.set(\"pin3\",pin3);\nreturn msg;","outputs":1,"noerr":0,"x":461.94445419311523,"y":326.385440826416,"wires":[["bc2c50a3.91dc6"]]},{"id":"bc2c50a3.91dc6","type":"function","z":"58e45d0e.8e40d4","name":"Output 3","func":"msg.payload = flow.get(\"pin1\");\nvar msg1 = {payload : flow.get(\"pin2\")};\nvar msg2 = {payload : flow.get(\"pin3\")};\n\nreturn [msg,msg1,msg2];","outputs":3,"noerr":0,"x":603.9964790344238,"y":327.33678245544434,"wires":[["4cbf66c1.0d1738"],["34ed4389.c72e1c"],["16118cdd.7119d3"]]},{"id":"4cbf66c1.0d1738","type":"debug","z":"58e45d0e.8e40d4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":796.9999771118164,"y":313.6353930234909,"wires":[]},{"id":"34ed4389.c72e1c","type":"debug","z":"58e45d0e.8e40d4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":799.9408798217773,"y":353.0450838804245,"wires":[]},{"id":"16118cdd.7119d3","type":"debug","z":"58e45d0e.8e40d4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":802.9408798217773,"y":393.0450838804245,"wires":[]},{"id":"a4f3c52.5d75b38","type":"comment","z":"58e45d0e.8e40d4","name":"Pin Output (Array)","info":"","x":183.0034408569336,"y":47.194430351257324,"wires":[]},{"id":"6ba186f0.92cf08","type":"comment","z":"58e45d0e.8e40d4","name":"3 Pin Output","info":"","x":162.94094848632812,"y":284.045108795166,"wires":[]}]

Windwos 使用 SQLite於Node-RED中 (2)

Windwos 使用 SQLite於Node-RED中 (2)

[{"id":"c0ba6dfa.a85dd","type":"inject","z":"72a12cfc.f771e4","name":"CREATE","topic":"CREATE TABLE dhtreadings(id INTEGER PRIMARY KEY AUTOINCREMENT, temperature NUMERIC, humidity NUMERIC, currentdate DATE, currenttime TIME, device TEXT)","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":125,"y":48,"wires":[["1a34e68f.e39ff9"]]},{"id":"2e776df3.a57812","type":"inject","z":"72a12cfc.f771e4","name":"INSERT","topic":"INSERT INTO dhtreadings(temperature, humidity, currentdate, currenttime, device) values(22.4, 48, date('now'), time('now'), \"manual\")","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":125,"y":108,"wires":[["1a34e68f.e39ff9"]]},{"id":"c068385d.8a3638","type":"inject","z":"72a12cfc.f771e4","name":"SELECT","topic":"SELECT * FROM dhtreadings","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":125,"y":168,"wires":[["1a34e68f.e39ff9"]]},{"id":"5ccaf966.4eece8","type":"inject","z":"72a12cfc.f771e4","name":"DELETE","topic":"DELETE from dhtreadings","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":125,"y":228,"wires":[["1a34e68f.e39ff9"]]},{"id":"180db3b.4327a4c","type":"inject","z":"72a12cfc.f771e4","name":"DROP TABLE","topic":"DROP TABLE dhtreadings","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":135,"y":288,"wires":[["1a34e68f.e39ff9"]]},{"id":"1a34e68f.e39ff9","type":"sqlite","z":"72a12cfc.f771e4","mydb":"17a5d028.036f8","sqlquery":"msg.topic","sql":"","name":"SQLite","x":305,"y":168,"wires":[["5a91c882.f16008"]]},{"id":"5a91c882.f16008","type":"debug","z":"72a12cfc.f771e4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":468,"y":168,"wires":[]},{"id":"b16cf7e3.e28658","type":"sqlite","z":"72a12cfc.f771e4","mydb":"17a5d028.036f8","sqlquery":"msg.topic","sql":"","name":"SQLite","x":310,"y":360,"wires":[["b7961e1d.eb831"]]},{"id":"82b39c8.a4bba6","type":"inject","z":"72a12cfc.f771e4","name":"View Records","topic":"SELECT * FROM dhtreadings","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":130,"y":360,"wires":[["b16cf7e3.e28658"]]},{"id":"b7961e1d.eb831","type":"ui_template","z":"72a12cfc.f771e4","group":"2a2a636f.57fcfc","name":"UI Table","order":2,"width":"6","height":"3","format":"<table style=\"width:100%\">\n  <tr>\n    <th>Time</th> \n    <th>Temp</th> \n    <th>Hum</th>\n  </tr>\n  <tr ng-repeat=\"x in msg.payload | limitTo:120\">\n    <td>{{msg.payload[$index].currenttime}}</td>\n    <td>{{msg.payload[$index].temperature}}</td> \n    <td>{{msg.payload[$index].humidity}}</td>\n  </tr>\n</table>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":480,"y":360,"wires":[[]]},{"id":"17a5d028.036f8","type":"sqlitedb","z":"","db":"C:\\Users\\User\\AppData\\Roaming\\SPB_16.6\\.node-red\\db\\mydb.db","mode":"RWC"},{"id":"2a2a636f.57fcfc","type":"ui_group","z":"","name":"Data","tab":"17a49c76.7ad054","order":3,"disp":true,"width":"6","collapse":false},{"id":"17a49c76.7ad054","type":"ui_tab","z":"","name":"Sqlit3","icon":"photo_camera"}]