Method deleteUser

server/controllers/UserController.js:92–277

(id)

  }

  async deleteUser(id) {
    const transaction = await db.sequelize.transaction();
    const cleanupConversations = async (where) => {
      const conversations = await db.AiConversation.findAll({
        attributes: ["id"],
        where,
        transaction
      });

      if (conversations.length < 1) {
        return;
      }

      const conversationIds = conversations.map((conversation) => conversation.id);

      await Promise.all([
        db.AiMessage.destroy({
          where: { conversation_id: { [Op.in]: conversationIds } },
          transaction
        }),
        db.AiUsage.update(
          { conversation_id: null },
          {
            where: { conversation_id: { [Op.in]: conversationIds } },
            transaction
          }
        )
      ]);

      await db.AiConversation.destroy({
        where: { id: { [Op.in]: conversationIds } },
        transaction
      });
    };

    try {
      await cleanupConversations({ user_id: id });

      await Promise.all([
        db.SavedQuery.destroy({
          where: { "user_id": id },
          transaction
        }),
        db.ChartCache.destroy({
          where: { "user_id": id },
          transaction
        }),
        db.User2fa.destroy({
          where: { "user_id": id },
          transaction
        }),
        db.PinnedDashboard.destroy({
          where: { "user_id": id },
          transaction
        }),
        db.ProjectRole.destroy({
          where: { "user_id": id },
          transaction