Providing input to a nested mongoose query

Question

Providing input to a nested mongoose query

I can't figure out why I keep experiencing 504 Gateway timeouts.

app.get("/api/exercise/log", function(req,res) {
  let userId = req.query.userId;
  let from = req.query.from;
  let to = req.query.to;
  let limit = req.query.limit;
  console.log("limit1 " + limit);
  User.findById(userId).exec(function (err,data) {
    console.log("limit2 " + limit);
    if (err) return err;
    Exercise.find({userId: userId}).limit(limit).exec(function (err2,data2) {
      console.log("limit3 " + limit);
      if (err2) return err2;
      let logArr = [];
      logArr.push(data2);
      let total = logArr[0].length;
      let answer = Object.assign({}, data._doc, {log: logArr}, {total: total});  
      res.json(answer);
    })    
  })  
})

My url ends with log?userId=555&limit=2. Despite all console logs (limit1, limit2, limit3) correctly printing '2', I am still encountering only timeouts. However, when manually setting the limit value to 2 as shown below:

Exercise.find({userId: userId}).limit(2).exec(function (err2,data2) {

everything seems to work fine and I receive the accurate number of results. What could be causing this inconsistency?

javascript mongodb express mongoose mongodb-query

Answer 1

Answer №1

Use parseInt to convert a string to a number and validate if it can be converted successfully.

app.get("/api/exercise/log", function(req,res) {
  let userId = req.query.userId;
  let from = req.query.from;
  let to = req.query.to;
  let limit = 10;
  if(!isNaN(req.query.limit)){
      limit = parseInt(req.query.limit);   // set limit to query parameter value if it's a valid number
  }
  console.log("limit1 " + limit);
  User.findById(userId).exec(function (err,data) {
    console.log("limit2 " + limit);
    if (err) return err;
    Exercise.find({userId: userId}).limit(limit).exec(function (err2,data2) {
      console.log("limit3 " + limit);
      if (err2) return err2;
      let logArr = [];
      logArr.push(data2);
      let total = logArr[0].length;
      let answer = Object.assign({}, data._doc, {log: logArr}, {total: total});  
      res.json(answer);
    })    
  })  
})

Answer 2

Use parseInt to convert a string to a number and validate if it can be converted successfully.

app.get("/api/exercise/log", function(req,res) {
  let userId = req.query.userId;
  let from = req.query.from;
  let to = req.query.to;
  let limit = 10;
  if(!isNaN(req.query.limit)){
      limit = parseInt(req.query.limit);   // set limit to query parameter value if it's a valid number
  }
  console.log("limit1 " + limit);
  User.findById(userId).exec(function (err,data) {
    console.log("limit2 " + limit);
    if (err) return err;
    Exercise.find({userId: userId}).limit(limit).exec(function (err2,data2) {
      console.log("limit3 " + limit);
      if (err2) return err2;
      let logArr = [];
      logArr.push(data2);
      let total = logArr[0].length;
      let answer = Object.assign({}, data._doc, {log: logArr}, {total: total});  
      res.json(answer);
    })    
  })  
})

Providing input to a nested mongoose query

Answer №1

Similar questions

What is the best way to display all filtered items in PyMongo?

I'm struggling to figure out how to apply the push operator in an aggregation function using an array. Whenever I attempt to do so, I encounter an error stating that

The method to permit a single special character to appear multiple times in a regular expression

Tips for resolving the issue: React is unable to recognize the X prop on a DOM element

The intended functionality of clicking on an image is exclusively reserved for its immediate parent element

Internet Explorer 8 halts the progress of the loading animated GIF

Developing a fresh instance that collaborates with other components like Sequelize, NodeJs, Express, and Postgres

Unable to retrieve the authorization code following the redirection of the URL

Why does Typescript not enforce a specific return type for my function?

Set up Vue.prototype prior to the component loading

What is the best way to add HTML content to a specific div element within an AJAX call's success function?

Dynamic Creation of a jQuery Selector

The ng-repeats functionality is triggered multiple times whenever I attempt to make this call

Expanding the size of a textarea using JavaScript

What is the best way to execute an axios request within my custom API endpoint?

How to display two elements side by side within a div using React

"webpack" compared to "webpack --watch" produces varying results in terms of output

Tips for adjusting the search bar's position on a mobile device when it is activated by the user

bringing in a nested object from an API

Event triggered when a Socket.IO connection is disconnected