dcumcTest/models/picture.js

let sharp = require('sharp')

module.exports = (sequelize, DataTypes) => {
	let ProfilePicture = sequelize.define('ProfilePicture', {
		file: DataTypes.BLOB('long'),
		mimetype: DataTypes.STRING
	}, {
		classMethods: {
			associate (models) {
				ProfilePicture.belongsTo(models.User)
			}
		},
		hooks: {
			beforeUpdate (profilePicture, options, cb) {
				sharp(profilePicture.file)
					.resize(300, 300, { fit: 'cover' })
					.toBuffer((err, buff) => {
						profilePicture.file = buff

						cb(err || null, options)
					})
			}
		}
	})

	return ProfilePicture
}