使用node/request/sequelize/mysql将图像文件保存到数据库中

npm install request sequelize mysql2

const Sequelize = require('sequelize');

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const Image = sequelize.define('image', {
  name: {
    type: Sequelize.STRING,
    allowNull: false
  },
  data: {
    type: Sequelize.BLOB('long'), // 使用BLOB类型来存储二进制数据
    allowNull: false
  }
});

const request = require('request');

function saveImageToDatabase(imageUrl, imageName) {
  return new Promise((resolve, reject) => {
    request.get(imageUrl, { encoding: null }, (error, response, body) => {
      if (error) {
        return reject(error);
      }

      Image.create({
        name: imageName,
        data: body
      }).then(image => {
        resolve(image);
      }).catch(err => {
        reject(err);
      });
    });
  });
}

const imageUrl = 'http://example.com/image.jpg';
const imageName = 'example.jpg';

saveImageToDatabase(imageUrl, imageName)
  .then(image => {
    console.log('Image saved:', image.toJSON());
  })
  .catch(error => {
    console.error('Error saving image:', error);
  });