How to add multiple entries using Node.js and Tedious

Question

How to add multiple entries using Node.js and Tedious

I am currently working with an array of customer objects that I need to insert into a SQL database. These customer objects are retrieved from the request data.

For this task, I am utilizing Tedious for handling the request and Tedious Connectionpool to manage multiple connections simultaneously.

As I loop through the objects, I encountered an error while attempting to insert them, specifically:

{ [RequestError: Violation of PRIMARY KEY constraint `'PK__Customer__A4AE64D873A5400C'. Cannot insert duplicate key in object 'dbo.Customer'. The duplicate key value is (2).]`

It seems that only the last object in the request is being handled and inserted, even though there are only 3 objects being sent at this time. Since I am new to using tedious with Node.js, I am struggling to identify my mistake. Any suggestions would be greatly appreciated.

router.post('/',jsonParser, function(req, res) {

    // Code for processing the request and inserting customer objects

});

javascript sql node.js for-loop tedious

Answer 1

Answer №1

The global variables count and firstName have a scope that extends throughout the code. However, when the pool.acquire( function is executed, it ends up inserting the last customer twice because the for loop has already completed. One potential solution is to encapsulate the insert operation within an anonymous function inside the for loop, as shown below:

for (var i = 0; i < customers.length; i++) {
    (function(count, firstName) {
       ...insert code here...
    }(i, customers[i].firstname));
}

Answer 2

The global variables count and firstName have a scope that extends throughout the code. However, when the pool.acquire( function is executed, it ends up inserting the last customer twice because the for loop has already completed. One potential solution is to encapsulate the insert operation within an anonymous function inside the for loop, as shown below:

for (var i = 0; i < customers.length; i++) {
    (function(count, firstName) {
       ...insert code here...
    }(i, customers[i].firstname));
}

How to add multiple entries using Node.js and Tedious

Answer №1

Similar questions

The issue of JavaScript failing to connect to the HTML file

Node.js and socket.io come together in this collaborative text editing tool

Tips for managing @ManyToMany relationships in TypeORM

Debugger in VSCode is not stopping at the designated break-point when a postman request is made

Attempting to execute the Angular CLI directive "ng generate module flat true" is proving to be unsuccessful

I encountered an issue when installing npm modules as I tried using all the available registry commands but still

What is the best way to append these values to an array?

Switch app engines in real-time based on the URL path with express framework

What is the best way to change the orientation of column names from vertical to horizontal?

Integrating Asp.Net Core for server-side functionality with React for client-side interactions

The perplexing saga of Google Assistant and the WorldWeatherOnline API

Node.js JSDOM unable to locate the 'parsingMode' property in the code

What happens when an AJAX request doesn't have a success field?

Stop Antd Modal from automatically scrolling to the top

What is causing the issue of the page overflowing in both the x and y axis while also failing to center vertically?

How to send a JavaScript variable to Flask and trigger an AJAX reload action

Guide for bringing in a complete npm library into React Native beyond just a single file access

Unable to render canvas element

Angular - Electron interface fails to reflect updated model changes

Losing authentication token when refreshing with Nuxt asyncData and Axios