I'm developing a backend application using Apollo GraphQL and Mongoose. I have two models: User and Post, which have a one-to-many relationship (a user can have many posts, but a post belongs to one user). I want to query the…
How to query the "car" collection, which stores a document for every car, and retrieve all cars that include specific keywords in their names. Then, find the latest "carInfo" document for each of these cars and return only the cars…
I have three mongoDB collections and their respective documents namely; mosques, prayers and subscriptions as follows: mosque document: { "_id": "64a48ce14ebcac9ec9a3b0b9", "address": "pti road , effurun", "city": "Warri", "state": "Delta", "country": "Nigeria", "name": "PTI central mosque", "image": "", "imamName": "Malam…
Here is the mongodb document that I want to update through mongoose: My model: const mongoose = require("mongoose"); const Schema = mongoose.Schema; const reservationSchema = new Schema({ username: { type: String, required: true, }, name: { type: String, required: true,…
I am using Ruby on Rails and I have the following Mongo collection, { _id: 1, name: "Jackie Chan", sn: "ABC123", Country: Australia }, { _id: 2, name: "Brad Pitt", sn: "ABC124", Country: Russia }, { _id: 3, name: "Al…
Help me please. Working with Mongoose, and I want to check if there are duplicates in the "ViolationID" field and delete them, except the last one created. I think, _id: { $lt: record._id } works incorrect. May be some types…
I'm trying to seed data for my db but both my schema reference each other so I'm not sure how it's possible to seed one before the other. I want to use fakerjs to have some data to play with,…
I have a studentsubject schema. Properties are subject_id,student_id,class_id So my usecase is i want to find the one student where class_id, student_id matches. Subject id is optional. Means if subject id is present with that student and class id ,…
I am trying to find the way to remove the properties from nested object array by using aggregate framework in MongoDB but I still can't find any solution for my issue. I have an nested object array like below: {…
import express from 'express' const app = express(); const port = process.env.PORT || 8000; import mongoose from 'mongoose'; mongoose.connect("mongodb://localhost:27017/schooldb").then(() => { console.log("connection successfully "); }) app.get('/', (req, res) => { res.send('Hello user') }) app.listen(port, () => { console.log(`listening at port…