how to create an api to push form input data into mongodb document as a subdocument?

Question

can this be done with fetch api which method should i use post or put? please reply.. can someone please give me the complete api to push orderSchema as a subdocument in userSchema i have scrolled tons and tons of links still i am not able to find any answer too this

this is the schema i am using in mongo db.

    import mongoose from 'mongoose'
    const orderSchema = new mongoose.Schema({
        rsph: { type: Number },
        rcyl: { type: Number },
        raxis: { type: Number },
        lsph: { type: Number },
        lcyl: { type: Number },
        laxis: { type: Number },
        add: { type: Number },
        frame: { type: String },
        lens: { type: String }
    }, {
        timestamps: true
    });
    
    const userSchema = new mongoose.Schema({
        name: { type: String, required: true },
        phone: { type: Number, required: true },
        address: { type: String, required: true },
        orders: [orderSchema]
    }, {
        timestamps: true
    });
    
    export default mongoose.models.User || mongoose.model('User', userSchema)

I am using this api to save userschema and this is working.

    import initDB from '../../helper/initDB';
    import User from '../../models/addUser';
    
    initDB()
    
    export default async (req, res) => {
      (req.method)
      {
        "POST"
        await handler(req, res)
      }
    }
    const handler = async (req, res) => {
      if (req.method == 'POST') {
        console.log(req.body)
        const { name,phone,address } = req.body
        let u = new User( {name,phone,address } )
        await u.save()
        res.status(200).json({ success: "success" })
      }
      else {
        res.status(400).json({ error: "this method is not required" })
      }
    }
    
    
    

I am using this api to save this data as a subdocument but this api is not working what changes should i make?

    import initDB from '../../../helper/initDB';
    import User from '../../../models/addUser';
    
    initDB()
    
    export default async (req, res) => {
      (req.method)
      {
        "POST"
        await handler(req, res)
      }
    }
    const handler = async (req, res) => {
      if (req.method == 'POST') {
        console.log(req.body)
        const { uid } = req.query
        const user = await User.findOne({ _id: uid })
        const { rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens } = req.body
        const order = ({ rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens });
        user.orders.push(order);
        await user.save()
        res.status(200).json({ success: "success" })
      }
      else {
        res.status(400).json({ error: "this method is not required" })
      }
    }

please reply...

Answer 1

Remove bracket () from the below line.

const order = ({ rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens });

only pass the object, as

const order = { rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens };

The final should be as:

const handler = async (req, res) => {
      if (req.method == 'POST') {
        console.log(req.body)
        const { uid } = req.query
        const user = await User.findOne({ _id: uid })
        const { rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens } = req.body
        const order = { rsph, rcyl, raxis, lsph, lcyl, laxis, add, frame, lens };
        user.orders.push(order);
        await user.save()
        res.status(200).json({ success: "success" })
      }
      else {
        res.status(400).json({ error: "this method is not required" })
      }
    }