Unable to execute mongoose operation on database collection due to certain restrictions

Question

Unable to execute mongoose operation on database collection due to certain restrictions

Currently utilizing Mongoose for communication with MongoDB. Running into issues while attempting to execute certain operations.

The database contains a collection named USERS, characterized by the following schema:

{username: 'user1', id: 1, lastName: 'ln1' }
{username: 'user2', id: 0, lastName: 'ln2' }

The 'id' field can possess values of 0, 1, 2, or 3.

I am looking to add a new object based on the following conditions:

If the username already exists and has an id of 1, update the details.
If the username does not currently exist, create a new entry without verifying the id field.
If the username exists but has an id of 0, 2, or 3 (non-1 values), refrain from making any updates or adding the user to the collection, maintaining the existing user's data as they failed to be added to the database.

Your assistance is greatly appreciated.

javascript json mongodb mongoose mongoose-schema

Answer 1

Answer №1

Utilizing a promise library has been my approach, although callbacks can also be utilized.

Let's assume that the intention is to work on the User model.

User.findOne({username:"USERNAME"}).exec()
    .then((result)=>{
      if(result){
          if(result.id == 1){
         //update result object and then save it
           result.lastName="abc";
           result.save(); // this will update your result
            }else{
           console.log('failed to enter in the db.')  
           }
        }else{
          User(userObject).save(); // this will create a new entry
        }

})

Answer 2

Utilizing a promise library has been my approach, although callbacks can also be utilized.

Let's assume that the intention is to work on the User model.

User.findOne({username:"USERNAME"}).exec()
    .then((result)=>{
      if(result){
          if(result.id == 1){
         //update result object and then save it
           result.lastName="abc";
           result.save(); // this will update your result
            }else{
           console.log('failed to enter in the db.')  
           }
        }else{
          User(userObject).save(); // this will create a new entry
        }

})

Unable to execute mongoose operation on database collection due to certain restrictions

Answer №1

Similar questions

Developing versatile form elements with Formik and the Yup library for React and Vite

Connecting JavaScript and jQuery scripts

What is the correct way to serialize and deserialize an array of objects to and from JSON format?

When faced with the scenario of having the hashtag in the href attribute and a browser's back button, it

How can I ensure that Redux-saga waits for API calls to resolve instead of returning promises continuously? Is there a way to make "yield call" wait for API calls to complete?

The ng-route feature seems to be malfunctioning and I am unable to identify the error, as no information is being displayed in the console

Using Express and Node.js to display a page populated with information

Verifying user authorization for Microphone access prior to triggering event in React application

How can you retrieve nested JSON data in ReactJS by clicking the Search button?

Could someone assist me in crafting a C# mongo query that mirrors the functionality of an SQL query?

Issues with CreateJS chained animations failing to reach their intended target positions

Unable to establish connection with Uploadthing due to a timeout error

What is the reason for this basic callback running before the setTimeout function?

Directive in Angular for customer management with filtering and sorting functionality

Issue encountered while trying to utilize the reset function of the FormGroup with the angular2-tinymce plugin

Is there a way to achieve a transparent background while animating the second text?

What is the best way to utilize d3.domain for extracting both d3.min and d3.max values from various columns within a JSON dataset?

I am in search of a JavaScript or jQuery plugin for an HTML slider with a unique range functionality

Determine the originating page in Next.js that leads to the current page

Is there any HTML code that is able to implement a currency format identical to the one we've customized in Google Sheets/Google Apps Script