Insert a 2d array as multiple rows in a SQLite database using nodejs

Question

This 2d array can be of any length so if for example the array is

var my_2D_Array = 
[['jack',22,'student'],
['Bob',45,'doctor'],
['bucky',30,'unelployed']]

// currently I am using this but it isn't working properly 

for(i=0;i<my_2D_Array.length;i++){
  clientChart.run(`INSERT INTO HP2255 VALUES (?, ?, ?)`,my_2D_Array[i],(err)=>{
  console.log('err' + err)
})

Is it possible to insert an array like this into the database with out using a for loop

I am really new to programming in general and if there is anything that I am missing than please help me out

You're passing an array to the query not 3 individual values and you aren't specifying which columns the VALUES reference, should be INSERT INTO HP2255 (name, age, job) VALUES (?,?,?);. Which sqlite library are you using? — pilchard
– pilchard, Commented Nov 20, 2021 at 11:42
You'll need the for loop, there is a clear example in the Usage section on the repo. I might recommend looking at better-sqlite3 though. — pilchard
– pilchard, Commented Nov 20, 2021 at 12:08

pilchard · Accepted Answer · 2021-11-20 12:20:43Z

2

Without knowing more about your setup/table definition and based on the Usage presented in the repo I would guess something like the following:

const my_2D_Array = [
  ['jack', 22, 'student'],
  ['Bob', 45, 'doctor'],
  ['bucky', 30, 'unelployed'],
];

// explicitly declare columns (it may work without, but is more fragile and less clear)
const stmt = clientChart.prepare('INSERT INTO HP2255 (name, age, job) VALUES (?, ?, ?)');
for (const row of my_2D_Array) {
  stmt.run(...row); // spread each sub-array to pass the individual elements
}
stmt.finalize();

edited Nov 20, 2021 at 12:20

answered Nov 20, 2021 at 12:12

pilchard

13.1k5 gold badges14 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Insert a 2d array as multiple rows in a SQLite database using nodejs

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