Let's say I have this document: { "_id": objectId(), "products": [ { "product_id": "" } ] } I would like to make that the key product_id of documents in the array products must be unique for that document in the…
I cannot filter items that only have a specific role: When I try to filter only the element with rol ROL_CONTADOR return all elements of items, but the second element in items, not should filter. db.menu.find({ "items": { "$elemMatch": {…
I'm trying to create a basic login system using Node.js, mongodb and bcrypt.js. The registration is working as expected, however the user login is not, since it only works correctly for the first user in the database, only allowing any…
Why are the street and city fields not present in the address sub-document of a new user document created using Mongoose, despite being included in the addressSchema and provided when creating the document? Here is my addressSchema: const addressSchema =…
I am trying to simply console.log the output of the mongoose function model.find() I am using node.js version 18.14.0, "express": "^4.18.2", "mongoose": "^7.0.0", I have the following issues: model.find no longer accepts callbacks, so I tried to create a variable…
I've encountered a problem while setting up mongoose. Here is my code: const { SlashCommandBuilder } = require('@discordjs/builders'); const testSchema = require(`../../Schemas.js/test`); module.exports = { data: new SlashCommandBuilder() .setName('dbtest') .setDescription('db test'), async execute(interaction) { testSchema.findOne({ GuildID: interaction.guild.id, UserID: interaction.user.id}, async(err,…
I am trying to copy a million document in a collection to another colletion. > db.source_collection.find().forEach(function(doc) { db.dest_collection.insertOne(doc)}); This works fine. but I wonder it might cause any trouble to operating Database if I loop a million documents. Can I…
I have a collection named employees with documents like. { first_name:"john", last_name:"doe" } I want to run an update query which adds a new field like {name:'john doe'} I know it can be done like this db.employees.find({}).forEach(doc=>db.employees.update({"_id":doc._id},{$set:{name:doc.first_name+"-"+doc.last_name}})) but its taking…
Given the following dataset: category date amount fruit 2023-01-01 1 fruit 2023-01-02 2 meat 2023-01-03 3 nuts 2023-01-04 4 nuts 2023-01-05 5 nuts 2023-01-06 6 Is it possible to do a multi-group aggregation in Mongo JPA that yields: One row…
all! I'm working on a project with MongoDB and Spring Boot. I want to implement a feature so that once I start running the server, there will be a fixed item (or file) stored in the collection of the MongoDB…