· 6 years ago · Apr 15, 2019, 03:16 AM
1[{"id":"566bb2d8.50056c","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"8d070c16.95ef58","type":"sqlite","z":"566bb2d8.50056c","mydb":"ff49bbf4.a7e72","sqlquery":"msg.topic","sql":"","name":"","x":570,"y":240,"wires":[["725d8c4a.8bb57c","9e0aea51.b8f4b8"]]},{"id":"eadff6e5.ebabe8","type":"function","z":"566bb2d8.50056c","name":"create candidatos","func":"msg.topic = `CREATE TABLE IF NOT EXISTS candidatos (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n nombre TEXT NOT NULL,\n apellido TEXT NOT NULL,\n desc TEXT NOT NULL,\n img TEXT NOT NULL,\n votos INT NOT NULL DEFAULT 0\n);`\nreturn msg;","outputs":1,"noerr":0,"x":350,"y":120,"wires":[["8d070c16.95ef58"]]},{"id":"e2dee773.98a24","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":180,"y":120,"wires":[["eadff6e5.ebabe8"]]},{"id":"725d8c4a.8bb57c","type":"debug","z":"566bb2d8.50056c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":710,"y":280,"wires":[]},{"id":"a12cb27c.f0ec5","type":"function","z":"566bb2d8.50056c","name":"select candidatos","func":"msg.topic = `SELECT * FROM candidatos;`\nreturn msg;","outputs":1,"noerr":0,"x":350,"y":200,"wires":[["8d070c16.95ef58"]]},{"id":"3da06827.eb21b8","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":180,"y":160,"wires":[["a12cb27c.f0ec5"]]},{"id":"d8a913cb.917f88","type":"function","z":"566bb2d8.50056c","name":"insert candidato","func":"msgs = [\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Jorge', 'Caballero', 'por el Centro metal-mecánico', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Ãlvaro', 'Vicuña', 'por Inversiones Núcleo', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Alejandro', 'Villasante', 'por MultiquÃmica', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Giovani', 'Piraino', 'por Difem Laboratorios', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Drago', 'Gluscevic', 'por Patio La Reina', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Héctor', 'Fernández', 'por Lavacenter Express', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Claudio', 'Saavedra', 'por Gran Pavesi', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Pablo', 'Sakamoto', 'por SAGU', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`},\n { topic: `INSERT INTO candidatos (nombre, apellido, desc, img) VALUES ('Felipe', 'Westendarp', 'por Anilinas Montblanc', 'https://images-na.ssl-images-amazon.com/images/I/8166xCVDGnL._SL1500_.jpg');`}\n]\nreturn [msgs];","outputs":1,"noerr":0,"x":360,"y":240,"wires":[["8d070c16.95ef58"]]},{"id":"e3ad2d02.749a98","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":200,"y":240,"wires":[["d8a913cb.917f88"]]},{"id":"13b1c55a.54868b","type":"http in","z":"566bb2d8.50056c","name":"","url":"candidatos","method":"get","upload":false,"swaggerDoc":"","x":160,"y":200,"wires":[["a12cb27c.f0ec5"]]},{"id":"9e0aea51.b8f4b8","type":"http response","z":"566bb2d8.50056c","name":"","statusCode":"","headers":{"Access-Control-Allow-Origin":"*"},"x":690,"y":240,"wires":[]},{"id":"340b98b2.d4c448","type":"http in","z":"566bb2d8.50056c","name":"","url":"voto","method":"post","upload":false,"swaggerDoc":"","x":190,"y":280,"wires":[["634ee9f6.1ef37","89cc1657.cf3cb8"]]},{"id":"6b9df40a.0fd494","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":480,"wires":[["83551b31.2c8938"]]},{"id":"83551b31.2c8938","type":"function","z":"566bb2d8.50056c","name":"post voto","func":"msg.payload = {\n idCandidato: 1\n}\nreturn msg;","outputs":1,"noerr":0,"x":300,"y":480,"wires":[["e05c12d3.bc3ee"]]},{"id":"e05c12d3.bc3ee","type":"http request","z":"566bb2d8.50056c","name":"","method":"POST","ret":"txt","url":"localhost:1880/voto","tls":"","x":450,"y":480,"wires":[["aab4bfa0.3df59"]]},{"id":"aab4bfa0.3df59","type":"debug","z":"566bb2d8.50056c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":610,"y":480,"wires":[]},{"id":"634ee9f6.1ef37","type":"debug","z":"566bb2d8.50056c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":350,"y":320,"wires":[]},{"id":"89cc1657.cf3cb8","type":"function","z":"566bb2d8.50056c","name":"update votos","func":"msg.topic = `UPDATE candidatos SET votos = votos + 1 WHERE id = ${msg.payload.idCandidato};`\nreturn msg;","outputs":1,"noerr":0,"x":350,"y":280,"wires":[["8d070c16.95ef58"]]},{"id":"5732c6c7.8ef4d8","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":200,"y":320,"wires":[["89cc1657.cf3cb8"]]},{"id":"33a31c07.375a84","type":"function","z":"566bb2d8.50056c","name":"drop candidatos","func":"msg.topic = `DROP TABLE candidatos;`\nreturn msg;","outputs":1,"noerr":0,"x":340,"y":80,"wires":[["8d070c16.95ef58"]]},{"id":"80f2c6f3.405dd8","type":"inject","z":"566bb2d8.50056c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":180,"y":80,"wires":[["33a31c07.375a84"]]},{"id":"ff49bbf4.a7e72","type":"sqlitedb","z":"","db":"votos","mode":"RWC"}]