I've indexed nuit, regNumber and _id for a faster query. You can find sample data and a solution which i'm not happy with because using $unwind and $lookup makes it iterate a million documents: https://mongoplayground.net/p/jR4Y-9-5As7 This is what i did:…
I get this error whenever I use the api and send post, Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client This is the code ! //LOGIN router.post("/login", async (req, res) => { try { const user…
Given the following data in a Mongo collection: { _id: "1", dateA: ISODate("2021-12-31T00:00.000Z"), dateB: ISODate("2022-01-11T00:00.000Z") }, { _id: "2", dateA: ISODate("2022-01-02T00:00.000Z"), dateB: ISODate("2022-01-08T00:00.000Z") }, { _id: "3", dateA: ISODate("2022-01-03T00:00.000Z"), dateB: ISODate("2022-01-05T00:00.000Z") }, { _id: "4", dateA: ISODate("2022-01-09T00:00.000Z"), dateB: null },…
I am having a huge collection of objects where the data is stored for different employees. { "employee": "Joe", "areAllAttributesMatched": false, "characteristics": [ { "step": "A", "name": "house", "score": "1" }, { "step": "B", "name": "car" }, { "step": "C",…
I am trying to take user input and then add a drug(medicine) to MongoDB. But it is not working and I am getting the error "Add proper parameter first". The user input should be patient name, drug name, dosage, frequency,…
I have an esp32-wrover-e ( 16mb flash and 8mb external ram ) I'm coding it with arduino framework. On the esp32, there is a webserver and it has multiple files for login, the main page and things like that. I…
We have the following records in a collection: { "_id" : ObjectId("1"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("2"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("3"), "date" : ISODate("2017-03-03T00:00:00Z") } { "_id" : ObjectId("4"), "date" : ISODate("2017-02-02T00:00:00Z") }…
So I'm creating a ticket system, and what I'd like to do is to add any type of file to my tickets and store them in my database. So I was thinking about using a noSQL database just for the…
singleObj = await Objects.findByIdAndUpdate({ _id: req.body.id, }, { $inc: { 'total_obj': -1, 'total_stuff': 1 }, }, { new: true }) The user clicks a button and the value of 'total_obj' gets decreased by one. The value doesn't have to be…
So I am using Prisma for the first time and my provider is mongodb and when I want to create a model it throws me an error Invalid `prisma.user.create()` invocation: Prisma needs to perform transactions, which requires your MongoDB server…