How to combine 2 arrays into 1?

General
5

Hi, I think you sql syntax on Inserting multiple rows is a little off
I made some changes to cleanup the Price since it had a return character in

[{"id":"7a43b0e4.382d4","type":"html","z":"49b7aeb2.4e263","name":"","property":"payload","outproperty":"payload","tag":"h3.productrow__title.heading.mb-4.mt-3.mt-md-0","ret":"text","as":"single","x":770,"y":1060,"wires":[["47252756.aeff48"]]},{"id":"7763ca89.b836a4","type":"html","z":"49b7aeb2.4e263","name":"","property":"payload","outproperty":"payload","tag":"span.js-price","ret":"text","as":"single","x":650,"y":980,"wires":[["eee4ea67.097098"]]},{"id":"47252756.aeff48","type":"join","z":"49b7aeb2.4e263","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"payload","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":1030,"y":980,"wires":[["81bc716d.0bda2","befb27b2.7df558"]]},{"id":"eee4ea67.097098","type":"function","z":"49b7aeb2.4e263","name":"","func":"var ar = [];\nfor(var i = 1; i < msg.payload.length; i += 2) {  // take every second element\n    ar.push(msg.payload[i].split(\"\\n\")[1].trim());\n    msg.test = ar\n}\nmsg.payload = msg.test\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":800,"y":980,"wires":[["47252756.aeff48"]]},{"id":"befb27b2.7df558","type":"function","z":"49b7aeb2.4e263","name":"","func":"// var myArray = msg.payload;\n// var myArray2 = msg.payload[1];\n// msg.topic = `INSERT INTO alarmsysteem (ArtikelNaam,Prijs) VALUES (\"${myArray.join('\"),(\"')}\")`\n// var topic2 = `(\"${myArray2.join('\"),(\"')}\")`\n// var arrayLength = msg.payload.length;\n// for (var i = 0; i <= arrayLength; i++) {\n// msg.testant = arrayLength\n// }\n// return msg;\n\n\nlet sql = \"INSERT INTO alarmsysteem (ArtikelNaam,Prijs) VALUES \"\n\nlet artikelNaam = msg.payload[0]\nlet prijs = msg.payload[1]\nlet valuesSql = []\n\n\nartikelNaam.forEach( (el, index) => {\n    valuesSql.push(`('${el}', '${prijs[index]}')`)\n    \n})\n\nmsg.topic = sql + valuesSql.join(\",\")\n\nreturn msg","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1220,"y":980,"wires":[["4bc38e10.8c88f8"]]},{"id":"81bc716d.0bda2","type":"debug","z":"49b7aeb2.4e263","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1150,"y":900,"wires":[]},{"id":"ac54a326.7b805","type":"http request","z":"49b7aeb2.4e263","name":"Request 5MP PoC camera's","method":"GET","ret":"txt","paytoqs":"ignore","url":"https://www.alarmsysteemexpert.nl/nl/hd-camerabewaking/hikvision-turbo-hd-camerabewaking/dome-camera/power-over-coax-poc-cameras/5mp-poc-cameras/","tls":"","persist":false,"proxy":"","authType":"","x":440,"y":1020,"wires":[["7a43b0e4.382d4","7763ca89.b836a4"]]},{"id":"66807acb.21f1b4","type":"inject","z":"49b7aeb2.4e263","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":220,"y":1020,"wires":[["ac54a326.7b805"]]},{"id":"4bc38e10.8c88f8","type":"debug","z":"49b7aeb2.4e263","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1370,"y":980,"wires":[]}]

Sql should be in the format

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');

Result after modification in the last function

INSERT INTO alarmsysteem (ArtikelNaam,Prijs) VALUES ('DS-2CE56H0T-ITME, 5MP, 2.8mm, klein model camera, 20m IR, Power over Coax', '62,00'),('DS-2CE56H0T-IT3E, Turbo HD camera Eyeball, 2.8mm, 40m EXIR, Power over Coax', '73,00'),('DS-2CE56H0T-VPITE 5MP D/N IR 3-Axis PoC Vandaal Dome 2.8mm Vaste lens', '82,00'),('5MP, 2.8mm~12mm motorzoom, 40m EXIR, Power over Coax, DS-2CE56H0T-IT3ZE', '119,00'),('5MP, Low Light, motorzoom 2.8~12mm, 40m EXIR, Power over Coax, DS-2CE56H5T-VPIT3ZE', '259,00')
1 Like