Mongodb – findOneAndUpdate doesn't work in Mongo db

The issues you’re encountering seem to be due to a mix of connection management and possible module loading problems. Let’s address them step-by-step:

Step 1: Ensure Connection Management
Make sure that your connection management logic (connectDB) works correctly and is used properly in your application.

Step 2: Verify Mongoose Model and Schema
Ensure your Mongoose model and schema are defined and exported correctly.

Step 3: Correctly Handle the Database Connection in Next.js
Ensure the database connection logic is properly handled within the Next.js environment.

Here is a revised approach to address these issues:

Connection Management:
Your connectDB function looks mostly correct, but let’s ensure it’s always exporting properly and is used correctly within your addAComment function.

Model Definition:
Make sure the ProposalModel is correctly defined and accessible.

Using connectDB and ProposalModel:
Ensure you’re importing and using them correctly in your server action.

Revised Code

connectDB.ts (Connection Management)

import mongoose from 'mongoose';
const connectDB = async () => {
  try {
    if (mongoose.connections[0].readyState) {
      console.log('Already connected to MongoDB');
      return;
    }
    await mongoose.connect(process.env.MONGODB_URI as string, {
      useNewUrlParser: true,
      useUnifiedTopology: true,
    });

    console.log('Connected to MongoDB');
  } catch (error) {
    console.error('Error connecting to MongoDB:', error);
    throw error;
  }
};

export default connectDB;

proposalModel.ts (Model Definition)

import { Document, Model, Schema, model, models } from 'mongoose';

interface IProposalDocument extends Document {
  proposalId: number;
  toCompanyAddress: string;
  fromAddress: string;
  proposalURI: string;
  decisionStatus: number;
  fundingGoal: string;
  currentFunding: string;
  deadline: string;
  comment?: string;
}

const proposalSchema: Schema<IProposalDocument> = new Schema(
  {
    proposalId: { type: Number, required: true, unique: true },
    toCompanyAddress: { type: String, required: true },
    fromAddress: { type: String, required: true },
    proposalURI: { type: String, required: true },
    decisionStatus: { type: Number, required: true },
    fundingGoal: { type: String, required: true },
    currentFunding: { type: String, required: true },
    deadline: { type: String, required: true },
    comment: { type: String, default: '' },
  },
  { timestamps: true }
);

const ProposalModel: Model<IProposalDocument> = models.proposals || model<IProposalDocument>('proposals', proposalSchema);

export default ProposalModel;

serverAction.ts (Server Action)

import connectDB from './connectDB';
import ProposalModel from './proposalModel';

export async function addAComment(proposalId: number, newComment: string) {
  await connectDB();
  const updateFields: any = { comment: newComment };

  console.log('Here is a new comment:', newComment);
  try {
    const result = await ProposalModel.findOneAndUpdate(
      { proposalId: proposalId },
      { $set: updateFields },
      { new: true }
    );
    console.log('Comment added, this is the result:', result);
    return result;
  } catch (error) {
    console.error('Error updating comment:', error);
    throw error;
  }
}

Usage in Next.js Component

Ensure you call addAComment correctly from your component:

import { useState } from 'react';
import { addAComment } from './serverAction';

const CommentComponent = ({ proposalId }) => {
  const [comment, setComment] = useState('');

  const handleSendTransaction = async () => {
    if (comment.length) {
      try {
        const result = await addAComment(proposalId, comment);
        console.log('Comment updated:', result);
      } catch (error) {
        console.error('Error adding comment:', error);
      }
    }
  };

  return (
    <div>
      <input
        type="text"
        value={comment}
        onChange={(e) => setComment(e.target.value)}
        placeholder="Add a comment"
      />
      <button onClick={handleSendTransaction}>Send Transaction</button>
    </div>
  );
};

export default CommentComponent;

Hope that with these changes, your code should correctly handle database connections and perform updates without prematurely closing the connection.