WOKWI DHT22 & LED , Node-Red + SQLite database
Node-Red程式
[{"id":"6f0240353e534bbd","type":"comment","z":"d90cd4f43857dd3e","name":"TABLE DHT22STATUS","info":"//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n","x":160,"y":300,"wires":[]},{"id":"826ba79734e77bca","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":530,"y":340,"wires":[["04fd1dd0adc2e130"]]},{"id":"4a334564f94f7fcc","type":"function","z":"d90cd4f43857dd3e","name":"CREATE DATABASE","func":"//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n//CREATE TABLE DHT22STATUS (id INTEGER,Temp TEXT,Humi TEXT,Date DATE,Time TIME,PRIMARY KEY (id));\nmsg.topic = \"CREATE TABLE DHT22STATUS (id INTEGER,Temp TEXT,Humi TEXT,Date DATE,Time TIME,PRIMARY KEY (id))\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":320,"y":340,"wires":[["826ba79734e77bca"]]},{"id":"314685a445c2381d","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":7,"width":0,"height":0,"passthru":false,"label":"建立資料庫","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"建立資料庫","payloadType":"str","topic":"topic","topicType":"msg","x":130,"y":340,"wires":[["4a334564f94f7fcc","779d325bdf9e2cc0"]]},{"id":"779d325bdf9e2cc0","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":245,"y":400,"wires":[],"l":false},{"id":"7a108bc5db731170","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","order":1,"width":6,"height":1,"passthru":false,"label":"ON","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"on","payloadType":"str","topic":"topic","topicType":"msg","x":130,"y":60,"wires":[["f396c3b64911fa04","a14b4674c6a34660","8697ad0d5894c796"]]},{"id":"449746f56ea6c82e","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","order":2,"width":6,"height":1,"passthru":false,"label":"OFF","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"off","payloadType":"str","topic":"topic","topicType":"msg","x":130,"y":100,"wires":[["f396c3b64911fa04","a14b4674c6a34660","8697ad0d5894c796"]]},{"id":"128ad71539ada8a6","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","order":3,"width":6,"height":1,"passthru":false,"label":"TIMER","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"timer","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":140,"wires":[["f396c3b64911fa04","a14b4674c6a34660","8697ad0d5894c796"]]},{"id":"4a4c2d1ec53a6f62","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","order":4,"width":6,"height":1,"passthru":false,"label":"FLASH","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"flash","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":180,"wires":[["f396c3b64911fa04","a14b4674c6a34660","8697ad0d5894c796"]]},{"id":"f396c3b64911fa04","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":295,"y":120,"wires":[],"l":false},{"id":"04fd1dd0adc2e130","type":"debug","z":"d90cd4f43857dd3e","name":"debug ","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":710,"y":340,"wires":[]},{"id":"270e32067dabb9ef","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":4,"width":0,"height":0,"passthru":false,"label":"檢視資料庫資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"檢視資料","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":500,"wires":[["93dc37739f4c49ca","21e4e036d8987fea"]]},{"id":"93dc37739f4c49ca","type":"function","z":"d90cd4f43857dd3e","name":"檢視資料","func":"//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n\n//SELECT * FROM DHT22STATUS ORDER BY id DESC LIMIT 50;\n\nmsg.topic = \"SELECT * FROM DHT22STATUS ORDER BY id DESC LIMIT 50\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":360,"y":500,"wires":[["83e2a325774e26e2"]]},{"id":"f30298c1e6890b2d","type":"ui_table","z":"d90cd4f43857dd3e","group":"3a18026dc181f483","name":"","order":1,"width":10,"height":12,"columns":[],"outputs":0,"cts":false,"x":810,"y":500,"wires":[]},{"id":"83e2a325774e26e2","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":550,"y":500,"wires":[["f30298c1e6890b2d"]]},{"id":"fc5c75ae20fdb73b","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":6,"width":3,"height":1,"passthru":false,"label":"刪除資料庫 ","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除資料庫 ","payloadType":"str","topic":"topic","topicType":"msg","x":130,"y":740,"wires":[["7265060f2af01c7f","4e2701b4f43c7f2f"]]},{"id":"03f1dfd7ad10fccd","type":"function","z":"d90cd4f43857dd3e","name":"DROP DATABASE","func":"//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n\nmsg.topic = \"DROP TABLE DHT22STATUS\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":540,"y":680,"wires":[["a92134f903f04a0a"]]},{"id":"a92134f903f04a0a","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":770,"y":600,"wires":[["5664a000d04d8985"]]},{"id":"41311e4178c4f2b2","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":5,"width":3,"height":1,"passthru":false,"label":"刪除所有資料 ","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除所有資料 ","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":640,"wires":[["4e2701b4f43c7f2f","b5cc53139a165a6d"]]},{"id":"a9df1f0ce94a2af1","type":"function","z":"d90cd4f43857dd3e","name":"DELETE ALL DATA","func":"//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n\nmsg.topic = \"DELETE from DHT22STATUS\";\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":410,"y":580,"wires":[["a92134f903f04a0a"]]},{"id":"7265060f2af01c7f","type":"ui_toast","z":"d90cd4f43857dd3e","position":"prompt","displayTime":"3","highlight":"","sendall":true,"outputs":1,"ok":"OK","cancel":"Cancel","raw":true,"className":"","topic":"","name":"","x":330,"y":740,"wires":[["22df757e0314aef0"]]},{"id":"22df757e0314aef0","type":"function","z":"d90cd4f43857dd3e","name":"function Y/N ?","func":"var topic=msg.payload;\nif (topic==\"\"){\n return [msg,null];\n \n}\nif (topic==\"Cancel\"){\n return [null,msg];\n \n}\nreturn msg;","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":520,"y":740,"wires":[["03f1dfd7ad10fccd"],[]]},{"id":"4e2701b4f43c7f2f","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":225,"y":680,"wires":[],"l":false},{"id":"b5cc53139a165a6d","type":"ui_toast","z":"d90cd4f43857dd3e","position":"prompt","displayTime":"3","highlight":"","sendall":true,"outputs":1,"ok":"OK","cancel":"Cancel","raw":true,"className":"","topic":"","name":"","x":350,"y":640,"wires":[["41e98cfedebb5434"]]},{"id":"41e98cfedebb5434","type":"function","z":"d90cd4f43857dd3e","name":"function Y/N ?","func":"var topic=msg.payload;\nif (topic==\"\"){\n return [msg,null];\n \n}\nif (topic==\"Cancel\"){\n return [null,msg];\n \n}\nreturn msg;","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":520,"y":640,"wires":[["a9df1f0ce94a2af1"],[]]},{"id":"21e4e036d8987fea","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"a4d2ace4206ad2ca","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":215,"y":540,"wires":[],"l":false},{"id":"f20067d3f5f79578","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":3,"width":2,"height":1,"passthru":false,"label":"查詢一筆資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"查詢一筆資料","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":800,"wires":[["4e2701b4f43c7f2f","c180197f4e3bda67"]]},{"id":"21b30402f72f5e23","type":"function","z":"d90cd4f43857dd3e","name":"查詢一筆資料","func":"//\nvar id = msg.payload.id;\nvar s=global.get(\"SEL1\")\nmsg.topic=\"\";\nvar temp=\"\";\n\nif (s==1)\n{\n temp =\"SELECT * FROM DHT22STATUS\";\n temp=temp+\" WHERE id LIKE '\"+ id +\"'\";\n}\nmsg.topic=temp;\nglobal.set(\"SEL1\",0);\n\nreturn msg;\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":680,"y":800,"wires":[["2cb949ba4cadd7aa"]]},{"id":"2cb949ba4cadd7aa","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":790,"y":720,"wires":[["f30298c1e6890b2d"]]},{"id":"9f2f73aa6c35403b","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":1,"width":2,"height":1,"passthru":false,"label":"刪除一筆資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"刪除一筆資料","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":860,"wires":[["3ad5d199dc7b72bf","6e916cb7bb92703e"]]},{"id":"3ad5d199dc7b72bf","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"11d8514.a44dcaf","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":true,"x":275,"y":900,"wires":[],"l":false},{"id":"9f833d46767c6d92","type":"ui_form","z":"d90cd4f43857dd3e","name":"","label":"輸入id","group":"92ed45c1ead25706","order":8,"width":0,"height":0,"options":[{"label":"ID","value":"id","type":"number","required":true,"rows":null}],"formValue":{"id":""},"payload":"","submit":"Submit","cancel":"Cancle","topic":"Form","topicType":"str","splitLayout":false,"className":"","x":530,"y":860,"wires":[["21b30402f72f5e23","95385e58736c8781","d54c996990ff5aed"]]},{"id":"95385e58736c8781","type":"function","z":"d90cd4f43857dd3e","name":"刪除一筆資料","func":"//\nvar id = msg.payload.id;\nvar s=global.get(\"SEL2\")\nmsg.topic=\"\";\nvar temp=\"\";\n\nif (s==2)\n{\n temp =\"DELETE FROM DHT22STATUS\";\n temp=temp+\" WHERE id LIKE '\"+ id +\"'\";\n}\n\nmsg.topic=temp;\nglobal.set(\"SEL2\",0)\nreturn msg;\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":700,"y":860,"wires":[["29520d8aeaf20941","3e3ce5e5c22f23d4"]]},{"id":"5664a000d04d8985","type":"link out","z":"d90cd4f43857dd3e","name":"link out 62","mode":"link","links":["821d3319de5c02a3"],"x":895,"y":600,"wires":[]},{"id":"821d3319de5c02a3","type":"link in","z":"d90cd4f43857dd3e","name":"link in 60","links":["5664a000d04d8985"],"x":275,"y":540,"wires":[["93dc37739f4c49ca"]]},{"id":"29520d8aeaf20941","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":950,"y":860,"wires":[["5664a000d04d8985"]]},{"id":"7921d7bb4a433c0e","type":"ui_button","z":"d90cd4f43857dd3e","name":"","group":"92ed45c1ead25706","order":2,"width":2,"height":1,"passthru":false,"label":"更正一筆資料","tooltip":"","color":"","bgcolor":"","className":"","icon":"","payload":"更正一筆資料","payloadType":"str","topic":"topic","topicType":"msg","x":140,"y":940,"wires":[["3ad5d199dc7b72bf","cc1524b3ce85e730"]]},{"id":"0922993ffe425812","type":"comment","z":"d90cd4f43857dd3e","name":"UPDATE查詢的WHERE","info":"UPDATE查詢的WHERE子句的基本語法如下：\n\nUPDATE table_name\nSET column1 = value1, column2 = value2...., columnN = valueN\nWHERE [condition];","x":160,"y":980,"wires":[]},{"id":"b97e40cdd6b22098","type":"function","z":"d90cd4f43857dd3e","name":"更正一筆資料","func":"//\nvar id = global.get(\"ID\");\n\nvar Temper = msg.payload.Temper;\nvar Humid = msg.payload.Humi;\nvar date = msg.payload.date;\nvar time = msg.payload.time;\n\nvar s=global.get(\"SEL3\")\nmsg.topic=\"\";\nvar temp=\"\";\n\nif (s==3)\n{\n temp =\"update DHT22STATUS set \";\n temp=temp+\" Temp= '\" + Temper + \"'\";\n temp=temp+\" , Humi= '\" + Humid + \"'\"; \n temp=temp+\" , Date= '\" + date + \"'\";\n temp=temp+\" , Time= '\" + time + \"'\";\n temp=temp+\" WHERE id=\" + id;\n \n //msg.topic = \"update DHT22STATUS set ( id , Temp , Humi , Date , Time ) VALUES ($id, $status , $date , $time ) \" ;\n //msg.payload = [id,status,date,time]\n}\nmsg.topic=temp;\n\nreturn msg;\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":800,"y":980,"wires":[["29520d8aeaf20941","c905b674511f7799"]]},{"id":"c180197f4e3bda67","type":"function","z":"d90cd4f43857dd3e","name":"function flow set1","func":"var s1=1;\nglobal.set(\"SEL1\",s1);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":350,"y":800,"wires":[["9f833d46767c6d92"]]},{"id":"6e916cb7bb92703e","type":"function","z":"d90cd4f43857dd3e","name":"function flow set2","func":"var s1=2;\nglobal.set(\"SEL2\",s1);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":350,"y":860,"wires":[["9f833d46767c6d92"]]},{"id":"cc1524b3ce85e730","type":"function","z":"d90cd4f43857dd3e","name":"function flow set3","func":"var s1=3;\nglobal.set(\"SEL3\",s1);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":350,"y":940,"wires":[["9f833d46767c6d92"]]},{"id":"66799965948d7085","type":"ui_form","z":"d90cd4f43857dd3e","name":"","label":"更正欄位","group":"92ed45c1ead25706","order":9,"width":0,"height":0,"options":[{"label":"Temperature","value":"Temper","type":"text","required":true,"rows":null},{"label":"Humidity","value":"Humi","type":"text","required":true,"rows":null},{"label":"DATE","value":"date","type":"text","required":true,"rows":null},{"label":"TIME","value":"time","type":"text","required":true,"rows":null}],"formValue":{"Temper":"","Humi":"","date":"","time":""},"payload":"","submit":"Submit","cancel":"Cancle","topic":"Form","topicType":"str","splitLayout":false,"className":"","x":620,"y":980,"wires":[["b97e40cdd6b22098"]]},{"id":"3e3ce5e5c22f23d4","type":"debug","z":"d90cd4f43857dd3e","name":"debug 324","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"topic","targetType":"msg","statusVal":"","statusType":"auto","x":910,"y":820,"wires":[]},{"id":"d54c996990ff5aed","type":"function","z":"d90cd4f43857dd3e","name":"Store ID資料","func":"//\nvar id = msg.payload.id;\nglobal.set(\"ID\",id)\nreturn msg;\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":630,"y":920,"wires":[["66799965948d7085","90ec5c2a06dc131c"]]},{"id":"90ec5c2a06dc131c","type":"function","z":"d90cd4f43857dd3e","name":"查詢一筆資料","func":"//\nvar id = global.get(\"ID\");\nmsg.topic=\"\";\nvar temp=\"\";\ntemp =\"SELECT * FROM DHT22STATUS\";\ntemp=temp+\" WHERE id LIKE '\"+ id +\"'\";\n\nmsg.topic=temp;\n\nreturn msg;\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":820,"y":920,"wires":[["2cb949ba4cadd7aa"]]},{"id":"c905b674511f7799","type":"debug","z":"d90cd4f43857dd3e","name":"debug 325","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"topic","targetType":"msg","statusVal":"","statusType":"auto","x":990,"y":980,"wires":[]},{"id":"431ca02417754844","type":"mqtt in","z":"d90cd4f43857dd3e","name":"LED status ","topic":"alex9ufo/wokwi/dht22","qos":"1","datatype":"utf8","broker":"584db2f88f8050c2","nl":false,"rap":true,"rh":0,"inputs":0,"x":100,"y":1280,"wires":[["f24f827457cd66df"]]},{"id":"f13742343cdf0af6","type":"function","z":"d90cd4f43857dd3e","name":"function ","func":"var temp=msg.payload[0];\nvar humi=msg.payload[1];\n\nmsg.payload=\" ---ESP32回來資料---\" + '溫度' + temp + '濕度' + humi;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":420,"y":1220,"wires":[["d506fccb2fead3c9","d4a628bbb74220ad","af50936ec9348b60"]]},{"id":"d506fccb2fead3c9","type":"function","z":"d90cd4f43857dd3e","name":"Set Line API ","func":"msg.headers = {'content-type':'application/x-www-form-urlencoded','Authorization':'Bearer A4wwPNh2WqB7dlfeQyyIAwtggn1kfZSI5LkkCdia1gB'};\nmsg.payload = {\"message\":msg.payload};\nreturn msg;\n\n//oR7KdXvK1eobRr2sRRgsl4PMq23DjDlhfUs96SyUBZu","outputs":1,"noerr":0,"x":610,"y":1160,"wires":[["32a67e448f49163b"]]},{"id":"32a67e448f49163b","type":"http request","z":"d90cd4f43857dd3e","name":"","method":"POST","ret":"txt","paytoqs":false,"url":"https://notify-api.line.me/api/notify","tls":"","persist":false,"proxy":"","authType":"","x":760,"y":1160,"wires":[["170217955493ed65"]]},{"id":"170217955493ed65","type":"debug","z":"d90cd4f43857dd3e","name":"debug 326","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":910,"y":1160,"wires":[]},{"id":"05a2015e7195ca04","type":"comment","z":"d90cd4f43857dd3e","name":"Line Notify Message ","info":"","x":630,"y":1120,"wires":[]},{"id":"a14b4674c6a34660","type":"mqtt out","z":"d90cd4f43857dd3e","name":"Control LED","topic":"alex9ufo/wokwi/led","qos":"1","retain":"true","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"584db2f88f8050c2","x":350,"y":60,"wires":[]},{"id":"cefeec1ac1ca5e7f","type":"comment","z":"d90cd4f43857dd3e","name":"Topic : alex9ufo/wokwi/led","info":"### ## # **Topic : alex9ufo/wokwi/led******","x":470,"y":100,"wires":[]},{"id":"8697ad0d5894c796","type":"ui_text","z":"d90cd4f43857dd3e","group":"a4d2ace4206ad2ca","order":5,"width":6,"height":1,"name":"","label":"Node-RED發行到MQTT的資料 : ","format":"{{msg.payload}}","layout":"row-left","className":"","x":410,"y":180,"wires":[]},{"id":"df92bbeeb09f18c7","type":"ui_audio","z":"d90cd4f43857dd3e","name":"","group":"3a18026dc181f483","voice":"Microsoft Hanhan - Chinese (Traditional, Taiwan)","always":"","x":760,"y":1200,"wires":[]},{"id":"d4a628bbb74220ad","type":"delay","z":"d90cd4f43857dd3e","name":"","pauseType":"delay","timeout":"1","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":600,"y":1200,"wires":[["df92bbeeb09f18c7"]]},{"id":"f1abdc1260b065ed","type":"comment","z":"d90cd4f43857dd3e","name":"資料庫位置 C:\\Users\\User\\.node-red\\202409_DHT22.db","info":"","x":480,"y":300,"wires":[]},{"id":"1da4c0e301a2d608","type":"comment","z":"d90cd4f43857dd3e","name":"mqtt_server = \"broker.mqttgo.io\"","info":"const char* mqtt_server = \"broker.mqttgo.io\";\n//const char* mqtt_server = \"test.mosquitto.org\";","x":410,"y":20,"wires":[]},{"id":"af50936ec9348b60","type":"ui_text","z":"d90cd4f43857dd3e","group":"3a18026dc181f483","order":2,"width":10,"height":1,"name":"","label":"訂閱MQTT的資料 : ","format":"{{msg.payload}}","layout":"row-left","className":"","x":630,"y":1240,"wires":[]},{"id":"f24f827457cd66df","type":"function","z":"d90cd4f43857dd3e","name":"function 103","func":"msg.payload = msg.payload.split(\",\");\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":270,"y":1280,"wires":[["4aef162671169373","60705eadddf942b3","5c6e40bdc2ead748","f13742343cdf0af6","daf0202ce55f5c9b"]]},{"id":"f2096640664014f4","type":"debug","z":"d90cd4f43857dd3e","name":"debug 327","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":1280,"wires":[]},{"id":"4aef162671169373","type":"function","z":"d90cd4f43857dd3e","name":"function 104","func":"msg.payload=msg.payload[0];\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":430,"y":1280,"wires":[["f2096640664014f4"]]},{"id":"60705eadddf942b3","type":"function","z":"d90cd4f43857dd3e","name":"function 105","func":"msg.payload=msg.payload[1];\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":430,"y":1340,"wires":[["18a2cab9108622e9"]]},{"id":"18a2cab9108622e9","type":"debug","z":"d90cd4f43857dd3e","name":"debug 328","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":1340,"wires":[]},{"id":"5c6e40bdc2ead748","type":"debug","z":"d90cd4f43857dd3e","name":"debug 329","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":430,"y":1160,"wires":[]},{"id":"daf0202ce55f5c9b","type":"function","z":"d90cd4f43857dd3e","name":"INSERT","func":"var temp=msg.payload[0];\nvar humi=msg.payload[1];\n\nvar Today = new Date();\nvar yyyy = Today.getFullYear(); //年\nvar MM = Today.getMonth()+1; //月\nvar dd = Today.getDate(); //日\nvar h = Today.getHours(); //時\nvar m = Today.getMinutes(); //分\nvar s = Today.getSeconds(); //秒\nif(MM<10)\n{\n MM = '0'+MM;\n}\n\nif(dd<10)\n{\n dd = '0'+dd;\n}\n\nif(h<10)\n{\n h = '0'+h;\n}\n\nif(m<10)\n{\n m = '0' + m;\n}\n\nif(s<10)\n{\n s = '0' + s;\n}\nvar var_date = yyyy+'/'+MM+'/'+dd;\nvar var_time = h+':'+m+':'+s;\n\n\nmsg.topic = \"INSERT INTO DHT22STATUS ( Temp, Humi , Date , Time ) VALUES ($temp, $humi, $var_date , $var_time ) \" ;\nmsg.payload = [temp, humi, var_date , var_time ]\nreturn msg;\n\n\n//CREATE TABLE DHT22STATUS (\n//id INTEGER,\n//Temp TEXT,\n//Humi TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":420,"y":1060,"wires":[["cf0ec0632468bc8d"]]},{"id":"cf0ec0632468bc8d","type":"sqlite","z":"d90cd4f43857dd3e","mydb":"4e71ffcc.32ba8","sqlquery":"msg.topic","sql":"","name":"DHT22_STATUS","x":610,"y":1060,"wires":[["5ca84b1ded133e95"]]},{"id":"5ca84b1ded133e95","type":"link out","z":"d90cd4f43857dd3e","name":"link out 63","mode":"link","links":["6032fd42e42809e1"],"x":735,"y":1060,"wires":[]},{"id":"6032fd42e42809e1","type":"link in","z":"d90cd4f43857dd3e","name":"link in 61","links":["5ca84b1ded133e95"],"x":265,"y":460,"wires":[["93dc37739f4c49ca"]]},{"id":"4e71ffcc.32ba8","type":"sqlitedb","db":"C:\\Users\\User\\.node-red\\202409_DHT22.db","mode":"RWC"},{"id":"92ed45c1ead25706","type":"ui_group","name":"DHT22 資料庫命令區","tab":"62b7557c711185f0","order":3,"disp":true,"width":"6","collapse":false,"className":""},{"id":"a4d2ace4206ad2ca","type":"ui_group","name":"LED控制","tab":"62b7557c711185f0","order":1,"disp":true,"width":6,"collapse":false,"className":""},{"id":"3a18026dc181f483","type":"ui_group","name":"DHT22 資料庫顯示區","tab":"62b7557c711185f0","order":2,"disp":true,"width":10,"collapse":false,"className":""},{"id":"11d8514.a44dcaf","type":"ui_group","name":"控制","tab":"8f1ada5fa4df30e2","order":2,"disp":true,"width":"6","collapse":false,"className":""},{"id":"584db2f88f8050c2","type":"mqtt-broker","name":"broker.mqttgo.io","broker":"broker.mqttgo.io","port":"1883","clientid":"","autoConnect":true,"usetls":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"userProps":"","sessionExpiry":""},{"id":"62b7557c711185f0","type":"ui_tab","name":"WOKWI SQLite DHT22 LED","icon":"dashboard","order":136,"disabled":false,"hidden":false},{"id":"8f1ada5fa4df30e2","type":"ui_tab","name":"作業2-1","icon":"dashboard","disabled":false,"hidden":false}]
WOKWI程式
沒有留言:
張貼留言