使用sequelize检索链接状态字段的值

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

const Link = sequelize.define('Link', {
  status: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

// 同步模型到数据库
(async () => {
  await sequelize.sync();
  console.log('Model synced');
})();

module.exports = Link;

const Link = require('./models/Link');

async function retrieveLinkStatus() {
  try {
    const links = await Link.findAll();
    for (const link of links) {
      console.log(`Link ID: ${link.id}, Status: ${link.status}`);
    }
  } catch (error) {
    console.error('Error retrieving link status:', error);
  }
}

retrieveLinkStatus();