Retrieving information from MongoDB for a specific ObjectID associated with the current authenticated user

Question

Retrieving information from MongoDB for a specific ObjectID associated with the current authenticated user

Having two collections in my MongoDB structured as follows:

Data

User:

id: ObjectId ("5fb39e3d11eaad3e30cfb1b0")
userName: "Tobias"
password: "yyy"

id: ObjectId ("5fb3c83fb774ff3340482250")
userName: "Thor"
password: "xxx"

Courses:

id: ObjectId ("5fb3cf3da8227e101826e2db")
CourseName: "Design"
userId: "5fb39e3d11eaad3e30cfb1b0" (THIS IS THE SAME AS THE OBJECT ID FOR THE FIRST USER)

When a user logs in, they can add a course which then gets added to the MongoDB collection along with the coursename.

I'm trying to figure out how to display only the courses that match the currently logged in user. My tech stack includes Mongoose for user-login, Express for server connection, EJS for view, and VueJS for control.

Coming from relational databases, I'm unsure if my approach of joining objectIDs is a good practice or not.

javascript mongodb express mongoose ejs

Answer 1

Answer №1

If you're working with MySQL, you'll be familiar with joining tables. However, in MongoDB, the equivalent operation involves using $lookup

   BooksModel.aggregate([
      {
        $lookup: {
          from: AuthorModel.collection.name,
          localField: "authorId",
          foreignField: "_id",
          as: "author"
        }
      },
    ]).then(res => {
       console.log(res);
    })

The resulting data will include an additional field called author, which will contain an array of documents that match the authorId

While you can specify a string instead of AuthorModel.collection.name, it's recommended to dynamically determine the collection name.

Answer 2

If you're working with MySQL, you'll be familiar with joining tables. However, in MongoDB, the equivalent operation involves using $lookup

   BooksModel.aggregate([
      {
        $lookup: {
          from: AuthorModel.collection.name,
          localField: "authorId",
          foreignField: "_id",
          as: "author"
        }
      },
    ]).then(res => {
       console.log(res);
    })

The resulting data will include an additional field called author, which will contain an array of documents that match the authorId

While you can specify a string instead of AuthorModel.collection.name, it's recommended to dynamically determine the collection name.

Answer 3

Answer №2

To search for a specific item, you have the option to utilize either the find() or findOne() method.

courses.findOne(function (err, course) {
  if (err) return handleError(err);
  if (course) {
    // Perform action
  }
});

Answer 4

To search for a specific item, you have the option to utilize either the find() or findOne() method.

courses.findOne(function (err, course) {
  if (err) return handleError(err);
  if (course) {
    // Perform action
  }
});

Retrieving information from MongoDB for a specific ObjectID associated with the current authenticated user

Answer №1

Answer №2

Similar questions

Implement the callback-console.log feature from the epic-games-api into an Express.js application

What is the process for incorporating custom controls into the Mantine Embla Carousel within a Next.js environment?

I'm unable to resolve all parameters for xxx -- unit testing using jest

What could be the reason for receiving a 431 status error after including a JWT token in the Authorization section of the header?

Tips for creating a personalized asynchronous Express handler that seamlessly receives specific typed parameters

Using CSS properties as false values within React applications

How can you gradually fade out the bottom edge of a rendered component until it is re-rendered?

Verify whether the user's email is registered in the database

Does the TS keyof typeof <Object> rule prohibit the assignment of object.keys(<Object>)?

Making a Button-triggered Post Request in NodeJS

Exploring the Power of v-for in Nested Objects with Vue

Tips for closing print window dialog during Protractor testing

Navigating a JSON array using the Handlebars template engine

Having trouble with installing node-steam on your node.js server?

How can I resolve the issue of encountering the "Modal dialog present: If you navigate away from this page, any unsaved changes will be lost" message while using Internet Explorer with

Infinite scroll causing Firebase ".length" function malfunction

Can someone help me figure out how to increase the values of two specific attributes within a class?

Adding client-side scripts to a web page in a Node.js environment

The jQuery .hasClass() function does not work properly with SVG elements

Strange CSS/browser storage glitch