I am having trouble with making a post request to the database. The datatype for images is a string and I need to be able to upload one, two, or multiple images.
What is the best way to store these images?
Below is my Posts model:
const Sequelize = require("sequelize");
const db = require("../config/database");
const Posts = db.define(
"post",
{
id: {
type: Sequelize.INTEGER,
primaryKey: true,
autoIncrement: true,
},
title: {
type: Sequelize.STRING,
},
images: {
type: Sequelize.STRING,
}})
This is my post method:
router.post(
"/",
[
upload.array("images", config.get("maxImageCount")),
imageResize,
],
async (req, res) => {
const paths = await req.files.map((file) => ({ fileName: file.filename }));
Posts.create({
title: req.body.title,
images: paths,
}).then(
() => {
res.status(201).send({
msg: "Upload successful",
});
},
(validation) => {
res.status(422).json({
errors: validation.errors.map((error) => {
return {
fieldName: error.path,
message: error.message,
};
}),
});
}
);
}
);
Why do I keep receiving an error when uploading images?
{
"errors": [
{
"fieldName": "images",
"message": "Images cannot be an array or an object"
}
]
}