I want to execute the following two updates in single update query. // delete the user with (requestID) from friends await User.updateOne({ _id: id, }, { $pull: { friends: requestID } }) // delete the user with (id) from friends…
Given this collection of courses, there is a list of subjects that are composed of objects. Is it possible to create an aggregation to create a new field newSubjects that maps all subjects by their ids? For example, given this…
const score_schema = mongoose.Schema( { tester_id: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true, }, test_id: { type: mongoose.Schema.Types.ObjectId, ref: "test", required: true, }, score: { type: Number, required: true, }, }, { collection: `score`, timestamps: true, } ); query 1:…
MongoDB upgraded their command-line interface (formerly mongo, now mongosh). Before, the mongo command output was in proper JSON, the kind jq could ingest. For example: { "abc" : "hello" } The new mongosh command now outputs stuff like: { abc:…
I am trying to update the name of a key inside an object of an array and annoyed due to the inability to make the queries work. I have tried this How rename nested key in array of object in…
I'm trying to create a discord bot, specifically the wedding team. I am using a MongoDB database. Now everything works and is saved, but there is one problem, the data is saved for the second and third rounds, etc. That…
I took the code from the documentation, but it doesn't work. pub fn get_countries(&self) { let cursor = self.countries.find(None, None); for doc in cursor { println!("{}", doc?) } } mongodb::sync::Cursor<bson::Document> doesn't implement std::fmt::Display mongodb::sync::Cursor<bson::Document> cannot be formatted with the default…
I am using Go's MongodDB driver (https://pkg.go.dev/go.mongodb.org/[email protected]/mongo#section-documentation) and want to obtain the version of the mongoDB server deployed. For instance, if it would been a MySQL database, I can do something like below: db, err := sql.Open("mysql", DbUser+":"+DbPwd+"@tcp("+Host+")/"+DbName) if err…
I have a collection "TokenBalance" like this holding documents of this structure { _id:"SvVV1qdUcxNwSnSgxw6EG125" balance:Array address:"0x6262998ced04146fa42253a5c0af90ca02dfd2a3" timestamp:1648156174658 _created_at:2022-03-24T21:09:34.737+00:00 _updated_at:2022-03-24T21:09:34.737+00:00 } Each address has multiple documents like of structure above based on timestamps. So address X can have 1000 objects with…
I have a collection: { "_id": 1, "_deleted": false, "customFields": [{ "fieldName": "sapID", "value": "" }, { "fieldName": "salesTerritory", "value": "" }, { "fieldName": "clientType", "value": "Corporate" }], } How can I project(aggregate) only the value field of the element…