Mysql Result, array to json but adding an element

Question

I use this very beginner's skill code to get some info from a mysql database:

    var sql_select = "SELECT COL1, COL2 FROM MYTABLE WHERE ID = ? LIMIT 1"
     connection.query(sql_select, Id, (error, results) => {
    if (error){
        return console.error(error.message);
    }
    console.log("result:", results);
});

I know how to get results from SQL select into JSON and get something like :

[{"COL1": "VALUE_COL_1", "COL2": "VALUE_COL_2"}]

but how can i get something like this instead?

[{"2020-01-01":{"COL1": "VALUE_COL_1", "COL2": "VALUE_COL_2"}]

(2020-01-01 would be a variable date set upper in the code).

Thanks

["2020-01-01":{"COL1": "VALUE_COL_1", "COL2": "VALUE_COL_2"}] is not valid. Do you mean {{"2020-01-01":{"COL1": "VALUE_COL_1", "COL2": "VALUE_COL_2"}} ? — Seblor
– Seblor, Commented Apr 2, 2020 at 14:20

O. Jones · Accepted Answer · 2020-04-02 14:32:56Z

1

This is a job for forEach, push, and using the bracket form of the property accessor to set an property in an object.

 const output = []                           // empty new array
 results.forEach ( row => {
    const x = {}                             // empty object
    x[theDateStringFromSomeplaceElse] = row  // your row as value, date as name
    output.push( x )                         // push into the output array
 } )
 // now output has the array you want.

answered Apr 2, 2020 at 14:32

O. Jones

110k17 gold badges134 silver badges187 bronze badges

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

Collectives™ on Stack Overflow

Mysql Result, array to json but adding an element

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