can't insert data using mongoose

can't inset data using mongoose.here are the details.i am working in seperate directories

middleware.js code

import mongoose from "mongoose";
const connectDB=handler=> async(req,res)=>{
    if(mongoose.connections[0].readyState){  //if already connection exist
return handler(req,res)
    }
    await mongoose.connect(process.env.MONGO_URI)
    return handler(req,res)
}
export default connectDB;

Product Model Schema

addproductapi code

import Product from "../../../models/Product";
import connectDB from "../../../middleware/mongoose";
const handler= async (req, res)=> {
    if(req.method=='POST'){
        for (let i = 0; i < req.body.lenght; i++) {
            let p=new Product({
                title:req.body[i].title,
                slug:req.body[i].slug,
                desc:req.body[i].desc,
                img:req.body[i].img,
                category:req.body[i].category,
                size:req.body[i].size,
                color:req.body[i].color,
                price:req.body[i].price,
                qtyInStocks:req.body[i].qtyInStocks
            });
            await p.save();
        }
        res.status(200).json({success:"Success"});
    }
    else{
        res.status(400).json({error:"this method is not allowed"});
    }
  }
  export default connectDB(handler)

get product api code

import Product from "../../../models/Product";
import connectDB from "../../../middleware/mongoose";
const handler= async (req, res)=> {
    let products= await Product.find();
    res.status(200).json({products});
  }

export default connectDB(handler) //if our application not connected to db this line will connect us

Note: this code is creating database in mongodb compass with name products, addproducts api is working fine because thunder client returns status 200. Getproduct is returning 304 why I don’t know. i have check my code twice,thrice even i restart my server many times.

help me out please

Hi umair,

please try below code if it is resolves your issue please accept the answer

middleware.js code

import mongoose from "mongoose";

const connectDB = handler => async (req, res) => {
    if (mongoose.connections[0].readyState) {  // If a connection already exists
        return handler(req, res);
    }

    await mongoose.connect(process.env.MONGO_URI, {
        useNewUrlParser: true,
        useUnifiedTopology: true
    });
    
    return handler(req, res);
}

export default connectDB;

Product Model Schema

import mongoose from 'mongoose';

const ProductSchema = new mongoose.Schema({
    title: { type: String, required: true },
    slug: { type: String, required: true, unique: true },
    desc: { type: String, required: true },
    img: { type: String, required: true },
    category: { type: String, required: true },
    size: { type: String },
    color: { type: String },
    price: { type: Number, required: true },
    qtyInStocks: { type: Number, required: true }
}, { timestamps: true });

const Product = mongoose.models.Product || mongoose.model('Product', ProductSchema);

export default Product;

addproductapi code

import Product from "../../../models/Product";
import connectDB from "../../../middleware/db"; 
const handler = async (req, res) => {
    if (req.method === 'POST') {
        try {
            for (let i = 0; i < req.body.length; i++) {
                let p = new Product({
                    title: req.body[i].title,
                    slug: req.body[i].slug,
                    desc: req.body[i].desc,
                    img: req.body[i].img,
                    category: req.body[i].category,
                    size: req.body[i].size,
                    color: req.body[i].color,
                    price: req.body[i].price,
                    qtyInStocks: req.body[i].qtyInStocks
                });
                await p.save();
            }
            res.status(200).json({ success: "Products added successfully" });
        } catch (error) {
            res.status(500).json({ error: "Server error", details: error.message });
        }
    } else {
        res.status(400).json({ error: "This method is not allowed" });
    }
};

export default connectDB(handler);

get product api code

import Product from "../../../models/Product";
import connectDB from "../../../middleware/db";

const handler = async (req, res) => {
    try {
        let products = await Product.find();
        res.status(200).json({ products });
    } catch (error) {
        res.status(500).json({ error: "Server error", details: error.message });
    }
};

export default connectDB(handler);

A 304 status code stands for "Not Modified," which means that the resource requested has not been modified since the last request. This usually occurs when caching is involved. However, if you're experiencing this with a development API where caching shouldn't be an issue.

Make sure that Thunder Client is not caching the response. Some clients have settings or options to disable caching. Try disabling cache or using "No-Cache" in your request headers.

have you tested your api in postman