How to insert json array to mysql database usnig Node JS and Express

Question

I'm creating a MySQL database and I want to insert about 1000 records that are structured in a JSON array

This is the JSON array that I'm importing:

 [
  {
   "DESCRIPTION": "انفرتر 1   حصان أحادي",
   "TYPE": "ODE-2-12075-1K012XX",
   "CLASSIFICATION": "VFD",
   "BRAND": "INVERTEK",
   "ORIGIN": "UK",
   "FAMILY": "ODE-2",
   "ar_classification": "انفرتر"
  },
 {
  "DESCRIPTION": "انفرتر 2   حصان أحادي",
  "TYPE": "ODE-2-120150-1K012XX",
  "CLASSIFICATION": "VFD",
  "BRAND": "INVERTEK",
  "ORIGIN": "UK",
  "FAMILY": "ODE-2",
  "ar_classification": "انفرتر"
 },
 {
  "DESCRIPTION": "انفرتر كتيم 3 حصان أحادي بدون\nمقاومة ومفتاح",
  "TYPE": "ODE-2-24400-3K04N-XX",
  "CLASSIFICATION": "VFD IP55",
  "BRAND": "INVERTEK",
  "ORIGIN": "UK",
  "FAMILY": "ODE-2",
  "ar_classification": "انفرتر"
 }
]

  const {readFileSync} = require('fs')
  //Here is where the Json array is located
  const first = readFileSync('./Zahabi-Products.json', 'utf8')
 const products = JSON.parse(first)

   
    pool.query("INSERT INTO products SET ?", products, 
        function(err, result) {
        if(err) throw err;
        console.log('data inserted');
     });

But the result is that only the first object in the array is being inserted

How could I insert all of the array

Abdullah Manafikhi · Accepted Answer · 2022-10-15 10:38:17Z

1

I tried this and it worked, but I think that is not the perfect answer

var test02 = {}
for(var i = 0; i <= products.length; i++ ){
   test02 = products[i]
   pool.query("INSERT INTO products SET ?",test02 , 
   function(err, result) {
   if(err) throw err;
   console.log('data inserted');
});

}

answered Oct 15, 2022 at 10:38

Abdullah Manafikhi

681 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

How to insert json array to mysql database usnig Node JS and Express

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