Agfdhyk

My question is how can I send the driver of my web api to make an insert to my database from node js ?, the web api is in visual studio and the node js in visual studio code. An acquaintance says that with a request I can do it, but I am very confused on how it should be done. If anyone can help I'd appreciate it.

https://www.w3schools.com/nodejs/nodejs_mysql.asp:

var mysql = require('mysql');



var con = mysql.createConnection({

  host: "localhost",

  user: "yourusername",

  password: "yourpassword",

  database: "mydb"

});



con.connect(function(err) {

  if (err) throw err;

  console.log("Connected!");

  var sql = "INSERT INTO customers (name, address) VALUES ('Company Inc', 'Highway 37')";

  con.query(sql, function (err, result) {

    if (err) throw err;

    console.log("1 record inserted");

  });

});

Then simply run the file from the terminal. I know on lunix it's $ node file.js

if you are using sql server, you can use tedious:

    const Request = require('tedious').Request;

    const Connection = require('tedious').Connection;



    const DB = {

      async connect() {

    const config = {

      userName: your username,

      password: your password,

      server: your host,

      options: {

        port: port,

        database: database,

        rowCollectionOnRequestCompletion: true,

        rowCollectionOnDone: true,

      },

    };

    return new Promise((resolve, reject) => {

      const connection = new Connection(config);

      connection.on('connect', (err) => {

        if (err) {

          console.log(`connect error: ${err.message}`);

          reject(err);

        } else {

          resolve(connection);

        }

      });

    });

  },

  async request(sql) {

    const connection = await DB.connect();

    return new Promise((resolve, reject) => {

      connection.execSql(new Request(sql, (error, rowCount, rows) => {

        connection.close();

        if (error) {

          reject(error);

        } else {

          resolve({

            rowCount,

            rows

          });

        }

      }));

    });

  },

};



module.exports = DB;