"Sharing fields between mongoose models: How can I reference a field from one model in another

Question

"Sharing fields between mongoose models: How can I reference a field from one model in another

I am currently working on linking specific fields from the User model to the Card schema using the username as a reference point. Let me provide an example using my Card schema:

 const CardSchema = new mongoose.Schema({
      text: {
        type: String,
      },
      username: {
       type: String,
       ref: 'User',
       required: true
      },
      userSticker: {
       I need to extract this information from the user model based on either the username or user ID.
      }

Now, let's take a look at how the user model is structured:

const UserSchema = new mongoose.Schema({
  username: {
    type: String,
  },
  userSticker: {
   type: String,
  }

Essentially, what I am trying to achieve is to always have the same userSticker value in the Card schema as the corresponding user in the User model. Simply adding it upon card creation won't suffice since the userSticker may change over time. Therefore, I am looking for a solution that will dynamically update the field in the Card schema whenever the associated user's userSticker changes - perhaps through some form of reference implementation.

javascript mongodb express mongoose

Answer 1

Answer №1

Exploring the wonders of mongoose with insights from its official documentation Query Population

 const cardSchema = new mongoose.Schema({
      text: {
        type: String,
      },
      username: {
       type: String,
       ref: 'User',
       required: true
      },
      userSticker: {
       type: Schema.Types.ObjectId, 
       ref: 'User'
      }
};

const userSchema = new mongoose.Schema({
  username: {
    type: String,
  },
  userSticker: {
   type: String,
  }
}

const User = mongoose.model('User', userSchema);
const Card = mongoose.model('Card', cardSchema);

Card.findbyId(id).populate('userSticker', 'userSticker').exec(function(err, card) {/* Carry out actions... */})

Answer 2

Exploring the wonders of mongoose with insights from its official documentation Query Population

 const cardSchema = new mongoose.Schema({
      text: {
        type: String,
      },
      username: {
       type: String,
       ref: 'User',
       required: true
      },
      userSticker: {
       type: Schema.Types.ObjectId, 
       ref: 'User'
      }
};

const userSchema = new mongoose.Schema({
  username: {
    type: String,
  },
  userSticker: {
   type: String,
  }
}

const User = mongoose.model('User', userSchema);
const Card = mongoose.model('Card', cardSchema);

Card.findbyId(id).populate('userSticker', 'userSticker').exec(function(err, card) {/* Carry out actions... */})

Answer 3

Answer №2

UPDATE: After some research, I've discovered that mongoose handles relational data modeling by allowing you to define references in the schema.

For more information, check out this resource: Relational database design to mongoDB/mongoose design

This section pertains to MongoDB specifically

Since MongoDB is not a relational database like SQL, there are two common solutions:

The first solution involves duplicating data and updating all related fields when changes occur:

const CardSchema = new mongoose.Schema({
  text: {
    type: String,
  },
  username: {
    type: String
  },
  userSticker: {
    type: String,
  }
})

const UserSchema = new mongoose.Schema({
  username: {
    type: String,
  },
  userSticker: {
    type: String,
  }
})

Whenever the userSticker changes, you would need to query the card collection and update all matching userStickers.

The second solution requires manually creating a reference between collections:

const CardSchema = new mongoose.Schema({
  text: {
    type: String,
  },
  user_id: {
    type: String,
  }
})

const UserSchema = new mongoose.Schema({
  _id: {
    type: String,
  },
  username: {
    type: String,
  },
  userSticker: {
    type: String,
  }
})

When querying the document in the card collection, a second query can be made for the document referenced by user_id.

The first solution is slower on write but faster on read.
The second solution is faster on write but slower on read (especially when paginating queries).

Answer 4

UPDATE: After some research, I've discovered that mongoose handles relational data modeling by allowing you to define references in the schema.

For more information, check out this resource: Relational database design to mongoDB/mongoose design

This section pertains to MongoDB specifically

Since MongoDB is not a relational database like SQL, there are two common solutions:

The first solution involves duplicating data and updating all related fields when changes occur:

const CardSchema = new mongoose.Schema({
  text: {
    type: String,
  },
  username: {
    type: String
  },
  userSticker: {
    type: String,
  }
})

const UserSchema = new mongoose.Schema({
  username: {
    type: String,
  },
  userSticker: {
    type: String,
  }
})

Whenever the userSticker changes, you would need to query the card collection and update all matching userStickers.

The second solution requires manually creating a reference between collections:

const CardSchema = new mongoose.Schema({
  text: {
    type: String,
  },
  user_id: {
    type: String,
  }
})

const UserSchema = new mongoose.Schema({
  _id: {
    type: String,
  },
  username: {
    type: String,
  },
  userSticker: {
    type: String,
  }
})

When querying the document in the card collection, a second query can be made for the document referenced by user_id.

The first solution is slower on write but faster on read.
The second solution is faster on write but slower on read (especially when paginating queries).

"Sharing fields between mongoose models: How can I reference a field from one model in another

Answer №1

Answer №2

Similar questions

Encountering a CORS issue while attempting to make a GET request to an API in an

Learn the process of downloading a pdf file with vuejs and bootstrap-vue

Exploring the world of unit testing with Jest in Strapi version 4

Encountering difficulty in adding content to a table using JavaScript. An error message appears stating that assignment to a function

Does one require the express.js framework in order to create a web application using nodeJS?

CORS blocked the JavaScript Image's request

Making HTTP requests with axios in Node.js based on multiple conditions

Increasing Asynchronous Capabilities with Dynamically Updating jQuery Deferred within then() Method

Is the "json_encode" function dropping the '+' character when using "json.parse"?

Exploring the fundamentals of Express.js code base

Obtain the position and text string of the highlighted text

Refresh Vue/Nuxt Components Fully

Why is my React component not being updated with Routes?

Web Security Vulnerability: Cross Site Scripting Detected

Calculate the sum of multiple user-selected items in an array to display the total (using Angular)

The random quote generator or current tweet quote feature is malfunctioning

send data to a hyperlink

Using the "OR" operator in regular expressions within express routing

Updating the value within a nested array in a ReactJS application

How can you use CSS animations to animate two images in a way that hides one while showing the other?