smick_dbms_v04r01
Flow dbms Flow di gestione di una tabella contenente le misure di tutt i tipi di sensori.
[{"id":"d5b29273.aa958","type":"go","z":"39d1a849.3ea778","name":"","x":130,"y":100,"wires":[["b2ea2e3e.b6dd7"]]},{"id":"93d5fe0b.e57ce","type":"go","z":"39d1a849.3ea778","name":"","x":130,"y":160,"wires":[["20cf9545.6cafc2"]]},{"id":"78d32b7c.40ef74","type":"go","z":"39d1a849.3ea778","name":"","x":130,"y":220,"wires":[["eadf4f6.6b4d8b"]]},{"id":"eb5c1e37.582008","type":"mysql","z":"39d1a849.3ea778","mydb":"fd196c36.4d8748","name":"db","x":499,"y":102,"wires":[["f3222826.f36e38"]]},{"id":"b2ea2e3e.b6dd7","type":"template","z":"39d1a849.3ea778","name":"CREATE","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"CREATE TABLE db (\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\ntime TIMESTAMP,\nsn VARCHAR(12),\ntype INT(6) UNSIGNED,\nname VARCHAR(16),\npos VARCHAR(16),\nd1 VARCHAR(16),\nd2 VARCHAR(16),\nd3 VARCHAR(16),\nd4 VARCHAR(16),\nd5 VARCHAR(16),\nd6 VARCHAR(16),\nd7 VARCHAR(16),\nd8 VARCHAR(16)\n)","output":"str","x":280,"y":100,"wires":[["eb5c1e37.582008"]]},{"id":"20cf9545.6cafc2","type":"template","z":"39d1a849.3ea778","name":"DROP","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DROP TABLE db","output":"str","x":270,"y":160,"wires":[["eb5c1e37.582008"]]},{"id":"eadf4f6.6b4d8b","type":"template","z":"39d1a849.3ea778","name":"DELETE ","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DELETE FROM db","output":"str","x":280,"y":220,"wires":[["eb5c1e37.582008"]]},{"id":"43c44c09.f1146c","type":"template","z":"39d1a849.3ea778","name":"SELECT NOW()","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"SELECT NOW()","output":"str","x":300,"y":41,"wires":[["eb5c1e37.582008"]]},{"id":"118f0911.fdf7df","type":"go","z":"39d1a849.3ea778","name":"","x":130,"y":41,"wires":[["43c44c09.f1146c"]]},{"id":"f3222826.f36e38","type":"display","z":"39d1a849.3ea778","active":true,"x":669,"y":102,"wires":[]},{"id":"fd196c36.4d8748","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"nodered","tz":"'-02:00'"}]
