javascript array in array to postgres parenthesis

Question

I have an array of array of values that I make using .map():

let my data = [ [ "ted", 20 ], [ "jon", 30 ], [ "bob", 25 ] ]

And I am creating a sql statement in postgres which needs to end up with:

values (("ted", 20),("jon", 30),("bob", 25))

Is there an easy way to put this into postgres. I can change it to just text in the .map() method, but I would like to keep it as an usable array.

Shidersz · Accepted Answer · 2019-05-11 04:08:15Z

2

You can use Array.map() and Array.join() to generate the desired string. This won't change the original data.

function toValuesStr(data)
{
    let values = data.map(([k,v]) => `("${k}", ${v})`).join(",");
    return `values (${values})`;
}

let data = [[ "ted", 20 ], [ "jon", 30 ], [ "bob", 25 ]];
console.log("String:", toValuesStr(data));
console.log("Data:", data);

.as-console {background-color:black !important; color:lime;}
.as-console-wrapper {max-height:100% !important; top:0;}

answered May 11, 2019 at 4:08

Shidersz

17.2k2 gold badges28 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

javascript array in array to postgres parenthesis

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related