I have implemented GraphQL MongoDB Mongoose in my project, where I have defined 2 collections - users and categories.
Category.js
const mongoose = require('mongoose');
const Schema = mongoose.Schema;
const categorySchema = new mongoose.Schema({
title:{
type: String,
required: true
},
userid: {
type: Schema.Types.ObjectId,
ref: 'User',
required: true,
},
});
module.exports = mongoose.model('Category',categorySchema);
`
User.js
const mongoose = require('mongoose');
const Schema = mongoose.Schema;
const userSchema = new mongoose.Schema({
name:{
type: String,
required: true
},
email:{
type: String,
required: true,
unique: true
},
password:{
type: String,
required: true
}
});
module.exports = mongoose.model('User',userSchema);
Resolver.js
const User = require('../models/User');
const Category = require('../models/Category');
const resolvers = {
getUsers: async () => {
try {
const users = await User.find().populate('categories');
return users;
} catch(err){
throw new Error(err);
}
},
};
module.exports = resolvers;
Having set up these collections, I am facing an issue. Even though the data is present in the Categories collection with a valid userid, when querying to get categories, it returns null in the response.
Below is my GraphQL query:
query{
getUsers{
id,
name
}
}
The response I receive does not show the categories even though there are matching ids from the users collection.
{
"data": {
"getUsers": [
{
"id": "65d316bdab8179475bdb0fef",
"name": "mittul"
}
]
}
}
UPDATE ..
When trying a different method for querying, I still get a null response.
{
"data": {
"getUsers": null
}
}
try {
var resources = {};
const users = await User.aggregate([{
$group : {_id : null, totalPop: { $sum: "$pop" }}
},{
$lookup: {
from: "Category", // from collection name
localField: "userid",
foreignField: "_id",
as: "categories"
}
}]);
console.log(users);
} catch(err){
console.log(err);
throw new Error(err);
}
Furthermore, the code snippet provided below also gives me a null response without any output in the console log.
User.find().populate("categories")
.then(users => {
console.log(users);
//res.send(users);
}).catch(err => {
throw new Error(err);
});
Attached are the screenshots of my 2 collections. Can anyone assist me in identifying the missing piece?
https://i.stack.imgur.com/lKPBH.png
https://i.stack.imgur.com/WW3FO.png
Thank you!