Posting URL's to Postgres db

I have mostly configured my node backend to handle multi-part forms and it is saving my images to the correct directly. However the only part I can’t seem to get to work is the url address being posted into the photos text field in postgres. As I have yet to see this work I am not sure how it should look. I have tried changing the file type to BLOB / BYTEA (‘long’) and it looked like it populated with binary data but I am trying to just get the URL and store the file on my backend.

Should it be the fs.readFileSync line of my controller method that inserts this into the table? what does it look like I am doing wrong?

    const article = sequelize.define("articles", {

            articleID: {
                type: Sequelize.INTEGER,
                primaryKey: true,
                autoIncrement: true,
                allowNull: false
            articleTitle: {
                type: Sequelize.TEXT
            articleContent: {
                    type: Sequelize.TEXT
            articlePhotos: {
                type: Sequelize.TEXT,
                data: Sequelize.Buffer,
            articleAuthor: {
                type: Sequelize.INTEGER
            articleType: {
                type: Sequelize.INTEGER
                timestamps: false
            }, {});
            article.associate = function(models){
                article.articleType.belongsTo(models.article, {
                    foreignKey: {name: 'articleTypeID', as: 'articleTypeID'}})
                article.articleAuthor.belongsTo(models.userLogin, {
                    foreignKey: {name: 'userID', as: 'userID'}})
    return article;


exports.createArticle = (req, res) => {
    try {
    // article being added to the db
    console.log("kuiogio", req.body)

        articleID: req.body.articleID,
        articleTitle: req.body.articleTitle,
        articleContent: req.body.articleContent,
        articleAuthor: req.body.articleAuthor,
        articleType: req.body.articleType,
        photos: fs.readFileSync(
            __basedir + "/assets/" + req.file.filename
    }).then((article) => {
            __basedir + "/assets/" + article.articleTitle,

        return res.send(`File has been uploaded.`);
        // set user role to 1 to get basic user access on sign up
    } catch (error) {
        return res.send(`Error when trying upload images: ${error}`);


const multer = require("multer");

// config for multer to disk storage engine
const imageFilter = (req, file, cb) => {
    if (file.mimetype.startsWith("image")) {
        cb(null, true);
    } else {
        cb("Please upload only images.", false);

//sustscub timestamp prefix to stop duplicates
const storage = multer.diskStorage({
    destination: (req, file, cb) => {
        cb(null, __basedir + "/assets/");
    filename: (req, file, cb) => {
        cb(null, `${}-SustScub-${file.originalname}`);

// filter only allows images to pass
const uploadFile = multer({ storage: storage, fileFilter: imageFilter });
module.exports = uploadFile;

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.