Cannot update db with multer and mongose

Question

I am using mongoose with node.js to find a document and update its properties but everytime i do so there is some sort of error which is not logging into the console.It is some issue with multer. Can anyone guess what am id doing wrong?

My schema:

const mongoose = require('mongoose');

const UserSchema = new mongoose.Schema({
    name : {
        type: String,
        required: true
    },
    email : {
        type: String,
        required: true
    },
    password : {
        type: String,
        required: true
    },
    details: {
    type: Object,
},
profile_img: {
    data: String,
    contentType: String,
}
})

const User = mongoose.model('User',UserSchema);

module.exports = User

Multer code:

var fs = require('fs');
var path = require('path');

var multer = require('multer');
 

//store images in db 
var storage = multer.diskStorage({
    destination: (req, file, cb) => {
        cb(null, 'uploads')
    },
    filename: (req, file, cb) => {
         cb(null, new Date().toISOString().replace(/:/g, '-')+ file.originalname);
    }
});

const fileFilter = (req, file, cb) => {
  // reject a file
  if (file.mimetype === 'image/jpeg' || file.mimetype === 'image/png') {
    cb(null, true);
  } else {
    cb(null, false);
  }
};

const upload = multer({
  storage: storage,
  fileFilter: fileFilter
});

Route:

router.post('/profile-chooser/developer/:method',upload.single('profile_photo'),ensureAuthenticated,(req,res) => {
  
        //do db stuff
        User.findOneAndUpdate({ "_id": mongoose.Types.ObjectId(req.user._id) },
         { "$set": 
            { 
                "details": {
                    "Some stuff": "update itttt"
                },
                "profile_img": {
                    "data": fs.readFileSync(path.resolve(__dirname, '../uploads/' + req.file.filename)),
                    "contentType": 'image/png'
                }
            }
        })
        .exec(function(err, user){
            if(err) {
                console.log(err);
                res.status(500).send(err);
            } else {
                res.status(200).send(user);
            }
        });
    })  

I am sure this a problem with multer because when i changed fs.readFileSync(path.resolve(__dirname, ../uploads/ + req.file.filename)) this line into string and also removed upload.single(profile_photo) it magically worked.

Can anyone please help me out.

Your fast response will be highly appreciated.

Thanks in advance.

Answer 1

I have figured out. Use multer with multer-gridfs-storage and grid-fs-stream to read/write photos into the db.

Create a middlewares folder and add these lines of code:

const multer = require("multer");
const {GridFsStorage} = require("multer-gridfs-storage");

const storage = new GridFsStorage({
    url: process.env.CONNECTION_URL,
    options: { useNewUrlParser: true, useUnifiedTopology: true },
    file: (req, file) => {
        const match = ["image/png", "image/jpeg"];

        if (match.indexOf(file.mimetype) === -1) {
            const filename = `${Date.now()}-any-name-${file.originalname}`;
            return filename;
        }

        return {
            bucketName: "photos",
            filename: `${Date.now()}-any-name-${file.originalname}`,
        };
    },
});

module.exports = multer({ storage });

Wherever you are posting the data.

Add this piece of middleware after requiring it:

upload.single('profile_photo')

Grid fs stream allows us to read/write into the collections.

If you want to give your collection a name:

let gfs;

const conn = mongoose.connection;
conn.once("open", function () {
    gfs = Grid(conn.db, mongoose.mongo);
    gfs.collection("photos");
});

Yup, that's it. You have successfully learned to write alphabets!

External links (please refer to these links in the order if you are serious).

Complete reference for beginners

For advanced usage:

Multer docs(well written)

Grid-fs-storage(the core of our project)

Grid-fs-stream