"Linking and accessing data from different collections in MongoDB to enhance overall

Question

"Linking and accessing data from different collections in MongoDB to enhance overall

Extracting information from an external API provides me with two separate data sets: one for football matches and another for football competitions. I store this information in MongoDB. Inquiring about a specific football match, I am interested in knowing the standings of each team within the associated competition.

Below are the models being used:

Game

{
    ...,
    homeTeam: {
        id: 1234
    },
    awayTeam: {
        id: 2345
    },
    ...
}

Competition

{
    ...
    standings: [
    {
        position: 1,
        team: {
            id: 1234,
            ...
        },
        ...
    },
    {
        position: 2,
        team: {
            id: 2345,
            ...
        },
        ...
    }
    ]
}

I attempted using aggregation with $lookup but encountered challenges getting it to perform as desired.

const game = await Game.aggregate([
        {$match: {'competition.id': parseInt(req.params.id)} },
        {$lookup: {
            from: 'competitions',
            localField: 'homeTeam.id',
            foreignField: 'standings.team.id',
            as: 'homeTeam.position',
        }}
    ]);

The expected outcome for each game is represented below:

{
    ...,
    homeTeam: {
        id: 1234,
        position: 1
    },
    awayTeam: {
        id: 2345
        position: 2
    },
    ...
}

javascript mongodb mongoose

Answer 1

Answer №1

Here's a method using forEach and an if statement to achieve the desired outcome. The code is well-commented for clarity, and any questions you have can be addressed by asking.

let objectsArr = Object.keys(firstOBJ); // extracting properties
let answer = []; // creating a new array for the answer
let childs = Object.keys(secondOBJ); // getting properties of secondOBJ
secondOBJ[childs].forEach((val, i) => { // iterating through properties of secondOBJ
  if (firstOBJ[objectsArr[i]].id == val.team.id) { // comparing id's before proceeding
    name = objectsArr[i]; // storing the name
    answer.push({ // pushing data along with the name
      [name]: {
        id: val.team.id,
        position: val.position
      }
    })
  }
});

Test snippet provided below for verification:

let firstOBJ = {
  homeTeam: {
    id: 1234
  },
  awayTeam: {
    id: 2345
  }
}
let secondOBJ = {
  standings: [{
      position: 1,
      team: {
        id: 1234,
      },
    },
    {
      position: 2,
      team: {
        id: 2345
      },
    }
  ]
}
let objectsArr = Object.keys(firstOBJ);
let answer = [];
secondOBJ[Object.keys(secondOBJ)].forEach((val, i) => {
  if (firstOBJ[objectsArr[i]].id == val.team.id)
    answer.push({
      [objectsArr[i]]: {
        id: val.team.id,
        position: val.position
      }
    });
});
console.log(answer)

Answer 2

Here's a method using forEach and an if statement to achieve the desired outcome. The code is well-commented for clarity, and any questions you have can be addressed by asking.

let objectsArr = Object.keys(firstOBJ); // extracting properties
let answer = []; // creating a new array for the answer
let childs = Object.keys(secondOBJ); // getting properties of secondOBJ
secondOBJ[childs].forEach((val, i) => { // iterating through properties of secondOBJ
  if (firstOBJ[objectsArr[i]].id == val.team.id) { // comparing id's before proceeding
    name = objectsArr[i]; // storing the name
    answer.push({ // pushing data along with the name
      [name]: {
        id: val.team.id,
        position: val.position
      }
    })
  }
});

Test snippet provided below for verification:

let firstOBJ = {
  homeTeam: {
    id: 1234
  },
  awayTeam: {
    id: 2345
  }
}
let secondOBJ = {
  standings: [{
      position: 1,
      team: {
        id: 1234,
      },
    },
    {
      position: 2,
      team: {
        id: 2345
      },
    }
  ]
}
let objectsArr = Object.keys(firstOBJ);
let answer = [];
secondOBJ[Object.keys(secondOBJ)].forEach((val, i) => {
  if (firstOBJ[objectsArr[i]].id == val.team.id)
    answer.push({
      [objectsArr[i]]: {
        id: val.team.id,
        position: val.position
      }
    });
});
console.log(answer)

"Linking and accessing data from different collections in MongoDB to enhance overall

Answer №1

Similar questions

Removing an item from a Firebase array: A step-by-step guide

What is the best way to loop through arrays of objects within other arrays and delete specific attributes?

Updating front end data using Node.js - A Comprehensive Guide

The homepage was updated following the click of the "Home" link

Using a node module for Three.js path manipulation

From jQuery to Vanilla JavaScript: Implementing a simple click event listener

Troubleshooting problems with jQuery Chosen plugin post-AJAX request

The 'command cursor' object cannot be accessed using square brackets

Passing a number instead of a string in Reactjs onClick for the <MenuItem> element

Handling onChange events for several typescript <Select> elements

Struggling to retrieve a particular user using ExpressJs due to an error

What is the best way to access a JSON object obtained through AJAX within the DOM?

When extracting a value from an HTML textarea that contains multiple lines of text inputted by the user, the JSON becomes invalid

Javascript Pretty Print Format is producing inaccurate output

Interactive marker popup appearing beyond the boundaries of the map container

Explore the wonders of utilizing MongoDB in conjunction with Node.js

Tips for resolving the "Unexpected reserved word" error during the installation of Laravel Jetstream

I require my two elements to possess opposing transformations in their coordinates or directions to enable dragging capabilities

Display a dialogue box in close proximity to a text area without utilizing a pop-up or alert notification

calls for angular http.get within other angular http.get calls