TypeScript Sequelize关联模型查询报错求助

我刚学NodeJS，已经创建了第一个NodeJS项目，正在迁移到TypeScript，但遇到了两个Sequelize相关的错误，求帮忙修复。

我的group.service.ts代码 #

import { Model, DataTypes, Sequelize } from 'sequelize';
import GroupMembers from '../models/groupmember.model';
// 导入Sequelize实例（假设定义在其他文件）
import { sequelize } from '../models'; // 根据项目结构调整导入路径
import Groups from '../models/group.model';
class Group extends Model {
  public id!: number;
  public group_Name!: string;
}

Group.init(
  {
    group_Name: {
      type: DataTypes.STRING, // 根据需要调整数据类型
      allowNull: false,
    },
  },
  {
    sequelize,
    modelName: 'Groups',
  }
);

class GroupMember extends Model {
  public id!: number;
  public user_id!: number;
  public group_id!: number;
}

GroupMember.init(
  {
    user_id: {
      type: DataTypes.INTEGER,
      allowNull: false,
    },
    group_id: {
      type: DataTypes.INTEGER,
      allowNull: false,
    },
  },
  {
    sequelize,
    modelName: 'GroupMembers',
  }
);

// 创建新群组的函数
const createGroup = async (group_Name: string, creator_id: number): Promise<Groups> => {
  try {
    const group = await Groups.create({
      creator_id,
      group_Name,
    });
    return group;
  } catch (error) {
    console.error('创建群组出错', error);
    throw new Error('创建群组失败');
  }
};

// 获取用户所属的所有群组（包括私聊）
const getUsersGroups = async (user_id: number): Promise<any[]> => {
  try {
    const userGroups = await GroupMembers.findAll({
      where: { user_id },
      include: [{ model: Groups }],
    });
    console.log("检查群组", userGroups);
    return userGroups.map((entry) => entry.getDataValue('groups'));
  } catch (error) {
    console.error('获取用户群组出错', error);
    throw new Error('获取用户群组失败');
  }
};

// 删除群组及关联消息的函数
const deleteGroupWithMessages = async (group_id: number): Promise<{ message: string }> => {
  try {
    const deleteGroup = await Groups.destroy({
      where: { id: group_id },
    });

    if (!deleteGroup) {
      throw new Error('群组不存在');
    }

    return { message: '群组及关联消息删除成功' };
  } catch (error) {
    console.error('删除群组及消息出错', error);
    throw new Error('删除群组及消息失败');
  }
};

export { createGroup, getUsersGroups, deleteGroupWithMessages };

遇到的错误 #

1. 类型“"groups"”的参数不能赋值给类型“keyof GroupMembersModelAttributes”的参数。
2. 类型“{ id: number; }”不能赋值给类型“WhereOptions | undefined”。对象字面量只能指定已知属性，而“id”不在类型“WhereOptions”中。

错误修复方案 #

核心问题根源 #

你在service文件中重复定义了Group和GroupMember类，这会与从../models导入的官方模型产生类型冲突，导致TypeScript无法正确识别模型属性和关联关系。

修复后的完整代码 #

import { Model, DataTypes, Sequelize } from 'sequelize';
import GroupMembers from '../models/groupmember.model';
import { sequelize } from '../models';
import Groups from '../models/group.model';

// 移除重复定义的Group和GroupMember类，直接使用导入的模型

// 创建新群组
const createGroup = async (group_Name: string, creator_id: number): Promise<Groups> => {
  try {
    const group = await Groups.create({
      creator_id,
      group_Name,
    });
    return group;
  } catch (error) {
    console.error('创建群组出错', error);
    throw new Error('创建群组失败');
  }
};

// 获取用户所属的所有群组
const getUsersGroups = async (user_id: number): Promise<Groups[]> => {
  try {
    const userGroups = await GroupMembers.findAll({
      where: { user_id },
      include: [{ 
        model: Groups,
        as: 'group' // 需与GroupMembers模型中定义的关联别名一致
      }],
    });
    console.log("检查群组", userGroups);
    // 直接访问关联属性，TypeScript会自动识别类型
    return userGroups.map(entry => entry.group);
  } catch (error) {
    console.error('获取用户群组出错', error);
    throw new Error('获取用户群组失败');
  }
};

// 删除群组及关联消息
const deleteGroupWithMessages = async (group_id: number): Promise<{ message: string }> => {
  try {
    const deleteCount = await Groups.destroy({
      where: { id: group_id }, // 导入的Groups模型已包含id主键，类型匹配
    });

    if (!deleteCount) {
      throw new Error('群组不存在');
    }

    return { message: '群组及关联消息删除成功' };
  } catch (error) {
    console.error('删除群组及消息出错', error);
    throw new Error('删除群组及消息失败');
  }
};

export { createGroup, getUsersGroups, deleteGroupWithMessages };

额外配套调整 #

需要确保你的模型文件正确定义字段和关联：

1. group.model.ts（补充creator_id字段）

import { Model, DataTypes } from 'sequelize';
import { sequelize } from './index';

class Groups extends Model {
  public id!: number;
  public group_Name!: string;
  public creator_id!: number;
}

Groups.init({
  group_Name: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  creator_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
}, {
  sequelize,
  modelName: 'Groups',
});

export default Groups;

2. groupmember.model.ts（定义关联关系）

import { Model, DataTypes } from 'sequelize';
import { sequelize } from './index';
import Groups from './group.model';

class GroupMembers extends Model {
  public id!: number;
  public user_id!: number;
  public group_id!: number;
}

GroupMembers.init({
  user_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
  group_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
}, {
  sequelize,
  modelName: 'GroupMembers',
});

// 定义与Groups的关联，指定外键和别名
GroupMembers.belongsTo(Groups, { foreignKey: 'group_id', as: 'group' });

export default GroupMembers;

内容的提问来源于stack exchange，提问作者Hadiqa