How to delete a single item from an array using MongoDB

Question

How to delete a single item from an array using MongoDB

For my discord bot, I've implemented a purchasing system that adds items to the inventory array in mongoDB like this:

data.Inventory[itemTobuy] ++;

The stored format looks like this:

pizza: 1

I also have a system in place where users can use items from their inventory. I want to remove the item entirely if there's only one instance of it, but if there are multiple instances, I want to decrement the value by one, for example, from pizza: 5 to pizza: 4. Although, I'm only about 25% sure on how to accomplish this.

The following is the full code for the command that adds the item if necessary:

const { Client, Message, MessageEmbed } = require('discord.js');
const { User } = require("../../databasing/schemas/User")
const inventory = require('../../databasing/schemas/inventory')
const items = require('../../items/shopItems')

module.exports = {
    name: 'buy',
    /** 
     * @param {Client} client 
     * @param {Message} message 
     * @param {String[]} args 
     */
    run: async(client, message, args) => {
        userData = await User.findOne({ id: message.author.id }) || new User({ id: message.author.id })
        const itemTobuy = args[0].toLowerCase()
        embed = new MessageEmbed({ color: "#2F3136" })
        if(!args[0]) return message.channel.send({
            embeds: [ embed.setTitle('<:redCross:1004290018724020224> | Please mention something to buy!')]
        });
        const itemid = !!items.find((val) => val.item.toLowerCase() === itemTobuy);
        if(!itemid) return message.channel.send({
            embeds: [ embed.setTitle(`<:redCross:1004290018724020224> | ${itemTobuy} is not a valid item!`)]
        });
        itemPrice = items.find((val) => val.item.toLowerCase() === itemTobuy).price;
        userBalance = userData.wallet;
        if(userBalance < itemPrice) return message.channel.send({
            embeds: [embed.setTitle(`<:redCross:1004290018724020224> | You dont have enough money to buy this item(LOL)`)]
        }); 
        const param ={
            User: message.author.id
        }
        inventory.findOne(param, async(err, data) => {
            if(data){
                const hasItem = Object.keys(data.Inventory).includes(itemTobuy);
                if(!hasItem){
                    data.Inventory[itemTobuy] = 1;
                } else {
                    data.Inventory[itemTobuy] ++;
                }
                await inventory.findOneAndUpdate(param, data);
                } else {
                new inventory({
                    User: message.author.id,
                    Inventory: {
                        [itemTobuy]: 1,
                    }
                }).save()
                }
                message.channel.send({
                    embeds: [embed.setTitle(`<:greenTick:1004290019927785472> | Successfully bought ${itemTobuy}!`)]
                });
                userData.wallet -= itemPrice;
                userData.save()
        })
    }
}

javascript mongodb mongoose discord.js

Answer 1

Answer №1

If you want to reduce the value of your item, you can utilize the $inc method. Here's an example:

const param = {
  User: message.author.id
}

const item_name = args.splice(0).join(" ").toLowerString();
//Please note that .toLowerString() will convert any string to lowercase.
//If case sensitivity is important, omit the .toLowerString().

inventory.findOne({
   param, //User.id
   "Inventory.name": item_name //Modify the "name" based on how you reference your item names.
}, async(err, data) => {
   //We are checking for item existence here.
  if(data) {
    //Reduce the item quantity here.
    await inventory.findOneAndUpdate({
      param,
      "Inventory.name": item_name
    }, {
       $inc: {
         "Inventory.$.value": -1 //Adjust based on how you represent item values.
       }
    })
  } else {
    //Send a message if the item doesn't exist.
  }
})

UPDATE:

To retrieve the name and value of your item, you must search for the specific item name.

Begin by setting up your inventory as an array.

const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;

const arr = inv.Inventory; converts it into an array. Next, locate the name.

const item_name = args.splice(0).join(" ").toLowerString();
const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;
const item = arr.find(x => x.name == item_name);

Once you have the item_name, you can display the value and name wherever you choose, whether in an embed or a regular message.

const item_name = args.splice(0).join(" ").toLowerString();
const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;
const item = arr.find(x => x.name == item_name);

const items_value = item.value;
const items_name = item.name;

const embed = new MessageEmbed()
.addFields(
  {name: `Name:`, value: `${items_name}`},
  {name: `Value:`, value: `${items_value}`}
)

message.channel.send({embeds: [embed]})

Answer 2

If you want to reduce the value of your item, you can utilize the $inc method. Here's an example:

const param = {
  User: message.author.id
}

const item_name = args.splice(0).join(" ").toLowerString();
//Please note that .toLowerString() will convert any string to lowercase.
//If case sensitivity is important, omit the .toLowerString().

inventory.findOne({
   param, //User.id
   "Inventory.name": item_name //Modify the "name" based on how you reference your item names.
}, async(err, data) => {
   //We are checking for item existence here.
  if(data) {
    //Reduce the item quantity here.
    await inventory.findOneAndUpdate({
      param,
      "Inventory.name": item_name
    }, {
       $inc: {
         "Inventory.$.value": -1 //Adjust based on how you represent item values.
       }
    })
  } else {
    //Send a message if the item doesn't exist.
  }
})

UPDATE:

To retrieve the name and value of your item, you must search for the specific item name.

Begin by setting up your inventory as an array.

const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;

const arr = inv.Inventory; converts it into an array. Next, locate the name.

const item_name = args.splice(0).join(" ").toLowerString();
const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;
const item = arr.find(x => x.name == item_name);

Once you have the item_name, you can display the value and name wherever you choose, whether in an embed or a regular message.

const item_name = args.splice(0).join(" ").toLowerString();
const inv = await inventory.findOne({
  param
})

const arr = inv.Inventory;
const item = arr.find(x => x.name == item_name);

const items_value = item.value;
const items_name = item.name;

const embed = new MessageEmbed()
.addFields(
  {name: `Name:`, value: `${items_name}`},
  {name: `Value:`, value: `${items_value}`}
)

message.channel.send({embeds: [embed]})

How to delete a single item from an array using MongoDB

Answer №1

Similar questions

Is it true that by utilizing Vue's v-for, every line of HTML code becomes a

Send the values of the form variables as arguments

Troubleshooting module not being found with rekuire, requirish, or rfr in resolving relative require problem in nodejs

Having trouble removing a cookie in express?

Issues have arisen with the execution of JavaScript code inside a callback function

A React component created in a class cannot effectively update its state when using a functional component to pass

When utilizing the Map.get() method in typescript, it may return undefined, which I am effectively managing in my code

To enhance the MUI v5 table row, simply apply a border when the mouse hovers

Press anywhere outside the slide menu to close it using Javascript

What is the best way to pass an email as a Laravel parameter within a function using Angular?

Changing dimensions of cube on stable base

Leveraging the ng-hide property of one controller to adjust the ng-style attribute of another controller through a centralized global controller

What is the reason for placing a ReactJS component, defined as a function, within tags when using the ReactDom.render() method?

What is the best way to set up the login page and logged-in homepage using Node, Express, and Passport with the "/" route?

Adjust Fabric js Canvas Size to Fill Entire Screen

JavaScript - Deleting the last element of an array

Not quite sure about the best way to showcase the results // using JavaScript

Is it possible to employ a jQuery handler as the selector for the .on() method?

One common issue popping up in Webpack logs is the error message "net::ERR_SSL_PROTOCOL_ERROR" caused by a call to sock

The issue of actions failing to flow from sagas to reducers in React.js