JSFiddle - React, Tailwind, and code Playground

by Santosh Giridhara

JavaScript

var vendorObject = {
  "fruitVendor": [{
    "firstname": "FN",
    "lastname": "LN",
    "address_line1": "Address_Line 1",
    "address_line2": "Address_Line_2",
    "address_line3": "Address_Line_3",
    "city": "city",
    "bank_name_1": "BANK_NAME",
    "zip_code": "12345",
    "mail_address": "[email protected]"
  }],
  "vegetableVendor": [{
    "firstname": "VFN",
    "lastname": "VLN",
    "address_line1": "VAddress_Line 1",
    "address_line2": "VAddress_Line_2",
    "address_line3": "VAddress_Line_3",
    "city": "vcity",
    "bank_name_1": "VBANK_NAME",
    "zip_code": "12112345",
    "mail_address": "[email protected]"
  }]
};

var keys = [],
  values = [];
for (var key in vendorObject) {
  if (vendorObject.hasOwnProperty(key)) {
    let newObject = vendorObject[key];
    for (let i = 0; i < newObject.length; i++) {

      for (const vendorKey in newObject[i]) {
        if (newObject[i].hasOwnProperty(vendorKey)) {
          keys.push(vendorKey);
          values.push("'" + newObject[i][vendorKey] + "'");
          //console.log(keys.toString());
          // console.log(values.toString());
          let insertStatement = `INSERT INTO INSERT INTO mytable(` + keys.toString() + `) VALUES (` + values.toString() + ` );`;
          console.log(insertStatement);


        }
      }
    }
  }
}