Transforming JSON-like data into a string, node mysql

Question

Quick edit - I am a complete beginner in web development, so I realize the solution might be stupidly obvious.

I'm attempting to insert a data set into a MySQL db through nodejs/expressjs/mysql.

I have a successful connection to the db and can query from it without issues.

Here is my post code:

app.post('/pyme', function(req,res){
    console.log("Data being POSTED to db...");
    var post = req.body;
    console.log(post);
    var sql_insert_pyme = 'INSERT INTO pyme(NombreComercio,NumeroTelefono) VALUES =?';
    sql.query(sql_insert_pyme,post,function(err){
    if(err) throw err;
    });
});

The POST data I am getting looks as follows:

{ NombreComercio: 'Sebastian Avila',
  NumeroTelefono: '71021714' }

I need a method to break that post into a simple:

"'Sebastian Avila', '71021714'"

Basically I want to end with:

post = "'Sebastian Avila', '71021714'"

Damaged Organic · Accepted Answer · 2016-10-03 09:57:40Z

1

You need to reduce a JSON object to an array (you can reduce it to string straight away, but array gives you more control over) and join it.

var postObject = {
    NombreComercio: 'Sebastian Avila',
    NumeroTelefono: '71021714'
}

var postArray = Object.keys(postObject).reduce(function(reduced, jsonKey) {
    reduced.push("'" + postObject[jsonKey] + "'");
    return reduced;
}, []);

var postString = postArray.join(',');

console.log(postString);

If you want query parameters to be dynamic, you can as well set Object.keys(postObject).join(',') in columns names part of the query.

edited Oct 3, 2016 at 9:57

answered Sep 25, 2016 at 5:14

Damaged Organic

8,4676 gold badges64 silver badges90 bronze badges

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

2 Comments

Sebastian Avila Over a year ago

This solved it. Thanks! I was running around in circles figuring out how to reduce and push the object

Damaged Organic Over a year ago

You're welcome. Simple stuff and now you know how to handle it. Cheers!

abdulbari · Accepted Answer · 2016-09-25 05:21:38Z

0

Try this

 var postObject = {
NombreComercio: 'Sebastian Avila',
NumeroTelefono: '71021714'
}

var vals = Object.keys(postObject).map(function(key) {
return "'"+postObject[key]+"'";
});

console.log(vals.join(','))

answered Sep 25, 2016 at 5:21

abdulbari

6,2625 gold badges41 silver badges65 bronze badges

Collectives™ on Stack Overflow

Transforming JSON-like data into a string, node mysql

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related