const sql = require('mssql/msnodesqlv8')
const sleep = (waitTimeInMs) => new Promise(resolve => setTimeout(resolve, waitTimeInMs));
var fs = require('fs');
var dir='D:\RECADV\\';

var config = {
    driver: 'msnodesqlv8',
    server: 'STAG\\SQLEXPRESS',
    database: 'veld2_L_small',
    port: 1433,
	  options: {
    trustedConnection: true,
    useUTC: true
	  }
};
 function sqllis(sql_q, callback) {
    sql.connect(config, function (err) {
        if (err) console.log(err);
        var request = new sql.Request();
        request.query(sql_q, callback);

    });
}
sqllis("truncate table t4xml", function(err, results){
   //console.log(err);
   // console.log(results);
})

//XML to table
fs.readdir(dir, function(err, items) {
  for (var i=0; i<items.length; i++)
  {
	var content = fs.readFileSync(dir+ items[i], 'utf8');
				sqllis("INSERT INTO t4xml (id,xml) values('"+i+"', '"+content+"')", function(err, results){
    // console.log(err);
    //console.log(results);
                })
  }

  //Table to XML
   sqllis("SELECT xml FROM t4xml ORDER BY id", function(err, results){
    fs.writeFile("XMLtoTable.txt", JSON.stringify(results), err => {
          if (err) throw err;
          console.log('File successfully written to disk');
     })
   });
});