在nodejs中使用关联和排序来序列化findAll

const { Sequelize, Model, DataTypes } = require('sequelize');

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

// 定义模型
class User extends Model {}
User.init({
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false
  },
  role_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    references: {
      model: 'Role',
      key: 'id'
    }
  }
}, {
  sequelize,
  modelName: 'User',
  tableName: 'users',
  timestamps: false
});

class Role extends Model {}
Role.init({
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  name: {
    type: DataTypes.STRING,
    allowNull: false
  }
}, {
  sequelize,
  modelName: 'Role',
  tableName: 'roles',
  timestamps: false
});

// 关联模型
User.belongsTo(Role, { foreignKey: 'role_id' });

// 查询并序列化数据
async function findAllWithAssociationsAndSorting() {
  try {
    const users = await User.findAll({
      include: [
        {
          model: Role,
          attributes: ['name']
        }
      ],
      order: [
        ['name', 'ASC']
      ]
    });
    return JSON.stringify(users);
  } catch (error) {
    console.error('Error:', error);
  }
}

findAllWithAssociationsAndSorting()
  .then(result => console.log('Result:', result))
  .catch(error => console.error('Error:', error));