Forming an array format for multi row insertion nodejs-mysql

Question

I have an object item like below

var item = {"9":"9","22":"22","23":"23","24":"24"};

and variables var cart = 23; and var group = 40;

Now I want to form those items in a format such that I can perform multi-row MySQL insert like below

var sql = "INSERT INTO test (item, cart, group) VALUES ?";
var values = [
    [9, 23, 40],
    [22, 23, 40],
    [23, 23, 40],
    [24, 23, 40]
];

I need to form the above array format to perform multi rows insert in node js. How to make the above format?

values of item object. I want to make that values array format — SO-user
– SO-user, Commented May 19, 2017 at 20:55

Matias Cicero · Accepted Answer · 2017-05-19 20:51:47Z

1

Use Array.prototype.map:

var values = Object.keys(item).map(k => [k, cart, group]);

answered May 19, 2017 at 20:51

Matias Cicero

26.5k21 gold badges91 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nina Scholz · Accepted Answer · 2017-05-19 20:58:05Z

0

You could map the values of the object and return an array with numbers.

var item = { 9: "9", 22: "22", 23: "23", 24:"24" },
    cart = 23,
    group = 40,
    array = Object.keys(item).map(function (k) {
        return [+item[k], cart, group];
    });
    
console.log(array);

answered May 19, 2017 at 20:58

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Collectives™ on Stack Overflow

Forming an array format for multi row insertion nodejs-mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related