使用Sequelize和Express更新链接表

// 引入依赖
const express = require('express');
const { Sequelize, DataTypes } = require('sequelize');

// 创建数据库连接
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义链接表模型
const Link = sequelize.define('Link', {
  title: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  url: {
    type: DataTypes.STRING,
    allowNull: false,
  },
});

// 创建Express应用程序
const app = express();

// 创建PUT请求的路由
app.put('/links/:id', async (req, res) => {
  const linkId = req.params.id;
  const { title, url } = req.body;

  try {
    // 更新链接表
    const updatedLink = await Link.update({ title, url }, {
      where: { id: linkId },
    });

    res.status(200).json(updatedLink);
  } catch (error) {
    res.status(500).json({ error: 'Failed to update link' });
  }
});

// 启动应用程序
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});