[{"id":"326cdcd2.a5f0a4","type":"inject","z":"45ee788b.7e0a08","name":"query","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":99.16667175293,"y":77.333335876465,"wires":[["ad9219cd.b09e48"]]},{"id":"b27f022a.1e6a4","type":"debug","z":"45ee788b.7e0a08","name":"","active":true,"console":"false","complete":"false","x":631.16668701172,"y":75.66667175293,"wires":[]},{"id":"511326c0.356458","type":"mysql","z":"45ee788b.7e0a08","mydb":"60cea294.12cacc","name":"MySQL","x":428.16669464111,"y":75.666675567627,"wires":[["b27f022a.1e6a4"]]},{"id":"ad9219cd.b09e48","type":"function","z":"45ee788b.7e0a08","name":"","func":"msg.topic=\"SELECT * FROM address;\";\nreturn msg;","outputs":1,"noerr":0,"x":260,"y":77,"wires":[["511326c0.356458"]]},{"id":"18c61de9.0ff262","type":"inject","z":"45ee788b.7e0a08","name":"insert","topic":"","payload":"{\"id\":6,\"name\":\"Piero Bellini\", \"telephone\":\"0039055 2758517\", \"email\":\"pierfrancesco.bellini@unifi.it\"}","payloadType":"json","repeat":"","crontab":"","once":false,"x":106,"y":214,"wires":[["6af37508.72746c"]]},{"id":"d28b4439.bcd708","type":"debug","z":"45ee788b.7e0a08","name":"","active":true,"console":"false","complete":"false","x":630,"y":214.33333587646,"wires":[]},{"id":"189b34b4.ab56eb","type":"mysql","z":"45ee788b.7e0a08","mydb":"60cea294.12cacc","name":"MySQL","x":437.00003051758,"y":214.33334350586,"wires":[["d28b4439.bcd708"]]},{"id":"6af37508.72746c","type":"template","z":"45ee788b.7e0a08","name":"","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"INSERT INTO address VALUES (\"{{payload.id}}\",\"{{payload.name}}\",\"{{payload.telephone}}\",\"{{payload.email}}\");","output":"str","x":261,"y":214,"wires":[["189b34b4.ab56eb"]]},{"id":"436f8b7c.b66304","type":"inject","z":"45ee788b.7e0a08","name":"delete","topic":"","payload":"{\"id\":6}","payloadType":"json","repeat":"","crontab":"","once":false,"x":97,"y":333,"wires":[["9403799c.97e058"]]},{"id":"bc29315e.1dc82","type":"debug","z":"45ee788b.7e0a08","name":"","active":true,"console":"false","complete":"false","x":621,"y":333.33333587646,"wires":[]},{"id":"e7b21b2b.59a6d8","type":"mysql","z":"45ee788b.7e0a08","mydb":"60cea294.12cacc","name":"MySQL","x":425.00003051758,"y":333.33334350586,"wires":[["bc29315e.1dc82"]]},{"id":"9403799c.97e058","type":"template","z":"45ee788b.7e0a08","name":"","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DELETE FROM address WHERE id={{payload.id}};","output":"str","x":252,"y":333,"wires":[["e7b21b2b.59a6d8"]]},{"id":"60cea294.12cacc","type":"MySQLdatabase","z":"","host":"192.168.0.37","port":"3306","db":"test","tz":""}]