Question

0

221

Views

Updating table depending on dynamic keys of object

Here myObject is an object and I want to update my table depending upon the number of keys myObject contains. The number of keys in myObject can be dynamic how do I update the table in that case?

var myObject ={
   x1 : 0,
   x2 :1
}

var stmt =""UPDATE tb_data SET x1 = ?, x2 = ?....xn =?";

over 4 years ago · Santiago Trujillo

2 answers

Answer question

0

Improving on jsw324's answer

var myObject ={
   x1 : 0,
   x2 :1
}

let stmt ='UPDATE tb_data SET ';

Object.keys(myObject).forEach((key)=>{
    const val = myObject[key];
    stmt += `${key} = ${val}, `;
})

stmt = stmt.splitOnLast(',')[0]+';'
//Stmt = "UPDATE tb_data SET x1=0, x2=1;"

over 4 years ago · Santiago Trujillo Report

Answer question

Find remote jobs

Accepted Answer · 2022-05-26T15:01:05.838Z

Try using Object.keys(myObject).forEach to loop through each of your objects, building up the string you need each time.

var myObject ={
       x1 : 0,
       x2 :1
    }

    var stmnt = '';

    Object.keys(myObject).forEach((val) => {
      stmnt += val;
    })

0

221

Updating table depending on dynamic keys of object

2 answers

0

0

Find remote jobs

Andres GPT