sequelize.js

// 案例一：toJSON()
const data = tweets.map(t => ({
  ...t.toJSON(),
}))

// 改為使用下面的參數
const tweets = await Tweet.findAll({
  nest: true,
  raw: true,
})

// 案例二：sort
const topFollowings = allUsers
  .sort((a, b) => {
    b.Followers.length - a.Followers.length
  })
  .slice(0, 10)
  .map(topFollowing => {
    return {
      ...topFollowing.toJSON(),
      isFollowed: followingList.includes(topFollowing.id)
    }
})

// 改為用 aggregation
const users = await User.findAll({
  attributes: [
    [sequelize.literal('(SELECT COUNT(*) FROM Followers WHERE Followers.userId = User.id)'), 'FollowerCount']
  ],
  order: [[sequelize.literal('FollowerCount'), 'DESC']]
})