0

I have here a code that allows me to display on the console some table datas.

I would like to write them on a txt file to save them local.

I don't know how to do that very easily! Is it possible with only javascript and with few lines?

const { Connection, Request } = require("tedious");

const config = {
  authentication: {
    options: {
      userName: "xxxxxxxxxx", 
      password: "xxxxxxxxxxx*" 
    },
    type: "default"
  },
  server: "xxxxxxxxxxxxxxxxxxxxxx", 
  options: {
    database: "DBSTORY1",
    encrypt: true
  }
};

const connection = new Connection(config);

connection.on("connect", err => {
  if (err) {
    console.error(err.message);
  } else {
    queryDatabase();
  }
});

connection.connect();

function queryDatabase() {
  console.log("Reading rows from the Table...");

  const request = new Request(
   `SELECT TOP (1000) * FROM [dss].[userdatabase]`,
    (err, rowCount) => {
      if (err) {
        console.error(err.message);
      } else {
        console.log(`-----------------------------------------------`);
      }
    }
  );

  request.on("row", columns => {
    columns.forEach(column => {
      console.log("%s\t%s", column.metadata.colName, column.value);
    });
  });

  connection.execSql(request);
}

0 Answers0