Currently, I am faced with the challenge of displaying an image that is stored in an MSSQL database created by another person.
The column was originally of type IMAGE, but I converted it to varbinary(MAX) using Sequelize. Although I lost some data during testing, it was necessary for the process.
After reinserting the image, I attempted to display it on my fotos.handlebars file.
Unfortunately, all I got were a string of characters instead of the actual image:
I'm seeking advice on how to rectify this issue and successfully display the image.
This is my code snippet:
Model Fotos.JS:
const db = require('./db')
const Fotos = db.sequelize.define('Fotos', {
COD_PESSOA:{
type: db.Sequelize.INTEGER
},
Sequencia:{
type: db.Sequelize.INTEGER
},
Foto:{
type: db.Sequelize.BLOB
},
Padrao:{
type: db.Sequelize.INTEGER
}
}, {
timestamps: false
})
module.exports = Fotos
//Fotos.sync({force: true})fotos.handlebars:
<h1>Fotos:</h1>
{{#each fotos}}
<h2>{{dataValues.Foto}}</h2>
<hr>
{{/each}}app.js:
const express = require('express')
const app = express()
const handlebars = require('express-handlebars')
const bodyParser = require('body-parser')
const Fotos = require('./models/Fotos')
//template engine
app.engine('handlebars', handlebars({defaultLayout: 'main'}))
app.set('view engine', 'handlebars')
//body-parser
app.use(bodyParser.urlencoded({extended: false}))
app.use(bodyParser.json())
//Routes
app.use('/fotos', (req, res)=>{
//res.send('test route')
Fotos.findAll().then((fotos)=>{
res.render('fotos', {fotos: fotos})
}).catch((error)=>{
res.send(error)
})
})
app.listen(8081, ()=>{
console.log('Server is running')
})