"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

The default choice vanishes once a non-empty option is chosen

I'm experiencing difficulties in retrieving my request body parameters despite using express.json()

Move files in Node.js without removing the original source directory

Node.js: Array remains undefined despite being logged on the console

Sending Ajax data to a controller function

Currently, I am utilizing Angular 2 to extract the name of a restaurant from a drop-down menu as soon as I input at least two characters

Retrieve information and display it in a text field using ajax

Incorrect character set used in jsonp ajax requests

Triggering Firebase Cloud Functions upon a database event to perform a redirect

Error: Node application using Express does not display 'Server Started' message in console upon execution

Utilizing vue-router to create two separate navigation bars where only one link is highlighted as active

An unexpected issue occurred while converting XML data into JSON format

What is the best way to pass default event argument alongside another argument in React?

Tips on utilizing a function that was generated within the constructor

Preventing the selection of 'None selected' upon dropdown change

displaying data once "other" is chosen from a dynamic chart

Mapping DOM elements to VueJS components for hydration is a key process in facilitating

What techniques can be used to ensure an element remains visible within the viewport

`Developing reusable TypeScript code for both Node.js and Vue.js`

Limit DerbyJS to re-rendering specific DOM elements